public async Task <JsonResult> PupupLookupData(int PopupType, string SearchValue)
{
PopupLookupRequestModel collection = new PopupLookupRequestModel();
var draw = HttpContext.Request.Form["draw"].FirstOrDefault();
// Skiping number of Rows count
var start = Request.Form["start"];
// Paging Length 10,20
var length = Request.Form["length"];
// Sort Column Name
var sortColumn = Request.Form["columns[" + Request.Form["order[0][column]"].FirstOrDefault() + "][name]"];
// Sort Column Direction ( asc ,desc)
var sortColumnDirection = Request.Form["order[0][dir]"];
// Search Value from (Search box)
// var searchValue = SearchValue;// Request.Form["search[value]"];
if (string.IsNullOrWhiteSpace(SearchValue) || string.IsNullOrEmpty(SearchValue))
{
SearchValue = string.Empty;
}
//Paging Size (10,20,50,100)
int pageSize = length != null?Convert.ToInt32(length) : 0;
int skip = start != null?Convert.ToInt32(start) : 0;
collection.PageNo = skip;
collection.PageSize = pageSize;
collection.SortOrder = sortColumnDirection;
collection.SortColumn = sortColumn;
collection.SearchValue = SearchValue;
collection.LookType = PopupType;
var stringContent = new StringContent(JsonConvert.SerializeObject(collection).ToString(), Encoding.UTF8, "application/json");
var list = await objLookupService.GetPoupupLookupData(stringContent);
return(ReturnData(list.DataList, (PopLookupTypes)collection.LookType, list.TotalRecord, draw));
}
public override PopupLookupResponseModel GetAllData(PopupLookupRequestModel objPopupLookupModel)
{
PopupLookupResponseModel objPopupLookupResponseModel = new PopupLookupResponseModel();
GEEDbContext context = new GEEDbContext();
var cadDetailList = (from candDet in context.CandidateDetails
select new
{
candDet.CandidateDetail_ID,
candDet.FirstName,
candDet.Lastname,
candDet.FatheFirstName,
candDet.FatherLasttName,
candDet.ContactMobileNo,
candDet.Email
});
//This should replace with resex Key.
objPopupLookupResponseModel.StrColumnList = "CandidateDetail_ID,FirstName,Lastname,FatheFirstName,FatherLasttName,ContactMobileNo,Email";
//Sorting
if (!(string.IsNullOrEmpty(objPopupLookupModel.SortColumn) && string.IsNullOrEmpty(objPopupLookupModel.SortOrder)))
{
cadDetailList = cadDetailList.OrderBy(objPopupLookupModel.SortColumn + " " + objPopupLookupModel.SortOrder);
}
//Search
if (!string.IsNullOrEmpty(objPopupLookupModel.SearchValue))
{
cadDetailList = cadDetailList.Where(m => m.FirstName.ToLower().Contains(objPopupLookupModel.SearchValue.ToLower()) ||
m.Lastname.ToLower().Contains(objPopupLookupModel.SearchValue.ToLower()) ||
m.FatheFirstName.ToLower().Contains(objPopupLookupModel.SearchValue.ToLower()));
}
int recordsTotal = cadDetailList.Count();
var data = cadDetailList.Skip(objPopupLookupModel.PageNo).Take(objPopupLookupModel.PageSize).ToList();
objPopupLookupResponseModel.DataList = ToDataTable(data);
objPopupLookupResponseModel.TotalRecord = recordsTotal;
return(objPopupLookupResponseModel);
}
public PopupLookupResponseModel GetData(PopupLookupRequestModel objPopupLookupModel)
{
_iCommonPopupLookup = CommonPopupLookupManager.CreatePopLookup((CommonPopupLookupManager.PopLookupTypes)objPopupLookupModel.LookType);
return(_iCommonPopupLookup.GetAllData(objPopupLookupModel));
}
public abstract PopupLookupResponseModel GetAllData(PopupLookupRequestModel objPopupLookupModel);
