private SQLiteDataReader returnTimeIns()
{
clsLocalDB objLocalDB = new clsLocalDB(resStaticData.localDB);
string SQL = "SELECT ID, PersonID, TimeIn";
SQL = SQL + " FROM remoteTime";
SQL = SQL + " WHERE TimeIn_Added='false'";
SQLiteDataReader objReader = objLocalDB.returnDataReader(SQL);
return(objReader);
}
private SQLiteDataReader returnTimeOuts()
{
clsLocalDB objLocalDB = new clsLocalDB(resStaticData.localDB);
string SQL = "SELECT ID, MySQL_ID, TimeOut";
SQL = SQL + " FROM remoteTime";
SQL = SQL + " WHERE TimeOut is not null";
SQL = SQL + " AND TimeOut_Added= 'false'";
SQL = SQL + " AND MySQL_ID is not null";
SQLiteDataReader objReader = objLocalDB.returnDataReader(SQL);
return(objReader);
}
private void updateRemoteDB(List <Times> objQueries, string strType)
{
clsRemoteDB objRemoteDB = new clsRemoteDB();
clsLocalDB objLocalDB = new clsLocalDB(resStaticData.localDB);
int totalIns = 0, totalOuts = 0;
clsLog objLog = new clsLog();
foreach (Times i in objQueries)
{
string Query = i.Query;
int SQLiteID = i.SQLite_ID;
int Rows;
if (strType == "TimeIn")
{
int MySQL_ID = objRemoteDB.Update_MySQL(Query, "TimeIn");
if (MySQL_ID != -1)
{
objLocalDB.addMySQLID(MySQL_ID, SQLiteID);
totalIns++;
}
else
{
objLog.writeToLog("There was an error adding sqlite_ID = " + SQLiteID.ToString() + " to remoteDB.");
totalIns--;
}
}
else if (strType == "TimeOut")
{
Rows = objRemoteDB.Update_MySQL(Query, "TimeOut");
if (Rows > 0)
{
objLocalDB.updateTimeOut_Added(SQLiteID);
totalOuts++;
}
else
{
totalOuts--;
}
}
}
objLog.writeToLog(returnLogMsg(totalOuts + totalIns, strType));
}