public int InsertLatestPullRecord(DateTime todaysDateTime) { string sql = "insert into LatestPullRecord values(@a)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@a", todaysDateTime) }; int i = DAO.IUD(sql, param); return(i); }
public int UpdateLogData(int personId, string outTime) { string sql = "update [LogData] set OutTime=@b where PersonID=@a"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@a", personId), new SqlParameter("@b", outTime) }; int i = DAO.IUD(sql, param); return(i); }
public int InsertUser(int personID, string userName) { string sql = "insert into [User] values(@a,@b)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@a", personID), new SqlParameter("@b", userName) }; int i = DAO.IUD(sql, param); return(i); }
public int Insert(DeviceRecord deviceRecord) { string sql = "insert into LogData values(@a,@b,@c,@d,@e)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@a", deviceRecord.PersonalId), new SqlParameter("@b", deviceRecord.AttendanceDate), new SqlParameter("@c", deviceRecord.AttendanceDateTime), new SqlParameter("@d", deviceRecord.InTime), new SqlParameter("@e", deviceRecord.OutTime) }; int i = DAO.IUD(sql, param); return(i); }
public void TruncateUserTable() { string sql = "Truncate table [User]"; int j = DAO.IUD(sql); }