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 PartialViewResult GetListOfCategoriesPartial()
{
using (ShopDbDataContext db = new ShopDbDataContext())
{
ViewBag.Categories = db.Categories.ToList();
return(PartialView());
}
}
public ActionResult GetShopNamePartial()
{
using (ShopDbDataContext db = new ShopDbDataContext())
{
ViewBag.ShopName = db.AllNames.First(m => m.Name == "ShopName");
return(PartialView());
}
}
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 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 ActionResult CategoryEdit()
{
List <Categories> categories;
using (ShopDbDataContext db = new ShopDbDataContext())
{
categories = db.Categories.ToList();
}
return(View(categories));
}
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 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 ActionResult ManufacturerEdit()
{
List <Manufacturers> manufacturers;
using (ShopDbDataContext db = new ShopDbDataContext())
{
manufacturers = db.Manufacturers.ToList();
}
return(View(manufacturers));
}
public ActionResult AttributeEdit()
{
AttributeViewModel attributeViewModel = new AttributeViewModel();
using (ShopDbDataContext db = new ShopDbDataContext())
{
attributeViewModel.Attributes = db.Attributes.ToList();
attributeViewModel.Categories = db.Categories.ToList();
}
return(View(attributeViewModel));
}
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 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 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 List <string> Validate(ShopDbDataContext db)
{
List <string> errors = new List <string>();
if (db.ApplicationUsers.Any(u => u.UserName == this.UserName)) // Валидация UserName
{
errors.Add("Такой пользователь уже существует");
}
if (this.Password.Length < 6) // Валидация длины пароля
{
errors.Add("Длина пароля должна быть больше 6 символов");
}
return(errors);
}
public ActionResult UserEdit()
{
if (Session["userId"] == null || Session["isAdmin"].ToString() == false.ToString())
{
return(RedirectToAction("Index", "Shop"));
}
List <ApplicationUsers> users;
using (ShopDbDataContext db = new ShopDbDataContext())
{
users = db.ApplicationUsers.ToList();
}
return(View(users));
}
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 AttributeValueEdit(int productId)
{
ProductViewModel productViewModel = new ProductViewModel();
using (ShopDbDataContext db = new ShopDbDataContext())
{
productViewModel.Product = db.Products.First(p => p.Id == productId);
productViewModel.Manufacturer = db.Manufacturers.First(m => m.Id == productViewModel.Product.ManufacturerId);
productViewModel.Category = db.Categories.First(c => c.Id == productViewModel.Product.CategoryId);
productViewModel.Attributes = db.Attributes.Where(a => a.CategoryId == productViewModel.Category.Id).ToList();
productViewModel.AttributeValues = db.AttributeValues.Where(av => av.ProductId == productId).ToList();
}
return(View(productViewModel));
}
public ActionResult OrderDetails(int?id)
{
OrderViewModel orderViewModel = new OrderViewModel();
using (ShopDbDataContext db = new ShopDbDataContext())
{
orderViewModel.Order = db.Orders.First(o => o.Id == id);
orderViewModel.ProductOrders = db.ProductOrders.Where(po => po.OrderId == id).ToList();
var productsId = orderViewModel.ProductOrders.Select(po => po.ProductId).ToList();
orderViewModel.Products = db.Products.Where(p => productsId.Contains(p.Id)).ToList();
var manufId = orderViewModel.Products.Select(p => p.ManufacturerId).ToList();
orderViewModel.Manufacturers = db.Manufacturers.Where(m => manufId.Contains(m.Id)).ToList();
}
return(View(orderViewModel));
}
public ActionResult Index(int?id)
{
if (id == null || id != int.Parse(Session["userId"].ToString()))
{
return(Redirect("/Shop/"));
}
UserViewModel userViewModel = new UserViewModel();
using (ShopDbDataContext db = new ShopDbDataContext())
{
userViewModel.User = db.ApplicationUsers.First(u => u.Id == id);
userViewModel.Orders = db.Orders.Where(o => o.UserId == id).ToList();
}
return(View(userViewModel));
}
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 ActionResult Cart()
{
CartViewModel cartViewModel = new CartViewModel();
using (ShopDbDataContext db = new ShopDbDataContext())
{
if (Session["userId"] == null)
{
return(Redirect("/Account/Login/"));
}
cartViewModel.Cart = db.Carts.Where(c => c.UserId == (int)Session["userId"]).ToList();
var productsId = cartViewModel.Cart.Select(c => c.ProductId).ToList();
cartViewModel.Products = db.Products.Where(p => productsId.Contains(p.Id)).ToList();
var manufId = cartViewModel.Products.Select(p => p.ManufacturerId).ToList();
cartViewModel.Manufacturers = db.Manufacturers.Where(m => manufId.Contains(m.Id)).ToList();
}
return(View(cartViewModel));
}
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 Product(int?id) // Страница продукта
{
if (id == null)
{
return(Redirect("/Shop/Index"));
}
ProductViewModel productViewModel = new ProductViewModel();
using (ShopDbDataContext db = new ShopDbDataContext())
{
productViewModel.Product = db.Products.FirstOrDefault(p => p.Id == id);
productViewModel.Manufacturer = productViewModel.Product.Manufacturers;
productViewModel.Category = productViewModel.Product.Categories;
productViewModel.Attributes = db.Attributes.Where(a => a.CategoryId == productViewModel.Category.Id).ToList();
productViewModel.AttributeValues = db.AttributeValues.Where(av => av.ProductId == id).ToList();;
}
if (productViewModel.Product == null)
{
return(HttpNotFound());
}
return(View(productViewModel));
}
public ActionResult Order(CartViewModel cartViewModel)
{
if (Session["userId"] == null)
{
return(Redirect("/Account/Login/"));
}
OrderViewModel orderViewModel = new OrderViewModel();
if (cartViewModel.ProductsToBuy == null)
{
return(Redirect("/shop/"));
}
using (ShopDbDataContext db = new ShopDbDataContext())
{
orderViewModel.UserId = int.Parse(Session["userId"].ToString());
orderViewModel.User = db.ApplicationUsers.First(a => a.Id == orderViewModel.UserId);
orderViewModel.Address = orderViewModel.User.Address;
orderViewModel.Phone = orderViewModel.User.PhoneNumber;
orderViewModel.Price = cartViewModel.FinalSum;
orderViewModel.ProductsToBuy = cartViewModel.ProductsToBuy;
}
return(View(orderViewModel));
}
