00001 /* 00002 * Copyright (c) 2002-2011 Nokia Corporation and/or its subsidiary(-ies). All rights reserved. 00003 * 00004 * Redistribution and use in source and binary forms, with or without 00005 * modification, are permitted provided that the following conditions are met: 00006 * 00007 * * Redistributions of source code must retain the above copyright notice, this 00008 * list of conditions and the following disclaimer. 00009 * * Redistributions in binary form must reproduce the above copyright notice, 00010 * this list of conditions and the following disclaimer in the documentation 00011 * and/or other materials provided with the distribution. 00012 * * Neither the name of Nokia Corporation nor the names of its contributors 00013 * may be used to endorse or promote products derived from this software 00014 * without specific prior written permission. 00015 * 00016 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" 00017 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE 00018 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE 00019 * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE 00020 * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL 00021 * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR 00022 * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER 00023 * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, 00024 * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE 00025 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. 00026 * 00027 * Description: 00028 */ 00029 00030 #ifndef STOREDATABASEAPPUI_H 00031 #define STOREDATABASEAPPUI_H 00032 00033 // INCLUDES 00034 #include <aknappui.h> 00035 #include <d32dbms.h> 00036 00037 // FORWARD DECLARATION 00038 class CStoreDatabaseMainView; 00039 class CFileStore; 00040 class CEmployee; 00041 00042 // CLASS DECLARATION 00043 00044 class CStoreDatabaseAppUi : public CAknAppUi 00045 { 00046 private: 00047 enum TStatus 00048 { 00049 EStatusUninitialized = 0, 00050 EStatusCreated, 00051 EStatusAdded 00052 }; 00053 00054 public: // Constructor and destructor 00055 void ConstructL(); 00056 ~CStoreDatabaseAppUi(); 00057 00058 public: // From AppUi 00059 void HandleCommandL(TInt aCommand); 00060 00061 00062 void HandleResourceChangeL(TInt aType); 00063 00064 00065 private: // Private methods 00066 void DoCreateDbL(); 00067 void DoAddDataToDbL(); 00068 void DoReadDataFromDbL(); 00069 void DoDeleteDataFromDbL(); 00070 00071 void CreateDatabaseL(RFs& aFs, const TDesC& aFileName); 00072 void CreateTableL(RDbDatabase& aDatabase); 00073 void CreateIndexL(RDbDatabase& aDatabase); 00074 void AddEmployeeToDatabaseL(RDbDatabase& aDatabase, 00075 const CEmployee& aEmployee); 00076 void AddEmployeeToDatabaseUsingSqlL(RDbDatabase& aDatabase, 00077 const CEmployee& aEmployee); 00078 void ReadEmployeesFromDatabaseL(RDbDatabase& aDatabase); 00079 void DeleteEmployeeFromDatabaseL(RDbDatabase& aDatabase, 00080 const TDesC& aName); 00081 00082 private: // Member variables 00083 CStoreDatabaseMainView* iMainView; 00084 CFileStore* iFileStore; 00085 RDbStoreDatabase iDatabase; 00086 00087 RPointerArray<CEmployee> iArray; 00088 00089 TStatus iStatus; 00090 }; 00091 00092 #endif // STOREDATABASEAPPUI_H 00093 00094 // End of File