public ActionResult EditProduct(string seller, string name = "", string description = "") { List <int> lSeller = seller.Split(new[] { ' ' }, StringSplitOptions.RemoveEmptyEntries).Select(Int32.Parse).ToList(); name = name.ToLower(); description = description.ToLower(); List <Product> model = new List <Product>(); using (ManaCenaEntities context = new ManaCenaEntities()) { model = context.Products .Include(o => o.Cathegory.CathegoryType) .Include(o => o.SubCathegory.Cathegory.CathegoryType) .Include(o => o.ProductImage) .Include(o => o.ProductImageSmall) .Include(o => o.ProductLocations) .Where(o => (lSeller.Contains(o.Seller.Id)) //seller == "" || o.Seller == null || o.Seller.Name.ToLower().Contains(seller)) && (name == "" || o.Name.ToLower().Contains(name)) && (description == "" || o.Description.ToLower().Contains(description)) ) .ToList(); ViewBag.SubCathegoryEnum = context.SubCathegories.ToList(); ViewBag.CathegoryEnum = context.Cathegories.ToList(); ViewBag.CathegoryTypeEnum = context.CathegoryTypes.ToList(); ViewBag.SellerEnum = context.Sellers.Include(o => o.Locations).ToList(); } return(View(model)); }
public ActionResult Search(List <int> sellersList, string search = "", Nullable <int> subCathegoryId = null, Nullable <int> cathegoryId = null, Nullable <int> cathegoryTypeId = null) { List <Product> model = new List <Product>(); if (sellersList == null) { sellersList = new List <int>(); } using (ManaCenaEntities context = new ManaCenaEntities()) { model = context.Products //.Include(o => o.ProductImage) .Include(o => o.ProductImageSmall) .Include(o => o.Seller) .Include(o => o.Seller.SellerImage) .Where(o => (o.SubCathegoryId == subCathegoryId || subCathegoryId == null) && (o.CathegoryId == cathegoryId || cathegoryId == null) && (o.CathegoryTypeId == cathegoryTypeId || cathegoryTypeId == null) && (sellersList.Count == 0 || sellersList.Contains(o.SellerId)) ).ToList(); } return(PartialView("ProductDashboard", model)); }
public bool EditSeller(Seller rec) { using (ManaCenaEntities context = new ManaCenaEntities()) { context.Sellers.Add(rec); if (rec.Id > 0) { context.Entry(rec).State = System.Data.Entity.EntityState.Modified; if (rec.SellerImage != null) { if (rec.SellerImage.Id > 0) { context.Entry(rec.SellerImage).State = System.Data.Entity.EntityState.Modified; } else { context.Entry(rec.SellerImage).State = System.Data.Entity.EntityState.Added; } } } else { context.Entry(rec).State = System.Data.Entity.EntityState.Added; context.Entry(rec.SellerImage).State = System.Data.Entity.EntityState.Added; rec.SellerImage.Id = 0; } context.SaveChanges(); } return(true); }
public string GetLargeImage(int id) { using (ManaCenaEntities context = new ManaCenaEntities()) { var img = context.ProductImages.Where(o => o.Id == id).Select(o => o.Image).First(); return(img); } }
// GET: Product public ActionResult Index() { using (ManaCenaEntities context = new ManaCenaEntities()) { ViewBag.SellerEnum = context.Sellers.ToList(); } return(View()); }
public ActionResult Index() { TestModel model = new TestModel(); using (ManaCenaEntities context = new ManaCenaEntities()) { model.p = context.Products.FirstOrDefault(); } return(View(model)); }
public ActionResult EditCathegoryType() { List <CathegoryType> model = new List <CathegoryType>(); using (ManaCenaEntities context = new ManaCenaEntities()) { model = context.CathegoryTypes.ToList(); } return(View(model)); }
public ActionResult EditLocation() { List <Location> model = new List <Location>(); using (ManaCenaEntities context = new ManaCenaEntities()) { model = context.Locations.ToList(); ViewBag.SellerEnum = context.Sellers.ToList(); } return(View(model)); }
public ActionResult EditSubCathegory() { List <SubCathegory> model = new List <SubCathegory>(); using (ManaCenaEntities context = new ManaCenaEntities()) { model = context.SubCathegories.ToList(); ViewBag.CathegoryEnum = context.Cathegories.ToList(); } return(View(model)); }
public ActionResult EditSeller() { List <Seller> model = new List <Seller>(); using (ManaCenaEntities context = new ManaCenaEntities()) { model = context.Sellers .Include(o => o.SellerImage) .ToList(); } return(View(model)); }
public bool DeleteItem(int id) { using (ManaCenaEntities context = new ManaCenaEntities()) { var rec = new Product { Id = id }; context.Entry(rec).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } return(true); }
public string GetImageSmall(int id) { using (ManaCenaEntities context = new ManaCenaEntities()) { var rec = context.Products.Include(o => o.ProductImageSmall).Where(o => o.Id == id).FirstOrDefault(); if (rec.ProductImageSmall != null && !string.IsNullOrEmpty(rec.ProductImageSmall.Image)) { return(rec.ProductImageSmall.Image); } else { return(""); } } }
public bool EditLocation(Location rec) { using (ManaCenaEntities context = new ManaCenaEntities()) { context.Locations.Add(rec); if (rec.Id > 0) { context.Entry(rec).State = System.Data.Entity.EntityState.Modified; } else { context.Entry(rec).State = System.Data.Entity.EntityState.Added; } context.SaveChanges(); } return(true); }
public bool EditCathegoryType(CathegoryType rec) { using (ManaCenaEntities context = new ManaCenaEntities()) { context.CathegoryTypes.Add(rec); if (rec.Id > 0) { context.Entry(rec).State = System.Data.Entity.EntityState.Modified; } else { context.Entry(rec).State = System.Data.Entity.EntityState.Added; } context.SaveChanges(); } return(true); }
public ActionResult ProductView(int id) { Product model = null; using (ManaCenaEntities context = new ManaCenaEntities()) { model = context.Products .Include(o => o.Cathegory.CathegoryType) .Include(o => o.SubCathegory.Cathegory.CathegoryType) .Include(o => o.ProductImage) //.Include(o => o.ProductImageSmall) .Include(o => o.ProductLocations) .Include(o => o.Seller) .Include(o => o.Seller.SellerImage) .Where(o => o.Id == id) .First(); } return(PartialView(model)); //return View(model); }
public ActionResult Index() { List <Product> model = new List <Product>(); using (ManaCenaEntities context = new ManaCenaEntities()) { //ViewBag.CathegoryTypeEnum = context // .CathegoryTypes // .Include(o => o.Cathegories.Select(q => q.SubCathegories)).ToList() // .ToList(); var menuList = context .CathegoryTypes .Include(o => o.Cathegories.Select(k => k.SubCathegories)) .OrderBy(o => o.Name) .ToList(); // lame order by, EF cna't hande a shit foreach (var team in menuList) { team.Cathegories = team.Cathegories.OrderBy(m => m.Name).ToList(); foreach (var teamMember in team.Cathegories) { teamMember.SubCathegories = teamMember.SubCathegories.OrderBy(u => u.Name).ToList(); } } ViewBag.CathegoryTypeEnum = menuList; ViewBag.CathegoryEnum = context.Cathegories.ToList(); ViewBag.SubCathegoryEnum = context.SubCathegories.ToList(); ViewBag.SellerEnum = context.Sellers.ToList(); //ViewBag.CathegoryEnum = context.Cathegories.Include(o => o.CathegoryType).OrderBy(o => o.CathegoryType.Name).ToList(); } return(View()); }
public bool EditItem(Product rec) { //ProductLocation peredajotsa, sledujushije shagi: //1) Proverj ne perezapisivajutsa li oni //2) Proverj, chtobi stiralis vse predidushije esli v nachale bili XX/X/XXX a potm pusto //2.1.) Sohranenije novoj zapisi //3) Otobrazhenije // 4) otobrazhenije v Detailes using (ManaCenaEntities context = new ManaCenaEntities()) { //dell all Locations (if any) context.ProductLocations.RemoveRange(context.ProductLocations.Where(o => o.ProductId == rec.Id)); if (rec.ProductLocations.Count == context.Locations.Count(o => o.SellerId == rec.SellerId)) { rec.ProductLocations = null; } context.Products.Add(rec); if (rec.Id > 0) { context.Entry(rec).State = System.Data.Entity.EntityState.Modified; if (rec.ProductImage != null) { context.Entry(rec.ProductImage).State = System.Data.Entity.EntityState.Modified; } if (rec.ProductImageSmall != null) { context.Entry(rec.ProductImageSmall).State = System.Data.Entity.EntityState.Modified; } else { rec.ProductImageSmall = new ProductImageSmall(); } rec.ProductImageSmall.Image = Helpers.ImageHelper.ResizeImage(rec.ProductImage.Image); //// if same image in DB already, do not overwrite then //var image = context.ProductImages.Where(o => o.Id == rec.ProductImageId).First(); //if (rec.ProductImage != null && image != null && image.Image != rec.ProductImage.Image) //{ // rec.ProductImageSmall = new ProductImageSmall { Image = Helpers.ImageHelper.ResizeImage(rec.ProductImage.Image) }; //} } else { context.Entry(rec).State = System.Data.Entity.EntityState.Added; context.Entry(rec.ProductImage).State = System.Data.Entity.EntityState.Added; rec.ProductImage.Id = 0; rec.ProductImageSmall = new ProductImageSmall { Image = Helpers.ImageHelper.ResizeImage(rec.ProductImage.Image) }; } context.SaveChanges(); } return(true); }