public void bind_data() { eWorldEntities db = new eWorldEntities(); var tmp = db.ShopInfoes.FirstOrDefault(); info_contact.Text = tmp.InfoContact; warranty.Text = tmp.Warranty; showroom.Text = tmp.Showroom; var tmp2 = db.ImageBanners.ToList(); foreach (ImageBanner im in tmp2) { listofuploadedfiles.Text += String.Format("<br />{0}", im.Path); } var tmp3 = db.ImageSlides.ToList(); foreach (ImageSlide im in tmp3) { list_upload_slide.Text += String.Format("<br />{0}", im.Path); } var tmp4 = db.CategoryMenus.ToList(); foreach (CategoryMenu cm in tmp4) { foreach (ListItem lt in MenuCategory.Items) { if (cm.CategoryID.ToString() == lt.Value) { lt.Selected = true; break; } } } }
public List<Product> GetProduct() { using (db = new eWorldEntities()) { var result = db.Products.ToList(); return result; } }
public List<Order> GetOrder() { using (db = new eWorldEntities()) { var result = db.Orders.ToList(); return result; } }
public void Dispose() { if (db != null) { db.Dispose(); db = null; } }
public List<Category> GetCategories() { using (db = new eWorldEntities()) { var tmp = from c in db.Categories select c; var result = tmp.ToList<Category>(); return result; } }
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 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 List<Order> GetOrder() { string email = HttpContext.Current.User.Identity.Name; using (db = new eWorldEntities()) { var result = db.Orders.Where(z => z.Email == email).ToList(); if(result.Count == 0) { Title_EmptyOrder.Visible = true; } return result; } }
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 Page_PreRender(object sender, EventArgs e) { db = new eWorldEntities(); var tmp = db.Orders.ToList(); for (int i = 0; i < OrderList.Rows.Count; i++) { DropDownList status = new DropDownList(); status = (DropDownList)OrderList.Rows[i].FindControl("order_status"); if (tmp[i].paid == true) { //OrderList.Rows[i].Cells[4].Text = "DDax"; status.SelectedIndex = 0; } else { //OrderList.Rows[i].Cells[4].Text = "Chuaw"; status.SelectedIndex = 1; } } }
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(); }
public List<OrderDetail> GetOrderDetail() { db = new eWorldEntities(); return db.OrderDetails.Where(z => z.OrderID == order_id).ToList(); }
protected void submit_banner_Click(object sender, EventArgs e) { eWorldEntities db = new eWorldEntities(); var tmp = db.ImageBanners; db.ImageBanners.RemoveRange(tmp); if (banner.HasFiles) { foreach (HttpPostedFile uploadedFile in banner.PostedFiles) { uploadedFile.SaveAs(MapPath("~/style/image/banner/") + uploadedFile.FileName); listofuploadedfiles.Text += String.Format("<br />{0}", uploadedFile.FileName); ImageBanner im = new ImageBanner(); im.Path = uploadedFile.FileName; db.ImageBanners.Add(im); } } }
public IQueryable GetCategories() { var _db = new eWorldEntities(); IQueryable query = _db.Categories; return query; }
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); } } }
public decimal GetTotal() { using (db = new eWorldEntities()) { ShoppingCartId = GetCartId(); decimal? total = decimal.Zero; total = (decimal?)(from cartItems in db.Carts where cartItems.CartID == ShoppingCartId select (int?)cartItems.Quantity * cartItems.Product.Price).Sum(); return total ?? decimal.Zero; } }
public List<Cart> GetCartItems() { ShoppingCartId = GetCartId(); db = new eWorldEntities(); // var tmp = from c in db.Carts // where c.CartID == ShoppingCartId // select c; // var result = tmp.ToList(); // return result; return db.Carts.Where( c => c.CartID == ShoppingCartId).ToList(); }
protected void Page_Load(object sender, EventArgs e) { string productAction = Request.QueryString["ProductAction"]; if (productAction == "edit") { LabelAddStatus.Text = "Sản phẩm đã được sửa thành công."; } if (!IsPostBack) { pro_id = Convert.ToInt32(Session["edit_pro_id"].ToString()); db = new eWorldEntities(); p = db.Products.Where(z => z.ProductID == pro_id).FirstOrDefault(); bind_data(p); } }
public List<Category> GetCategories() { var db = new eWorldEntities(); return db.Categories.ToList(); }
public IQueryable GetStock() { var _db = new eWorldEntities(); IQueryable query = _db.ProductStocks; return query; }
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 = ""; }