/*===========================================================================

FILE: databasesample.c
===========================================================================*/


/*===============================================================================
INCLUDES AND VARIABLE DEFINITIONS
=============================================================================== */
#include "AEEModGen.h"          // Module interface definitions
#include "AEEAppGen.h"          // Applet interface definitions
#include "AEEShell.h"           // Shell interface definitions
#include "AEEFile.h"			// File interface definitions
#include "AEEDB.h"				// Database interface definitions

#include "databasesample.bid"

/*-------------------------------------------------------------------
Function Prototypes
-------------------------------------------------------------------*/
static boolean databasesample_HandleEvent(IApplet * pi, AEEEvent eCode, 
                                      uint16 wParam, uint32 dwParam);

/*===============================================================================
FUNCTION DEFINITIONS
=============================================================================== */
static boolean AddRecordToDB(IShell *pIShell);
static boolean DelRecordFromDB(IShell *pIShell);

/*===========================================================================

FUNCTION: AEEClsCreateInstance

DESCRIPTION
	This function is invoked while the app is being loaded. All Modules must provide this 
	function. Ensure to retain the same name and parameters for this function.
	In here, the module must verify the ClassID and then invoke the AEEApplet_New() function
	that has been provided in AEEAppGen.c. 

   After invoking AEEApplet_New(), this function can do app specific initialization. In this
   example, a generic structure is provided so that app developers need not change app specific
   initialization section every time except for a call to IDisplay_InitAppData(). 
   This is done as follows: InitAppData() is called to initialize AppletData 
   instance. It is app developers responsibility to fill-in app data initialization 
   code of InitAppData(). App developer is also responsible to release memory 
   allocated for data contained in AppletData -- this can be done in 
   IDisplay_FreeAppData().

PROTOTYPE:
   int AEEClsCreateInstance(AEECLSID ClsId,IShell * pIShell,IModule * po,void ** ppObj)

PARAMETERS:
	clsID: [in]: Specifies the ClassID of the applet which is being loaded

	pIShell: [in]: Contains pointer to the IShell object. 

	pIModule: pin]: Contains pointer to the IModule object to the current module to which
	this app belongs

	ppObj: [out]: On return, *ppObj must point to a valid IApplet structure. Allocation
	of memory for this structure and initializing the base data members is done by AEEApplet_New().

DEPENDENCIES
  none

RETURN VALUE
  AEE_SUCCESS: If the app needs to be loaded and if AEEApplet_New() invocation was
     successful
  EFAILED: If the app does not need to be loaded or if errors occurred in 
     AEEApplet_New(). If this function returns FALSE, the app will not be loaded.

SIDE EFFECTS
  none
===========================================================================*/
int AEEClsCreateInstance(AEECLSID ClsId,IShell * pIShell,IModule * po,void ** ppObj)
{
   *ppObj = NULL;
		
   if(ClsId == AEECLSID_DATABASESAMPLE){
      if(AEEApplet_New(sizeof(AEEApplet), ClsId, pIShell,po,(IApplet**)ppObj,
         (AEEHANDLER)databasesample_HandleEvent,NULL)
         == TRUE)
      {
		 // Add your code here .....

         return (AEE_SUCCESS);
      }
   }
	return (EFAILED);
}

