public CartItem Add(int customerId, int productId, int qty) { CartItem cartItem = null; Product product = (from p in db.Product where p.ProductId == productId select p).First(); cartItem = new CartItem(); cartItem.CustomerId = customerId; cartItem.ProId = product.ProductId; cartItem.ProName = product.Name; cartItem.ListPrice = product.ListPrice.Value; cartItem.Qty = qty; int ExistCartItemCount = (from c in db.CartItem where c.CustomerId == customerId && c.ProId == productId select c).Count(); if (ExistCartItemCount > 0) { CartItem existCartItem = (from c in db.CartItem where c.CustomerId == customerId && c.ProId == productId select c).First(); existCartItem.Qty += qty; } else { db.CartItem.InsertOnSubmit(cartItem); } db.SubmitChanges(); return(cartItem); }
public void ChangePassword(int customerId, string password) { Customer customer = (from c in db.Customer where c.CustomerId == customerId select c).First(); customer.Password = password; db.SubmitChanges(); }
protected void Button1_Click(object sender, EventArgs e) { Category category = new Category(); category.Name = TextBox1.Text; category.Descn = TextBox2.Text; db.Category.InsertOnSubmit(category); db.SubmitChanges(); Bind(); }
protected void BtnInsert_Click(object sender, EventArgs e) { Category category = new Category(); //建立Category实例category category.Name = txtName.Text; category.Descn = txtDescn.Text; db.Category.InsertOnSubmit(category); //插入实体category db.SubmitChanges(); //提交更改 Bind(); //调用自定义方法,用于在gvCategory中显示最新结果 }
public void InsertCategory(int categoryId, string name, string descn) { Category category = new Category(); category.CategoryId = categoryId; category.Name = name; category.Descn = descn; db.Category.InsertOnSubmit(category); db.SubmitChanges(); }
protected void BtnInsert_Click(object sender, EventArgs e) { Category category = new Category { Name = txtName.Text, Descn = txtDescn.Text }; db.Categories.InsertOnSubmit(category); db.SubmitChanges(); Bind(); }
protected void btnSubmit_Click(object sender, EventArgs e) { MyPetShopDataContext db = new MyPetShopDataContext(); //在Order表中添加记录 Order order = new Order(); order.UserName = User.Identity.Name; order.OrderDate = DateTime.Now; order.Addr1 = txtAddr1.Text.Trim(); order.Addr2 = txtAddr2.Text.Trim(); order.City = txtCity.Text.Trim(); order.State = txtState.Text.Trim(); order.Zip = txtZip.Text.Trim(); order.Phone = txtPhone.Text.Trim(); order.Status = "未审核"; db.Order.InsertOnSubmit(order); db.SubmitChanges(); //在OrderItem中添加记录 int orderId = order.OrderId; for (int i = 0; i < Profile.Cart.ProName.Count; i++) { OrderItem orderItem = new OrderItem(); orderItem.OrderId = orderId; orderItem.ProName = (string)Profile.Cart.ProName[i]; orderItem.ListPrice = (decimal)Profile.Cart.ListPrice[i]; orderItem.Qty = (int)Profile.Cart.Qty[i]; orderItem.TotalPrice = (int)Profile.Cart.Qty[i] * (decimal)Profile.Cart.ListPrice[i]; //修改Product表的商品库存 var product = (from p in db.Product where p.ProductId == (int)Profile.Cart.ProId[i] select p).First(); product.Qty -= orderItem.Qty; db.OrderItem.InsertOnSubmit(orderItem); db.SubmitChanges(); } //清空各数组列表对象 Profile.Cart.Qty.Clear(); Profile.Cart.ProName.Clear(); Profile.Cart.ProId.Clear(); Profile.Cart.ListPrice.Clear(); Profile.Cart.TotalPrice = ""; pnlConsignee.Visible = false; lblMsg.Text = "已经成功结算,谢谢光临!"; }
public void InsertSupplier(int suppId, string name, string addr1, string addr2, string city, string state, string zip, string phone) { Supplier supplier = new Supplier(); supplier.SuppId = suppId; supplier.Name = name; supplier.Addr1 = addr1; supplier.Addr2 = addr2; supplier.City = city; supplier.State = state; supplier.Zip = zip; supplier.Phone = phone; db.Supplier.InsertOnSubmit(supplier); db.SubmitChanges(); }
public void Add(string imageFile, string name, int categoryId, int supplierId, decimal listPrice, decimal unitCost, string descn, int qty) { Product product = new Product(); product.Image = imageFile; product.Name = name; product.CategoryId = categoryId; product.SuppId = supplierId; product.ListPrice = listPrice; product.UnitCost = unitCost; product.Descn = descn; product.Qty = qty; db.Product.InsertOnSubmit(product); db.SubmitChanges(); }
protected void btnUpdate_Click(object sender, EventArgs e) { if (Request.QueryString["ProductId"] != null) { int productId = int.Parse(Request.QueryString["ProductId"]); var product = (from p in db.Product where p.ProductId == productId select p).First(); product.Name = txtName.Text.Trim(); product.CategoryId = int.Parse(ddlCategoryId.SelectedValue); product.SuppId = int.Parse(ddlSuppId.SelectedValue); product.ListPrice = decimal.Parse(txtListPrice.Text.Trim()); product.UnitCost = decimal.Parse(txtUnitCost.Text.Trim()); product.Descn = txtDescn.Text.Trim(); product.Qty = int.Parse(txtQty.Text.Trim()); //如果有上传文件,就删除原来的图片,保存上传的图片 if (fupImage.PostedFile.ContentLength != 0) { string filePath = Server.MapPath("~/") + product.Image.Substring(2); File.Delete(filePath); fupImage.PostedFile.SaveAs(filePath); } db.SubmitChanges(); //清空页面缓存 Response.Buffer = true; //重定向到Admin文件夹中的Default.aspx Response.Redirect("ProductMaster.aspx"); } }
protected void btnUpdate_Click(object sender, EventArgs e) { var category = (from c in db.Category where c.CategoryId == int.Parse(txtCategoryId.Text) select c).First(); category.Name = txtName.Text; category.Descn = txtDescn.Text; db.SubmitChanges(); }
protected void btnDelete_Click(object sender, EventArgs e) { var results = from c in db.Category where c.CategoryId == int.Parse(txtCategoryId.Text) select c; db.Category.DeleteAllOnSubmit(results); db.SubmitChanges(); Bind(); }
/// <summary> /// 将指定orderId的订单状态设置为“已审核” /// </summary> /// <param name="orderId">订单编号</param> protected void UpdataOrder(int orderId) { var order = (from o in db.Order where o.OrderId == orderId select o).First(); order.Status = "已审核"; db.SubmitChanges(); }
protected void btnInsert_Click(object sender, EventArgs e) { MyPetShopDataContext db = new MyPetShopDataContext(); Category category = new Category(); category.Name = txtName.Text; category.Descn = txtDescn.Text; db.Category.InsertOnSubmit(category); db.SubmitChanges(); }
protected void Button1_Click(object sender, EventArgs e) { MyPetShopDataContext db = new MyPetShopDataContext(); Category category = new Category(); category.Name = TextBox1.Text; category.Descn = TextBox2.Text; db.Category.InsertOnSubmit(category); db.SubmitChanges(); GridView1.DataBind(); }
protected void BtnUpdate_Click(object sender, EventArgs e) { MyPetShopDataContext db = new MyPetShopDataContext(); var category = (from r in db.Category where r.CategoryId == int.Parse(txtCategoryId.Text) select r).First(); category.Name = txtName.Text; category.Descn = txtDescn.Text; db.SubmitChanges(); Response.Redirect("~/Chap8/GridUpdate.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { MyPetShopDataContext db = new MyPetShopDataContext(); var category = (from r in db.Category where r.CategoryId == int.Parse(TextBox1.Text) select r).First(); category.Name = TextBox2.Text; category.Descn = TextBox3.Text; db.SubmitChanges(); Response.Redirect("~/GridUpdate.aspx"); }
public void CreateOrderFromCart(int customertId, string customerName, string addr1, string addr2, string city, string state, string zip, string phone) { using (TransactionScope ts = new TransactionScope()) { List <CartItem> cartItemList = (from c in db.CartItem where c.CustomerId == customertId select c).ToList(); Order order = new Order(); order.CustomerId = customertId; order.UserName = customerName; order.OrderDate = DateTime.Now; order.Addr1 = addr1; order.Addr2 = addr2; order.City = city; order.State = state; order.Zip = zip; order.Phone = phone; order.Status = "未审核"; OrderItem orderItem = null; Product product = null; foreach (CartItem cartItem in cartItemList) { orderItem = new OrderItem(); orderItem.OrderId = order.OrderId; orderItem.ProName = cartItem.ProName; orderItem.ListPrice = cartItem.ListPrice; orderItem.Qty = cartItem.Qty; orderItem.TotalPrice = cartItem.Qty * cartItem.ListPrice; order.OrderItem.Add(orderItem); product = (from p in db.Product where p.ProductId == cartItem.ProId select p).First(); product.Qty = product.Qty - cartItem.Qty; db.CartItem.DeleteOnSubmit(cartItem); } db.Order.InsertOnSubmit(order); db.SubmitChanges(); ts.Complete(); } }
/// <summary> /// 删除指定商品编号的产品信息 /// </summary> /// <param name="productId">指定的商品编号</param> protected void DeletePro(int productId) { var product = (from p in db.Product where p.ProductId == productId select p).First(); string filePath = Server.MapPath("~") + product.Image.Substring(1); if (File.Exists(filePath)) { File.Delete(filePath); } db.Product.DeleteOnSubmit(product); db.SubmitChanges(); }
protected void btnAdd_Click(object sender, EventArgs e) { if (IsExitProduct(txtName.Text.Trim())) //输入的商品名已存在 { lblNameErr.Text = "商品已经存在"; } else //添加商品到Product表 { Product product = new Product(); string fileName; string fileFolder; string dateTime = ""; fileName = Path.GetFileName(fupImage.PostedFile.FileName); dateTime += DateTime.Now.Year.ToString(); dateTime += DateTime.Now.Month.ToString(); dateTime += DateTime.Now.Day.ToString(); dateTime += DateTime.Now.Hour.ToString(); dateTime += DateTime.Now.Minute.ToString(); dateTime += DateTime.Now.Second.ToString(); fileName = dateTime + fileName; fileFolder = Server.MapPath("~/") + "Prod_Images\\" + ddlCategoryId.SelectedItem.Text + "\\"; fileFolder = fileFolder + fileName; fupImage.PostedFile.SaveAs(fileFolder); product.Image = "~\\Prod_Images\\" + ddlCategoryId.SelectedItem.Text + "\\" + fileName; product.Name = txtName.Text.Trim(); product.CategoryId = int.Parse(ddlCategoryId.SelectedValue); product.SuppId = int.Parse(ddlSuppId.SelectedValue); product.ListPrice = decimal.Parse(txtListPrice.Text.Trim()); product.UnitCost = decimal.Parse(txtUnitCost.Text.Trim()); product.Descn = txtDescn.Text.Trim(); product.Qty = int.Parse(txtQty.Text.Trim()); db.Product.InsertOnSubmit(product); db.SubmitChanges(); Response.Redirect("ProductMaster.aspx"); } }