//public void AddJewelry(AddJewelry jewelry, ImageHelper image) public void AddJewelry(AddJewelry jewelry) { using (var _context = new SmyckenContext()) { var image = new Image() { FileName = jewelry.PictureFileName, Url = jewelry.PictureURL, News = false, Description = "", Category = jewelry.Category }; _context.Images.Add(image); _context.SaveChanges(); var newJewelry = _context.Jewelries.Add(new Jewelry() { Name = jewelry.Name, Price = jewelry.Price, Quantity = jewelry.Quantity, Description = jewelry.Description, Category = jewelry.Category, Visibility = true, Image = image }); _context.Jewelries.Add(newJewelry); _context.SaveChanges(); } }
public void RemoveJewelry(int jewelry) { using (var _context = new SmyckenContext()) { var updateJewelry = (from j in _context.Jewelries where j.ID == jewelry select j).FirstOrDefault(); if (updateJewelry != null) { updateJewelry.Visibility = false; } _context.SaveChanges(); } }
public List<JewelryHelper> GetAllEarrings() { using (var _context = new SmyckenContext()) { return (from a in _context.Jewelries orderby a.ID descending where a.Category == JewelryCategory.Earrings && a.Visibility == true select new JewelryHelper { ID = a.ID, Description = a.Description, ArticleNr = a.ArticleNr, Name = a.Name, Price = a.Price, PictureFileName = a.Image.FileName, Category = a.Category, Quantity = a.Quantity }).ToList(); } }
public void UpdateJewelry(EditJewelry jewelry) { using (var _context = new SmyckenContext()) { var updateJewelry = (from j in _context.Jewelries where j.ID == jewelry.ID && j.Visibility == true select j).FirstOrDefault(); if (updateJewelry != null) { updateJewelry.ID = jewelry.ID; updateJewelry.Name = jewelry.Name; updateJewelry.Price = jewelry.Price; updateJewelry.Quantity = jewelry.Quantity; updateJewelry.Category = jewelry.Category; updateJewelry.Description = jewelry.Description; } _context.SaveChanges(); } }
public JewelryHelper GetOneJewelryById(int jewelryID) { using (var _context = new SmyckenContext()) { _context.Jewelries.AsNoTracking(); return (from a in _context.Jewelries where a.ID == jewelryID && a.Visibility == true select new JewelryHelper { ID = a.ID, Description = a.Description, Name = a.Name, Price = a.Price, Quantity = a.Quantity, //ImageFileName = a.Image.FileName, Category = a.Category }).FirstOrDefault(); } }
public List<ImageHelper> GetAllNewsImage() { using (var _context = new SmyckenContext()) { return (from i in _context.Images where (i.News == true) select new ImageHelper() { FileName = i.FileName, Description = i.Description, News = i.News, Category = i.Category }).ToList(); } }