public async Task <IActionResult> GetCountWiseTutorReport(JQueryDataTableParamModel param, TutorFilterLessionWiseAnswerDto model)
{
using (var txscope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
try
{
var parameters = CommonMethod.GetJQueryDatatableParamList(param, GetSortingColumnName(param.iSortCol_0));
parameters.Parameters.Insert(0, new SqlParameter("@Fromdate", SqlDbType.DateTime)
{
Value = Convert.ToDateTime(model.FromDate).ToString("yyyy/MM/dd")
});
parameters.Parameters.Insert(1, new SqlParameter("@Todate", SqlDbType.DateTime)
{
Value = Convert.ToDateTime(model.ToDate).ToString("yyyy/MM/dd")
});
parameters.Parameters.Insert(2, new SqlParameter("@TutorId", SqlDbType.Int)
{
Value = model.Tid
});
var allList = await _tutorService.GetCountWiseTutorReport(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, "GetFilterTutorReport");
return(Json(new
{
param.sEcho,
iTotalRecords = 0,
iTotalDisplayRecords = 0,
aaData = ""
}));
}
}
}