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