Beispiel #1
0
        public DataTable GetDataTable(string strSQL, string TableName)
        {
            DataTable dt = null;

            try
            {
                using (SQLiteConnection scon = new SQLiteConnection(DataAccessUtilities.CreateSQLiteConnectionString()))
                {
                    scon.Open();
                    SQLiteCommand com = new SQLiteCommand(strSQL, scon);
                    using (SQLiteDataReader dr = com.ExecuteReader())
                    {
                        dt = new DataTable(TableName);
                        dt.Load(dr);
                        dr.Close();
                    }
                    com.Dispose();
                    scon.Close();
                    scon.Dispose();
                }
            }
            catch (Exception ex)
            {
                LogManager.Instance.LogMessage("Error in GetDataTable", ex);
            }
            return(dt);
        }
Beispiel #2
0
        public bool SyncClientDatabase()
        {
            bool ReturnStatus = true;

            try
            {
                UpdateEventMessage("Syncing Client and Server");

                //=================================================================
                //Testing Code
                //=================================================================
                //if ( System.Diagnostics.Debugger.IsAttached )
                //    if (ClientDatabaseExist())
                //        return true;
                //=================================================================

                DeleteClientDatabase();
                InitClientDatabase();

                string sqliteConnString = DataAccessUtilities.CreateSQLiteConnectionString();

                using (SQLiteConnection conn = new SQLiteConnection(sqliteConnString))
                {
                    conn.Open();
                    foreach (string TableName in DataAccessUtilities.SyncTableNames())
                    {
                        i9Message responseMsg = i9MessageManager.SendMessage(MobileMessageType.SyncCache, SyncCacheType.GetFullTable, "SyncClientDatabase", typeof(string), TableName);
                        if (responseMsg.ErrorStatus.IsError)
                        {
                            UpdateEventMessage("Error Syncing Table " + TableName + " - Error Message: " + responseMsg.ErrorStatus.ErrorMsg);
                            ReturnStatus = false;
                        }
                        else
                        {
                            UpdateEventMessage("   " + TableName);
                            LoadData(conn, responseMsg.MsgBodyDataSet, TableName);
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                UpdateEventMessage("Error Syncing Tables - Error Message: " + ex.Message);
                LogManager.Instance.LogMessage("Sync method error", ex);
                ReturnStatus = false;
            }

            return(ReturnStatus);
        }