private static MissingScanTime BindScanTimeData(IDataReader dataReader) { MissingScanTime objItem = new MissingScanTime(); 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.ST_InTime = SqlHelper.GetString(dataReader, "ST_InTime"); objItem.ST_OutTime = SqlHelper.GetString(dataReader, "ST_OutTime"); objItem.InTime = SqlHelper.GetString(dataReader, "InTime"); objItem.OutTime = SqlHelper.GetString(dataReader, "OutTime"); objItem.DirectManager = SqlHelper.GetInt(dataReader, "DirectManager"); objItem.DomainId = SqlHelper.GetString(dataReader, "DomainId"); return(objItem); }
public static MissingScanTimeCollection GetMissingScanTime(MissCanTimePara objPara) { var pars = new SqlParameter[] { new SqlParameter("@EmployeeCode", objPara.EmployeeCode), new SqlParameter("@StartDate", objPara.StartDate), new SqlParameter("@EndDate", objPara.EndDate), new SqlParameter("@EntityID", objPara.EntityID), }; MissingScanTimeCollection collection = new MissingScanTimeCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "USP_TMS_NotFillScanTime_Report", pars)) { MissingScanTime obj = new MissingScanTime(); while (reader.Read()) { obj = BindScanTimeData(reader); collection.Add(obj); } } return(collection); }