public ShoppingCarts(Products product, int quantity, string cartId) { Product = product; Quantity = quantity; DateCreated = DateTime.Now; CartId = cartId; }
public void AddToCart(Products product) { var cartItems = _cartRepo.GetAll(); if (cartItems.Count == 0) { var cartItem = new ShoppingCarts(product, 1, ShoppingCartId); _cartRepo.Save(cartItem); } else if (cartItems.Count > 0) { var cartItem = cartItems.FirstOrDefault(x => x.CartId == ShoppingCartId && x.Product.Name == product.Name); if (cartItem == null) { cartItem = new ShoppingCarts(product, 1, ShoppingCartId); _cartRepo.Save(cartItem); } else { cartItem.Quantity++; } _cartRepo.Update(cartItem); } }
public void Delete(Products entity) { using (_session.BeginTransaction()) { _session.Delete(entity); _session.Transaction.Commit(); } }
public ActionResult Create(ProductModel model) { bool isNotExist = _productRepo.FindDuplicateByName(model.Name); if (isNotExist) { Categories category = _categoryRepo.Get(Int32.Parse(model.Category)); Manufacturers manufacturer = _manufacturersRepo.Get(Int32.Parse(model.Manufacturer)); var product = new Products(model.Name, model.Description, Convert.ToDecimal(model.Price, CultureInfo.InvariantCulture), category, manufacturer, Int32.Parse(model.Quantity), model.IsFeatured, model.IsRecent, model.IsBestSeller, model.ShortDescription); try { _productRepo.Save(product); TempData["success"] = "Pomyślnie dodano nowy towar."; return RedirectToAction("index"); } catch (Exception) { TempData["error"] = "Wystąpił problem z połączeniem do bazy danych."; return RedirectToAction("Create"); } } TempData["error"] = "Towar o podanej nazwie już istnieje"; return RedirectToAction("Create"); }
public void Save(Products entity) { _session.Save(entity); }
public void Products() { var conn = new NHibernateConnection(); var productRepo = new ProductsRepository(conn); var categoryRepo = new CategoryRepository(conn); var manufacturersRepository = new ManufacturersRepository(conn); Categories category = categoryRepo.Get(4); Manufacturers manufacturer = manufacturersRepository.Get(1); var product = new Products("Towar", "Jego opis", Convert.ToDecimal(125.99), category, manufacturer, 100, false, true, false, "Krótki opis"); productRepo.Save(product); Products fromDB = productRepo.Get(product.ID); Assert.AreEqual(product, fromDB); }
public ActionResult Create(CreateProductModel model) { bool isNotExist = _productsRepository.FindDuplicateByName(model.Name); if (isNotExist) { var categoryId = Convert.ToInt32(model.Category); var manufacturerId = Convert.ToInt32(model.Manufacturer); var price = model.Price.Contains(".") ? Convert.ToDecimal(model.Price.Replace('.', ',')) : Convert.ToDecimal(model.Price); var newProduct = new Products(model.Name, model.Description ?? String.Empty, price, _categoryRepository.Get(categoryId), _manufacturerRepository.Get(manufacturerId), model.Quantity, model.IsFeatured, model.IsRecent, model.IsBestseller, model.ShortDescription); try { _productsRepository.Save(newProduct); if (model.Photo != null) { var target = new MemoryStream(); model.Photo.InputStream.CopyTo(target); var data = target.ToArray(); var productImage = new ProductImages(model.Photo.FileName, data, newProduct); _productImagesRepository.Save(productImage); } TempData["success"] = String.Format("Produkt {0} została utworzona pomyślnie", newProduct.Name); } catch (Exception) { throw new Exception(); } return RedirectToAction("List"); } TempData["error"] = String.Format("Produkt o nazwie {0} już istnieje", model.Name); return RedirectToAction("List"); }
public ActionResult Update(CreateProductModel model, int id) { bool isNotExist = _productsRepository.FindDuplicateByNameAndID(model.Name, id); if (isNotExist) { var categoryId = Convert.ToInt32(model.Category); var manufacturerId = Convert.ToInt32(model.Manufacturer); var price = model.Price.Contains(".") ? Convert.ToDecimal(model.Price.Replace('.', ',')) : Convert.ToDecimal(model.Price); var newProduct = new Products(model.Name, model.Description, price, _categoryRepository.Get(categoryId), _manufacturerRepository.Get(manufacturerId), model.Quantity, model.IsFeatured, model.IsRecent, model.IsBestseller, model.ShortDescription) {ID = id}; try { _productsRepository.Update(newProduct); TempData["success"] = String.Format("Produkt {0} został edytowany pomyślnie", newProduct.Name); } catch (Exception) { throw new Exception(); } } else { TempData["error"] = String.Format("Produkt o nazwie {0} już istnieje", model.Name); } return RedirectToAction("Update", new {id = id}); }
public ActionResult InstallDB() { _session.CreateSQLQuery("delete from orderdetails").ExecuteUpdate(); _session.CreateSQLQuery("delete from orders").ExecuteUpdate(); _session.CreateSQLQuery("delete from productimages").ExecuteUpdate(); _session.CreateSQLQuery("delete from products").ExecuteUpdate(); _session.CreateSQLQuery("delete from categories").ExecuteUpdate(); _session.CreateSQLQuery("delete from manufacturers").ExecuteUpdate(); _session.CreateSQLQuery("delete from users").ExecuteUpdate(); _session.CreateSQLQuery("delete from deliverytypes").ExecuteUpdate(); #region catregorie var category1 = new Categories("Akcja",""); var category2 = new Categories("MMO", ""); var category3 = new Categories("Zręcznościowe", ""); var category4 = new Categories("Klasyka", ""); var category5 = new Categories("Strategia", ""); var category6 = new Categories("Logiczne", ""); var category7 = new Categories("Bijatyki", ""); var category8 = new Categories("Sportowe", ""); var category9 = new Categories("Wyścigi i rajdy", ""); var category10 = new Categories("Symulatory", ""); _catRepo.Save(category1); _catRepo.Save(category2); _catRepo.Save(category3); _catRepo.Save(category4); _catRepo.Save(category5); _catRepo.Save(category6); _catRepo.Save(category7); _catRepo.Save(category8); _catRepo.Save(category9); _catRepo.Save(category10); #endregion #region producenci var manufacturer = new Manufacturers("Electronic Arts"); var manufacturer2 = new Manufacturers("Ubisoft"); var manufacturer3 = new Manufacturers("CD Projekt RED"); var manufacturer4 = new Manufacturers("Blizzard"); var manufacturer5 = new Manufacturers("SEGA"); var manufacturer6 = new Manufacturers("Valve"); var manufacturer7 = new Manufacturers("BioVare"); var manufacturer8 = new Manufacturers("Activision"); var manufacturer9 = new Manufacturers("RockstarGames"); var manufacturer10 = new Manufacturers("THQ"); _manuRepo.Save(manufacturer); _manuRepo.Save(manufacturer2); _manuRepo.Save(manufacturer3); _manuRepo.Save(manufacturer5); _manuRepo.Save(manufacturer4); _manuRepo.Save(manufacturer6); _manuRepo.Save(manufacturer7); _manuRepo.Save(manufacturer8); _manuRepo.Save(manufacturer9); _manuRepo.Save(manufacturer10); #endregion #region products Random rand = new Random(); for (int i = 0; i < 30; i++) { string name = "Test " + i; string description = "Description " + i; string shortDescription = "Short desc " + i; var randomPrice = rand.Next(20, 200); var category = rand.Next(category1.ID, category6.ID+1); var producXt = new Products(name, description, Convert.ToDecimal(randomPrice), _catRepo.Get(category), _manuRepo.Get(category), category, Common.GetRandomBool(), Common.GetRandomBool(), Common.GetRandomBool(), shortDescription); _productRepo.Save(producXt); } #endregion #region productImages string filename = Server.MapPath(Url.Content("~/FrontEnd/img/empty_gallery.png")); //@"C:\Projekty\SklepInternetowy\SklepInternetowy\FrontEnd\img\empty_gallery.png"; //string filename = @"E:\Projekty\SklepInternetowy\SklepInternetowy\FrontEnd\img\empty_gallery.png"; byte[] bytes = System.IO.File.ReadAllBytes(filename); IList<Products> products = _productRepo.GetAll(); foreach (Products productse in products) { var productImages = new ProductImages(filename, bytes, productse); _productImagesRepository.Save(productImages); } #endregion #region users string password = "******"; var crypto = new PBKDF2(); string enryptPass = crypto.Compute(password); string Email = "*****@*****.**"; string City = "WWA"; string Address = "Sik 41/12"; bool IsAdmin = false; string Name = "Name"; string Surname = "Surname"; string ipAddress = "102.154.12.12"; string ZipCode = "12-222"; string Password = enryptPass; string PasswordSalt = crypto.Salt; var user = new Users(Name, Surname, Email, Password, City, Address, ZipCode, IsAdmin, PasswordSalt, ipAddress); string pass = "******"; string email2 = "*****@*****.**"; string enryptPass2 = crypto.Compute(pass); string password2 = enryptPass2; string passwordSalt = crypto.Salt; var user2 = new Users(Name, Surname, email2, password2, City, Address, ZipCode, true, passwordSalt, ipAddress); _userRepo.Save(user); _userRepo.Save(user2); #endregion #region deliveryTypes var deliveryType = new DeliveryTypes("Poczta Polska", Convert.ToDecimal(8.99)); _deliveryRepo.Save(deliveryType); #endregion #region orders Random rnd = new Random(); for (int i = 0; i < 15; i++) { System.Threading.Thread.Sleep(50); var order1 = new Orders(user, DateTime.Now.AddDays(-2.0), Convert.ToDecimal(rnd.Next(50, 400)), deliveryType); var order2 = new Orders(user2, DateTime.Now.AddDays(-rnd.Next(1, 50)), Convert.ToDecimal(rnd.Next(50, 400)), deliveryType); _ordersRepository.Save(order1); _ordersRepository.Save(order2); } var order = new Orders(user, DateTime.Now, Convert.ToDecimal(29.99), deliveryType); _ordersRepository.Save(order); #endregion string[] myCookies = Request.Cookies.AllKeys; foreach (string cookie in myCookies) { Response.Cookies[cookie].Expires = DateTime.Now.AddDays(-1); } FormsAuthentication.SignOut(); return RedirectToAction("index", "Home"); }
public void SaveProduct() { var category = _categoryRepository.GetAll().First(); var manufacturer = _manufacturersRepository.GetAll().First(); Assert.IsNotNull(category); Assert.IsNotNull(manufacturer); var product = new Products("TestName", "", Convert.ToDecimal(29.99), category, manufacturer, 1, true, true, true, ""); Assert.AreEqual(0,product.ID); _productsRepository.Save(product); Assert.AreNotEqual(0,product.ID); }