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