#ifndef  __LEVEL1_WRITE_SOFIE_SUMMARY_TABLE_2006_06_16__
#define  __LEVEL1_WRITE_SOFIE_SUMMARY_TABLE_2006_06_16__
/**
      @file ModifySOFIE_Summary.h &
      @author Brian Magill
      @datecreated 6/16/2006

	$Date:$
    $Revision:$

    @copyright
     (©) Copyright 2006 by GATS Inc.
     11864 Canon Blvd., Suite 101, Newport News, VA 23606

     All Rights Reserved. No part of this software or publication may be
     reproduced, stored in a retrieval system, or transmitted, in any form
     or by any means, electronic, mechanical, photocopying, recording, or
     otherwise without the prior written permission of GATS Inc.

 
      @brief Class for writing data to ModifySOFIE_Summary table
      
*/
//----------------------------------------------------------------------
//
#include<string>
#include "WriteTables.h"
#include "GATS_Utilities.hpp"

    class ModifySOFIE_Summary:public WriteTables
        {
        private:
        

        public:

            ModifySOFIE_Summary( ) { };     

            ModifySOFIE_Summary(gatsDBpp::GATS_DB *conn, std::string name):WriteTables(conn, name) { };     

            ModifySOFIE_Summary(ModifySOFIE_Summary const& rhs ):WriteTables(rhs) { };

            ModifySOFIE_Summary& operator = (ModifySOFIE_Summary const& rhs )
                {
                if (this == &rhs)
                        return *this;
                
                WriteTables::operator=(rhs);
                
                return *this;        
                };
                                     
            ~ModifySOFIE_Summary() { };     

            void insertIntoTable(long event, long orbit,  long start_time, long end_time, 
                        long start_occ, long end_occ,
                        long start_scan, long end_scan, char mode,
                        float latitude, float longitude, 
                        long procDate, std::string Level0_ID, std::string Version);

            void updateTable(long event, long orbit, long start_time, long end_time, 
                        long start_occ, long end_occ,
                        long start_scan, long end_scan, char mode,
                        float latitude, float longitude,
                        long procDate, std::string Level0_ID, std::string Version);

            bool eventExists(long event);  

            void deleteEvent(int event) const;
                                    
        };

#endif