public static External_TimesCollection GetAllItemByMonth(DateTime FromDate, DateTime ToDate, int UserID, string FilterBy, string FilterValue)
{
var pars = new SqlParameter[]
{
new SqlParameter("@FromDate", FromDate),
new SqlParameter("@ToDate", ToDate),
new SqlParameter("@FilterBy", FilterBy),
new SqlParameter("@FilterValue", FilterValue),
new SqlParameter("@ManagerID", UserID),
new SqlParameter("@OrderBy", "AssociateNo"),
new SqlParameter("@OrderDirection", 1),
};
External_TimesCollection collection = new External_TimesCollection();
using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "USP_TMS_External_AssociatesTimeSheet_Get_MonthlyScantime_V1", pars))
{
//return CommonHelper.DataReaderToList<External_TimesCollection>(reader);
External_Times obj = new External_Times();
while (reader.Read())
{
obj = GetMonthly(reader);
collection.Add(obj);
}
}
return(collection);
}
private static External_Times GetMonthly(IDataReader dataReader)
{
External_Times objItem = new External_Times();
objItem.AssociateNo = SqlHelper.GetString(dataReader, "AssociateNo");
objItem.AssociateName = SqlHelper.GetString(dataReader, "AssociateName");
objItem.JoinDate = SqlHelper.GetDateTime(dataReader, "JoinDate");
objItem.EndDate = SqlHelper.GetDateTime(dataReader, "EndDate");
objItem.Standard = SqlHelper.GetDecimal(dataReader, "Standard");
objItem.Actual = SqlHelper.GetDecimal(dataReader, "Actual");
objItem.IsActive = SqlHelper.GetBoolean(dataReader, "IsActive");
objItem.NT_ID = SqlHelper.GetString(dataReader, "NT_ID");
objItem.AccessCardNo = SqlHelper.GetInt(dataReader, "AccessCardNo");
objItem.VendorName = SqlHelper.GetString(dataReader, "VendorName");
objItem.Role = SqlHelper.GetString(dataReader, "Role");
objItem.DeptName = SqlHelper.GetString(dataReader, "DeptName");
objItem.DeptName = SqlHelper.GetString(dataReader, "DeptName");
objItem.GroupName = SqlHelper.GetString(dataReader, "GroupName");
objItem.ProjectCode = SqlHelper.GetString(dataReader, "ProjectCode");
objItem.PONumber = SqlHelper.GetString(dataReader, "PONumber");
objItem.DirectManager = SqlHelper.GetString(dataReader, "DirectManager");
return(objItem);
}