public async Task <IActionResult> GetStaffOperationReport(JQueryDataTableParamModel param, StaffReportDto model) { using (var txscope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled)) { try { var parameters = CommonMethod.GetJQueryDatatableParamList(param, GetSortingColumnName(param.iSortCol_0)); parameters.Parameters.Insert(0, new SqlParameter("@StaffIdList", SqlDbType.VarChar) { Value = model.staffId }); parameters.Parameters.Insert(1, new SqlParameter("@Fromdate", SqlDbType.VarChar) { Value = Convert.ToDateTime(model.StartDate).ToString("yyyy/MM/dd") }); parameters.Parameters.Insert(2, new SqlParameter("@Todate", SqlDbType.VarChar) { Value = Convert.ToDateTime(model.EndDate).ToString("yyyy/MM/dd") }); var allList = await _staffLog.GetStaffOperationReport(parameters.Parameters.ToArray()); var total = allList.FirstOrDefault()?.TotalRecords ?? 0; return(Json(new { param.sEcho, iTotalRecords = total, iTotalDisplayRecords = total, aaData = allList })); } catch (Exception ex) { ErrorLog.AddErrorLog(ex, "GetStaffOperationReport"); return(Json(new { param.sEcho, iTotalRecords = 0, iTotalDisplayRecords = 0, aaData = "" })); } } }
public IActionResult CreateReport(StaffReportDto model) { return(View(model)); }