Exemplo n.º 1
0
 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();
 }
Exemplo n.º 2
0
 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();
 }
Exemplo n.º 3
0
        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;
        }