protected void save_cateMenu_Click(object sender, EventArgs e) { eWorldEntities db = new eWorldEntities(); var t = db.CategoryMenus; db.CategoryMenus.RemoveRange(t); db.SaveChanges(); foreach (ListItem item in MenuCategory.Items) { if (item.Selected) { var tmp = db.Categories.Where(z => z.CategoryID.ToString() == item.Value).FirstOrDefault(); CategoryMenu cm = new CategoryMenu(); cm.CategoryID = tmp.CategoryID; db.CategoryMenus.Add(cm); } } db.SaveChanges(); MenuCategory.DataSource = GetCategories(); MenuCategory.DataBind(); }
protected void order_status_SelectedIndexChanged(object sender, EventArgs e) { DropDownList btn = (DropDownList)sender; GridViewRow gvr = (GridViewRow)btn.NamingContainer; string id = gvr.Cells[0].Text; db = new eWorldEntities(); var tmp = (from o in db.Orders where o.OrderID.ToString() == id select o).FirstOrDefault(); if (btn.SelectedIndex == 0) tmp.paid = true; else tmp.paid = false; db.SaveChanges(); }
protected void del_cat_Click(object sender, EventArgs e) { int catID = Convert.ToInt16(list_cat.SelectedValue); using (db = new eWorldEntities()) { var cat = (from c in db.Categories where c.CategoryID == catID select c).FirstOrDefault(); if (cat != null) { var cat_pro = from pc in db.ProductInCategories where pc.CategoryID == catID select pc; if (cat_pro != null) { var tmp = cat_pro.ToList(); int count = tmp.Count; for (int i = 0; i < count; i++) db.ProductInCategories.Remove(tmp[i]); } var cat_menu = from cm in db.CategoryMenus where cm.CategoryID == catID select cm; if (cat_pro != null) { var tmp = cat_menu.ToList(); int count = tmp.Count; for (int i = 0; i < count; i++) db.CategoryMenus.Remove(tmp[i]); } db.Categories.Remove(cat); db.SaveChanges(); delate_cat_status.Text = "Xóa nhóm sản phẩm thành công."; delate_cat_status.Visible = true; update_cat_status.Visible = false; add_cat_status.Visible = false; data_blind(); } else { delate_cat_status.Text = "Có lỗi xảy ra, vui lòng thử lại."; update_cat_status.Visible = false; delate_cat_status.Visible = true; add_cat_status.Visible = false; } } new_name_cat.Text = ""; }
protected void add_cat_Click(object sender, EventArgs e) { cat = new Category(); cat.Name = add_name_cat.Text; cat.KeyWord = add_name_cat.Text; using (db = new eWorldEntities()) { db.Categories.Add(cat); db.SaveChanges(); } add_cat_status.Text = "Thêm nhóm sản phẩm thành công."; delate_cat_status.Visible = false; update_cat_status.Visible = false; add_cat_status.Visible = true; add_name_cat.Text = ""; data_blind(); }
protected void save_info_Click(object sender, EventArgs e) { eWorldEntities db = new eWorldEntities(); var tmp = db.ShopInfoes; db.ShopInfoes.RemoveRange(tmp); ShopInfo s = new ShopInfo(); s.InfoContact = info_contact.Text; s.Warranty = warranty.Text; s.Showroom = showroom.Text; db.ShopInfoes.Add(s); db.SaveChanges(); }
public void UpdateItem(string updateCartID, int updateProductID, int quantity) { using (var _db = new eWorldEntities()) { try { var myItem = (from c in _db.Carts where c.CartID == updateCartID && c.Product.ProductID == updateProductID select c).FirstOrDefault(); if (myItem != null) { myItem.Quantity = quantity; _db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp); } } }
public void RemoveItem(string removeCartID, int removeProductID) { using (var _db = new eWorldEntities()) { try { var myItem = (from c in _db.Carts where c.CartID == removeCartID && c.Product.ProductID == removeProductID select c).FirstOrDefault(); if (myItem != null) { _db.Carts.Remove(myItem); _db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to Remove Cart Item - " + exp.Message.ToString(), exp); } } }
protected void update_cat_Click(object sender, EventArgs e) { int catID = Convert.ToInt16(list_cat.SelectedValue); using (db = new eWorldEntities()) { var cat = (from c in db.Categories where c.CategoryID == catID select c).FirstOrDefault(); if (cat != null) { cat.Name = new_name_cat.Text; db.SaveChanges(); update_cat_status.Text = "Sửa nhóm sản phẩm thành công."; delate_cat_status.Visible = false; update_cat_status.Visible = true; add_cat_status.Visible = false; data_blind(); } else { delate_cat_status.Text = "Có lỗi xảy ra, vui lòng thử lại."; update_cat_status.Visible = true; delate_cat_status.Visible = false; add_cat_status.Visible = false; } } new_name_cat.Text = ""; }