示例#1
0
 public DbExpense SaveExpense(DbExpense expense)
 {
     using (var context = new ExpensesContext())
     {
         context.Expenses.Add(expense);
         context.SaveChanges();
         return expense;
     }
 }
示例#2
0
        public string Post(ExpenseModel model)
        {
            if (model != null)
            {
                try
                {
                    DbExpense dbExp = new DbExpense()
                    {
                        Category = model.Category,
                        Description = model.Description,
                        ExpenseAmount = Convert.ToDecimal(model.ExpenseAmount),
                        ExpenseDate = model.ExpenseDate,
                        SubCategory = model.SubCategory,
                        UserCreated = "UserID",//If this is new record
                        UserModified = "UserID",
                        DateCreated = DateTime.Now,
                        DateModified = DateTime.Now

                    };
                    //db.Expenses.Add(new DbExpense()
                    //{
                    //    Category = model.Category,
                    //    Description = model.Description,
                    //    ExpenseAmount = Convert.ToDecimal(model.ExpenseAmount),
                    //    ExpenseDate = model.ExpenseDate,
                    //    SubCategory = model.SubCategory,
                    //    UserCreated = "UserID",//If this is new record
                    //    UserModified = "UserID"
                    //});
                    //db.SaveChangesAsync();
                    //return "success";

                    db.Entry(dbExp).State = System.Data.Entity.EntityState.Added;
                    db.SaveChanges();
                    return "success";

                }
                catch (Exception ex)
                {
                    //Handle or Log
                    return "Error";
                }
            }
            else
            {
                return "Enter Values";
            }
        }
示例#3
0
        public static IEnumerable<DbExpense> CreateDefaultExpenses()
        {
            var repository = new ExpensesRepository();
            DbExpense expense = new DbExpense()
                {
                    Category = "Hardware",
                    Description = "Hardware Expenses",
                    ExpenseAmount = 12.20M,
                    ExpenseDate = DateTime.Now,
                    DateModified = DateTime.Now,
                    DateCreated = DateTime.Now,
                    SubCategory = "RAM",
                    UserCreated = "sthunga",
                    UserModified = "sthunga"

                };
            expense = repository.SaveExpense(expense);

            DbExpense expense1 = new DbExpense()
            {
                Category = "Hardware",
                Description = "Hardware Expenses",
                ExpenseAmount = 20.00M,
                ExpenseDate = DateTime.Now,
                DateModified = DateTime.Now,
                DateCreated = DateTime.Now,
                SubCategory = "Monitor",
                UserCreated = "User55",
                UserModified = "User55"

            };
            repository.SaveExpense(expense1);

            DbExpense expense2 = new DbExpense()
            {
                Category = "Software",
                Description = "Software Expenses",
                ExpenseAmount = 100.20M,
                ExpenseDate = DateTime.Now,
                DateModified = DateTime.Now,
                DateCreated = DateTime.Now,
                SubCategory = "OS",
                UserCreated = "sthunga",
                UserModified = "sthunga"

            };
            repository.SaveExpense(expense2);

            DbExpense expense3 = new DbExpense()
            {
                Category = "Software",
                Description = "Software Expenses",
                ExpenseAmount = 302.0M,
                ExpenseDate = DateTime.Now,
                DateModified = DateTime.Now,
                DateCreated = DateTime.Now,
                SubCategory = "Maya",
                UserCreated = "sthunga",
                UserModified = "sthunga"

            };
            repository.SaveExpense(expense3);

            DbExpense expense4 = new DbExpense()
            {
                Category = "Food",
                Description = "Miscellaneous Expenses",
                ExpenseAmount = 30.02M,
                ExpenseDate = DateTime.Now,
                DateModified = DateTime.Now,
                DateCreated = DateTime.Now,
                SubCategory = "Lunch",
                UserCreated = "User2",
                UserModified = "User2"

            };
            repository.SaveExpense(expense4);

            return repository.GetExpenses();
        }
示例#4
0
 public void Create(Expense expense)
 {
     _dbContext.Expenses.Add(DbExpense.FromExpense(expense));
     _dbContext.SaveChanges();
 }