public ActionResult Create(OrderDetailViewModel orderDetailVM) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var orderDetails = new OrderDetails { Quantity = orderDetailVM.OrderDetails.Quantity, QuantityPrice = orderDetailVM.OrderDetails.QuantityPrice, ItemPrice = orderDetailVM.OrderDetails.ItemPrice, TotalOrderPrice = orderDetailVM.OrderDetails.TotalOrderPrice, OrderId = orderDetailVM.OrderDetails.OrderId, Orders = orderDetailVM.OrderDetails.Orders, ManufacturerProductId = orderDetailVM.OrderDetails.ManufacturerProductId, ManufacturerProducts = orderDetailVM.OrderDetails.ManufacturerProducts }; if (ModelState.IsValid) { db.OrderDetails.Add(orderDetails); db.SaveChanges(); return(RedirectToAction("Index")); } orderDetailVM.ManufacturerProducts = db.ManufacturerProducts.ToList(); orderDetailVM.Orders = db.Orders.ToList(); return(View(orderDetailVM)); } }
// GET: Manufacturer public ActionResult Index() { using (GoodSupplyEntities db = new GoodSupplyEntities()) { return(View(db.Manufacturers.ToList())); } }
public ActionResult IndexClients() { using (GoodSupplyEntities db = new GoodSupplyEntities()) { return(View(db.Clients.ToList())); } }
public ActionResult ClientChangePassword(ChangePasswordViewModel model) { if (!ModelState.IsValid) { return(View(model)); } else { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var client = db.Clients.Where(c => c.Id == model.Id).FirstOrDefault(); if (client != null && client.Password == model.OldPassword) { client.Password = model.NewPassword; db.SaveChanges(); Session["ChangePasswordSuccess"] = "הסיסמא שונתה בהצלחה."; return(RedirectToAction("ClientLoggedIn", new { id = client.Id })); } else { ModelState.AddModelError("", "סיסמא אינה נכונה."); } } return(View()); } }
public ActionResult ShowItems(int?Id, string option = null, string search = null) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { List <ThumbnailProductsModel> Thumbnail = (from m in db.ManufacturerProducts select new ThumbnailProductsModel { ProductId = m.Id, ProductName = m.Products.Name, ManufacturerName = m.Manufacturers.Name, CommerciallName = m.Name, CatalogNumber = m.CatalogNumber, ImageUrl = m.ImageUrl, PackageQuantity = m.PackageQuantity, Link = "/ProductDetail/Index/" + m.Id }).ToList(); if (search != null) { if (option == "ProductName" && search.Length > 0) { return(View(Thumbnail.Where(t => t.ProductName.ToLower().Contains(search.ToLower())).OrderBy(t => t.ProductName))); } if (option == "CatalogNumber" && search.Length > 0) { return(View(Thumbnail.Where(t => t.CatalogNumber.ToLower().Contains(search.ToLower())).OrderBy(t => t.ProductName))); } return(View(Thumbnail.Where(t => t.ProductName.ToLower().Contains(search.ToLower())).OrderBy(t => t.ProductName))); } return(View(Thumbnail.OrderBy(p => p.ProductName))); } }
// GET: Client Delete public ActionResult ClientDelete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (GoodSupplyEntities db = new GoodSupplyEntities()) { Clients client = db.Clients.Find(id); if (client == null) { return(HttpNotFound()); } ClientViewModel model = new ClientViewModel { Id = client.Id, FirstName = client.FirstName, LastName = client.LastName, Email = client.Email, Phone = client.Phone, BusinessName = client.BusinessName, BusinessAddress = client.BusinessAddress, VATIdNumber = client.VATIdNumber }; return(View(model)); } }
public ActionResult SupplierChangePassword(ChangePasswordViewModel model) { if (!ModelState.IsValid) { return(View(model)); } else { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var supplier = db.Suppliers.Where(s => s.Id == model.Id).FirstOrDefault(); if (supplier != null && supplier.Password == model.OldPassword) { supplier.Password = model.NewPassword; db.SaveChanges(); Session["ChangePasswordSuccess"] = "הסיסמא שונתה בהצלחה."; return(RedirectToAction("SupplierLoggedIn", new { id = supplier.Id })); } else { ModelState.AddModelError("", "סיסמא אינה נכונה."); } } return(View()); } }
public ActionResult MyProducts(int?Id, string option = null, string search = null) { //Add a view for supplier to see all his products in a list, with search button. using (GoodSupplyEntities db = new GoodSupplyEntities()) { var myProducts = db.Prices.Include(p => p.ManufacturerProducts.Products).Include(p => p.ManufacturerProducts.Manufacturers).Include(p => p.Suppliers).Where(p => p.SupplierId == Id).ToList(); //if (!String.IsNullOrEmpty(searchString)) //{ // myProducts = myProducts.Where(s => s.ManufacturerProducts.Products.Name.Contains(searchString) // || s.FirstMidName.Contains(searchString)); //} if (search != null) { if (option == "ProductName" && search.Length > 0) { return(View(myProducts.Where(t => t.ManufacturerProducts.Products.Name.ToLower().Contains(search.ToLower())).OrderBy(t => t.ManufacturerProducts.Products.Name))); } if (option == "ManufacturerName" && search.Length > 0) { return(View(myProducts.Where(t => t.ManufacturerProducts.Manufacturers.Name.ToLower().Contains(search.ToLower())).OrderBy(t => t.ManufacturerProducts.Manufacturers.Name))); } return(View(myProducts.Where(t => t.ManufacturerProducts.Products.Name.ToLower().Contains(search.ToLower())).OrderBy(t => t.ManufacturerProducts.Products.Name))); } return(View(myProducts.OrderBy(p => p.ManufacturerProducts.Products.Name))); //return View(myProducts.ToList()); } }
// GET: Supplier Delete public ActionResult SupplierDelete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (GoodSupplyEntities db = new GoodSupplyEntities()) { Suppliers supplier = db.Suppliers.Find(id); if (supplier == null) { return(HttpNotFound()); } SupplierViewModel model = new SupplierViewModel { Id = supplier.Id, FirstName = supplier.FirstName, LastName = supplier.LastName, Email = supplier.Email, Phone = supplier.Phone, BusinessName = supplier.BusinessName, BusinessAddress = supplier.BusinessAddress, VATIdNumber = supplier.VATIdNumber }; return(View(model)); } }
// GET: SupplierProducts/Edit/5 public ActionResult Edit(int?id) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Prices prices = db.Prices.Find(id); if (prices == null) { return(HttpNotFound()); } var model = new PriceViewModel { Prices = prices, ManufacturerProducts = db.ManufacturerProducts.ToList(), Suppliers = db.Suppliers.ToList() }; return(View(model)); } }
public ActionResult Edit(PriceViewModel priceVM) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var prices = new Prices { Id = priceVM.Prices.Id, ManufacturerPrice = priceVM.Prices.ManufacturerPrice, ProductPrice = priceVM.Prices.ProductPrice, Quantity = priceVM.Prices.Quantity, ManufacturerProductId = priceVM.Prices.ManufacturerProductId, ManufacturerProducts = priceVM.Prices.ManufacturerProducts, SupplierId = priceVM.Prices.SupplierId, Suppliers = priceVM.Prices.Suppliers }; if (ModelState.IsValid) { db.Entry(prices).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } priceVM.ManufacturerProducts = db.ManufacturerProducts.ToList(); priceVM.Suppliers = db.Suppliers.ToList(); return(View(priceVM)); } }
public ActionResult Create(PriceViewModel priceVM) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var prices = new Prices { ProductPrice = priceVM.Prices.ProductPrice, Quantity = priceVM.Prices.Quantity, ManufacturerPrice = priceVM.Prices.ManufacturerPrice, Suppliers = priceVM.Prices.Suppliers, SupplierId = priceVM.Prices.SupplierId, ManufacturerProducts = priceVM.Prices.ManufacturerProducts, ManufacturerProductId = priceVM.Prices.ManufacturerProductId }; if (ModelState.IsValid) { db.Prices.Add(prices); db.SaveChanges(); return(RedirectToAction("Index")); } priceVM.Suppliers = db.Suppliers.ToList(); priceVM.ManufacturerProducts = db.ManufacturerProducts.ToList(); return(View(priceVM)); } }
// GET: Details public ActionResult Details(int?id) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } OrderDetails orderDetails = db.OrderDetails.Find(id); if (orderDetails == null) { return(HttpNotFound()); } var model = new OrderDetailViewModel { OrderDetails = orderDetails, ManufacturerProducts = db.ManufacturerProducts.ToList(), Orders = db.Orders.ToList() }; return(View(model)); } }
public ActionResult Create(ManufacturerProductViewModel manufacturerProductVM) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var manufacturerProducts = new ManufacturerProducts { Name = manufacturerProductVM.ManufacturerProducts.Name, CatalogNumber = manufacturerProductVM.ManufacturerProducts.CatalogNumber, ImageUrl = manufacturerProductVM.ManufacturerProducts.ImageUrl, PackageQuantity = manufacturerProductVM.ManufacturerProducts.PackageQuantity, Width = manufacturerProductVM.ManufacturerProducts.Width, Length = manufacturerProductVM.ManufacturerProducts.Length, Height = manufacturerProductVM.ManufacturerProducts.Height, Manufacturers = manufacturerProductVM.ManufacturerProducts.Manufacturers, ManufacturerId = manufacturerProductVM.ManufacturerProducts.ManufacturerId, Products = manufacturerProductVM.ManufacturerProducts.Products, ProductId = manufacturerProductVM.ManufacturerProducts.ProductId }; if (ModelState.IsValid) { db.ManufacturerProducts.Add(manufacturerProducts); db.SaveChanges(); return(RedirectToAction("Index")); } manufacturerProductVM.Manufacturers = db.Manufacturers.ToList(); manufacturerProductVM.Products = db.Products.ToList(); return(View(manufacturerProductVM)); } }
// GET: Delete public ActionResult Delete(int?id) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ManufacturerProducts manufacturerProducts = db.ManufacturerProducts.Find(id); if (manufacturerProducts == null) { return(HttpNotFound()); } var model = new ManufacturerProductViewModel { ManufacturerProducts = manufacturerProducts, Manufacturers = db.Manufacturers.ToList(), Products = db.Products.ToList() }; return(View(model)); } }
// GET: Category public ActionResult Index() { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var categories = db.Categories.Include(c => c.Parents); return(View(categories.ToList())); } }
// GET: Product public ActionResult Index() { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var products = db.Products.Include(p => p.Categories); return(View(products.ToList())); } }
// LOGIN PROPERTIES public ActionResult Index() { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var prices = db.Prices.Include(p => p.ManufacturerProducts).Include(p => p.Suppliers); return(View(prices.ToList())); } }
// GET: ManufacturerProduct public ActionResult Index() { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var manufacturerProducts = db.ManufacturerProducts.Include(m => m.Manufacturers).Include(m => m.Products); return(View(manufacturerProducts.ToList())); } }
public ActionResult DeleteProductConfirmed(int id) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { Prices prices = db.Prices.Find(id); db.Prices.Remove(prices); db.SaveChanges(); return(RedirectToAction("MyProducts", new { id = prices.SupplierId })); } }
public ActionResult DeleteConfirmed(int id) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { ManufacturerProducts manufacturerProducts = db.ManufacturerProducts.Find(id); db.ManufacturerProducts.Remove(manufacturerProducts); db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult DeleteConfirmed(int id) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { OrderDetails orderDetails = db.OrderDetails.Find(id); db.OrderDetails.Remove(orderDetails); db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult DeleteConfirmed(int id) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { Categories categories = db.Categories.Find(id); db.Categories.Remove(categories); db.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult SupplierRegister(SupplierViewModel supplierVM) { SupplierViewModel model = new SupplierViewModel { //Id = supplierVM.Id, FirstName = supplierVM.FirstName, LastName = supplierVM.LastName, Email = supplierVM.Email, Password = supplierVM.Password, ConfirmPassword = supplierVM.ConfirmPassword, Phone = supplierVM.Phone, BusinessName = supplierVM.BusinessName, BusinessAddress = supplierVM.BusinessAddress, VATIdNumber = supplierVM.VATIdNumber }; if (!ModelState.IsValid) { return(View("SupplierRegister", model)); } else { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var user1 = db.Suppliers.Where(s => s.Email == model.Email).FirstOrDefault(); var user2 = db.Clients.Where(c => c.Email == model.Email).FirstOrDefault(); if (user1 != null || user2 != null) { ModelState.AddModelError("", "אימייל קיים כבר במערכת, נסה להרשם עם אימייל שונה."); return(View("SupplierRegister", model)); } var supplier = new Suppliers { //Id = supplierVM.Id, FirstName = supplierVM.FirstName, LastName = supplierVM.LastName, Email = supplierVM.Email, Password = supplierVM.Password, Phone = supplierVM.Phone, BusinessName = supplierVM.BusinessName, BusinessAddress = supplierVM.BusinessAddress, VATIdNumber = supplierVM.VATIdNumber }; db.Suppliers.Add(supplier); db.SaveChanges(); } ModelState.Clear(); ViewBag.Message = supplierVM.FirstName + " " + supplierVM.LastName + " הצלחת להרשם בהצלחה."; return(View()); } }
public ActionResult SupplierDeleteConfirmed(int id) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { Suppliers supplier = db.Suppliers.Find(id); db.Suppliers.Remove(supplier); db.SaveChanges(); } return(RedirectToAction("Logout")); }
public ActionResult ClientDeleteConfirmed(int id) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { Clients client = db.Clients.Find(id); db.Clients.Remove(client); db.SaveChanges(); } return(RedirectToAction("Logout")); }
public static IEnumerable <ThumbnailProductsModel> GetSupplierProductsThumbnails(this List <ThumbnailProductsModel> productsthumbnails, GoodSupplyEntities db = null, int id = 0, string option = null, string search = null) { try { if (db == null) { db = new GoodSupplyEntities(); } int supplierId = 0; if (id > 0) { supplierId = id; } productsthumbnails = (from m in db.ManufacturerProducts join p in db.Prices on m.Id equals p.ManufacturerProductId where p.SupplierId.Equals(supplierId) select new ThumbnailProductsModel { ProductId = m.Id, ProductName = m.Products.Name, ManufacturerName = m.Manufacturers.Name, CommerciallName = m.Name, CatalogNumber = m.CatalogNumber, ImageUrl = m.ImageUrl, PackageQuantity = m.PackageQuantity, //Link = "/ProductDetail/Index/" + m.Id, ProductPrice = p.ProductPrice }).ToList(); // a list of thumbnails models //if (search != null) // return thumbnails.Where(t => t.Name.ToLower().Contains(search.ToLower())).OrderBy(t => t.Name); if (search != null) { if (option == "ProductName" && search.Length > 0) { return(productsthumbnails.Where(t => t.ProductName.ToLower().Contains(search.ToLower())).OrderBy(t => t.ProductName)); } if (option == "CatalogNumber" && search.Length > 0) { return(productsthumbnails.Where(t => t.CatalogNumber.ToLower().Contains(search.ToLower())).OrderBy(t => t.ProductName)); } return(productsthumbnails.Where(t => t.ProductName.ToLower().Contains(search.ToLower())).OrderBy(t => t.ProductName)); } } catch (Exception ex) { } return(productsthumbnails.OrderBy(p => p.ProductName)); }
// GET: Details //public ActionResult Details(int? id) //{ // if (id == null) // { // return new HttpStatusCodeResult(HttpStatusCode.BadRequest); // } // Categories categories = db.Categories.Find(id); // if (categories == null) // { // return HttpNotFound(); // } // return View(categories); //} // GET: Create public ActionResult Create() { using (GoodSupplyEntities db = new GoodSupplyEntities()) { var categoriesList = db.Categories.ToList(); var model = new CategoryViewModel { CategoriesList = categoriesList }; return(View(model)); } }
public ActionResult Edit(Manufacturers manufacturers) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { if (ModelState.IsValid) { db.Entry(manufacturers).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(manufacturers)); } }
public ActionResult Create(Manufacturers manufacturers) { using (GoodSupplyEntities db = new GoodSupplyEntities()) { if (ModelState.IsValid) { db.Manufacturers.Add(manufacturers); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(manufacturers)); } }