private static ExternalDaily GetItem(IDataReader dataReader) { ExternalDaily objItem = new ExternalDaily(); objItem.AssociateNo = SqlHelper.GetString(dataReader, "AssociateNo"); objItem.AssociateName = SqlHelper.GetString(dataReader, "AssociateName"); objItem.Work_Date = SqlHelper.GetDateTime(dataReader, "Work_Date"); objItem.JoinDate = SqlHelper.GetDateTime(dataReader, "JoinDate"); objItem.EndDate = SqlHelper.GetDateTime(dataReader, "EndDate"); objItem.RootIn = SqlHelper.GetString(dataReader, "InTime"); objItem.RootOut = SqlHelper.GetString(dataReader, "OutTime"); objItem.WorkHour = SqlHelper.GetDecimal(dataReader, "WorkHour"); return(objItem); }
public static ExternalDailyCollection GetExDailyTMS(int ManagerID, string FD, string TD, int AID) { var pars = new SqlParameter[] { new SqlParameter("@FromDate", FD), new SqlParameter("@ToDate", TD), new SqlParameter("@ManagerID", ManagerID), new SqlParameter("@AssosiateID", AID), }; ExternalDailyCollection collection = new ExternalDailyCollection(); using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "USP_TMS_Associate_GetByManager", pars)) { ExternalDaily obj = new ExternalDaily(); while (reader.Read()) { obj = GetItem(reader); collection.Add(obj); } } return(collection); }