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