diff -r 1fc85118c3ae -r 870918037e16 eventsui/eventsengine/inc/evtdatabase.h
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/eventsui/eventsengine/inc/evtdatabase.h	Wed Sep 01 12:31:27 2010 +0100
@@ -0,0 +1,248 @@
+/*
+* Copyright (c) 2008 Nokia Corporation and/or its subsidiary(-ies). 
+* All rights reserved.
+* This component and the accompanying materials are made available
+* under the terms of "Eclipse Public License v1.0"
+* which accompanies this distribution, and is available
+* at the URL "http://www.eclipse.org/legal/epl-v10.html".
+*
+* Initial Contributors:
+* Nokia Corporation - initial contribution.
+*
+* Contributors:
+*
+* Description:  Class that directly interacts with Sqlite database.
+*
+*/
+
+
+#ifndef C_EVTDATABASE_H
+#define C_EVTDATABASE_H
+
+// System Includes
+#include <sqldb.h>
+
+// User Includes
+#include "evtbasiceventinfo.h"
+#include "evtevent.h"
+#include "evtdbobserver.h"
+#include "evtstoragedbobserver.h"
+
+// Forward Declarations
+class CEvtDbNotifier;
+
+// extern data types
+
+// global Functions
+
+// constants
+const TInt KTempStringLength=32;
+
+/**
+ *  Interface class to Location Events Database.
+ *  This class allows for Events to be stored in persistent database
+ *   - Sqlite. Events can be added, deleted and modified from 
+ *  database.
+ *
+ *  @lib evtstorage.lib
+ *  @since S60 v9.1
+ */
+class CEvtDatabase : public CBase, 
+					   public MEvtDbObserver
+    {   
+public:  // Member Functions
+    /**
+     * Constructs a new instance of CEvtDatabase.
+     *
+     * @return The new instance of CEvtDatabase.
+     * @leave System wide error code if the object creation fails.         
+     */
+    static CEvtDatabase* NewL( );
+    
+    /**
+     * Constructs a new instance of Event Storage Manager interface.
+     * Leaves the created instance on the cleanup stack.
+     *
+     * @return The new instance of CEvtDatabase.
+     * @leave System wide error code if the object creation fails.         
+     */
+    static CEvtDatabase* NewLC( );  
+
+    /**
+    * Destructor.
+    */
+    virtual ~CEvtDatabase();
+                    
+    /**
+     * Get Events List based on status.
+     */                
+    void GetEventsL( TEvtEventStatus 	aEvtStatus,
+                     RPointerArray<CEvtBasicEventInfo>& aEvtEventArray );
+                    
+    /**
+     * Get Events List based on status.
+     */                
+    void GetEventsL( RPointerArray<CEvtBasicEventInfo>& aEvtEventArray );
+		
+    /**
+     * Get Event based on unique Id.
+     */    
+    CEvtEvent* GetEventL( TEvtEventId aEvtId  );
+	
+    /**
+     * Update Event based on unique Id.
+     */    
+    void UpdateEventL( CEvtEvent& aEvtEvent );
+	
+    /**
+     * Insert Event to database.
+     */    
+    void AddEventL( CEvtEvent&     aEvtEvent );
+	
+    /**
+     * Remove Events from database.
+     */    
+    void RemoveEventsL( const RArray<TEvtEventId>& aEvtIdArray );
+	
+    /**
+     * Update Event Status.
+     */ 
+    void UpdateEventsStatusL( const RArray<TEvtEventId>& aEventArray,  TEvtEventStatus  aEvtStatus );
+
+    /**
+     * Update Event Status based on unique Id.
+     */    
+    void UpdateEventStatusL( 
+                            TEvtEventId      aEvtId,
+                            TEvtEventStatus    aEvtStatus);
+                            
+    /**
+     * Remove Event from database based on unique Id.
+     */    
+    void RemoveEventL( TEvtEventId      aEvtId );	
+	
+    /**
+     * Set the Observer fo Storage Database.
+     */
+    void SetObserver( MEvtStorageDbObserver* aStorageDbObserver );
+	
+	 // Inherited from MEvtDbObserver
+    /**
+     * Observer for TDbChangeType changes in Storage Database.
+     */
+    void HandleDbChangedL( );
+
+   
+private:
+
+    /**
+     * Open Database Connection.
+     */
+	void OpenDatabaseL( );
+
+    /**
+     * Create and Open Database Connection.
+     */
+	void CreateOpenDatabaseL( );
+
+    /**
+     * Close Database Connection.
+     */
+	void CloseDatabase();
+
+    /**
+     * Create the Schema for Events Storage.
+     */
+	void CreateSchemaL();
+
+    /**
+     * Create All the Tables.
+     */
+	void CreateTablesL();
+
+    /**
+     * Create All the Indexes.
+     */
+	void CreateIndexL();
+
+    /**
+     * Create All the related Triggers.
+     */
+	void CreateTriggerL();
+
+    /**
+     * Get Events based on Query String.
+     */
+    void GetEventsL( RSqlStatement& 	aStmt,
+                     RPointerArray<CEvtBasicEventInfo>& aEvtEventArray );
+                     
+    /**
+     * Update Event Table.
+     */
+    void UpdateEventTableL( CEvtEvent&          aEvtEvent );
+
+    /**
+     * Delete Event.
+     */
+	void DeleteEventL( TEvtEventId          aEventId );
+
+    /**
+     * check if Event is present.
+     */
+	TBool CheckIfEventPresentL( TEvtEventId          aId );
+
+    /**
+     * check if Action is present.
+     */
+	TBool CheckIfActionPresentL( TInt64          aId );
+
+    /**
+     * Get the action Id based on Event Id.
+     */
+	TInt64 GetActionId( TEvtEventId          aId );
+
+    /**
+     * Create Action.
+     */
+    void CreateActionL( CEvtAction&   aEvtAction );
+    
+    /**
+     * Update Action.
+     */
+    void UpdateActionL( CEvtAction&   aEvtAction );
+    
+    /**
+     * Delete Action.
+     */
+	void DeleteActionL( TEvtEventId          aEventId );
+
+    /**
+     * Default C++ Constructor.
+     */
+    CEvtDatabase( );
+
+    /**
+     * Second phase of the two phase constructor.
+     */
+    void ConstructL();
+
+private: // data
+
+    /**
+     *  RSqlDatabase Instance
+     */
+    RSqlDatabase iDb;
+
+    /**
+     *  CEvtDbNotifier Instance
+     */
+    CEvtDbNotifier* iDbNotifier;
+
+    /**
+     *  CEvtDbNotifier Instance
+     */
+    MEvtStorageDbObserver* iStorageDbObserver;
+    
+    };
+
+#endif // C_EVTDATABASE_H