public void addGoal([FromBody] string goaltoAdd) { try { GoalDB _goal = new GoalDB(); string goalToAddString = goaltoAdd; string[] elements = goalToAddString.Split(','); foreach (string it in elements) { string _goalName = elements[0]; decimal _goalAmount = decimal.Parse(elements[1]); DateTime _goalDate = DateTime.Parse(elements[2]); int _userid = Int32.Parse(FrontendController.Instance().userId()); _goal.goalName = _goalName; _goal.goalAmount = _goalAmount; _goal.goalDate = _goalDate; _goal.userId = _userid; } using (var context = new Data.Smart_Saver_APIContext()) { context.GoalDB.Add(_goal); context.SaveChanges(); } } catch (Exception e) { _logger.LogError(e.ToString()); } }
public bool AttemptLogin(String userName, String password) { String passwordFromDatabase = ""; System.Collections.Generic.List <Smart_Saver_API.Models.LoginDB> logins = new System.Collections.Generic.List <Smart_Saver_API.Models.LoginDB>(); try { using (var context = new Data.Smart_Saver_APIContext()) { logins = context.LoginDB.ToList(); } } catch (Exception e) { //_logger?.LogError(e.ToString()); } bool userFound = false; foreach (Smart_Saver_API.Models.LoginDB oneUser in logins) { if (oneUser.Username == userName) { passwordFromDatabase = oneUser.Password; userFound = true; break; } } return((passwordFromDatabase == password) && userFound); }
public void AddExpenseWeb([FromBody] string recurringincomeadd) { try { ReccuringIncomeDB _recurringincome = new ReccuringIncomeDB(); string reccuringIncomeToAddString = recurringincomeadd; string[] elements = reccuringIncomeToAddString.Split(','); foreach (string it in elements) { decimal _reccuringIncomeAmount = decimal.Parse(elements[0]); DateTime _reccuringDateFrom = DateTime.Parse(elements[1]); DateTime _reccuringDateUntil = DateTime.Parse(elements[2]); int _userid = Int32.Parse(FrontendController.Instance().userId()); _recurringincome.reccuringincomeAmount = _reccuringIncomeAmount; _recurringincome.reccuringincomeDateFrom = _reccuringDateFrom; _recurringincome.reccuringincomeDateUntil = _reccuringDateUntil; _recurringincome.userId = _userid; } using (var context = new Data.Smart_Saver_APIContext()) { context.ReccuringIncomeDB.Add(_recurringincome); context.SaveChanges(); } } catch (Exception e) { _logger.LogError(e.ToString()); } }
public IEnumerable <ExpenseDB> ParseOneUserExpenses(String username, string password) { LoginController loginC = new LoginController(); int userId = loginC.UserId(username, password); List <ExpenseDB> expenses = new List <ExpenseDB>(); try { using (var context = new Data.Smart_Saver_APIContext()) { expenses = context.ExpenseDB.ToList(); } } catch (Exception e) { _logger?.LogError(e.ToString()); } List <ExpenseDB> userExpenses = new List <ExpenseDB>(); foreach (ExpenseDB oneExpense in expenses) { if (oneExpense.UserId == userId) { userExpenses.Add(oneExpense); } } return(userExpenses); }
public void AddExpenseWeb([FromBody] string expenseToAdd) { try { ExpenseDB _expense = new ExpenseDB(); string expenseToAddString = expenseToAdd; string[] elements = expenseToAddString.Split(','); foreach (string it in elements) { string _expenseName = elements[0]; decimal _expenseAmount = decimal.Parse(elements[1]); DateTime _expenseDate = DateTime.Parse(elements[2]); String _category = elements[3]; int _userid = Int32.Parse(FrontendController.Instance().userId()); _expense.expenseName = _expenseName; _expense.expenseAmount = _expenseAmount; _expense.expenseDate = _expenseDate; _expense.categoryId = CategoriesController.Instance().getId(_category); _expense.expenseCategory = CategoriesController.Instance().getCategory(_expense.categoryId); _expense.UserId = _userid; } using (var context = new Data.Smart_Saver_APIContext()) { context.ExpenseDB.Add(_expense); context.SaveChanges(); } } catch (Exception e) { _logger.LogError(e.ToString()); } }
public void AddIncomeWeb([FromBody] string income) { try { IncomeDB _income = new IncomeDB(); string incomeToAddString = income; string[] elements = incomeToAddString.Split(','); foreach (string it in elements) { decimal _incomeAmount = decimal.Parse(elements[0]); DateTime _incomeDate = DateTime.Parse(elements[1]); int _userid = Int32.Parse(FrontendController.Instance().userId()); _income.incomeAmount = _incomeAmount; _income.incomeDate = _incomeDate; _income.userId = _userid; } using (var context = new Data.Smart_Saver_APIContext()) { context.IncomeDB.Add(_income); context.SaveChanges(); } } catch (Exception e) { _logger.LogError(e.ToString()); } }
public decimal GetCategoryExpenseAmount(string neededCategory) { List <ExpenseDB> expenses = new List <ExpenseDB>(); try { using (var context = new Data.Smart_Saver_APIContext()) { expenses = context.ExpenseDB.ToList(); var categories = from expense in expenses group expense.expenseAmount by expense.expenseCategory into categoryGroup //<-----------------------------------LINQ select new { Name = categoryGroup.Key, Amount = categoryGroup.Sum() }; foreach (var category in categories) { if (category.Name == neededCategory) { return(category.Amount); } } //If category wasn;t found throw exception throw new Exception("Specified category was not found in the database."); } } catch (Exception e) { _logger.LogError(e.ToString()); return(-1); } }
public IEnumerable <GoalDB> ParseOneUserGoal(String username, String password) //Do not use this for several goals { LoginController loginC = new LoginController(); int userId = loginC.UserId(username, password); List <GoalDB> newGoal = new List <GoalDB>(); try { using (var context = new Data.Smart_Saver_APIContext()) { newGoal = context.GoalDB.ToList(); } } catch (Exception e) { _logger.LogError(message: e.ToString()); } List <GoalDB> oneUserGoals = new List <GoalDB>(); foreach (GoalDB oneGoal in newGoal) { if (oneGoal.userId == userId) { oneUserGoals.Add(oneGoal); } } return(oneUserGoals); }
public IEnumerable <Smart_Saver_API.Models.IncomeDB> parseOneUserIncomes(String username, string password) { LoginController loginC = new LoginController(); int userId = loginC.UserId(username, password); List <IncomeDB> income = new List <IncomeDB>(); try { using (var context = new Data.Smart_Saver_APIContext()) { income = context.IncomeDB.ToList(); } } catch (Exception e) { _logger?.LogError(e.ToString()); } List <IncomeDB> userIncome = new List <IncomeDB>(); foreach (IncomeDB oneIncome in income) { if (oneIncome.userId == userId) { userIncome.Add(oneIncome); } } return(userIncome); }
public IEnumerable <Smart_Saver_API.Models.IncomeDB> ParseIncomes() { List <IncomeDB> income = new List <IncomeDB>(); try { using (var context = new Data.Smart_Saver_APIContext()) { income = context.IncomeDB.ToList(); } }catch (Exception e) { _logger?.LogError(e.ToString()); } return(income); }
public IEnumerable <GoalDB> ParseGoal() //Do not use this for several goals { List <GoalDB> newGoal = new List <GoalDB>(); try { using (var context = new Data.Smart_Saver_APIContext()) { newGoal = context.GoalDB.ToList(); } } catch (Exception e) { _logger.LogError(message: e.ToString()); } return(newGoal); }
public string getCategory(int index) { List <CategoriesDB> ExpenseCategories = new List <CategoriesDB>(); using (var context = new Data.Smart_Saver_APIContext()) { ExpenseCategories = context.CategoriesDB.ToList(); } foreach (var category1 in ExpenseCategories) { if (category1.categoryId == index) { return(category1.categoryName); } } return(null); }
public IEnumerable <ExpenseDB> ParseExpenses() { List <ExpenseDB> expenses = new List <ExpenseDB>(); try { using (var context = new Data.Smart_Saver_APIContext()) { expenses = context.ExpenseDB.ToList(); } } catch (Exception e) { _logger?.LogError(e.ToString()); } return(expenses); }
public void ClearExpenseDB() { var expenses = ParseExpenses(); try { using (var context = new Data.Smart_Saver_APIContext()) { context.ExpenseDB.RemoveRange(expenses); context.SaveChanges(); } } catch (Exception e) { _logger.LogError(e.ToString()); } }
public decimal GetTotalExpenseAmount() { List <ExpenseDB> expenses = new List <ExpenseDB>(); Decimal totalAmount = 0; using (var context = new Data.Smart_Saver_APIContext()) { expenses = context.ExpenseDB.ToList(); foreach (var _expenses in expenses) { totalAmount += _expenses.expenseAmount; } } return(totalAmount); }
public string userInfo() { List <UserDB> user = new List <UserDB>(); List <string> listA = new List <string>(); using (var context = new Data.Smart_Saver_APIContext()) { user = context.UserDB.ToList(); foreach (var _user in user) { listA.Add(_user.userName); listA.Add(_user.userSurname); listA.Add(_user.userAge.ToString()); } } return(listA[1] + " " + listA[2]); }
public int getId(string categoryname) { List <CategoriesDB> ExpenseCategories = new List <CategoriesDB>(); int z = 1; using (var context = new Data.Smart_Saver_APIContext()) { ExpenseCategories = context.CategoriesDB.ToList(); } foreach (var category1 in ExpenseCategories) { if (category1.categoryName == categoryname) { return(category1.categoryId); } z++; } return(-1); }
[Route("add-income")] //Unusable // [EnableCors("AllowOrigin")] public void AddIncome(decimal amount, DateTime date) { try { IncomeDB _income = new IncomeDB() { incomeAmount = amount, incomeDate = date, userId = Int32.Parse(FrontendController.Instance().userId()) }; using (var context = new Data.Smart_Saver_APIContext()) { context.IncomeDB.Add(_income); context.SaveChanges(); } } catch (Exception e) { _logger.LogError(e.ToString()); } }
public void RemoveExpenseCategory(string neededCategory) //unusable because it can be more categories with the same name { try { using (var context = new Data.Smart_Saver_APIContext()) { var expenses = context.ExpenseDB.Where(p => p.expenseCategory == neededCategory) .FirstOrDefault(); if (expenses is ExpenseDB) { context.Remove(expenses); } context.SaveChanges(); } } catch (Exception e) { _logger.LogError(e.ToString()); } }
[Route("add-income-object")] //Unusable // [EnableCors("AllowOrigin")] public void PostNewIncome(IncomeDB income) //Models (general classes) in seperate project - lib { try { IncomeDB _income = new IncomeDB() { incomeAmount = income.incomeAmount, incomeDate = income.incomeDate, userId = Int32.Parse(FrontendController.Instance().userId()) }; using (var context = new Data.Smart_Saver_APIContext()) { context.IncomeDB.Add(_income); context.SaveChanges(); } } catch (Exception e) { _logger.LogError(e.ToString()); } }
public int UserId(String username, String password) { System.Collections.Generic.List <Smart_Saver_API.Models.LoginDB> logins = new System.Collections.Generic.List <Smart_Saver_API.Models.LoginDB>(); try { using (var context = new Data.Smart_Saver_APIContext()) { logins = context.LoginDB.ToList(); } } catch (Exception e) { //_logger?.LogError(e.ToString()); } Smart_Saver_API.Models.LoginDB foundUser = new Smart_Saver_API.Models.LoginDB(); bool userFound = false; foreach (Smart_Saver_API.Models.LoginDB oneUser in logins) { if (oneUser.Username == username) { foundUser = oneUser; userFound = true; if (password == foundUser.Password) { return(oneUser.UserId); } else { return(-1); } } } return(-1); }
public void AddIncome(decimal amount, DateTime dateFrom, DateTime dateUntil) { try { ReccuringIncomeDB _income = new ReccuringIncomeDB() { reccuringincomeAmount = amount, reccuringincomeDateFrom = dateFrom, reccuringincomeDateUntil = dateUntil, userId = Int32.Parse(FrontendController.Instance().userInfo()) }; using (var context = new Data.Smart_Saver_APIContext()) { context.ReccuringIncomeDB.Add(_income); context.SaveChanges(); } } catch (Exception e) { _logger.LogError(e.ToString()); } }
public void AddCategory([FromBody] string category) { try { CategoriesDB _category = new CategoriesDB(); string categoryToAddString = category; string[] elements = categoryToAddString.Split(','); foreach (string it in elements) { string _categoryName = elements[0]; _category.categoryName = _categoryName; } using (var context = new Data.Smart_Saver_APIContext()) { context.CategoriesDB.Add(_category); context.SaveChanges(); } } catch (Exception e) { _logger.LogError(e.ToString()); } }
public List <string> parseCategories() { List <CategoriesDB> ExpenseCategories = new List <CategoriesDB>(); List <string> expenses = new List <string>(); try { using (var context = new Data.Smart_Saver_APIContext()) { ExpenseCategories = context.CategoriesDB.ToList(); } foreach (var _expense in ExpenseCategories) { expenses.Add(_expense.categoryName); } } catch (Exception e) { _logger?.LogError(e.ToString()); } return(expenses); }
public void AddExpense(ExpenseDB expenseToAdd) { try { ExpenseDB _expense = new ExpenseDB() { expenseName = expenseToAdd.expenseName, expenseAmount = expenseToAdd.expenseAmount, expenseDate = expenseToAdd.expenseDate, categoryId = CategoriesController.Instance().getId(expenseToAdd.expenseCategory), expenseCategory = CategoriesController.Instance().getCategory(CategoriesController.Instance().getId(expenseToAdd.expenseCategory)), UserId = Int32.Parse(FrontendController.Instance().userId()) }; using (var context = new Data.Smart_Saver_APIContext()) { context.ExpenseDB.Add(_expense); context.SaveChanges(); } } catch (Exception e) { _logger.LogError(e.ToString()); } }