public static List<Adress> Select(string userName) { using (var dbContext = new DataContext()) { User user = new UserRepository().Find(userName); return dbContext.Adresses.Where(s => s.UserId == user.UserId).ToList(); } }
// // GET: /Home/CreateComment public ActionResult CreateComment(String comments, int productId) { int userId = new UserRepository().Find(User.Identity.Name).UserId; DescriptionRepository.Add(comments, productId, userId); return RedirectToAction("ViewProduct", "Search", new { productId = productId }); }
// // GET: /Personal/ public ActionResult PersonalPage() { int id = new UserRepository().Find(User.Identity.Name).UserId; var products = BasketRepository.Select(id); var baskets = new List<BasketModel>(); double totalPrice = 0; if (products != null) { foreach (var item in products) { double rate = CurrencyRepository.Rate(CurrencyRepository.ReturnId(item.ProductId)); if (item.Discount != 0) totalPrice += item.Price * item.Discount * rate; else totalPrice += item.Price * rate; baskets.Add(new BasketModel() { ProductId = item.ProductId, QuantityProduct = 1, Name = item.Name, Price = item.Price, Discount = item.Discount, CurrencyId = CurrencyRepository.ReturnId(item.ProductId) }); } } OrderModel order = new OrderModel() { TotalPrice = totalPrice, Basket = baskets }; return View(order); }
public ActionResult CreateOrder(Order order) { if (ModelState.IsValid) { if (order.AdressId != -1 ) { int orderId = new OrderRepository().Add(order); int id = new UserRepository().Find(User.Identity.Name).UserId; var products = BasketRepository.Select(id); foreach (var item in products) { new OrderRepository().AddOrderProduct(new OrderProduct() { OrderId = orderId, ProductId = item.ProductId, Quantity = 1, }); BasketRepository.Delete(item.ProductId, id); } return View("message"); } } return View(order); }
public ActionResult DeleteFromBasket(int idProduct, String nameUser) { int idUser = new UserRepository().Find(nameUser).UserId; BasketRepository.Delete(idProduct, idUser); return RedirectToAction("PersonalPage"); }