/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetAllAsync(DataTableParameter model) { try { var query = this.currencyRepository.Table.Include(r => r.PackageCountry).Select(x => new PackageCurrencyViewModel { Id = x.Id, CountryName = x.PackageCountry.Name, Code = x.Code, Country = x.Country, Symbol = x.Symbol, Name = x.Name, ExchangeRate = x.ExchangeRate == null ? 0 : Convert.ToDecimal(x.ExchangeRate), IsActive = x.IsActive }); var list = await this.currencyViewModelRepository.ToPagedListAsync(query, model); return(list); } catch (Exception ex) { throw ex; } }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetAllAsync(DataTableParameter model) { var query = this.homeBannerRepository.Table; var records = await this.homeBannerRepository.ToPagedListAsync(query, model); return(records); }
public async Task <IActionResult> LoadItems([FromBody] DataTableParameter obj) { IQueryable <Item> result = _context.Items.AsQueryable(); var resultCount = await _context.Items.CountAsync(); var searchValue = obj.search?.Value; if (!string.IsNullOrWhiteSpace(searchValue)) { result = result.Where(x => x.Name.Contains(searchValue) || x.Description.Contains(searchValue)); } var recordsFilteredCount = result.Count(); //todo: add filtering return(Json(new { draw = obj.draw, recordsTotal = resultCount, recordsFiltered = recordsFilteredCount, data = await result .Skip(obj.start) .Take(obj.length) .ToListAsync() })); }
public static List <UserModel> GetUserList(out int total, DataTableParameter para, string searchValue) { using (InnovatorSolutionsEntities db = new InnovatorSolutionsEntities()) { IQueryable <UserModel> datas = (from g in db.USER where g.LOGON_ENABLED == "1" && (g.FIRST_NAME.Contains(searchValue) || g.B_JOBNUMBER.Contains(searchValue) || g.EMAIL.Contains(searchValue) || g.B_CENTRE.Contains(searchValue) || g.B_DEPARTMENT.Contains(searchValue) || g.B_SENIORMANAGER.Contains(searchValue) || g.B_DIRECTOR.Contains(searchValue) || g.B_VP.Contains(searchValue)) select new UserModel() { Id = g.ID, first_Name = g.FIRST_NAME, b_JobNumber = g.B_JOBNUMBER, Email = g.EMAIL, b_Centre = g.B_CENTRE, b_Department = g.B_DEPARTMENT, b_SeniorManager = g.B_SENIORMANAGER, b_Director = g.B_DIRECTOR, b_VP = g.B_VP, b_AffiliatedCompany = g.B_AFFILIATEDCOMPANY }); //排序 if (para.sSortType == "asc") { datas = Common.OrderBy(datas, para.iSortTitle, false); } else { datas = Common.OrderBy(datas, para.iSortTitle, true); } total = datas.Count(); //分页 datas = datas.Skip(para.iDisplayStart).Take(para.iDisplayLength); return(datas.ToList()); } }
public JsonResult GetProjectManageList(DataTableParameter para, string searchValue) { int total = 0; var dataList = GetProjectManageList(Userinfo.Roles, out total, para, searchValue); if (dataList != null) { foreach (var item in dataList) { string strHtml = "<div class='row'><div class='col-md-6'>{0}</div><div class='col-md-6' style='text-align:right'>{1}</div></div>"; string linkAList = "<a class='glyphicon glyphicon-pencil edit' title='修改' Id='" + item.id + "'></a>"; linkAList += " " + "<a class='glyphicon glyphicon-eye-open detail' title='详情' id='" + item.id + "' ></a>"; linkAList += " " + "<a class='glyphicon glyphicon-remove delete' title='删除' id='" + item.id + "' ></a>"; strHtml = string.Format(strHtml, item.b_ProjectRecordNo, linkAList); item.b_ProjectRecordNo = strHtml; item.b_IsInUse = item.b_IsInUse == "1" ? "是" : "否"; if (item.b_PrIsUse != null) { item.b_PrIsUse = item.b_PrIsUse == "1" ? "是" : "否"; } item.b_ProjectName = "<div style='width:150px;word-wrap:break-word;'>" + item.b_ProjectName + "</div>"; } } return(Json(new { sEcho = para.sEcho, iTotalRecords = total, iTotalDisplayRecords = total, aaData = dataList }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Gets all asynchronous. /// </summary> /// <returns> /// Get All List /// </returns> /// <param name="model">Model.</param> public async Task <DataTableResult> GetAllVisaMasterAsync(DataTableParameter model) { try { var query = from visa in this.visaRespository.Table join country in this.packageCountryRespository.Table on visa.CountryId equals country.Id join vendor in this.vendorRespository.Table on visa.VendorID equals vendor.Id select new VisaMasterGridViewModel { Id = visa.Id, Vendor = vendor.Name + ", " + vendor.CityModel.Name + " ," + vendor.CountryModel.Name, IsActive = visa.IsActive, AdultPrice = visa.AdultPrice, ChildPrice = visa.ChildPrice, Country = country.Name, CreatedBy = visa.CreatedBy, CreatedDate = visa.CreatedDate, UpdatedBy = visa.UpdatedBy, UpdatedDate = visa.UpdatedDate }; return(await this.visaMasterGridRespository.ToPagedListAsync(query, model)); } catch (Exception ex) { string messege = ex.ToString(); return(null); } }
public JsonResult GetExpenseCategoryList(DataTableParameter para, string searchValue) { int total = 0; var dataList = GetExpenseCategoryList(out total, para, searchValue); if (dataList != null) { foreach (var item in dataList) { string strHtml = "<div class='row'><div class='col-md-6'>{0}</div><div class='col-md-6' style='text-align:right'>{1}</div></div>"; string linkAList = "<a class='glyphicon glyphicon-pencil edit' title='修改' Id='" + item.Id + "'></a>"; linkAList += " " + "<a class='glyphicon glyphicon-eye-open detail' title='详情' id='" + item.Id + "' ></a>"; linkAList += " " + "<a class='glyphicon glyphicon-remove delete' title='删除' id='" + item.Id + "' ></a>"; strHtml = string.Format(strHtml, item.b_CostName, linkAList); item.b_CostName = strHtml; } } return(Json(new { sEcho = para.sEcho, iTotalRecords = total, iTotalDisplayRecords = total, aaData = dataList }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <returns> /// Get All PaggedList /// </returns> public async Task <DataTableResult> GetAllAsync(DataTableParameter model) { var query = this.userDetailRepository.Table.OrderByDescending(x => x.CreatedDate); var records = await this.userDetailRepository.ToPagedListAsync(query, model); return(records); }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <param name="id">Vendor Identifier</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetVendorBankDetailByIdAsync(DataTableParameter model, int id) { try { var records = this.vendorBankRepo.Table.Where(x => x.VendorId == id).Select(x => new VendorBankDetailGridViewModel { Id = x.Id, AccountNumber = x.AccountNumber, AccountType = x.AccountType, BankName = x.BankName, GST = x.GST, HolderName = x.HolderName, IFSCCode = x.IFSCCode, PAN = x.PAN, SwiftCode = x.SwiftCode, IsPrimary = x.IsPrimary ? "Primary" : string.Empty, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, UpdatedBy = x.UpdatedBy, UpdatedDate = x.UpdatedDate }); return(await this.vendorBankGrid.ToPagedListAsync(records, model)); } catch (Exception ex) { string msg = ex.ToString(); return(null); } }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetAllVendorsAsync(DataTableParameter model) { try { var records = this.vendorInformationRepo.Table.Where(x => !x.IsDeleted).Select(x => new VendorGridViewModel { Id = x.Id, Category = x.CategoryModel.Name, Name = x.Name, City = x.CityModel.Name, Country = x.CountryModel.Name, Group = x.Group == 0 ? string.Empty : x.VendorGroupModel.Name, IsActive = x.IsActive, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, UpdatedBy = x.UpdatedBy, UpdatedDate = x.UpdatedDate }); return(await this.vendorGridViewModelRepo.ToPagedListAsync(records, model)); } catch (Exception ex) { string msg = ex.ToString(); return(null); } }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <param name="id">Vendor Identifier</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetVendorContractsByIdAsync(DataTableParameter model, int id) { try { var records = this.vendorContractsRepo.Table.Where(x => x.VendorId == id).Select(x => new VendorContractGridViewModel { Id = x.Id, EndDate = x.EndDate, StartDate = x.StartDate, MarginType = x.MarginTypeModel.Name, MarginValue = x.MarginValue.ToString(), CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, UpdatedBy = x.UpdatedBy, UpdatedDate = x.UpdatedDate }); return(await this.vendorContractGrid.ToPagedListAsync(records, model)); } catch (Exception ex) { string msg = ex.ToString(); return(null); } }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <param name="id">Vendor Identifier</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetVendorContactsByIdAsync(DataTableParameter model, int id) { try { var records = this.vendorContactsRepo.Table.Where(x => x.VendorId == id).Select(x => new VendorContactGridViewModel { Id = x.Id, FullName = x.Salutation + " " + x.FirstName + " " + x.LastName, Email = x.Email, Designation = x.Designation, Mobile = x.Mobile, WorkPhone = x.WorkPhone, Primary = x.IsPrimary ? "Yes" : "No", CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, UpdatedBy = x.UpdatedBy, UpdatedDate = x.UpdatedDate }); return(await this.vendorContactGrid.ToPagedListAsync(records, model)); } catch (Exception ex) { string msg = ex.ToString(); return(null); } }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetAllVendorGroupsAsync(DataTableParameter model) { try { var records = this.vendorGroupRepo.Table.Where(x => !x.IsDeleted).Select(x => new VendorGroupGridViewModel { Id = x.Id, Name = x.Name, Address = x.AddressLine1 + ", " + x.AddressLine2 + ", " + this.cityRepo.Table.Where(y => y.Id == x.CityId).Select(y => y.Name).FirstOrDefault() + ", " + this.countryRepo.Table.Where(y => y.Id == x.CountryId).Select(y => y.Name).FirstOrDefault(), Email = x.EmailId, WorkPhone = x.WorkPhone, IsActive = x.IsActive, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, UpdatedBy = x.UpdatedBy, UpdatedDate = x.UpdatedDate, ContactPerson = x.Salutation + " " + x.FName + " " + x.LName }); return(await this.vendorGroupGridRepo.ToPagedListAsync(records, model)); } catch (Exception ex) { string msg = ex.ToString(); return(null); } }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <param name="packageId">The Package Id</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetRatePlanAsync(DataTableParameter model, Guid packageId) { var query = this.ratePlanRepository.Table.Where(x => x.RoomConfigModel.PR_PackageId == packageId && !x.RP_IsDeleted).Select(x => new RatePlanGridViewModel { RoomName = x.RoomConfigModel.RoomTypeModel.Name, RP_BookingEndDate = x.RP_BookingEndDate, RP_BookingStartDate = x.RP_BookingStartDate, RP_ExtraAdultPrice = x.RP_ExtraAdultPrice, RP_ExtraChildPrice = x.RP_ExtraChildPrice, RP_ExtraInfantPrice = x.RP_ExtraInfantPrice, RP_FakePrice = x.RP_FakePrice, RP_Id = x.RP_Id, RP_IsActive = x.RP_IsActive, RP_IsDeleted = x.RP_IsDeleted, RP_Name = x.RP_Name, RP_RoomConfigId = x.RP_RoomConfigId, RP_SellingPrice = x.RP_SellingPrice, UpdatedBy = x.UpdatedBy, UpdatedDate = x.UpdatedDate, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, RP_TravelEndDate = x.RP_TravelEndDate, RP_TravelStartDate = x.RP_TravelStartDate }); return(await this.ratePlanGridModel.ToPagedListAsync(query, model)); }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetAllAsync(DataTableParameter model) { var query = this.categoryRepository.Table.Where(x => !x.IsDelete); var records = await this.categoryRepository.ToPagedListAsync(query, model); return(records); }
public ActionResult InitDataTable(DataTableParameter param) { var query = _roleService.GetAllRole(param.iDisplayStart / param.iDisplayLength, param.iDisplayLength); var filterResult = query.Select(t => new RoleListModel { Id = t.Id, Name = t.Name, SystemName = t.SystemName, Active = t.Active }); int sortId = param.iDisplayStart + 1; var result = from t in filterResult select new[] { sortId++.ToString(), t.Name, t.SystemName, t.Active.ToString(), t.Id.ToString() }; return(DataTableJsonResult(param.sEcho, param.iDisplayStart, query.TotalCount, query.TotalCount, result)); }
/// <summary> /// Gets all asynchronous. /// </summary> /// <returns> /// Get All List /// </returns> /// <param name="model">Model.</param> public async Task <DataTableResult> GetAllInsuranceMasterAsync(DataTableParameter model) { try { var query = from insurance in this.insuranceRespository.Table join vendor in this.vendorRespository.Table on insurance.VendorID equals vendor.Id select new InsuranceMasterGridViewModel { Id = insurance.Id, Vendor = vendor.Name + ", " + vendor.CityModel.Name + " ," + vendor.CountryModel.Name, IsActive = insurance.IsActive, AdultPrice = insurance.AdultRate, ChildPrice = insurance.ChildRate, Days = insurance.Days, CreatedBy = insurance.CreatedBy, CreatedDate = insurance.CreatedDate, UpdatedBy = insurance.UpdatedBy, UpdatedDate = insurance.UpdatedDate }; return(await this.insuranceMasterGridRespository.ToPagedListAsync(query, model)); } catch (Exception ex) { string messege = ex.ToString(); return(null); } }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <param name="packageId">The Package Id</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetPackageInventoryAsync(DataTableParameter model, Guid packageId) { var query = this.roomInventoryRepository.Table.Where(x => x.RoomConfigModel.PR_PackageId == packageId && !x.RI_IsDeleted).Select(x => new RoomInventoryGridViewModel { RoomName = x.RoomConfigModel.RoomTypeModel.Name, RI_BaseRate = x.RI_BaseRate, RI_ExtraAdultCost = x.RI_ExtraAdultCost, RI_ExtraChildCost = x.RI_ExtraChildCost, RI_ExtraInfantCost = x.RI_ExtraInfantCost, RI_Id = x.RI_Id, RI_Inventory = x.RI_Inventory, RI_IsActive = x.RI_IsActive, RI_IsDeleted = x.RI_IsDeleted, RI_RoomConfigId = x.RI_RoomConfigId, RI_SurgeRate = x.RI_SurgeRate, RI_EndDate = x.RI_EndDate, RI_StartDate = x.RI_StartDate, UpdatedBy = x.UpdatedBy, UpdatedDate = x.UpdatedDate, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, }); return(await this.roomInventoryGridModel.ToPagedListAsync(query, model)); }
public ActionResult List(DataTableParameter param) { string columns = Request["sColumns"]; string sortCol = Request["iSortCol_0"]; string sortDir = Request["sSortDir_0"]; int sortId = param.iDisplayStart + 1; List <INFOR_CATEGORIESModel> list = GetInforCategoryNode(""); int total = list.Count; var result = from c in list.Skip(param.iDisplayStart).Take(param.iDisplayLength) select new[] { sortId++.ToString(), c.InforCategoryName, c.DisplayOrder.ToString(), c.ParentName, c.Clevel.ToString(), CommonHelper.GetEnableStatusString(c.Status), c.ID, }; return(Json(new { sEcho = param.sEcho, iDisplayStart = param.iDisplayStart, iTotalRecords = total, iTotalDisplayRecords = total, aaData = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult InitDataTable(DataTableParameter param) { var query = _permissionService.GetAllPermission(param.iDisplayStart / param.iDisplayLength, param.iDisplayLength); var filterResult = query.Select(t => { var permission = new PermissionListModel { Id = t.Id, Icon = !string.IsNullOrEmpty(t.Icon) ? string.Format("<i class=\"fa {0}\"></i>", t.Icon) : "", Name = t.Name, BreadCrumb = _permissionService.GetFormattedBreadCrumb(t), LinkUrl = string.IsNullOrEmpty(t.Controller) ? "#" : string.Format("{0}/{1}/{2}", t.Area, t.Controller, t.Action), DisplayOrder = _permissionService.GetFormattedDisplayOrder(t), Active = t.Active }; return(permission); }); int sortId = param.iDisplayStart + 1; var result = from t in filterResult select new[] { sortId++.ToString(), t.Icon, t.Name, t.BreadCrumb, t.LinkUrl, t.DisplayOrder, t.Active.ToString(), t.Id.ToString() }; return(DataTableJsonResult(param.sEcho, param.iDisplayStart, query.TotalCount, query.TotalCount, result)); }
/// <summary> /// Initializes a new instance of the <see cref="BlogService" /> class. /// </summary> /// <param name="model">Data Table</param> /// <param name="mode">Curation Mode</param> /// <returns>A <see cref="Task"/> Returns Result </returns> public async Task <DataTableResult> GetAllBlogsAsync(DataTableParameter model, string mode) { var result = this.blogRepository.Table.Select(x => new BlogPostGridViewModel { Id = x.Id, Image = x.Image, Line1 = x.Line1, Line2 = x.Line2, Line3 = x.Line3, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, IsActive = x.IsActive, IsFeatured = x.IsFeatured, UpdatedBy = x.UpdatedBy, UpdatedDate = x.UpdatedDate, Url = x.Url }); if (mode == "feature") { result = result.Where(x => x.IsFeatured); } if (mode == "sub") { result = result.Where(x => !x.IsFeatured); } return(await this.blogGridModelRepository.ToPagedListAsync(result, model)); }
public ActionResult InitDataTable(DataTableParameter param) { var query = _categoryService.GetAllCategory(param.iDisplayStart / param.iDisplayLength, param.iDisplayLength); var filterResult = query.Select(t => { var category = new CategoryListModel { Id = t.Id, Name = _categoryService.GetFormattedBreadCrumb(t), Published = t.Published, DisplayOrder = t.DisplayOrder, CreatedOnDate = t.CreatedOnDate }; return(category); }); int sortId = param.iDisplayStart + 1; var result = from t in filterResult select new[] { sortId++.ToString(), t.Name, t.DisplayOrder.ToString(), t.Published.ToString(), t.Id.ToString() }; return(DataTableJsonResult(param.sEcho, param.iDisplayStart, query.TotalCount, query.TotalCount, result)); }
/// <summary> /// 获取审核配置列表 /// </summary> /// <param name="para"></param> /// <param name="searchValue"></param> /// <returns></returns> public JsonResult GetAuditConfigurationList(DataTableParameter para, string searchValue) { int total = 0; var dataList = GetAuditConfigurationList(out total, para, searchValue); if (dataList != null) { foreach (var item in dataList) { item.b_Type = item.b_Type == "Project" ? "项目" : "非项目"; string strHtml = "<div class='row'><div class='col-md-6'>{0}</div><div class='col-md-6' style='text-align:right'>{1}</div></div>"; string linkAList = "<a class='glyphicon glyphicon-pencil edit' title='修改' Id='" + item.Id + "'></a>"; linkAList += " " + "<a class='glyphicon glyphicon-eye-open detail' title='详情' id='" + item.Id + "' ></a>"; linkAList += " " + "<a class='glyphicon glyphicon-remove delete' title='删除' id='" + item.Id + "' ></a>"; strHtml = string.Format(strHtml, item.b_RoleName, linkAList); item.b_RoleName = strHtml; item.b_CostCenters = "<div style='width:200px;word-wrap:break-word;'>" + item.b_CostCenters + "</div>"; } } return(Json(new { sEcho = para.sEcho, iTotalRecords = total, iTotalDisplayRecords = total, aaData = dataList }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <param name="hotelId">Hotel Id</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetAllHotelReviewsByHotelId(DataTableParameter model, int hotelId) { try { var records = this.hotelierReviewRepo.Table.Where(x => x.HotelId == hotelId).Select(x => new HotelierReviewsGridViewModel { Id = x.Id, HotelId = x.HotelId, Comment = x.Comment, FullName = x.FName + " " + x.LName, Rating = x.Rating, Rating_Cleanliness = x.Rating_Cleanliness, Rating_Comfort = x.Rating_Comfort, Rating_Location = x.Rating_Location, Rating_Value = x.Rating_Value, UserRecommend = x.UserRecommend ? "Yes" : string.Empty, IsActive = x.IsActive, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, UpdatedBy = x.UpdatedBy, UpdatedDate = x.UpdatedDate }); return(await this.hotelierReviewGridModelRepo.ToPagedListAsync(records, model)); } catch (Exception ex) { string msg = ex.ToString(); return(null); } }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <param name="hotelId">Hotel Id</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetHotelierRoomCofigGrid(DataTableParameter model, int hotelId) { try { var records = this.hotelierRoomConfigRepo.Table.Where(x => x.HotelId == hotelId).Select(x => new HotelierRoomConfigGridViewModel { Id = x.Id, Adult = x.Adult, Child = x.Child, FreeChild = x.FreeChild, FreeInfant = x.FreeInfant, HotelId = x.HotelId, Infant = x.Infant, Max = x.Max, RoomType = x.PackageHotelRoomTypeModel.Name, IsActive = x.IsActive, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, UpdatedBy = x.UpdatedBy, UpdatedDate = x.UpdatedDate }); return(await this.hotelierRoomConfigGridRepo.ToPagedListAsync(records, model)); } catch (Exception ex) { string msg = ex.ToString(); return(null); } }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetHotelsAsync(DataTableParameter model) { try { var records = this.hotelierInformationRepo.Table.Where(x => !x.IsDeleted).Select(x => new HotelierGridViewModel { VendorId = x.VendorInformationModel.Id, Id = x.Id, Name = x.Name, PropertyType = x.HotelierPropertyTypeModel.Name, StarRating = x.StarRating.ToString(), ////AmenitiesCount = x.HotelierInformationModels.Count > 0 ? x.HotelierInformationModels.FirstOrDefault().HotelierAmenitiesModels.Count : 0, Group = x.VendorInformationModel.VendorGroupModel.Name, Area = x.Area.ToString(), City = x.City != null && x.City != 0 ? this.packageCityRespository.Table.Where(y => y.Id == x.City).Select(y => y.Name).FirstOrDefault() : string.Empty, State = x.State == null || x.State == 0 ? string.Empty : this.packageStateRespository.Table.Where(y => y.Id == x.State).Select(y => y.Name).FirstOrDefault(), Country = x.Country != null && x.Country != 0 ? this.packageCountryRespository.Table.Where(y => y.Id == x.Country).Select(y => y.Name).FirstOrDefault() : string.Empty, FormattedAddress = x.Address1 + ", " + x.Address2 + ", " + x.City != null && x.City != 0 ? this.packageCityRespository.Table.Where(y => y.Id == x.City).Select(y => y.Name).FirstOrDefault() : string.Empty + x.Country != null && x.Country != 0 ? this.packageCountryRespository.Table.Where(y => y.Id == x.Country).Select(y => y.Name).FirstOrDefault() : string.Empty, PrimaryContactId = x.VendorInformationModel.VendorContactModels.Where(y => y.IsPrimary == true).Select(y => y.Id).FirstOrDefault(), PrimaryContact = x.VendorInformationModel.VendorContactModels.Where(y => y.IsPrimary == true).Select(y => y.Salutation).FirstOrDefault() + " " + x.VendorInformationModel.VendorContactModels.Where(y => y.IsPrimary == true).Select(y => y.FirstName).FirstOrDefault() + " " + x.VendorInformationModel.VendorContactModels.Where(y => y.IsPrimary == true).Select(y => y.LastName).FirstOrDefault(), IsActive = x.IsActive, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, UpdatedBy = x.UpdatedBy, UpdatedDate = x.UpdatedDate, }); return(await this.hotelierGridRepo.ToPagedListAsync(records, model)); } catch (Exception ex) { string msg = ex.ToString(); return(null); } }
private DataTableParameter MapParameterModel(HttpContext httpContext) { var request = httpContext.Request.Form; int draw = Convert.ToInt32(request["draw"]); int start = Convert.ToInt32(request["start"]); int length = Convert.ToInt32(request["length"]); var search = new DataTableSearch { Value = request["search[value]"], Regex = Convert.ToBoolean(request["search[regex]"]) }; var o = 0; var order = new List <DataTableOrder>(); while (request["order[" + o + "][column]"].Count > 0) { order.Add(new DataTableOrder() { Column = Convert.ToInt32(request["order[0][column]"].ToList()[0]), Dir = request["order[" + o + "][dir]"] }); o++; } // Columns var c = 0; var columns = new List <DataTableColumn>(); while (request["columns[" + c + "][name]"].Count > 0) { columns.Add(new DataTableColumn { Data = request["columns[" + c + "][data]"][0], Name = request["columns[" + c + "][name]"][0], Orderable = Convert.ToBoolean(request["columns[" + c + "][orderable]"][0]), Search = new DataTableSearch { Value = request["columns[" + c + "][search][value]"][0], Regex = Convert.ToBoolean(request["columns[" + c + "][search][regex]"][0]) } }); c++; } var mapData = new DataTableParameter { Draw = draw, Start = start, Length = length, Search = search, Order = order, Columns = columns, }; return(mapData); }
/// <summary> /// Gets all asynchronous. /// </summary> /// <param name="model">The model.</param> /// <returns> /// GetAllAsync /// </returns> public async Task <DataTableResult> GetAllAsync(DataTableParameter model) { var query = from ct in this.cityRepository.Table select ct; var list = await this.cityRepository.ToPagedListAsync(query, model); return(list); }
public static DataTableParameter GetDataTableParameter(this ControllerBase controllerBase) { var dataTableParameter = new DataTableParameter(); dataTableParameter.Filter = controllerBase.ControllerContext.HttpContext.Request.Query["filter"]; dataTableParameter.Orderby = controllerBase.ControllerContext.HttpContext.Request.Query["orderby"]; dataTableParameter.PageSize = int.Parse(controllerBase.ControllerContext.HttpContext.Request.Query["pageSize"]); dataTableParameter.PageIndex = int.Parse(controllerBase.ControllerContext.HttpContext.Request.Query["pageIndex"]); return(dataTableParameter); }
/// <summary> /// Indexes the specified model. /// </summary> /// <param name="model">Model Data Table</param> /// <returns>View</returns> public IActionResult Recommendations([ModelBinder(typeof(DataTableModelBinder))] DataTableParameter model) { if (this.IsAjaxRequest()) { ////var result = await this.homePageService.GetAllSpecialDealsAsync(model); return(this.Json(new object { })); } return(this.View()); }