public RedirectToRouteResult AttributeValueEdit(int productId, AttributeViewModel attributeViewModel) { using (ShopDbDataContext db = new ShopDbDataContext()) { foreach (KeyValuePair <string, string> attrVal in attributeViewModel.AttributeValuesDict) { var ifExistAttrValue = db.AttributeValues.First(av => av.ProductId == productId && av.AttributeId == int.Parse(attrVal.Key)); if (ifExistAttrValue != null) { ifExistAttrValue.Value = attrVal.Value; db.SubmitChanges(); } else { AttributeValues attributeValues = new AttributeValues { ProductId = productId, AttributeId = int.Parse(attrVal.Key), Value = attrVal.Value }; db.AttributeValues.InsertOnSubmit(attributeValues); db.SubmitChanges(); } } } return(RedirectToAction("ProductEdit", "Admin")); }
public RedirectToRouteResult ManufacturerDelete(int id) { using (ShopDbDataContext db = new ShopDbDataContext()) { var manufacturerToDelete = db.Manufacturers.First(c => c.Id == id); db.Manufacturers.DeleteOnSubmit(manufacturerToDelete); db.SubmitChanges(); } return(RedirectToAction("ManufacturerEdit", "Admin")); }
public RedirectToRouteResult ProductDelete(int id) { using (ShopDbDataContext db = new ShopDbDataContext()) { var productToDelete = db.Products.First(c => c.Id == id); db.Products.DeleteOnSubmit(productToDelete); db.SubmitChanges(); } return(RedirectToAction("ProductEdit", "Admin")); }
public RedirectToRouteResult AttributeDelete(int id) { using (ShopDbDataContext db = new ShopDbDataContext()) { var attributeToDelete = db.Attributes.First(c => c.Id == id); db.Attributes.DeleteOnSubmit(attributeToDelete); db.SubmitChanges(); } return(RedirectToAction("AttributeEdit", "Admin")); }
public RedirectToRouteResult CategoryDelete(int id) { using (ShopDbDataContext db = new ShopDbDataContext()) { var categoryToDelete = db.Categories.First(c => c.Id == id); db.Categories.DeleteOnSubmit(categoryToDelete); db.SubmitChanges(); } return(RedirectToAction("CategoryEdit", "Admin")); }
public RedirectToRouteResult CategoryEdit(int id, string name) { using (ShopDbDataContext db = new ShopDbDataContext()) { var categoryToEdit = db.Categories.First(c => c.Id == id); categoryToEdit.Name = name; db.SubmitChanges(); } return(RedirectToAction("CategoryEdit", "Admin")); }
public RedirectToRouteResult PasswordEdit(RegisterUserViewModel registerUserViewModel) { using (ShopDbDataContext db = new ShopDbDataContext()) { var userToChangePassword = db.ApplicationUsers.First(u => u.Id == registerUserViewModel.Id); userToChangePassword.PasswordHash = registerUserViewModel.GetPasswordHash(); db.SubmitChanges(); } return(RedirectToAction("UserEdit", "Admin")); }
public RedirectToRouteResult ManufacturerEdit(int id, string name) { using (ShopDbDataContext db = new ShopDbDataContext()) { var manufacturerToEdit = db.Manufacturers.First(c => c.Id == id); manufacturerToEdit.Name = name; db.SubmitChanges(); } return(RedirectToAction("ManufacturerEdit", "Admin")); }
public RedirectToRouteResult AttributeEdit(int id, string name, int categoryId) { using (ShopDbDataContext db = new ShopDbDataContext()) { var attributeToEdit = db.Attributes.First(c => c.Id == id); attributeToEdit.Name = name; attributeToEdit.CategoryId = categoryId; db.SubmitChanges(); } return(RedirectToAction("AttributeEdit", "Admin")); }
public RedirectToRouteResult CategoryCreate(string name) { using (ShopDbDataContext db = new ShopDbDataContext()) { Categories newCategory = new Categories { Name = name }; db.Categories.InsertOnSubmit(newCategory); db.SubmitChanges(); } return(RedirectToAction("CategoryEdit", "Admin")); }
public RedirectToRouteResult ManufacturerCreate(string name) { using (ShopDbDataContext db = new ShopDbDataContext()) { Manufacturers newManufacturer = new Manufacturers { Name = name }; db.Manufacturers.InsertOnSubmit(newManufacturer); db.SubmitChanges(); } return(RedirectToAction("ManufacturerEdit", "Admin")); }
public RedirectToRouteResult AttributeCreate(string name, int categoryId) { using (ShopDbDataContext db = new ShopDbDataContext()) { Attributes newAttribute = new Attributes { Name = name, CategoryId = categoryId }; db.Attributes.InsertOnSubmit(newAttribute); db.SubmitChanges(); } return(RedirectToAction("AttributeEdit", "Admin")); }
public ActionResult Order(OrderViewModel orderViewModel) { if (ModelState.IsValid) { using (ShopDbDataContext db = new ShopDbDataContext()) { Orders newOrder = new Orders { UserId = orderViewModel.UserId, Address = orderViewModel.Address, Phone = orderViewModel.Phone, Price = orderViewModel.Price, DateOfOrder = DateTime.Now }; db.Orders.InsertOnSubmit(newOrder); db.SubmitChanges(); foreach (var product in orderViewModel.ProductsToBuy) { ProductOrders newProductOrder = new ProductOrders { OrderId = newOrder.Id, ProductId = int.Parse(product.Key), Quantity = int.Parse(product.Value) }; db.ProductOrders.InsertOnSubmit(newProductOrder); } var cartToDelete = db.Carts.Where(c => c.UserId == orderViewModel.UserId); db.Carts.DeleteAllOnSubmit(cartToDelete); db.SubmitChanges(); } return(View("OrderDone")); } else { return(View(orderViewModel)); } }
public RedirectToRouteResult ProductCreate(Products newProduct, HttpPostedFileBase Image) { if (Image != null) { string newFileName = System.IO.Path.GetFileName(Image.FileName); using (ShopDbDataContext db = new ShopDbDataContext()) { newProduct.Image = newFileName; db.Products.InsertOnSubmit(newProduct); db.SubmitChanges(); Image.SaveAs(Server.MapPath("~/Content/Img/" + newFileName)); } } return(RedirectToAction("AttributeValueEdit", "Admin", new { productId = newProduct.Id })); }
public RedirectToRouteResult UserEdit(RegisterUserViewModel user) { if (Session["userId"] == null || Session["isAdmin"].ToString() == false.ToString()) { return(RedirectToAction("Index", "Shop")); } using (ShopDbDataContext db = new ShopDbDataContext()) { var userToEdit = db.ApplicationUsers.First(u => u.Id == user.Id); userToEdit.UserName = user.UserName; userToEdit.Email = user.Email; userToEdit.PhoneNumber = user.PhoneNumber; userToEdit.Address = user.Address; userToEdit.IsAdmin = user.IsAdmin; db.SubmitChanges(); } return(RedirectToAction("UserEdit", "Admin")); }
public RedirectToRouteResult UserDelete(int?id) { if (Session["userId"] == null || Session["isAdmin"].ToString() == false.ToString()) { return(RedirectToAction("Index", "Shop")); } if (id != null) { using (ShopDbDataContext db = new ShopDbDataContext()) { var userToDelete = db.ApplicationUsers.First(u => u.Id == id); db.ApplicationUsers.DeleteOnSubmit(userToDelete); db.SubmitChanges(); return(RedirectToRoute("UserDeleteRoute")); } } return(RedirectToAction("UserDelete", "Admin")); }
public RedirectToRouteResult ProductEdit(Products editedProduct, HttpPostedFileBase Image) { using (ShopDbDataContext db = new ShopDbDataContext()) { var productToEdit = db.Products.First(c => c.Id == editedProduct.Id); productToEdit.Name = editedProduct.Name; productToEdit.ManufacturerId = editedProduct.ManufacturerId; productToEdit.CategoryId = editedProduct.CategoryId; productToEdit.Price = editedProduct.Price; if (Image != null) { string newFileName = System.IO.Path.GetFileName(Image.FileName); productToEdit.Image = newFileName; Image.SaveAs(Server.MapPath("~/Content/Img/" + newFileName)); } db.SubmitChanges(); return(RedirectToAction("AttributeValueEdit", "Admin", new { productId = productToEdit.Id })); } }
public ActionResult UserAdd(RegisterUserViewModel user) { if (Session["userId"] == null || Session["isAdmin"].ToString() == false.ToString()) { return(RedirectToAction("Index", "Shop")); } if (ModelState.IsValid) { using (ShopDbDataContext db = new ShopDbDataContext()) { var validateResult = user.Validate(db); if (validateResult.Count() > 0) // В случае неуспешной валидации выводим ошибки { foreach (string error in validateResult) { ModelState.AddModelError("", error); } return(View()); } else { ApplicationUsers newUser = new ApplicationUsers { UserName = user.UserName, PasswordHash = user.GetPasswordHash(), Email = user.Email, PhoneNumber = user.PhoneNumber, Address = user.Address, IsAdmin = user.IsAdmin }; db.ApplicationUsers.InsertOnSubmit(newUser); db.SubmitChanges(); return(RedirectToAction("Index", "Admin")); } } } else { return(View()); } }
public ActionResult Register(RegisterUserViewModel user) { if (ModelState.IsValid) { using (ShopDbDataContext db = new ShopDbDataContext()) { var validateResult = user.Validate(db); if (validateResult.Count() > 0) // В случае неуспешной валидации выводим ошибки { foreach (string error in validateResult) { ModelState.AddModelError("", error); } return(View()); } else { ApplicationUsers newUser = new ApplicationUsers { UserName = user.UserName, PasswordHash = user.GetPasswordHash(), Email = user.Email, PhoneNumber = user.PhoneNumber, Address = user.Address }; db.ApplicationUsers.InsertOnSubmit(newUser); db.SubmitChanges(); return(RedirectToAction("Login", "Account")); } } } else { return(View()); } }
public PartialViewResult AddToCartPartial(int productId) { if (Session["userName"] != null) { using (ShopDbDataContext db = new ShopDbDataContext()) { var cart = db.Carts .Where(c => c.UserId == (int)Session["userId"]) .Where(c => c.ProductId == productId) .FirstOrDefault(); if (cart == null) { db.Carts.InsertOnSubmit(new Carts { UserId = (int)Session["userId"], ProductId = productId, Quantity = 1 }); } else { cart.Quantity += 1; } try { db.SubmitChanges(); ViewBag.Result = "OK"; } catch (Exception e) { ViewBag.Result = e; } } } return(PartialView()); }