public void Insert(ProcedureBindingModel model)
{
using (var context = new BeautySaloonDatabase())
{
context.Procedures.Add(CreateModel(model, new Procedure()));
context.SaveChanges();
}
}
private Procedure CreateModel(ProcedureBindingModel model, Procedure procedure)
{
procedure.ProcedureName = model.ProcedureName;
procedure.Price = model.Price;
procedure.Duration = model.Duration;
procedure.ClientId = model.ClientId.Value;
return(procedure);
}
public void Update(ProcedureBindingModel model)
{
using (var context = new BeautySaloonDatabase())
{
var element = context.Procedures.FirstOrDefault(rec => rec.Id == model.Id);
if (element == null)
{
throw new Exception("Элемент не найден");
}
CreateModel(model, element);
context.SaveChanges();
}
}
public void Delete(ProcedureBindingModel model)
{
var element = _procedureStorage.GetElement(new ProcedureBindingModel
{
Id =
model.Id
});
if (element == null)
{
throw new Exception("Процедура не найдена");
}
_procedureStorage.Delete(model);
}
public List <ProcedureViewModel> Read(ProcedureBindingModel model)
{
if (model == null)
{
return(_procedureStorage.GetFullList());
}
if (model.Id.HasValue)
{
return(new List <ProcedureViewModel> {
_procedureStorage.GetElement(model)
});
}
return(_procedureStorage.GetFilteredList(model));
}
public List <ProcedureViewModel> GetFilteredList(ProcedureBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new BeautySaloonDatabase())
{
return(context.Procedures
.Where(rec => rec.ClientId == model.ClientId || rec.ProcedureName.Contains(model.ProcedureName))
.Select(CreateModel)
.ToList());
}
}
public ProcedureViewModel GetElement(ProcedureBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new BeautySaloonDatabase())
{
var procedure = context.Procedures
.FirstOrDefault(rec => rec.ProcedureName == model.ProcedureName || rec.Id == model.Id);
return(procedure != null?
CreateModel(procedure) :
null);
}
}
public void Delete(ProcedureBindingModel model)
{
using (var context = new BeautySaloonDatabase())
{
Procedure element = context.Procedures.FirstOrDefault(rec => rec.Id == model.Id);
if (element != null)
{
context.Procedures.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Элемент не найден");
}
}
}
public void CreateOrUpdate(ProcedureBindingModel model)
{
var element = _procedureStorage.GetElement(new ProcedureBindingModel
{
ProcedureName = model.ProcedureName
});
if (element != null && element.Id != model.Id)
{
throw new Exception("Уже есть процедура с таким названием");
}
if (model.Id.HasValue)
{
_procedureStorage.Update(model);
}
else
{
_procedureStorage.Insert(model);
}
}
