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