public IEnumerable <Machine> GetMachines()
{
using (dbCreator = new DbContextCreator(connString))
{
return(dbCreator.DbContext.Machines.Where(t => t.IsActive).ToList());
}
}
public Flavour GetFlavourBySeriesNumber(string seriesNumber)
{
using (dbCreator = new DbContextCreator(connString))
{
return(dbCreator.DbContext.Flaviours.Where(m => m.SeriesNumber == seriesNumber).FirstOrDefault());
}
}
public Machine GetMachineByseriesNumber(string seriesNumber)
{
using (dbCreator = new DbContextCreator(connString))
{
return(dbCreator.DbContext.Machines.Where(m => m.SeriesNumber == seriesNumber).FirstOrDefault());
}
}
public IEnumerable <Transaction> GetTransactions(string machineSeriesNumber)
{
using (dbCreator = new DbContextCreator(connString))
{
var transactions = dbCreator.DbContext.Transactions.Where(t =>
t.Machine.IsActive && t.Machine.SeriesNumber == machineSeriesNumber).FirstOrDefault();
return(dbCreator.DbContext.Transactions.Where(t => t.Machine.IsActive && t.Machine.SeriesNumber == machineSeriesNumber).ToList());
}
}
public void DeleteMachine(string seriesNumber)
{
using (dbCreator = new DbContextCreator(connString))
{
var machine = dbCreator.DbContext.Machines.Where(m => m.SeriesNumber == seriesNumber).FirstOrDefault();
if (machine != null)
{
dbCreator.DbContext.Machines.Remove(machine);
dbCreator.DbContext.SaveChanges();
}
}
}
public void SaveTransaction(Transaction transaction)
{
using (dbCreator = new DbContextCreator(connString))
{
try
{
// check reference
if (!dbCreator.DbContext.Machines.Any(m => m.Id == transaction.MachineId) ||
!dbCreator.DbContext.Flaviours.Any(f => f.Id == transaction.FlavourId))
{
Console.WriteLine("No reference resouces found");
return;
}
if (transaction.Id > 0)
{
var trans = dbCreator.DbContext.Transactions.Where(t => t.Id == transaction.Id)
.FirstOrDefault();
if (trans != null)
{
//update
trans.MachineId = transaction.MachineId;
trans.FlavourId = transaction.FlavourId;
trans.IsActive = transaction.IsActive;
trans.PriceInCents = transaction.PriceInCents;
trans.TransactionType = transaction.TransactionType;
trans.TansactionTime = transaction.TansactionTime;
}
}
// create new
transaction.Machine = null;
transaction.Flavour = null;
dbCreator.DbContext.Transactions.Add(transaction);
dbCreator.DbContext.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
}
}