public IHttpActionResult PutProducts_StoreProduct(int id, Products_StoreProduct products_StoreProduct) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != products_StoreProduct.Id) { return(BadRequest()); } db.Entry(products_StoreProduct).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!Products_StoreProductExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public string InsertDb(tbl_products args) { string result = ""; if (ValidateExist(args, null)) { tbl_products product = new tbl_products { number = args.number, title = args.title, price = args.price, last_update = DateTime.Now }; db.tbl_products.Add(product); db.SaveChanges(); InsertProductCategories(product.id_product, args.ids_product_categories); result = "Producto guardado exitosamente!"; } else { result = "El producto ya existe en la base de datos"; } return(result); }
public ActionResult CreateUser([Bind(Include = "Id,Ime,Prezime,Email,AdresaDostave,Kontakt,Napomena")] Korisnici korisnici) { if (ModelState.IsValid) { db.Korisnicis.Add(korisnici); db.SaveChanges(); return(RedirectToAction("CreateOrder", korisnici)); } return(View(korisnici)); }
public ActionResult Create([Bind(Include = "ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued")] Product product) { if (ModelState.IsValid) { db.Products.Add(product); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CategoryID = new SelectList(db.Categories, "CategoryID", "CategoryName", product.CategoryID); return(View(product)); }
public ActionResult Create([Bind(Include = "ItemId,CategoryId,ProducerId,Title,Price,ItemArtUrl")] Item item) { if (ModelState.IsValid) { db.Items.Add(item); db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.CategoryId = new SelectList(db.Categories, "CategoryId", "Name", item.CategoryId); ViewBag.ProducerId = new SelectList(db.Producers, "ProducerId", "Name", item.ProducerId); return View(item); }
public ActionResult Create([Bind(Include = "Id,Img,Stock,Name,Price,Section")] Products_StoreProduct products_StoreProduct) { if (ModelState.IsValid) { if (products_StoreProduct.Img == null) { products_StoreProduct.Img = "https://www.allianceplast.com/wp-content/uploads/no-image.png"; } db.Products_StoreProduct.Add(products_StoreProduct); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(products_StoreProduct)); }
public bool InsertOrder(Order newOrder) { try { WebShopEntities db = new WebShopEntities(); Order order = new Order(); order.email = newOrder.email; order.userId = newOrder.userId; order.address = newOrder.address; order.total = newOrder.total; order.status = newOrder.status; order.id = (from c in db.Orders orderby c.id descending select c.id).First() + 1; if (order.id < 10) { order.code = "OR00" + order.id; } else if (order.id >= 10 && order.id < 100) { order.code = "OR0" + order.id; } else { order.code = "OR" + order.id; } db.Orders.Add(order); db.SaveChanges(); return(true); } catch { return(false); } }
public bool InsertCategory(Category newCategory) { try { WebShopEntities db = new WebShopEntities(); Category category = new Category(); category.name = newCategory.name; category.description = newCategory.description; category.id = (from c in db.Categories orderby c.id descending select c.id).First() + 1; if (category.id < 10) { category.code = "CAT00" + category.id; } else if (category.id >= 10 && category.id < 100) { category.code = "CAT0" + category.id; } else { category.code = "CAT" + category.id; } db.Categories.Add(category); db.SaveChanges(); return(true); } catch { return(false); } }
/// <summary> /// Método que realiza el guardado de productCategories /// en la base de datos. /// </summary> /// <param name="args">Objeto con los argumentos requeridos.</param> /// <returns>String con las respuesta de la operación</returns> private string InsertDb(tbl_product_categories args) { string result = ""; try { if (validateExist(args, null)) { tbl_product_categories category = new tbl_product_categories { description = args.description, last_update = DateTime.Now }; db.tbl_product_categories.Add(category); db.SaveChanges(); result = "Categoría guardada correctamente"; } else { result = "La categoría ya existe en la base de datos"; } } catch (Exception error) { result = error.Message.ToString(); } return(result); }
public bool InsertOrderDetail(OrderDetail newOrderDetail) { try { WebShopEntities db = new WebShopEntities(); OrderDetail orderDetail = new OrderDetail(); orderDetail.idProduct = newOrderDetail.idProduct; orderDetail.quantity = newOrderDetail.quantity; orderDetail.price = newOrderDetail.price; orderDetail.totalPrice = newOrderDetail.totalPrice; orderDetail.id = (from c in db.OrderDetails orderby c.id descending select c.id).First() + 1; if (orderDetail.id < 10) { orderDetail.code = "ORDT00" + orderDetail.id; } else if (orderDetail.id >= 10 && orderDetail.id < 100) { orderDetail.code = "ORDT0" + orderDetail.id; } else { orderDetail.code = "ORDT" + orderDetail.id; } db.OrderDetails.Add(orderDetail); db.SaveChanges(); return(true); } catch { return(false); } }
public bool InsertImportBill(ImportBill newImportBill) { try { WebShopEntities db = new WebShopEntities(); ImportBill importBill = new ImportBill(); importBill.agencyName = newImportBill.agencyName; importBill.address = newImportBill.address; importBill.phone = newImportBill.phone; importBill.total = newImportBill.total; importBill.id = (from c in db.ImportBills orderby c.id descending select c.id).First() + 1; if (importBill.id < 10) { importBill.code = "IMT00" + importBill.id; } else if (importBill.id >= 10 && importBill.id < 100) { importBill.code = "IMT0" + importBill.id; } else { importBill.code = "IMT" + importBill.id; } db.ImportBills.Add(importBill); db.SaveChanges(); return(true); } catch { return(false); } }
public bool UpdateProduct(int id, Product newProduct) { try { WebShopEntities db = new WebShopEntities(); Product product = db.Products.FirstOrDefault(x => x.id == id); if (product == null) { return(false); } product.code = newProduct.code; product.name = newProduct.name; product.description = newProduct.description; product.detail = newProduct.detail; product.idCategory = newProduct.idCategory; product.price = newProduct.price; product.quantity = newProduct.quantity; product.image = newProduct.image; product.discount = newProduct.discount; db.SaveChanges(); return(true); } catch { return(false); } }
public string Remove(int id) { string result = ""; try { List <tbl_product_categories> categories = new List <tbl_product_categories>(); var sessionStorage = Session["isLocalStorage"]; if (sessionStorage == null || (bool)sessionStorage == false) { db.tbl_product_categories.RemoveRange(db.tbl_product_categories.Where(pc => pc.id_product_category == id)); db.SaveChanges(); } else { categories = (List <tbl_product_categories>)Session["productCategories"]; var itemToRemove = categories.Single(r => r.id_product_category == id); categories.Remove(itemToRemove); Session["productCategories"] = categories; } result = "La Categoría se ha eliminado de forma exitosa."; } catch (Exception error) { result = error.Message.ToString(); } return(result); }
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.Username = User.Identity.Name; order.OrderDate = DateTime.Now; storeDB.Orders.Add(order); storeDB.SaveChanges(); var cart = ShoppingCart.GetCart(this.HttpContext); cart.CreateOrder(order); return(RedirectToAction("Complete", new { id = order.OrderId })); } } catch { return(View(order)); } }
public string Remove(int id) { string result = ""; try { var sessionStorage = Session["isLocalStorage"]; if (sessionStorage == null || (bool)sessionStorage == false) { db.tbl_relationship_pc.RemoveRange(db.tbl_relationship_pc.Where(rel => rel.id_product == id)); db.tbl_products.RemoveRange(db.tbl_products.Where(p => p.id_product == id)); db.SaveChanges(); } else if ((bool)sessionStorage == true) { List <tbl_products> products = (List <tbl_products>)Session["products"]; var itemToRemove = products.Single(p => p.id_product == id); products.Remove(itemToRemove); Session["products"] = products; } result = "El producto se ha eliminado correctamente."; } catch (Exception error) { result = error.Message.ToString(); } return(result); }
public bool InsertImportBillDetail(ImportBillDetail newImportBillDetail) { try { WebShopEntities db = new WebShopEntities(); ImportBillDetail importBillDetail = new ImportBillDetail(); importBillDetail.quantity = newImportBillDetail.quantity; importBillDetail.price = newImportBillDetail.price; importBillDetail.totalPrice = newImportBillDetail.totalPrice; importBillDetail.id = (from c in db.ImportBillDetails orderby c.id descending select c.id).First() + 1; if (importBillDetail.id < 10) { importBillDetail.code = "IMTDT00" + importBillDetail.id; } else if (importBillDetail.id >= 10 && importBillDetail.id < 100) { importBillDetail.code = "IMTDT0" + importBillDetail.id; } else { importBillDetail.code = "IMTDT" + importBillDetail.id; } db.ImportBillDetails.Add(importBillDetail); db.SaveChanges(); return(true); } catch { return(false); } }
public ActionResult Create(ShoppingCart shoppingCart) { foreach (Products_OrderProduct orderProduct in shoppingCart) { db.Products_StoreProduct.Find(orderProduct.Id).Stock -= orderProduct.Quantity; } Client myClient = db.Clients.Where(client => client.Name.Equals(User.Identity.Name)).First(); Order order = db.Orders.Add(new Order(shoppingCart, myClient)); db.SaveChanges(); shoppingCart.Clear(); return(RedirectToAction("Details", new { id = order.Id })); }
public bool DeleteOrderDetail(int id) { try { WebShopEntities db = new WebShopEntities(); OrderDetail orderDetail = db.OrderDetails.FirstOrDefault(x => x.id == id); if (orderDetail == null) { return(false); } db.OrderDetails.Remove(orderDetail); db.SaveChanges(); return(true); } catch { return(false); } }
public bool DeleteImportBill(int id) { try { WebShopEntities db = new WebShopEntities(); ImportBill importBill = db.ImportBills.FirstOrDefault(x => x.id == id); if (importBill == null) { return(false); } db.ImportBills.Remove(importBill); db.SaveChanges(); return(true); } catch { return(false); } }
public bool DeleteCategory(int id) { try { WebShopEntities db = new WebShopEntities(); Category category = db.Categories.FirstOrDefault(x => x.id == id); if (category == null) { return(false); } db.Categories.Remove(category); db.SaveChanges(); return(true); } catch { return(false); } }
public bool DeleteProduct(int id) { try { WebShopEntities db = new WebShopEntities(); Product product = db.Products.FirstOrDefault(x => x.id == id); if (product == null) { return(false); } db.Products.Remove(product); db.SaveChanges(); return(true); } catch { return(false); } }
public bool UpdateImportBillDetail(int id, ImportBillDetail newImportBillDetail) { try { WebShopEntities db = new WebShopEntities(); ImportBillDetail importBillDetail = db.ImportBillDetails.FirstOrDefault(x => x.id == id); if (importBillDetail == null) { return(false); } importBillDetail.quantity = newImportBillDetail.quantity; importBillDetail.price = newImportBillDetail.price; importBillDetail.totalPrice = newImportBillDetail.totalPrice; db.SaveChanges(); return(true); } catch { return(false); } }
public bool UpdateCategory(int id, Category newCategory) { try { WebShopEntities db = new WebShopEntities(); Category category = db.Categories.FirstOrDefault(x => x.id == id); if (category == null) { return(false); } category.code = newCategory.code; category.name = newCategory.name; category.description = newCategory.description; db.SaveChanges(); return(true); } catch { return(false); } }
public bool UpdateOrderDetail(int id, OrderDetail newOrderDetail) { try { WebShopEntities db = new WebShopEntities(); OrderDetail orderDetail = db.OrderDetails.FirstOrDefault(x => x.id == id); if (orderDetail == null) { return(false); } orderDetail.idProduct = newOrderDetail.idProduct; orderDetail.quantity = newOrderDetail.quantity; orderDetail.price = newOrderDetail.price; orderDetail.totalPrice = newOrderDetail.totalPrice; db.SaveChanges(); return(true); } catch { return(false); } }
public bool UpdateOrder(int id, Order newOrder) { try { WebShopEntities db = new WebShopEntities(); Order order = db.Orders.FirstOrDefault(x => x.id == id); if (order == null) { return(false); } order.email = newOrder.email; order.userId = newOrder.userId; order.address = newOrder.address; order.total = newOrder.total; order.status = newOrder.status; db.SaveChanges(); return(true); } catch { return(false); } }
public bool UpdateImportBill(int id, ImportBill newImportBill) { try { WebShopEntities db = new WebShopEntities(); ImportBill importBill = db.ImportBills.FirstOrDefault(x => x.id == id); if (importBill == null) { return(false); } importBill.agencyName = newImportBill.agencyName; importBill.code = newImportBill.code; importBill.address = newImportBill.address; importBill.phone = newImportBill.phone; importBill.total = newImportBill.total; db.SaveChanges(); return(true); } catch { return(false); } }
public bool InsertProduct(Product newProduct) { try { WebShopEntities db = new WebShopEntities(); Product product = new Product(); product.name = newProduct.name; product.description = newProduct.description; product.id = (from c in db.Products orderby c.id descending select c.id).First() + 1; if (product.id < 10) { product.code = "PRO00" + product.id; } else if (product.id >= 10 && product.id < 100) { product.code = "PRO0" + product.id; } else { product.code = "PRO" + product.id; } product.detail = newProduct.detail; product.idCategory = newProduct.idCategory; product.price = newProduct.price; product.quantity = newProduct.quantity; product.image = newProduct.image; product.discount = newProduct.discount; db.Products.Add(product); db.SaveChanges(); return(true); } catch { return(false); } }
public ActionResult Create(Client client) { db.Clients.Add(client); db.SaveChanges(); return(RedirectToAction("Index", "Home")); }