public void CreateOrUpdate(ToyBindingModel model)
{
using (var context = new GoToWorkDatabase())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
Toy element = context.Toys.FirstOrDefault(rec => rec.ToyName == model.ToyName && rec.Id != model.Id);
if (element != null)
{
throw new Exception("Уже есть игрушка с таким названием");
}
if (model.Id.HasValue)
{
element = context.Toys.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Элемент не найден");
}
}
else
{
element = new Toy();
context.Toys.Add(element);
}
element.ToyName = model.ToyName;
element.DateCreate = DateTime.Now;
context.SaveChanges();
if (model.Id.HasValue)
{
var ToyParts = context.ToyParts.Where(rec => rec.ToyId == model.Id.Value).ToList();
}
foreach (var pc in model.ToyParts)
{
context.ToyParts.Add(new ToyParts
{
ToyId = element.Id,
PartId = pc.Key,
PartCount = pc.Value.Item3
});
context.SaveChanges();
}
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
}
public void CreateOrUpdate(ProviderBindingModel model)
{
using (var context = new GoToWorkDatabase())
{
Provider element = context.Providers.FirstOrDefault(rec => rec.Email == model.Email && rec.Id != model.Id);
if (element != null)
{
throw new Exception("Уже есть поставщик с такой почтой");
}
if (model.Id.HasValue)
{
element = context.Providers.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Элемент не найден");
}
}
else
{
element = new Provider();
context.Providers.Add(element);
}
element.FIO = model.FIO;
element.Password = model.Password;
element.Email = model.Email;
context.SaveChanges();
}
}
public void Delete(ToyBindingModel model)
{
using (var context = new GoToWorkDatabase())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
context.ToyParts.RemoveRange(context.ToyParts.Where(rec => rec.ToyId == model.Id));
Toy element = context.Toys.FirstOrDefault(rec => rec.Id == model.Id);
if (element != null)
{
context.Toys.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Элемент не найден");
}
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
}
public void Delete(ProviderBindingModel model)
{
using (var context = new GoToWorkDatabase())
{
Provider element = context.Providers.FirstOrDefault(rec => rec.Id == model.Id);
if (element != null)
{
context.Providers.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Элемент не найден");
}
}
}
