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