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