private void CreateAttributeValues() { ShopErDataClassesDataContext db = new ShopErDataClassesDataContext(Utilities.ConnectionString); var table = db.GetTable<Attribute>(); //Laddar alternativ till valt attribut var query2 = from av in db.GetTable<AttributeValue>() where av.AttributeID.ToString() == ddlistAttribute.SelectedItem.Value orderby av.Value select av; foreach (var attributeValue in query2) { ddlistAttributeChoice.Items.Add(new ListItem(attributeValue.Value, attributeValue.AttributeValueID.ToString())); } int qcount = query2.Count(); if ((ddlistAttributeChoice.Items.Count) - (qcount) != 0) { for (int i = 0; i < (ddlistAttributeChoice.Items.Count) - (qcount); i++) { ddlistAttributeChoice.Items.RemoveAt(0); qcount -= 1; } } }
/// <summary> /// Skapar tomma checkboxar för varje kategori /// </summary> private void CreateCategoryCheckboxesWithoutValue() { ShopErDataClassesDataContext dc = new ShopErDataClassesDataContext(Utilities.ConnectionString); var table = dc.GetTable<CategoryLinq>(); var query = from c in table orderby c.Name select c; foreach (var category in query) { CheckBox cb = new CheckBox(); cb.ID = category.CategoryID.ToString(); cb.Text = category.Name; plCategoryCheckboxes.Controls.Add(cb); Literal lit = new Literal(); lit.Text = "<br />"; plCategoryCheckboxes.Controls.Add(lit); } }
private void CreateAttributes() { ShopErDataClassesDataContext db = new ShopErDataClassesDataContext(Utilities.ConnectionString); var table = db.GetTable<Attribute>(); var query = from a in table orderby a.Name select a; if (ddlistAttribute.Items.Count == 0) { ddlistAttribute.Items.Add(new ListItem("", "Empty")); foreach (var attribute in query) { ddlistAttribute.Items.Add(new ListItem(attribute.Name, attribute.AttributeID.ToString())); } } }