public IActionResult Detail()
{
SSISPayrollLogic logic = new SSISPayrollLogic(_context);
DataTable dt1 = logic.ssisPayroll_getPayroll_staging();
return(View(dt1));
}
public IActionResult SSIStoMunis()
{
SSISPayrollLogic logic = new SSISPayrollLogic(_context);
ViewData["result1"] = logic.ssisPayroll_CreateFile();
return(View());
}
public IActionResult Detail(DateTime date1, DateTime date2)
{
SSISPayrollLogic logic = new SSISPayrollLogic(_context);
// logic.ssisPayroll_Loading_Record(date1, date2);
logic.ssisPayroll_Coding();
logic.ssisPayroll_Validation();
DataTable dt1 = logic.ssisPayroll_getPayroll_staging();
return(View(dt1));
}
public IActionResult SSISPayrollFullDetail(string employeenbr)
{
SSISPayrollLogic logic = new SSISPayrollLogic(_context);
DataTable dt0 = logic.ssisPayroll_getPayroll_staging(employeenbr);
DataTable dt1;
dt1 = logic.ssisPayroll_getDetail(employeenbr);
ViewData["empl_name"] = dt0.Rows[0][dt0.Columns["empl_name"]].ToString();
ViewData["empl_nbr"] = dt0.Rows[0][dt0.Columns["empl_nbr"]].ToString();
ViewData["reg_hrs"] = dt0.Rows[0][dt0.Columns["regular"]].ToString();
ViewData["hol_hrs"] = dt0.Rows[0][dt0.Columns["hol_hrs"]].ToString();
ViewData["comp"] = dt0.Rows[0][dt0.Columns["comp"]].ToString();
ViewData["ot"] = dt0.Rows[0][dt0.Columns["overtime"]].ToString();
return(PartialView("_DetailPartial", dt1));
}
