public JsonResult DataHandler(DTParameters param) { try { Models.SearchParemeters keyword = new SearchParemeters(); var dtsource = new List <AffidavitViewModel>(); List <String> columnSearch = new List <string>(); foreach (var col in param.Columns) { //switch (col.Data) //{ // case "aff_no": // keyword.AffidavitId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "property_id": // keyword.PropertyId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "post_dt": // keyword.InspectionDate = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "date_added": // keyword.AffidavitId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "notes": // keyword.AffidavitId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "designator": // keyword.AffidavitId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "property_desc": // keyword.AffidavitId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; //} columnSearch.Add(col.Search.Value); } dtsource = api.GetAffidavitByKeyword(keyword); List <AffidavitViewModel> data = new AffidavitResultSet().GetResult(param.Search.Value, param.SortOrder, param.Start, param.Length, dtsource, columnSearch); int count = new AffidavitResultSet().Count(param.Search.Value, dtsource, columnSearch); DTResult <AffidavitViewModel> result = new DTResult <AffidavitViewModel> { draw = param.Draw, data = data, recordsFiltered = count, recordsTotal = count }; return(Json(result)); } catch (Exception ex) { return(Json(new { error = ex.Message })); } }
public JsonResult DataHandler(DTParameters param) { try { Models.SearchParemeters keyword = new SearchParemeters(); var dtsource = new List <NoticeLetterViewModel>(); List <String> columnSearch = new List <string>(); foreach (var col in param.Columns) { //switch (col.Data) //{ // case "aff_no": // keyword.AffidavitId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "property_id": // keyword.PropertyId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "post_dt": // keyword.InspectionDate = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "date_added": // keyword.AffidavitId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "notes": // keyword.AffidavitId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "designator": // keyword.AffidavitId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; // case "property_desc": // keyword.AffidavitId = col.Search.Value; // param.Search.Value = col.Search.Value; // break; //} if (col.Data == "post_dt") { columnSearch.Add(ApplicationCommonClass.ConvertSearchDateFormat(col.Search.Value)); } else { columnSearch.Add(col.Search.Value); } } keyword.FromDate = (string.IsNullOrEmpty(param.FromDate) ? null : Convert.ToDateTime(param.FromDate).ToString("MM/dd/yyyy")); keyword.ToDate = (string.IsNullOrEmpty(param.ToDate) ? null : Convert.ToDateTime(param.ToDate).ToString("MM/dd/yyyy")); dtsource = api.GetAffidavitByParameters(keyword); List <NoticeLetterViewModel> data = new ResultSet().GetResult(param.Search.Value, param.SortOrder, param.Start, param.Length, dtsource, columnSearch); int count = new ResultSet().Count(param.Search.Value, dtsource, columnSearch); DTResult <NoticeLetterViewModel> result = new DTResult <NoticeLetterViewModel> { draw = param.Draw, data = data, recordsFiltered = count, recordsTotal = count }; return(Json(result)); } catch (Exception ex) { return(Json(new { error = ex.Message })); } }