private static REmployee GetItemFromReader(IDataReader dataReader) { REmployee objItem = new REmployee(); objItem.EntityID = SqlHelper.GetInt(dataReader, "EntityID"); objItem.EmployeeCode = SqlHelper.GetInt(dataReader, "EmployeeCode"); objItem.EmployeeNo = SqlHelper.GetString(dataReader, "EmployeeNo"); objItem.EmployeeName_EN = SqlHelper.GetString(dataReader, "EmployeeName_EN"); objItem.Email = SqlHelper.GetString(dataReader, "Email"); objItem.DirectManager = SqlHelper.GetInt(dataReader, "DirectManager"); objItem.DirectManagerNo = SqlHelper.GetString(dataReader, "DirectManagerNo"); objItem.DirectManagerName = SqlHelper.GetString(dataReader, "DirectManagerName"); objItem.IndirectManager = SqlHelper.GetInt(dataReader, "IndirectManager"); objItem.InDirectManagerNo = SqlHelper.GetString(dataReader, "InDirectManagerNo"); objItem.InDirectManagerName = SqlHelper.GetString(dataReader, "InDirectManagerName"); objItem.GroupCode = SqlHelper.GetInt(dataReader, "GroupCode"); objItem.GroupName = SqlHelper.GetString(dataReader, "GroupName"); objItem.DeptCode = SqlHelper.GetInt(dataReader, "DeptCode"); objItem.DeptName = SqlHelper.GetString(dataReader, "DeptName"); objItem.PositionID = SqlHelper.GetInt(dataReader, "PositionID"); objItem.PositionName = SqlHelper.GetString(dataReader, "PositionName"); objItem.IsScan = SqlHelper.GetBoolean(dataReader, "IsScan"); objItem.RangeDate = SqlHelper.GetString(dataReader, "RangeDate"); return(objItem); }
public static REmployeeCollections GetReminderList(REmployeePara objPara) { REmployeeCollections collection = new REmployeeCollections(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "USP_TMS_NotCheckINOUT_Get", new SqlParameter[] { new SqlParameter("@EntityID", objPara.EntityID), new SqlParameter("@FromDate", objPara.FromDate), new SqlParameter("@NumOfDay", objPara.NumOfDay), })) { while (reader.Read()) { REmployee obj = new REmployee(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }