public static void AddPayee(String name, Boolean active = true) { var db = new BudgetEntities(); var payee = new Payee(); payee.Name = name; payee.Active = active; payee.Guid = Guid.NewGuid(); db.Payees.Add(payee); db.SaveChanges(); }
public static void DeleteTransaction(IEnumerable<Transaction> transactions) { var db = new BudgetEntities(); foreach (var curTransaction in transactions) { var query = (from transaction in db.Transactions where transaction.Guid == curTransaction.Guid select transaction).Single(); db.Transactions.Remove(query); } db.SaveChanges(); }
public Boolean Save(out List<string> errors, out List<string> warnings, Boolean ignoreWarnings = false) { Boolean result = false; Validate(out errors, out warnings); if (errors.Count == 0 && (ignoreWarnings || warnings.Count == 0)) { try { var db = new BudgetEntities(); if (Mode == TransactionEntryWindow.ModeValues.Add) { // add the transaction var transaction = new Transaction(); transaction.Guid = Guid.NewGuid(); transaction = PopulateObject(transaction, db); db.Transactions.Add(transaction); db.SaveChanges(); result = true; } else if (Mode == TransactionEntryWindow.ModeValues.Edit) { // update the transaction var transaction = (from t in db.Transactions where t.Guid == TransationID select t).Single(); transaction = PopulateObject(transaction, db); db.SaveChanges(); result = true; } else { throw new InvalidOperationException("Invalid mode specified."); } } catch (Exception ex) { errors.Add(ex.Message); } } return result; }