public bool AddOrChangeBanknote(int denomination, long quantity)
{
BankDBEntities bankDBEntities = new BankDBEntities();
try
{
var banknote = bankDBEntities.Banknotes.FirstOrDefault(b => b.Denomination == denomination);
if (banknote != null)
{
banknote.Quantity = quantity;
}
else
{
bankDBEntities.Banknotes.Add(new Banknote {
Denomination = denomination, Quantity = quantity
});
}
bankDBEntities.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
finally
{
bankDBEntities.Dispose();
}
}
public BanknoteModel GetBanknote(int denomination)
{
using (BankDBEntities bankDBEntities = new BankDBEntities())
{
return(bankDBEntities.Banknotes
.Where(b => b.Denomination == denomination)
.ToArray()
.Select(b => new BanknoteModel(b.Denomination, b.Quantity))
.FirstOrDefault());
}
}
public List <BanknoteModel> GetAllBanknotes()
{
List <BanknoteModel> banknotes = new List <BanknoteModel>();
using (BankDBEntities bankDBEntities = new BankDBEntities())
{
foreach (var item in bankDBEntities.Banknotes)
{
banknotes.Add(new BanknoteModel(item.Denomination, item.Quantity));
}
}
return(banknotes);
}