public ActionResult ReportSearch(TimeSheetReportViewModel tsrvm)
{
tsrvm.EmployeeID = int.Parse(Session["IDEmployee"].ToString());
List <TimeSheet> TS = Repo.GetTimeSheetReports(tsrvm);
return(View("ReportShow", TS));
}
internal static List <TimeSheet> GetTimeSheetReports(TimeSheetReportViewModel tsrvm)
{
List <TimeSheet> TSList = new List <TimeSheet>();
SqlParameter[] Param = new SqlParameter[3];
Param[0] = new SqlParameter("@TimeSheetDateStart", SqlDbType.DateTime);
Param[0].Value = tsrvm.StartDate.ToString("yyyy-MM-dd");
Param[1] = new SqlParameter("@TimeSheetDateEnd", SqlDbType.DateTime);
Param[1].Value = tsrvm.EndDate.ToString("yyyy-MM-dd");
Param[2] = new SqlParameter("@EmployeeID", SqlDbType.Int);
Param[2].Value = tsrvm.EmployeeID;
DataTable dtTS = SqlHelper.ExecuteDataset(cs, "GetTimeSheets", Param).Tables[0];
foreach (DataRow row in dtTS.Rows)
{
TimeSheet timeSheet = new TimeSheet
{
ID = (int)row["IDTimeSheet"],
EmployeeID = (int)row["EmployeeID"],
TimeSheetDate = (DateTime)row["TimeSheetDate"],
WorkHoursSum = (int)row["WorkHours"],
OverTimeHoursSum = (int)row["OverTimeHours"],
TimesheetStatus = (TimesheetStatus)((int)row["TimeSheetStatus"])
};
TSList.Add(timeSheet);
}
return(TSList);
}
public ActionResult ReportSearch()
{
TimeSheetReportViewModel tsrvm = new TimeSheetReportViewModel
{
StartDate = DateTime.Now.AddDays(-1),
EndDate = DateTime.Now,
EmployeeID = int.Parse(Session["IDEmployee"].ToString())
};
return(View(tsrvm));
}
