/// <summary> /// Initial mapping entity model to view model. /// </summary> /// <param name="vendorFilter">The vendor filter entity model data.</param> /// <returns></returns> private VendorFilterViewModel InitialVendorFilterViewModel(VendorFilter vendorFilter) { var result = new VendorFilterViewModel(); var emp = _unitOfWork.GetRepository <Hremployee>().GetCache(x => x.Aduser == vendorFilter.AssignTo).FirstOrDefault(); var company = _unitOfWork.GetRepository <Hrcompany>().GetCache(x => x.SapcomCode == vendorFilter.CompanyCode).FirstOrDefault(); var period = _unitOfWork.GetRepository <PeriodItem>().GetCache(x => x.Id == vendorFilter.PeriodItemId).FirstOrDefault(); var purOrg = _unitOfWork.GetRepository <PurchaseOrg>().GetCache(x => x.PurchaseOrg1 == vendorFilter.PurchasingOrg).FirstOrDefault(); var vendor = _unitOfWork.GetRepository <Data.Pocos.Vendor>().GetCache(x => x.VendorNo == vendorFilter.VendorNo).FirstOrDefault(); var valueHelpList = _unitOfWork.GetRepository <ValueHelp>().GetCache(x => x.ValueType == ConstantValue.ValueTypeVendorSendingStatus); var weightingKeyList = _unitOfWork.GetRepository <ValueHelp>().GetCache(x => x.ValueType == ConstantValue.ValueTypeWeightingKey); return(new VendorFilterViewModel { Id = vendorFilter.Id, AssignTo = vendorFilter.AssignTo, AssignToName = string.Format(ConstantValue.EmpTemplate, emp?.FirstnameTh, emp?.LastnameTh), CompanyCode = vendorFilter.CompanyCode, CompanyName = company?.LongText, IsSending = vendorFilter.IsSending ?? false, SendingStatus = vendorFilter.IsSending.HasValue && vendorFilter.IsSending.Value ? valueHelpList.FirstOrDefault(x => x.ValueKey == ConstantValue.VendorSending)?.ValueText : valueHelpList.FirstOrDefault(x => x.ValueKey == ConstantValue.VendorWaiting)?.ValueText, PeriodItemId = vendorFilter.PeriodItemId, PeriodItemName = period?.PeriodName, PurchasingOrg = vendorFilter.PurchasingOrg, PurchasingName = purOrg?.PurchaseName, SendEvaluationDate = vendorFilter.SendingEvaDate, VendorNo = vendorFilter.VendorNo, VendorName = vendor?.VendorName, WeightingKey = vendorFilter.WeightingKey, WeightingKeyName = weightingKeyList.FirstOrDefault(x => x.ValueKey == vendorFilter.WeightingKey)?.ValueText }); }
public List <Vendor> GetVendors(VendorFilter filter) { using var context = Context(); var vendors = context.Vendor.Where(u => u.OrganisationId == filter.OrganisationId && (string.IsNullOrEmpty(filter.SearchText) || u.DisplayName.Contains(filter.SearchText) || u.LegalName.Contains(filter.SearchText))) .OrderBy(u => u.DisplayName) .Skip((filter.Page - 1) * filter.PageSize) .Take(filter.PageSize) .Select(u => new Vendor { BusinessRegistrationNumber = u.BusinessRegistrationNumber, DisplayName = u.DisplayName, LegalName = u.LegalName, TaxNumber = u.TaxNumber, Id = u.Id, ContactId = u.ContactId, Contact = new Contact { Id = u.ContactId, Address = u.Contact.Address, ContactName = u.Contact.ContactName, Email = u.Contact.Email, PhoneNumber = u.Contact.PhoneNumber, Website = u.Contact.Website } }).ToList(); return(vendors); }
public void GetTotalPage(VendorFilter filter) { using var context = Context(); filter.TotalRow = context.Vendor.Where(u => u.OrganisationId == filter.OrganisationId && (string.IsNullOrEmpty(filter.SearchText) || u.DisplayName.Contains(filter.SearchText) || u.LegalName.Contains(filter.SearchText))).Count(); }
private void PopulateVendors() { VendorFilter.DataSource = HccApp.ContactServices.Vendors.FindAll(); VendorFilter.DataTextField = "DisplayName"; VendorFilter.DataValueField = "Bvin"; VendorFilter.DataBind(); VendorFilter.Items.Insert(0, new ListItem("- Any Vendor -", string.Empty)); }
protected void Page_Init(object sender, EventArgs e) { //INITIALIZE VARIABLES _CategoryId = AbleCommerce.Code.PageHelper.GetCategoryId(); _Category = CategoryDataSource.Load(_CategoryId); _ProductId = AlwaysConvert.ToInt(Request.QueryString["ProductId"]); _Product = ProductDataSource.Load(_ProductId); if (_Product == null) { Response.Redirect(AbleCommerce.Code.NavigationHelper.GetAdminUrl("Catalog/Browse.aspx?CategoryId=" + _CategoryId.ToString())); } _KitComponentId = AlwaysConvert.ToInt(Request.QueryString["KitComponentId"]); _KitComponent = KitComponentDataSource.Load(_KitComponentId); if (_KitComponent == null) { Response.Redirect("EditKit.aspx?CategoryId=" + _CategoryId.ToString() + "&ProductId=" + _ProductId.ToString()); } CancelLink.NavigateUrl += "?CategoryId=" + _CategoryId.ToString() + "&ProductId=" + _ProductId.ToString(); Caption.Text = string.Format(Caption.Text, _KitComponent.Name); InstructionText.Text = string.Format(InstructionText.Text, _KitComponent.Name, _Product.Name); int categoryCount = CategoryDataSource.CountAll(); StoreSettingsManager settings = AbleContext.Current.Store.Settings; _DisplayCategorySearch = settings.CategorySearchDisplayLimit > 0 && categoryCount >= settings.CategorySearchDisplayLimit; // INITIALIZE DROP DOWN LISTS if (!_DisplayCategorySearch) { InitializeCategoryTree(); } else { // DISPLAY AUTO COMPLETE FOR CATEGORY SEARCH OPTION string js = PageHelper.GetAutoCompleteScript(Page.ResolveClientUrl("~/CategorySuggest.ashx"), CategoryAutoComplete, HiddenSelectedCategoryId, "Key", "Value"); ScriptManager.RegisterStartupScript(PageAjax, this.GetType(), "CATEGORY_SUGGEST", js, true); CategoryAutoComplete.Visible = true; CategoryFilter.Visible = false; } ManufacturerFilter.DataSource = ManufacturerDataSource.LoadAll("Name"); ManufacturerFilter.DataBind(); VendorFilter.DataSource = VendorDataSource.LoadAll("Name"); VendorFilter.DataBind(); // LOAD CUSTOM VIEWSTATE VARIABLES LoadCustomViewState(); if (_SelectedProducts.Count > 0) { // REBIND THE REPEATER BindSelectedProducts(_SelectedProducts); } AbleCommerce.Code.PageHelper.SetDefaultButton(NameFilter, SearchButton.ClientID); AbleCommerce.Code.PageHelper.SetDefaultButton(SkuFilter, SearchButton.ClientID); }
public PagedResultDto <VendorDto> GetVendors(VendorFilter input) { var query = vendorRepository.GetAll().Where(x => !x.IsDelete); // filter by code if (input.Code != null) { query = query.Where(x => x.Code.ToLower().Contains(input.Code.ToLower())); } // filter by name if (input.Name != null) { query = query.Where(x => x.Name.ToLower().Contains(input.Name.ToLower())); } // filter by typeID if (input.TypeID != 0) { query = query.Where(x => x.TypeID == input.TypeID); } // filter by isActive if (input.IsActive != null) { if (input.IsActive.Equals("True")) { query = query.Where(x => x.IsActive == true); } else if (input.IsActive.Equals("False")) { query = query.Where(x => x.IsActive == false); } } var totalCount = query.Count(); // sorting if (!string.IsNullOrWhiteSpace(input.Sorting)) { query = query.OrderBy(input.Sorting); } // paging var items = query.PageBy(input).ToList(); // result return(new PagedResultDto <VendorDto>( totalCount, items.Select(item => ObjectMapper.Map <VendorDto>(item)).ToList())); }
private void toolBtnFindOrderNumber_Click(object sender, EventArgs e) { List <Vendors> vendorList = new List <Vendors>(vendorBindingSource.DataSource as BindingList <Vendors>); VendorFilter vendorFilter = new VendorFilter(Convert.ToInt32(toolTxtFindOrderNumber.Text)); //Predicate<Vendors> filterByOrderID = new Predicate<Vendors>(orderFilter.MatchesOrderID); Predicate <Vendors> filterByOrderID = new Predicate <Vendors>(vendorFilter.BeginsWithOrderID); Vendors vendor = vendorList.Find(filterByOrderID); if (vendor == null) { MessageBox.Show("No matching Vendor found", "Not Found", MessageBoxButtons.OK); } else { int index = vendorBindingSource.IndexOf(vendor); vendorBindingSource.Position = index; } }
public PagedResultDto <VendorDto> GetVendorsByFilter(VendorFilter vendorFilter) { return(vendorAppService.GetVendors(vendorFilter)); }
public IActionResult GetTotalPage([FromBody] VendorFilter filter) { filter.OrganisationId = vendorService.OrganisationId; vendorService.GetTotalPage(filter); return(Ok(filter)); }
public IActionResult GetVendors([FromBody] VendorFilter filter) { filter.OrganisationId = vendorService.OrganisationId; return(Ok(vendorService.GetVendors(filter))); }
public CustomAdapterView(Activity context, ICursor cursor, DBHelper dbb) : base(context, cursor) { this.context = context; this.cursor = cursor; Filter = new VendorFilter(this, dbb); }