private void LoadParents()
{
if (Page.IsPostBack)
{
return;
}
pnlParent.Visible = true;
ddParent.Items.Add(new ListItem("-- No --", "0"));
ArrayList al = entityHelper.GetEntityArrayList(0, "", 0, ThisCustomer.LocaleSetting, false);
for (int i = 0; i < al.Count; i++)
{
ListItemClass lic = (ListItemClass)al[i];
string value = lic.Value.ToString();
string name = HttpUtility.HtmlDecode(lic.Item);
ddParent.Items.Add(new ListItem(name, value));
}
}
protected void LoadData()
{
ddDiscountCate.Items.Clear();
ddDiscountDep.Items.Clear();
ddDiscountManu.Items.Clear();
ddDiscountTable.Items.Clear();
ddOnSale.Items.Clear();
ddOnSaleCat.Items.Clear();
ddOnSaleDep.Items.Clear();
ddOnSaleManu.Items.Clear();
ddOnSale.Items.Add(new ListItem("- Select -", "0"));
using (SqlConnection con = new SqlConnection(DB.GetDBConn()))
{
con.Open();
using (IDataReader rsst = DB.GetRS("select * from salesprompt with (NOLOCK) where deleted=0", con))
{
while (rsst.Read())
{
ListItem li = new ListItem();
li.Value = DB.RSFieldInt(rsst, "SalesPromptID").ToString();
li.Text = DB.RSFieldByLocale(rsst, "Name", cust.LocaleSetting);
ddOnSale.Items.Add(li);
}
}
}
ddDiscountTable.Items.Add(new ListItem("- Select -", "0"));
using (SqlConnection con = new SqlConnection(DB.GetDBConn()))
{
con.Open();
using (IDataReader rsst = DB.GetRS("select * from quantitydiscount with (NOLOCK) order by DisplayOrder,Name", con))
{
while (rsst.Read())
{
ListItem li = new ListItem();
li.Value = DB.RSFieldInt(rsst, "QuantityDiscountID").ToString();
li.Text = DB.RSFieldByLocale(rsst, "Name", cust.LocaleSetting);
ddDiscountTable.Items.Add(li);
}
}
}
//Manufacturers
ddDiscountManu.Items.Add(new ListItem("All Manufacturers", "0"));
ddOnSaleManu.Items.Add(new ListItem("All Manufacturers", "0"));
using (SqlConnection conn = new SqlConnection(DB.GetDBConn()))
{
conn.Open();
using (IDataReader rs = DB.GetRS("select * from Manufacturer with (NOLOCK) where deleted=0 order by DisplayOrder,Name", conn))
{
while (rs.Read())
{
ListItem li = new ListItem();
li.Value = DB.RSFieldInt(rs, "ManufacturerID").ToString();
li.Text = Server.HtmlDecode(DB.RSFieldByLocale(rs, "Name", cust.LocaleSetting));
ddOnSaleManu.Items.Add(li);
ddDiscountManu.Items.Add(li);
}
}
}
//Sections
ddDiscountDep.Items.Add(new ListItem("All " + AppLogic.GetString("AppConfig.SectionPromptPlural", 1, cust.LocaleSetting), "0"));
ddOnSaleDep.Items.Add(new ListItem("All " + AppLogic.GetString("AppConfig.SectionPromptPlural", 1, cust.LocaleSetting), "0"));
EntityHelper eTemp = new EntityHelper(EntityDefinitions.readonly_SectionEntitySpecs, 0);
ArrayList al = eTemp.GetEntityArrayList(0, "", 0, cust.LocaleSetting, false);
for (int i = 0; i < al.Count; i++)
{
ListItemClass lic = (ListItemClass)al[i];
string value = lic.Value.ToString();
string name = Server.HtmlDecode(lic.Item);
ddDiscountDep.Items.Add(new ListItem(name, value));
ddOnSaleDep.Items.Add(new ListItem(name, value));
}
//Categories
ddDiscountCate.Items.Add(new ListItem("All " + AppLogic.GetString("AppConfig.CategoryPromptPlural", 1, cust.LocaleSetting), "0"));
ddOnSaleCat.Items.Add(new ListItem("All " + AppLogic.GetString("AppConfig.CategoryPromptPlural", 1, cust.LocaleSetting), "0"));
eTemp = new EntityHelper(EntityDefinitions.readonly_CategoryEntitySpecs, 0);
al = eTemp.GetEntityArrayList(0, "", 0, cust.LocaleSetting, false);
for (int i = 0; i < al.Count; i++)
{
ListItemClass lic = (ListItemClass)al[i];
string value = lic.Value.ToString();
string name = Server.HtmlDecode(lic.Item);
ddDiscountCate.Items.Add(new ListItem(name, value));
ddOnSaleCat.Items.Add(new ListItem(name, value));
}
}
protected void LoadData()
{
lblBreadcrumb.Text = AppLogic.GetString("admin.common.ExportProductPricing", 1, Customer.Current.LocaleSetting);
//clear
ddCategory.Items.Clear();
ddCategory.ClearSelection();
ddSection.Items.Clear();
ddSection.ClearSelection();
ddManufacturer.Items.Clear();
ddManufacturer.ClearSelection();
ddDistributor.Items.Clear();
ddDistributor.ClearSelection();
ddGenre.Items.Clear();
ddGenre.ClearSelection();
ddVector.Items.Clear();
ddVector.ClearSelection();
//load Categories
ddCategory.Items.Add(new ListItem(" - Select -", "-1"));
EntityHelper eTemp = new EntityHelper(EntityDefinitions.readonly_CategoryEntitySpecs, 0);
ArrayList al = eTemp.GetEntityArrayList(0, "", 0, cust.LocaleSetting, false);
for (int i = 0; i < al.Count; i++)
{
ListItemClass lic = (ListItemClass)al[i];
string value = lic.Value.ToString();
string name = lic.Item;
ddCategory.Items.Add(new ListItem(name, value));
}
//load Sections
ddSection.Items.Add(new ListItem(" - Select -", "-1"));
eTemp = new EntityHelper(EntityDefinitions.readonly_SectionEntitySpecs, 0);
al = eTemp.GetEntityArrayList(0, "", 0, cust.LocaleSetting, false);
for (int i = 0; i < al.Count; i++)
{
ListItemClass lic = (ListItemClass)al[i];
string value = lic.Value.ToString();
string name = lic.Item;
ddSection.Items.Add(new ListItem(name, value));
}
//load Manufacturers
ddManufacturer.Items.Add(new ListItem(" - Select -", "-1"));
using (SqlConnection dbconn = new SqlConnection(DB.GetDBConn()))
{
dbconn.Open();
using (IDataReader rsst = DB.GetRS("select * from Manufacturer with (NOLOCK) where deleted=0 order by DisplayOrder,Name", dbconn))
{
while (rsst.Read())
{
ddManufacturer.Items.Add(new ListItem(DB.RSFieldByLocale(rsst, "Name", cust.LocaleSetting), DB.RSFieldInt(rsst, "ManufacturerID").ToString()));
}
}
}
//load Distributors
ddDistributor.Items.Add(new ListItem(" - Select -", "-1"));
using (SqlConnection dbconn = new SqlConnection(DB.GetDBConn()))
{
dbconn.Open();
using (IDataReader rsst = DB.GetRS("select * from Distributor with (NOLOCK) where Deleted=0 order by DisplayOrder,Name", dbconn))
{
while (rsst.Read())
{
ddDistributor.Items.Add(new ListItem(DB.RSFieldByLocale(rsst, "Name", cust.LocaleSetting), DB.RSFieldInt(rsst, "DistributorID").ToString()));
}
}
}
//load Genres
ddGenre.Items.Add(new ListItem(" - Select -", "-1"));
using (SqlConnection dbconn = new SqlConnection(DB.GetDBConn()))
{
dbconn.Open();
using (IDataReader rsst = DB.GetRS("select * from Genre with (NOLOCK) where Deleted=0 order by DisplayOrder,Name", dbconn))
{
while (rsst.Read())
{
ddGenre.Items.Add(new ListItem(DB.RSFieldByLocale(rsst, "Name", cust.LocaleSetting), DB.RSFieldInt(rsst, "GenreID").ToString()));
}
}
}
//load Vectors
ddVector.Items.Add(new ListItem(" - Select -", "-1"));
using (SqlConnection dbconn = new SqlConnection(DB.GetDBConn()))
{
dbconn.Open();
using (IDataReader rsst = DB.GetRS("select * from Vector with (NOLOCK) where Deleted=0 order by DisplayOrder,Name", dbconn))
{
while (rsst.Read())
{
ddVector.Items.Add(new ListItem(DB.RSFieldByLocale(rsst, "Name", cust.LocaleSetting), DB.RSFieldInt(rsst, "VectorID").ToString()));
}
}
}
}
protected void LoadData()
{
//clear
ddCategory.Items.Clear();
ddSection.Items.Clear();
ddManufacturer.Items.Clear();
ddDistributor.Items.Clear();
//load Categories
ddCategory.Items.Add(new ListItem(" - Select -", "-1"));
EntityHelper eTemp = new EntityHelper(EntityDefinitions.readonly_CategoryEntitySpecs, 0);
ArrayList al = eTemp.GetEntityArrayList(0, "", 0, LocaleSetting, false);
for (int i = 0; i < al.Count; i++)
{
ListItemClass lic = (ListItemClass)al[i];
string value = lic.Value.ToString();
string name = Server.HtmlDecode(lic.Item);
ddCategory.Items.Add(new ListItem(name, value));
}
//load Sections
ddSection.Items.Add(new ListItem(" - Select -", "-1"));
eTemp = new EntityHelper(EntityDefinitions.readonly_SectionEntitySpecs, 0);
al = eTemp.GetEntityArrayList(0, "", 0, LocaleSetting, false);
for (int i = 0; i < al.Count; i++)
{
ListItemClass lic = (ListItemClass)al[i];
string value = lic.Value.ToString();
string name = Server.HtmlDecode(lic.Item);
ddSection.Items.Add(new ListItem(name, value));
}
//load Manufacturers
ddManufacturer.Items.Add(new ListItem(" - Select -", "-1"));
eTemp = new EntityHelper(EntityDefinitions.readonly_ManufacturerEntitySpecs, 0);
al = eTemp.GetEntityArrayList(0, "", 0, LocaleSetting, false);
for (int i = 0; i < al.Count; i++)
{
ListItemClass lic = (ListItemClass)al[i];
string value = lic.Value.ToString();
string name = Server.HtmlDecode(lic.Item);
ddManufacturer.Items.Add(new ListItem(name, value));
}
//load Distributors
ddDistributor.Items.Add(new ListItem(" - Select -", "-1"));
using (var dbconn = new SqlConnection(DB.GetDBConn()))
{
dbconn.Open();
using (var rsst = DB.GetRS("select * from Distributor with (NOLOCK) where Deleted=0 order by DisplayOrder,Name", dbconn))
{
while (rsst.Read())
{
ddDistributor.Items.Add(new ListItem(DB.RSFieldByLocale(rsst, "Name", LocaleSetting), DB.RSFieldInt(rsst, "DistributorID").ToString()));
}
}
}
}
