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