/// <summary> /// Overrides OnLoadCompleted method. /// </summary> protected override void OnLoadComplete(EventArgs e) { base.OnLoadComplete(e); if (!RequestHelper.IsPostBack()) { // Show error message if (QueryHelper.Contains("error")) { ShowError(HTMLHelper.HTMLEncode(QueryHelper.GetString("error", string.Empty))); } // Show warning message else if (QueryHelper.Contains("warning")) { ShowWarning(HTMLHelper.HTMLEncode(QueryHelper.GetString("warning", string.Empty))); } } // Setup variants if at least one category is assigned for generation if ((NewCategories.Count > 0) || (ExistingCategories.Count > 0)) { SetupVariants(); } // Exclude not selected categories VariantFilter.ExcludedCategories = CategorySelector.UnSelectedCategories.ToList(); VariantFilter.ReloadData(true); }
public List <VariantDBModel> GetVariants(VariantFilter filter) { SqlDataAccess sql = new SqlDataAccess(); var parameters = new { ProductId = filter.Product, MinPrice = filter.MinPrice, MaxPrice = filter.MaxPrice }; var variants = sql.LoadData <VariantDBModel, dynamic>("dbo.spVariantGetAll", parameters, "DefaultConnection"); return(variants); }
public HttpResponseMessage Get([FromUri] VariantFilter filter) { VariantData data = new VariantData(); List <VariantDBModel> variants = data.GetVariants(filter); HttpResponseMessage response; if (variants.Count() <= 0) { response = Request.CreateResponse(HttpStatusCode.NotFound, new { Message = "No data found matching given parameters values." }); } else { response = Request.CreateResponse(HttpStatusCode.OK, variants); } return(response); }