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);
}