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