public void CreatePricelist(string Name, int OwnerId, string ProductLines, string Currency, string IsPublic) { Pricelist p = new Pricelist(); p.Name = Name; p.IsDefault = false; p.IsPrivate = (IsPublic != "on"); p.OwnerId = OwnerId; p.Currency = Currency; p.Date = DateTime.Now; Pricelist new_p = p.Create(); foreach (string productLineId in ProductLines.Split(',')) { if (!String.IsNullOrEmpty(productLineId)) p.AttachProductLine(Convert.ToInt32(productLineId)); } }
/// <summary> /// Creates this instance. /// </summary> public Pricelist Create() { DatabaseConnection db = new DatabaseConnection(); System.Data.SqlClient.SqlCommand com = new System.Data.SqlClient.SqlCommand(this.GetInsertSQL("Pricelists")); db.RunScalarCommand(com); Pricelist p = new Pricelist(db.GetIdentity()); db.Dispose(); return p; }
public Panel[] QuotePanelComponents(int QuoteId) { // Get the quote! Quote q = new Quote(QuoteId); List<Panel> results = new List<Panel>(); if (q != null) { Pricelist p = new Pricelist(q.PricelistId); if (p != null) { foreach (int productLineId in p.ProductLines) { ProductLine pl = new ProductLine(productLineId); if (pl != null) { Panel newC = new Panel(); newC.title = pl.Name; newC.items = new ExtComponent[2]; // Product grid GridPanel grid = new GridPanel("quoteItemsDDGroup"); grid.store = new Store("PricedProducts", new Proxy(Proxy.ProxyType.AjaxWithJson, "Data.aspx?view=Data&model=GetPricedProductsToQuote&ProductLineId=" + productLineId + "&PricelistId=" + q.PricelistId)); grid.columns = new Column[1]; grid.columns[0] = new Column("Title", "Title"); grid.modelType = "PricedProducts"; newC.items[0] = grid; // Packages grid GridPanel grid2 = new GridPanel("quoteItemsDDGroup"); grid2.store = new Store("PricedPackages", new Proxy(Proxy.ProxyType.AjaxWithJson, "Data.aspx?view=Data&model=GetPricedPackagesToQuote&ProductLineId=" + productLineId + "&PricelistId=" + q.PricelistId)); grid2.columns = new Column[1]; grid2.columns[0] = new Column("Title", "Title"); grid2.modelType = "PricedPackages"; newC.items[1] = grid2; results.Add(newC); } } } } return results.ToArray(); }