public async Task <IActionResult> GetFilterTutorList(JQueryDataTableParamModel param, TutorFiltorDto model)
{
using (var txscope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled))
{
try
{
var parameters = CommonMethod.GetJQueryDatatableParamList(param, GetSortingColumnName(param.iSortCol_0));
if (model.TutorisActive == true && model.TutorisInActive == false)
{
parameters.Parameters.Insert(2, new SqlParameter("@IsActive", SqlDbType.Bit)
{
Value = true
});
}
if (model.TutorisInActive == true && model.TutorisActive == false)
{
parameters.Parameters.Insert(2, new SqlParameter("@IsActive", SqlDbType.Bit)
{
Value = false
});
}
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")
});
var allList = await _tutorService.GetFilterTutorReport(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 = ""
}));
}
}
}