/*===========================================================================

FUNCTION databasesample_HandleEvent

DESCRIPTION
	This is the EventHandler for this app. All events to this app are handled in this
	function. All APPs must supply an Event Handler.

PROTOTYPE:
	boolean databasesample_HandleEvent(IApplet * pi, AEEEvent eCode, uint16 wParam, uint32 dwParam)

PARAMETERS:
	pi: Pointer to the AEEApplet structure. This structure contains information specific
	to this applet. It was initialized during the AEEClsCreateInstance() function.

	ecode: Specifies the Event sent to this applet

   wParam, dwParam: Event specific data.

DEPENDENCIES
  none

RETURN VALUE
  TRUE: If the app has processed the event
  FALSE: If the app did not process the event

SIDE EFFECTS
  none
===========================================================================*/
static boolean databasesample_HandleEvent(IApplet * pi, AEEEvent eCode, uint16 wParam, uint32 dwParam)
{  
	AECHAR hints1[6] = {'(','N', 'O', 'T', 'E', ')'};
	AECHAR hints2[12] = {'P','r','e','s','s',' ','1',' ','A','D','D','!'};
	AECHAR hints3[12] = {'P','r','e','s','s',' ','2',' ','D','E','L','!'};

	AECHAR hints4[12] = {'A','D','D',' ','S','u','c','c','e','s','s','!'};
	AECHAR hints5[11] = {'A','D','D',' ','F','a','i','l','e','d','!'};
	
	AECHAR hints6[12] = {'D','E','L',' ','S','u','c','c','e','s','s','!'};
	AECHAR hints7[11] = {'D','E','L',' ','F','a','i','l','e','d','!'};

	AEEApplet *pAEEApplet = (AEEApplet *)pi;
	IDisplay  *pIDisplay  = pAEEApplet->m_pIDisplay;
	IShell	  *pIShell    = pAEEApplet->m_pIShell;

   switch (eCode) 
	{
      case EVT_APP_START:                        
		    IDISPLAY_ClearScreen(pIDisplay);
			IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints1,
				6, 0, 20, NULL, IDF_ALIGN_CENTER);
			IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints2, 
				12, 0, 40, NULL, IDF_ALIGN_CENTER);
			IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints3,
				12, 0, 60, NULL, IDF_ALIGN_CENTER);
			IDISPLAY_Update(pIDisplay);
		    // Add your code here .....

      		return(TRUE);
      case EVT_APP_STOP:
	
		    // Add your code here .....
	  case EVT_KEY:
		  switch(wParam)
		  {
		  case AVK_1:
			  IDISPLAY_ClearScreen(pIDisplay);
			  IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints1,
				6, 0, 20, NULL, IDF_ALIGN_CENTER);
			  IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints2, 
				12, 0, 40, NULL, IDF_ALIGN_CENTER);
			  IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints3,
				12, 0, 60, NULL, IDF_ALIGN_CENTER);
			  if(AddRecordToDB(pIShell) == SUCCESS){
				IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints4,
					12, 0, 90, NULL, IDF_ALIGN_CENTER);
			  }
			  else{
				IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints5,
					11, 0, 90, NULL, IDF_ALIGN_CENTER);
			  }
			  IDISPLAY_Update(pIDisplay);
			  
			  return TRUE;
		  case AVK_2:
			  IDISPLAY_ClearScreen(pIDisplay);
			  IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints1,
				6, 0, 20, NULL, IDF_ALIGN_CENTER);
			  IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints2, 
				12, 0, 40, NULL, IDF_ALIGN_CENTER);
			  IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints3,
				12, 0, 60, NULL, IDF_ALIGN_CENTER);
			  if(DelRecordFromDB(pIShell) == SUCCESS){
				IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints6,
					12, 0, 90, NULL, IDF_ALIGN_CENTER);
			  }
			  else{
				IDISPLAY_DrawText(pIDisplay, AEE_FONT_NORMAL, hints7,
					11, 0, 90, NULL, IDF_ALIGN_CENTER);
			  }
			  IDISPLAY_Update(pIDisplay);
			  return TRUE;
		  default:
			  break;
		  }
         return FALSE;
      default:
         break;
   }
   return FALSE;
}


