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