//[Authorize(Roles = AdmissionConstants.ENQUIRY_GET_ROLE)]
public JsonResult <List <EnquiryModel> > GetEnquiryDetailsWithPagingSorting(IndexScreenParameterModel IndexScreenParameterModel)
{
try
{
string SelectColumn = string.Empty, SearchValue = string.Empty;
string searchColumn = string.Empty;
foreach (var item in IndexScreenParameterModel.IndexScreenSelectParameterModel)
{
SelectColumn += item.SelectParameter + ",";
}
if (IndexScreenParameterModel.IndexScreenSearchParameterModel != null)
{
if (IndexScreenParameterModel.IndexScreenSearchParameterModel.Count > 0)
{
SearchValue = "Where ";
foreach (var itemSearch in IndexScreenParameterModel.IndexScreenSearchParameterModel)
{
if (!string.IsNullOrEmpty(searchColumn))
{
searchColumn += " AND ";
}
if (itemSearch.SearchParameterDataType.ToLower() == "string")
{
searchColumn += itemSearch.SearchParameter + " LIKE '%" + itemSearch.SearchParameterValue + "%' ";
}
else
{
searchColumn += itemSearch.SearchParameter + "=" + itemSearch.SearchParameterValue;
}
}
}
}
SearchValue = SearchValue + searchColumn;
var objList = _enquiry.GetEnquiryDetailsWithPagingSorting(SelectColumn.Substring(0, SelectColumn.Length - 1), SearchValue, IndexScreenParameterModel.PageNo, IndexScreenParameterModel.PageSize, IndexScreenParameterModel.SortColumn, IndexScreenParameterModel.SortOrder);
return(Json(objList));
}
catch (Exception ex)
{
Common.MyLogger.Error(ex.Message + ex.StackTrace + ex.InnerException.ToString());
return(null);
}
}
