public void Insert(BalanceBindingModel model)
{
using (var context = new AdBoardDatabase())
{
context.Balance.Add(CreateModel(model, new Balance()));
context.SaveChanges();
}
}
private Balance CreateModel(BalanceBindingModel model, Balance balance)
{
model.Id = balance.Id;
model.CardFIO = balance.CardFIO;
model.Username = balance.User.Username;
model.CardNumb = balance.CardFIO;
model.CardDate = balance.CardFIO;
return(balance);
}
public void CreateOrUpdate(BalanceBindingModel model)
{
if (model.Id.HasValue)
{
_balanceStorage.Update(model);
}
else
{
_balanceStorage.Insert(model);
}
}
public void Delete(BalanceBindingModel model)
{
var element = _balanceStorage.GetElement(new BalanceBindingModel
{
Id = model.Id
});
if (element == null)
{
throw new Exception("Баланс не найден");
}
_balanceStorage.Delete(model);
}
public void Update(BalanceBindingModel model)
{
using (var context = new AdBoardDatabase())
{
var element = context.Balance.FirstOrDefault(rec => rec.Id ==
model.Id);
if (element == null)
{
throw new Exception("Баланс не найден");
}
CreateModel(model, element);
context.SaveChanges();
}
}
public List <BalanceViewModel> Read(BalanceBindingModel model)
{
if (model == null)
{
return(_balanceStorage.GetFullList());
}
if (model.Id.HasValue)
{
return(new List <BalanceViewModel> {
_balanceStorage.GetElement(model)
});
}
return(_balanceStorage.GetFilteredList(model));
}
public void Delete(BalanceBindingModel model)
{
using (var context = new AdBoardDatabase())
{
Balance element = context.Balance.FirstOrDefault(rec => rec.Id ==
model.Id);
if (element != null)
{
context.Balance.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Клиент не найден");
}
}
}
public List <BalanceViewModel> GetFilteredList(BalanceBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AdBoardDatabase())
{
return(context.Balance
.Select(rec => new BalanceViewModel
{
Id = rec.Id,
CardFIO = rec.CardFIO,
Username = rec.User.Username,
CardNumb = rec.CardFIO,
CardDate = rec.CardFIO,
})
.ToList());
}
}
public BalanceViewModel GetElement(BalanceBindingModel model)
{
if (model == null)
{
return(null);
}
using (var context = new AdBoardDatabase())
{
var user = context.Balance
.FirstOrDefault(rec => rec.Id == model.Id);
return(user != null ?
new BalanceViewModel
{
Id = rec.Id,
CardFIO = rec.CardFIO,
Username = rec.User.Username,
CardNumb = rec.CardFIO,
CardDate = rec.CardFIO,
} :
null);
}
}