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