protected void Button1_Click(object sender, EventArgs e) { var N = from a in lu.items where a.description.Contains(TextBox1.Text) select new { itemId = a.itemId, unit = a.unit, categoryId = a.categoryId, description = a.description, reorderlevel = a.reorderlevel, reorderQty = a.reorderQty, balance = a.balance, binNumber = a.binNumber, photourl = a.photourl, }; List<item> itemList2 = new List<item>(); foreach (var i in N) { item it = new item(); it.itemId = i.itemId; it.unit = i.unit; it.categoryId = i.categoryId; it.description = i.description; it.reorderlevel = i.reorderlevel; it.reorderQty = i.reorderQty; it.balance = i.balance; it.binNumber = i.binNumber; it.photourl = i.photourl; itemList2.Add(it); } Session["itemList"] = null; Session["itemList"] = itemList2; }
protected void Button3_Click(object sender, EventArgs e) { int cid = Convert.ToInt32(DropDownList1.SelectedValue); var N = from a in lu.items where a.categoryId == cid select new { itemId = a.itemId, unit = a.unit, categoryId = a.categoryId, description = a.description, reorderlevel = a.reorderlevel, reorderQty = a.reorderQty, balance = a.balance, binNumber = a.binNumber, }; List<item> itemList2 = new List<item>(); foreach (var i in N) { item it = new item(); it.itemId = i.itemId; it.unit = i.unit; it.categoryId = i.categoryId; it.description = i.description; it.reorderlevel = i.reorderlevel; it.reorderQty = i.reorderQty; it.balance = i.balance; it.binNumber = i.binNumber; itemList2.Add(it); } Session["itemList"] = null; Session["itemList"] = itemList2; }
protected void Page_Load(object sender, EventArgs e) { User u = (User)Session["UserEntity"]; if (u == null) { Response.Redirect("../Security.aspx"); } Session["userRole"] = u.RoleId; if (!IsPostBack) { var N = from a in lu.items select new { itemId = a.itemId, unit = a.unit, categoryId = a.categoryId, description = a.description, reorderlevel = a.reorderlevel, reorderQty = a.reorderQty, balance = a.balance, binNumber = a.binNumber, }; foreach (var i in N) { item it = new item(); it.itemId = i.itemId; it.unit = i.unit; it.categoryId = i.categoryId; it.description = i.description; it.reorderlevel = i.reorderlevel; it.reorderQty = i.reorderQty; it.balance = i.balance; it.binNumber = i.binNumber; itemList.Add(it); } Session["itemList"] = itemList; //List<item> itemList = N.ToList(); //GridView1.DataSource = N.ToList(); //GridView1.DataBind(); var M = from a in lu.categories select new { categoryId = a.categoryId, categoryName = a.categoryName }; DropDownList1.DataSource = M.ToList(); DropDownList1.DataTextField = "categoryName"; DropDownList1.DataValueField = "categoryId"; DropDownList1.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var N = from a in lu.items select new { itemId = a.itemId, unit = a.unit, categoryId = a.categoryId, description = a.description, reorderlevel = a.reorderlevel, reorderQty = a.reorderQty, balance = a.balance, binNumber = a.binNumber, photourl = a.photourl, }; foreach (var i in N) { item it = new item(); it.itemId = i.itemId; it.unit = i.unit; it.categoryId = i.categoryId; it.description = i.description; it.reorderlevel = i.reorderlevel; it.reorderQty = i.reorderQty; it.balance = i.balance; it.binNumber = i.binNumber; it.photourl = i.photourl; itemList.Add(it); } Session["itemList"] = itemList; //List<item> itemList = N.ToList(); //GridView1.DataSource = N.ToList(); //GridView1.DataBind(); var M = from a in lu.categories select new { categoryId = a.categoryId, categoryName = a.categoryName }; DropDownList1.DataSource = M.ToList(); DropDownList1.DataTextField = "categoryName"; DropDownList1.DataValueField = "categoryId"; DropDownList1.DataBind(); } }