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; } } }