public async Task <IActionResult> GetViewQAReport(JQueryDataTableParamModel param, QADto 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("@GradeId", SqlDbType.VarChar)
{
Value = model.GradeList
});
parameters.Parameters.Insert(3, new SqlParameter("@AnsweredQuestion", SqlDbType.Int)
{
Value = model.ansSlectionType
});
var allList = await _questionResponseService.GetQAReport(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, "ViewQAReport");
return(Json(new
{
param.sEcho,
iTotalRecords = 0,
iTotalDisplayRecords = 0,
aaData = ""
}));
}
}
}
public IActionResult ViewQAReport(QADto model)
{
return(View(model));
}
