private void BtnAddCategory_Click(object sender, EventArgs e) { string categoryName = txtCategoryName.Text; if (categoryName != string.Empty) { if (db.Categories.Any(ct => ct.Name == categoryName)) { lblError.Text = "Dear Admin.Yeke oglansin bu adda category adi db'da var "; lblError.Visible = true; } else { db.Categories.Add(new Category { Name = categoryName }); db.SaveChanges(); MessageBox.Show("Category Name was successfully created", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); FillDgCategories(); } } else { lblError.Text = "Category name is not empty"; lblError.Visible = true; } }
//新增商品方法 public void Insert(Item newData) { //將資料加入資料庫實體 db.Item.Add(newData); //儲存資料庫變更 db.SaveChanges(); }
public IHttpActionResult PostFavoriteCategory([FromUri] Guid userId, [FromUri] Guid categoryId) { var user = shoppingEntities.Users.FirstOrDefault(t => t.Id == userId); var category = shoppingEntities.Categories.FirstOrDefault(t => t.Id == categoryId); if (user == null) { throw new BadRequestException("User khong ton tai"); } if (category == null) { throw new BadRequestException("Category khong ton tai"); } if (shoppingEntities.FavoriteCategories.FirstOrDefault(t => t.UserId == user.Id && t.CategoryId == category.Id) == null) { FavoriteCategory favoriteCategory = new FavoriteCategory(); favoriteCategory.Id = Guid.NewGuid(); favoriteCategory.Category = category; favoriteCategory.User = user; shoppingEntities.FavoriteCategories.Add(favoriteCategory); shoppingEntities.SaveChanges(); } return(Ok(new CategoryDto(category))); }
private void btnAdd_Click(object sender, EventArgs e) { lblError.Text = ""; string name = txtName.Text; string price = txtPrice.Text; string category = cmbCategory.Text; string type = cmbTypes.Text; if (name == string.Empty || price == string.Empty || category == string.Empty || type == string.Empty) { lblError.Text = "Bosluq buraxmayin"; return; } if(!decimal.TryParse(price,out decimal Price)) { lblError.Text = "Qiymeti duzgun yazin"; return; } Model.Product prt = new Model.Product { Name = name, Price = Price, CategoryId = Convert.ToInt32(category.Split('-')[0]), TypeId = Convert.ToInt32(type.Split('-')[0]), }; db.Products.Add(prt); db.SaveChanges(); Reset(); }
public IHttpActionResult Post([FromBody] RoleDto roleDto) { Role role = roleDto.ToModel(); shoppingEntities.Roles.Add(role); shoppingEntities.SaveChanges(); return(Ok(new RoleDto(role))); }
//註冊新會員方法 public void Register(Member newMember) { //將密碼Hash過 newMember.Password = HashPassword(newMember.Password); //將資料加入資料庫實體 db.Member.Add(newMember); //儲存資料庫變更 db.SaveChanges(); }
public ActionResult Edit([Bind(Include = "ID,Nome,Latitude,Longitude")] Loja loja) { if (ModelState.IsValid) { db.Entry(loja).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(loja)); }
public IHttpActionResult Post([FromBody] ShopDto shopDto) { var shop = shopDto.ToModel(); shop.CreatedDate = System.DateTime.Now; shoppingEntities.Shops.Add(shop); shoppingEntities.SaveChanges(); return(Ok(new ShopDto(shop))); }
public ActionResult Edit(Sale model) { int id = model.Id; int productid = model.ProductId; int customerid = model.CustomerId; int storeid = model.StoreId; DateTime saledate = model.SaleDate; string msg; if (id == 0) { // New Record try { var sale = db.Set <Sale>(); sale.Add(new Sale { Id = id, ProductId = productid, CustomerId = customerid, StoreId = storeid, SaleDate = saledate }); db.SaveChanges(); msg = "New record created."; } catch (Exception) { msg = "Cannot save new record. Contact the administrator."; } } else { // Existing Record var sale = db.Sales.Find(id); if (sale == null) { return(HttpNotFound()); } else { try { sale.ProductId = productid; sale.CustomerId = customerid; sale.SaleDate = saledate; db.SaveChanges(); msg = String.Format("Changes to record {0} have been saved.", id); } catch (Exception) { msg = "Changes cannot be saved. Contact the administrator"; } } } var result = new { success = "True", Message = msg }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Create([Bind(Include = "ShoppingID,ShoppingName,Address,Phone")] Shopping shopping) { if (ModelState.IsValid) { db.Shoppings.Add(shopping); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(shopping)); }
public bool DeleteOne(int id) { var item = Context.OrderDetails.Where(e => e.ODID == id).FirstOrDefault(); if (item.Equals(null)) { return(false); } Context.OrderDetails.Remove(item); Context.SaveChanges(); return(true); }
public ActionResult Create([Bind(Include = "ID,CategoriaID,Nome,Unidade,QtdNormal,MarcasSim,MarcasNao,ListaPadrao")] Produto produto) { if (ModelState.IsValid) { db.Produtos.Add(produto); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoriaID = new SelectList(db.Categorias, "ID", "Nome", produto.CategoriaID); return(View(produto)); }
public ActionResult Create([Bind(Include = "ProductID,Name,Price,Description,ImageURL,CategoryID")] Product product) { if (ModelState.IsValid) { db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CName", product.CategoryID); return(View(product)); }
//將商品放入購物車方法 public void AddtoCart(string Cart, int Item_Id) { //宣告一筆新的CartBuy資料表資料物件 CartBuy newData = new CartBuy(); //設定資料的值 newData.Cart_Id = Cart; newData.Item_Id = Item_Id; //將資料加入資料庫實體 db.CartBuy.Add(newData); //儲存資料庫變更 db.SaveChanges(); }
public ActionResult Edit(ProductViewModel model) { string msg; int id = model.Id; string name = model.ProductName; decimal?price = model.ProductPrice; if (id == 0) // New Record { try { var newprod = db.Set <Product>(); newprod.Add(new Product { Id = id, ProductName = name, ProductPrice = price }); db.SaveChanges(); msg = "New record has been created"; } catch (Exception) { msg = "Unable to save new record. Contact the administrator."; } } else // Existing record { var editproduct = db.Products.Find(id); if (editproduct == null) { return(HttpNotFound()); } else { try { editproduct.ProductName = name; editproduct.ProductPrice = price; db.SaveChanges(); msg = String.Format("Changes for record {0} have been saved", id); } catch (Exception) { msg = String.Format("Unable to save changes to {0}. Contact the administrator.", id); } } } var result = new { Success = "True", Message = msg }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(Sale model) { string msg; if (model.Id == 0) { // new record var sale = new Sale(); sale.ProductId = model.ProductId; sale.CustomerId = model.CustomerId; sale.StoreId = model.StoreId; sale.SaleDate = model.SaleDate; try { db.Sales.Add(sale); db.SaveChanges(); msg = "New record created."; } catch (Exception) { msg = "Unable to save changes. Contact the administrator."; } } else { var sale = db.Sales.Find(model.Id); if (sale == null) { return(HttpNotFound()); } else { try { sale.ProductId = model.ProductId; sale.CustomerId = model.CustomerId; sale.StoreId = model.StoreId; sale.SaleDate = model.SaleDate; db.SaveChanges(); msg = String.Format("Changes to record {0} have been saved.", model.Id); } catch (Exception) { msg = "Unable to save changes. Contact the administrator."; } } } var result = new { Message = msg }; return(Json(result, JsonRequestBehavior.AllowGet)); }
private ActionResult ListaAbrirFechar(int?id, bool abrir) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var lista = db.Listas.Find(id); if (lista == null) { return(HttpNotFound()); } lista.Aberta = abrir; db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult AddressAndPayment(FormCollection values) { var order = new Order(); TryUpdateModel(order); try { if (string.Equals(values["PromoCode"], PromoCode, StringComparison.OrdinalIgnoreCase) == false) { return(View(order)); } else { //order.EmployeeId = User.Identity.; order.OrderDate = DateTime.Now; //Save Order storeDB.Orders.Add(order); storeDB.SaveChanges(); //Process the order var cart = Models.ShoppingCart.GetCart(this.HttpContext); cart.CreateOrder(order); return(RedirectToAction("Complete", new { id = order.OrderId })); } } catch { //Invalid - redisplay with errors return(View(order)); } }
public ActionResult UpdateProduct(Product p) { WebImage photo = null; var newFileName = ""; var imagePath = ""; var imageThumbPath = ""; photo = WebImage.GetImageFromRequest(); if (photo != null) { newFileName = Path.GetFileName(photo.FileName); imagePath = @"images/Products/" + newFileName; photo.Save(@"~/" + imagePath); imageThumbPath = @"images/Products/thumbnails/" + newFileName; photo.Resize(width: 165, height: 35, preserveAspectRatio: false, preventEnlarge: true); photo.Save(@"~/" + imageThumbPath); } var db = new ShoppingEntities(); var im = "/" + imagePath; var im1 = "/" + imageThumbPath; p.Img = im; p.Thumbnail = im1; db.Entry(p).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("ListProducts")); }
//管理员删除产品操作 public ActionResult Delete(String id) { //1、检查参数id的合法性 string -> int int productId; if (!int.TryParse(id, out productId)) { return(Content("<script>alert('参数不合法');window.location.href='/AdminProduct/Index'</script>")); } //2、使用EF删除产品 using (ShoppingEntities dc = new ShoppingEntities()) { //1、先查询 Product entity = dc.Product.FirstOrDefault(p => p.ProID == productId); //2、后删除 dc.Product.Remove(entity); //3、保存回数据库中 if (dc.SaveChanges() > 0) { return(Content("<script>alert('产品下架成功!');window.location.href='/AdminProduct/Index'</script>")); } else { return(Content("<script>alert('产品下载失败!');window.location.href='/AdminProduct/Index'</script>")); } } }
public ActionResult Submit(int id) { //1. 登录判断 if (!IsLogined()) { return(Content("<script>alert('请登录');window.location.href='/Users/Login'</script>")); } //往数据库的表中修改内容 using (ShoppingEntities se = new ShoppingEntities()) { string text = Request.Form["text"]; TradeRecord order = se.TradeRecord.FirstOrDefault(u => u.TraPID == id); //判断是否提交过评论 if (order.TraComment == null) { var entry = se.Entry(order); entry.State = System.Data.EntityState.Unchanged; entry.Property("TraComment").IsModified = true; order.TraComment = text; if (se.SaveChanges() > 0) { return(Content("<script>alert('提价评价成功!');window.location.href='/Order/Index';</script>")); } else { return(Content("<script>alert('提价评价失败!');window.location.href='/Order/Index';</script>")); } } else { return(Content("<script>alert('已经提交过评论了,请勿重复提交!');window.location.href='/Order/Index';</script>")); } } }
private void BtnAddCategory_Click(object sender, EventArgs e) { string categoryName = txtCategoryName.Text; if (categoryName != string.Empty) { if (db.Category.Any(c => c.Name == categoryName)) { lblError.Text = "Admin yeke oglansan .Bu adda category var.Agresivik!!!"; lblError.Visible = true; } else { db.Category.Add(new Category { Name = categoryName }); db.SaveChanges(); MessageBox.Show("Category ugurla əlavə olundu"); FillDgcategories(); } } else { lblError.Text = "Boş gonderme brat!"; lblError.Visible = true; } }
public IHttpActionResult CompleteOrder(int OrderID) { if (OrderDataValidation.ValidateOpenOrder(OrderID)) { if (!CartDataValidation.ValidateEmptyCart(OrderID)) { using (ShoppingEntities entity = new ShoppingEntities()) { using (ShoppingDiscount total = new ShoppingDiscount()) { entity.Orders.First(o => o.O_ID == OrderID).O_TotalAmount = total.TotalAfterDiscount(OrderID); entity.Orders.First(o => o.O_ID == OrderID).O_Status = ShoppingData.CloseOrderStatus; entity.SaveChanges(); return(Ok("Total Amount after Discount = " + total.TotalAfterDiscount(OrderID))); } } } else { return(BadRequest("There is no item in cart")); } } else { return(BadRequest("Invalid OrderID")); } }
public ActionResult Edit(StoreViewModel model) { if (ModelState.IsValid) { var store = db.Stores.Find(model.Id); store.StoreName = model.StoreName; store.StoreAddress = model.StoreAddress; db.SaveChanges(); TempData["Message"] = "Changes have been saved."; return(RedirectToAction("Index")); } else { TempData["Message"] = "Unable to save changes. Contact the administrator."; return(RedirectToAction("Index")); } }
public ActionResult Edit(CustomerViewModel model) { int id = model.Id; string name = model.CustomerName; string address = model.CustomerAddress; string msg = ""; if (id == 0) { // New record try { var customer = new Customer() { CustomerName = name, CustomerAddress = address }; db.Customers.Add(customer); db.SaveChanges(); msg = "New record created."; } catch (Exception) { msg = "Unable to create new record. Contact the adminstrator"; } } else { // Existing record var customer = db.Customers.Find(id); if (customer == null) { return(HttpNotFound()); } try { customer.CustomerName = name; customer.CustomerAddress = address; db.SaveChanges(); msg = string.Format("Changes to {0} have been saved.", id); } catch (Exception) { msg = string.Format("Unable to save changes to {0}. Contact the administrator.", id); } } var result = new { success = "True", Message = msg }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Edit(ProductViewModel model) { if (ModelState.IsValid) { var product = db.Products.Find(model.Id); product.ProductName = model.ProductName; product.ProductPrice = model.ProductPrice; db.SaveChanges(); TempData["Message"] = "Product has been changed"; return(RedirectToAction("Index")); } else { TempData["Message"] = "Unable to edit record. Contact the administrator"; return(RedirectToAction("Index")); } }
public ActionResult Edit(ProductViewModel model) { string msg; if (model.Id == 0) // new record { try { var newproduct = new Product() { ProductName = model.ProductName, ProductPrice = model.ProductPrice }; db.Products.Add(newproduct); db.SaveChanges(); msg = "New record created"; } catch (Exception) { msg = "Unable to created new record. Contact the administrator."; } } else { var product = db.Products.Find(model.Id); if (product == null) { return(HttpNotFound()); } try { product.ProductName = model.ProductName; product.ProductPrice = model.ProductPrice; db.SaveChanges(); msg = String.Format("Changes to {0} have been saved.", model.Id); } catch (Exception) { msg = String.Format("Unable save changes for {0}. Contact the administrator", model.Id); } } var result = new { Message = msg }; return(Json(result, JsonRequestBehavior.AllowGet)); }
private void BtnAdd_Click(object sender, EventArgs e) { string productName = txtProName.Text; string price = txtPrice.Text; string comboName = cmbCatName.Text; int productPrice; if (productName != string.Empty && price != string.Empty) { if (int.TryParse(price, out productPrice)) { lblError.Visible = false; if (db.Products.Any(pro => pro.Name == productName)) { lblError.Visible = true; lblError.Text = "This Product has already been exsist in Database"; } else { int selectedcategory = db.Categories.FirstOrDefault(sc => sc.Name == comboName).Id; MessageBox.Show(selectedcategory.ToString()); db.Products.Add(new Product { Name = productName, Category_id = selectedcategory, Price = productPrice }); db.SaveChanges(); MessageBox.Show("Product have been added", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); FillDtgProduct(); } } else { lblError.Visible = true; lblError.Text = "Please enter number"; } } else { lblError.Visible = true; lblError.Text = "Please field all input"; } }
public ActionResult DeleteConfirmed(int id) { var db = new ShoppingEntities(); Product p = db.Products.Find(id); db.Products.Remove(p); db.SaveChanges(); return(RedirectToAction("ListProducts")); }
private void Button1_Click(object sender, EventArgs e) { string firstname = txtFirstName.Text; string lastname = txtLastName.Text; string email = txtEmail.Text; string password = txtPassword.Text; string repeatpassword = txtRepeat.Text; string phone = txtPhone.Text; bool allEmpty = Extensions.isNotEmpty(new string[] { firstname, lastname, email, repeatpassword, phone, password }, String.Empty); if (allEmpty) { lblError.Visible = false; if (password.Length >= 8) { if (password == repeatpassword) { Customers cusEmail = db.Customers.FirstOrDefault(a => a.Email == email); if (cusEmail == null) { Customers cus = new Customers(); cus.Firstname = firstname; cus.Surname = lastname; cus.Email = email; cus.Phone = phone; cus.Password = password.hashMe(); db.Customers.Add(cus); db.SaveChanges(); MessageBox.Show(firstname + " " + lastname + " was created successfully", "Custumer Created", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { lblError.Visible = true; lblError.Text = "Email already exsist"; } } else { lblError.Visible = true; lblError.Text = "Password and Repeat password does not contain"; } } else { lblError.Visible = true; lblError.Text = "Password should be long 8 charachter"; } } else { lblError.Visible = true; lblError.Text = "Please,field input"; } }