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