private static SqlParameter[] CreateSqlParameter(TMSMissingScanTime model)
{
return(new SqlParameter[]
{
new SqlParameter("@EntityID", model.EntityID),
new SqlParameter("@EmployeeNo", model.EmployeeNo),
new SqlParameter("@EmployeeCode", model.EmployeeCode),
new SqlParameter("@FirstName_EN", model.FirstName_EN),
new SqlParameter("@MiddleName_EN", model.MiddleName_EN),
new SqlParameter("@LastName_EN", model.LastName_EN),
new SqlParameter("@Work_Date", model.Work_Date),
new SqlParameter("@InTime", model.InTime),
new SqlParameter("@OutTime", model.OutTime),
new SqlParameter("@ST_InTime", model.ST_InTime),
new SqlParameter("@ST_OutTime", model.ST_OutTime),
new SqlParameter("@DirectManager", model.DirectManager),
new SqlParameter("@DomainId", model.DomainId),
});
}
private static TMSMissingScanTime GetItemFromReader(IDataReader dataReader)
{
TMSMissingScanTime objItem = new TMSMissingScanTime();
objItem.EntityID = SqlHelper.GetInt(dataReader, "EntityID");
objItem.EmployeeNo = SqlHelper.GetString(dataReader, "EmployeeNo");
objItem.EmployeeCode = SqlHelper.GetInt(dataReader, "EmployeeCode");
objItem.FirstName_EN = SqlHelper.GetString(dataReader, "FirstName_EN");
objItem.MiddleName_EN = SqlHelper.GetString(dataReader, "MiddleName_EN");
objItem.LastName_EN = SqlHelper.GetString(dataReader, "LastName_EN");
objItem.Work_Date = SqlHelper.GetDateTime(dataReader, "Work_Date");
objItem.InTime = SqlHelper.GetDateTime(dataReader, "InTime");
objItem.OutTime = SqlHelper.GetDateTime(dataReader, "OutTime");
objItem.ST_InTime = SqlHelper.GetDateTime(dataReader, "ST_InTime");
objItem.ST_OutTime = SqlHelper.GetDateTime(dataReader, "ST_OutTime");
objItem.DirectManager = SqlHelper.GetInt(dataReader, "DirectManager");
objItem.DomainId = SqlHelper.GetString(dataReader, "DomainId");
if (SqlHelper.ColumnExists(dataReader, "TotalRecord"))
{
objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord");
}
return(objItem);
}