public void Insert(DealBM model)
{
using (var context = new DataBaseContext())
{
context.Deals.Add(CreateModel(model, new Deal()));
context.SaveChanges();
}
}
private Deal CreateModel(DealBM model, Deal deal)
{
deal.Date = model.Date;
deal.EmployeeId = model.EmployeeId;
deal.ApplicantId = model.ApplicantId;
deal.VacancyId = model.VacancyId;
return(deal);
}
public void CreateOrUpdate(DealBM model)
{
if (model.Id.HasValue)
{
_dealStorage.Update(model);
}
else
{
_dealStorage.Insert(model);
}
}
public void Update(DealBM model)
{
using (var context = new DataBaseContext())
{
Deal element = context.Deals.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Сделка не найдена");
}
CreateModel(model, element);
context.SaveChanges();
}
}
public void Delete(DealBM model)
{
var element = _dealStorage.GetElement(new DealBM
{
Id = model.Id
});
if (element == null)
{
throw new Exception("Сделка не найдена");
}
_dealStorage.Delete(model);
}
public List <DealVM> Read(DealBM model)
{
if (model == null)
{
return(_dealStorage.GetFullList());
}
if (model.Id.HasValue)
{
return(new List <DealVM> {
_dealStorage.GetElement(model)
});
}
return(_dealStorage.GetFilteredList(model));
}
public void Delete(DealBM model)
{
using (var context = new DataBaseContext())
{
Deal element = context.Deals.FirstOrDefault(rec => rec.Id == model.Id);
if (element != null)
{
context.Deals.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Сделка не найдена");
}
}
}
public List <DealVM> GetFilteredList(DealBM model)
{
if (model == null)
{
return(null);
}
using (var context = new DataBaseContext())
{
return(context.Deals
.Include(rec => rec.Vacancy)
.Include(rec => rec.Applicant)
.Include(rec => rec.Employee)
.Where(rec => rec.Date >= model.Date)
.Select(CreateModel).ToList());
}
}
public DealVM GetElement(DealBM model)
{
if (model == null)
{
return(null);
}
using (var context = new DataBaseContext())
{
var deal = context.Deals
.Include(rec => rec.Vacancy)
.Include(rec => rec.Applicant)
.Include(rec => rec.Employee)
.FirstOrDefault(rec => rec.Id == model.Id);
return(deal != null?
CreateModel(deal) : null);
}
}
