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