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 string ByCategory(int index) { List <string> category = CategoriesController.Instance().parseCategories(); int z = 0; foreach (var category1 in category) { if (z == index) { return(category1); } z++; } return(null); }
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()); } }