/************************************************************************
/* 函數功能：向數據庫中添加一條記錄
/*
/* 參數：
/*		pIShell － IShell接口指針
/*
/* 返回值：
/*		SUCCESS － 執行成功
/*		EFAILED -  執行失敗                                                                 
************************************************************************/
boolean AddRecordToDB(IShell *pIShell)
{
	//數據庫名
	const char *dbName = "mydatabase";
	//添加的數據
	const char *data = "BREW2.0";
	
	//IDBMgr接口指針
	IDBMgr    *pIDBMgr = NULL;
	//IDatabase接口指針
	IDatabase *pIDatabase = NULL;
	//IDBRecord接口指針
	IDBRecord *pIDBRecord = NULL;

	//記錄字段
	AEEDBField dbField;
	dbField.fType = AEEDB_FT_STRING;		//字段類型
	dbField.fName = AEEDBFIELD_FULLNAME;	//字段名稱
	dbField.wDataLen = sizeof(data);		//字段的數據長度
	dbField.pBuffer = (void*)data;			//字段數據指針
	
	//創建IDBMgr接口實例
	if(ISHELL_CreateInstance(pIShell, AEECLSID_DBMGR, (void **)&pIDBMgr) != SUCCESS){
		//創建失敗
		return EFAILED;
	}
	
	//打開數據庫
	if((pIDatabase = IDBMGR_OpenDatabase(pIDBMgr, dbName, TRUE)) == NULL){
		//打開失敗
		IDBMGR_Release(pIDBMgr);
		return EFAILED;
	}

	//在數據庫中創建一條預先定義的記錄記錄
	if((pIDBRecord = IDATABASE_CreateRecord(pIDatabase, &dbField, 1)) == NULL){
		//創建失敗
		IDATABASE_Release(pIDatabase);
		IDBMGR_Release(pIDBMgr);
		return EFAILED;
	}
	
	//釋放IDBRecord接口實例
	IDBRECORD_Release(pIDBRecord);
	//釋放IDatabase接口實例
	IDATABASE_Release(pIDatabase);
	//釋放IDBMgr接口實例
	IDBMGR_Release(pIDBMgr);
	
	return SUCCESS;
}

/************************************************************************
/* 函數功能：刪除數據庫中的一條記錄
/*
/* 參數：
/*		pIShell － IShell接口指針
/*
/* 返回值：
/*		SUCCESS － 執行成功
/*		EFAILED -  執行失敗                                                                 
************************************************************************/
boolean DelRecordFromDB(IShell *pIShell)
{
	//數據庫名
	const char *dbName = "mydatabase";

	//IDBMgr接口指針
	IDBMgr    *pIDBMgr = NULL;
	//IDababase接口指針
	IDatabase *pIDatabase = NULL;
	//IDBRecord接口指針
	IDBRecord *pIDBRecord = NULL;
	
	//創建IDBMgr接口實例
	if(ISHELL_CreateInstance(pIShell, AEECLSID_DBMGR, (void **)&pIDBMgr) != SUCCESS){
		//創建失敗
		return EFAILED;
	}
	
	//打開數據庫
	if((pIDatabase = IDBMGR_OpenDatabase(pIDBMgr, dbName, TRUE)) == NULL){
		//打開失敗
		IDBMGR_Release(pIDBMgr);
		return EFAILED;
	}
	
	//重置數據庫的索引，使數據庫的訪問從頭開始
	IDATABASE_Reset(pIDatabase);
	//獲得數據庫中的一條記錄
	if((pIDBRecord = IDATABASE_GetNextRecord(pIDatabase)) == NULL){
		//獲取失敗
		IDATABASE_Release(pIDatabase);
		IDBMGR_Release(pIDBMgr);
		return EFAILED;
	}
	
	//刪除從數據庫中獲得的記錄
	//（注意：刪除成功后不用再調用IDBRECORD_Release()來釋放IDBRecord接口實例）
	if(IDBRECORD_Remove(pIDBRecord) != SUCCESS)
	{
		//刪除失敗
		IDBRECORD_Release(pIDBRecord);
		IDATABASE_Release(pIDatabase);
		IDBMGR_Release(pIDBMgr);
		return EFAILED;
	}
	
	//釋放IDatabase接口實例
	IDATABASE_Release(pIDatabase);
	//釋放IDBMgr接口實例
	IDBMGR_Release(pIDBMgr);

	return SUCCESS;
}