public List <PackagingViewModel> Read(PackagingBindingModel model) { using (var context = new FlowerShopDatabase()) { return(context.Packagings .Where(rec => model == null || rec.Id == model.Id) .Select(rec => new PackagingViewModel { Id = rec.Id, PackagingName = rec.PackagingName, Count = rec.Count, Price = rec.Price }) .ToList()); } }
public void Delete(PackagingBindingModel model) { using (var context = new FlowerShopDatabase()) { Packaging element = context.Packagings.FirstOrDefault(rec => rec.Id == model.Id); if (element != null) { context.Packagings.Remove(element); context.SaveChanges(); } else { CheckingElement(element); } } }
public void CreateOrUpdate(PackagingBindingModel model) { using (var context = new FlowerShopDatabase()) { Packaging element = context.Packagings.FirstOrDefault(rec => rec.PackagingName == model.PackagingName && rec.Id != model.Id); CheckingUniqueness(element); if (model.Id.HasValue) { element = context.Packagings.FirstOrDefault(rec => rec.Id == model.Id); CheckingElement(element); } else { element = new Packaging(); context.Packagings.Add(element); } element.Count = model.Count; element.PackagingName = model.PackagingName; element.Price = model.Price; context.SaveChanges(); } }