public List <Payment> AddPayments()
{
List <Payment> paymentList = new List <Payment>();
if (_context.Payments.Count() == 0)
{
//Adding Basic Categories on startup
paymentList.Add(new Payment {
PaymentType = "Cash"
});
paymentList.Add(new Payment {
PaymentType = "Visa"
});
paymentList.Add(new Payment {
PaymentType = "Master"
});
paymentList.Add(new Payment {
PaymentType = "AMEX"
});
paymentList.Add(new Payment {
PaymentType = "Paypal"
});
_context.Payments.AddRange(paymentList);
_context.SaveChanges();
}
return(paymentList);
}
public List <IncomeSource> AddIncomeSources()
{
List <IncomeSource> incomeSources = new List <IncomeSource>();
if (_context.IncomeSources.Count() == 0)
{
incomeSources.Add(new IncomeSource {
SourceName = "Salary"
});
incomeSources.Add(new IncomeSource {
SourceName = "Interest"
});
incomeSources.Add(new IncomeSource {
SourceName = "Dividend"
});
incomeSources.Add(new IncomeSource {
SourceName = "Inheritance"
});
incomeSources.Add(new IncomeSource {
SourceName = "Allowances"
});
incomeSources.Add(new IncomeSource {
SourceName = "Other incomes"
});
_context.IncomeSources.AddRange(incomeSources);
_context.SaveChanges();
}
return(incomeSources);
}
public ActionResult Create([Bind(Include = "IdAccount,Name")] Account account)
{
if (ModelState.IsValid)
{
db.Accounts.Add(account);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(account));
}
public List <Expense> AddExpense(Expense expense)
{
_context.Expenses.Add(expense);
_context.SaveChanges();
var expenses = GetExpenseByIdDate(expense.ProfileNo, expense.ExpenseDate);
if (expenses == null)
{
return(null);
}
return(expenses.ToList());
}
public async Task <IActionResult> Update(Expense expense)
{
var expenseToUpdate = await ctx.FindAsync <Expense>(expense.ExpenseID);
if (expenseToUpdate == null)
{
return(NotFound());
}
ctx.Entry(expenseToUpdate).CurrentValues.SetValues(expense);
ctx.SaveChanges();
return(Ok(expense));
}
public ActionResult Create([Bind(Include = "IdTransaction,FKAccount,FkCategory,Name,date,notes")] Transaction transaction)
{
if (ModelState.IsValid)
{
db.Transactions.Add(transaction);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.FKAccount = new SelectList(db.Accounts, "IdAccount", "Name", transaction.FKAccount);
ViewBag.FkCategory = new SelectList(db.Categories, "IdCategory", "Name", transaction.FkCategory);
return(View(transaction));
}
public void AddCost(Cost cost)
{
try
{
if (cost.Name?.Value == null)
{
throw new Exception("Nie wpisano nazwy kosztu.");
}
if (cost.Category?.Name == null)
{
throw new Exception("Nie wybrano kategorii.");
}
if (cost.Amount < 1)
{
throw new Exception("Nie podano wartości kosztu.");
}
_context.Costs.Add(cost);
_context.SaveChanges();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public FinancialSummary AddIncome(Income income)
{
decimal savingPercentage = income.Saving;
decimal budgetPercentage = 100 - savingPercentage;
income.Saving = (income.Amount * (savingPercentage / 100));
income.Budget = (income.Amount * (budgetPercentage / 100));
if (income.IsItRecurring == false)
{
income.Frequency = null;
}
_context.Incomes.Add(income);
_context.SaveChanges();
FinancialSummary financialSummary = new FinancialSummary();
financialSummary.Date = income.Date;
financialSummary.ProfileNo = income.ProfileNo;
return(FinancialSummaryDetails.GetfinancialSummary(financialSummary, _context));
}
public UserController(ExpenseTrackerContext context)
{
_context = context;
if (_context.Users.Count() == 0)
{
_context.Users.AddRange(new User {
UserName = "******", Password = "******"
}); //Set UserName and password startup
_context.SaveChanges();
}
}
public List <Category> AddCategories()
{
List <Category> categories = new List <Category>();
if (_context.Categories.Count() == 0)
{
//Adding Basic Categories on startup
categories.Add(new Category {
CategoryName = "Emi"
});
categories.Add(new Category {
CategoryName = "Entertainment"
});
categories.Add(new Category {
CategoryName = "Food"
});
categories.Add(new Category {
CategoryName = "Memberships"
});
categories.Add(new Category {
CategoryName = "Misc"
});
categories.Add(new Category {
CategoryName = "Purchases"
});
categories.Add(new Category {
CategoryName = "Subscriptions"
});
categories.Add(new Category {
CategoryName = "Transport"
});
categories.Add(new Category {
CategoryName = "Utility"
});
_context.Categories.AddRange(categories);
_context.SaveChanges();
}
return(categories);
}
public string AddNames(List <Name> names)
{
try
{
_context.Names.AddRange(names);
_context.SaveChanges();
return(null);
}
catch (Exception ex)
{
return(ex.Message);
}
}
static void CategoriesRefiller()
{
var categories = _context.Categories.ToList();
var list = new List <Category>
{
new Category {
Name = "Zakupy"
},
new Category {
Name = "Opłaty"
},
new Category {
Name = "Jedzenie"
},
new Category {
Name = "Jedzenie-Praca"
},
new Category {
Name = "Samochód"
},
new Category {
Name = "Studia"
},
new Category {
Name = "TEST"
}
};
var listToAdd = new List <Category>();
foreach (var item in list)
{
if (!categories.Any(x => x.Name.ToLower() == item.Name.ToLower()))
{
listToAdd.Add(item);
}
}
if (listToAdd.Count == 0)
{
return;
}
_context.Categories.AddRange(listToAdd);
_context.SaveChanges();
}
/// <summary>
/// Return bool if ok, the newly-created ExpenseGroup is still available (including
/// the id) to the calling class.
/// </summary>
/// <param name="eg"></param>
/// <returns></returns>
public RepositoryActionResult <ExpenseGroup> InsertExpenseGroup(ExpenseGroup eg)
{
try
{
_ctx.ExpenseGroups.Add(eg);
var result = _ctx.SaveChanges();
if (result > 0)
{
return(new RepositoryActionResult <ExpenseGroup>(eg, RepositoryActionStatus.Created));
}
else
{
return(new RepositoryActionResult <ExpenseGroup>(eg, RepositoryActionStatus.NothingModified, null));
}
}
catch (Exception ex)
{
return(new RepositoryActionResult <ExpenseGroup>(null, RepositoryActionStatus.Error, ex));
}
}
public bool Create<TEntity>(TEntity entity) where TEntity : class
{
_context.Set<TEntity>().Add(entity);
return _context.SaveChanges() > 0;
}
public List <Currency> AddCurrency()
{
List <Currency> currencies = new List <Currency>();
if (_context.Currencies.Count() == 0)
{
//Adding Basic Categories on startup
currencies.Add(new Currency {
CurrencyName = "Afghan afghani", CurrencyCode = "AFN"
});
currencies.Add(new Currency {
CurrencyName = "European euro", CurrencyCode = "EUR"
});
currencies.Add(new Currency {
CurrencyName = "Albanian lek", CurrencyCode = "ALL"
});
currencies.Add(new Currency {
CurrencyName = "Algerian dinar", CurrencyCode = "DZD"
});
currencies.Add(new Currency {
CurrencyName = "Angolan kwanza", CurrencyCode = "AOA"
});
currencies.Add(new Currency {
CurrencyName = "Argentine peso", CurrencyCode = "ARS"
});
currencies.Add(new Currency {
CurrencyName = "Armenian", CurrencyCode = "dram"
});
currencies.Add(new Currency {
CurrencyName = "East Caribbean dollar", CurrencyCode = "XCD"
});
currencies.Add(new Currency {
CurrencyName = "Aruban florin ", CurrencyCode = "AWG"
});
currencies.Add(new Currency {
CurrencyName = "Saint Helena pound", CurrencyCode = "SHP"
});
currencies.Add(new Currency {
CurrencyName = "Bermudian dollar", CurrencyCode = "BMD"
});
currencies.Add(new Currency {
CurrencyName = "Cayman Islands dollar", CurrencyCode = "KYD"
});
currencies.Add(new Currency {
CurrencyName = "New Zealand dollar", CurrencyCode = "NZD"
});
currencies.Add(new Currency {
CurrencyName = "Australian dollar", CurrencyCode = "AUD"
});
currencies.Add(new Currency {
CurrencyName = "Cook Islands dollar", CurrencyCode = "none"
});
currencies.Add(new Currency {
CurrencyName = "Netherlands Antillean guilder", CurrencyCode = "ANG"
});
currencies.Add(new Currency {
CurrencyName = "Falkland Islands pound", CurrencyCode = "FKP"
});
currencies.Add(new Currency {
CurrencyName = "Gibraltar pound", CurrencyCode = "GIP"
});
currencies.Add(new Currency {
CurrencyName = "Danish krone", CurrencyCode = "DKK"
});
currencies.Add(new Currency {
CurrencyName = "Guernsey Pound", CurrencyCode = "GGP"
});
currencies.Add(new Currency {
CurrencyName = "Hong Kong dollar", CurrencyCode = "HKD"
});
currencies.Add(new Currency {
CurrencyName = "Manx pound", CurrencyCode = "IMP"
});
currencies.Add(new Currency {
CurrencyName = "Jersey pound", CurrencyCode = "JEP"
});
currencies.Add(new Currency {
CurrencyName = "Kuwaiti dinar", CurrencyCode = "KWD"
});
currencies.Add(new Currency {
CurrencyName = "Macanese pataca", CurrencyCode = "MOP"
});
currencies.Add(new Currency {
CurrencyName = "East Caribbean dollar", CurrencyCode = "XCD"
});
currencies.Add(new Currency {
CurrencyName = "CFP franc", CurrencyCode = "XPF"
});
currencies.Add(new Currency {
CurrencyName = "Indian rupee", CurrencyCode = "INR"
});
_context.Currencies.AddRange(currencies);
_context.SaveChanges();
}
return(currencies);
}
