public ExpenditureModalBindingModel GetCategoryNames() { var allCategories = DbContext.BudgetCategories; var viewModel = new ExpenditureModalBindingModel(); foreach (var category in allCategories) { viewModel.CurrentCategories.Add(category.Name); } return(viewModel); }
public void AddExpenditureInGoogleSheets(ExpenditureModalBindingModel model) { sheet = DateTime.Now.ToString("MMMM", new CultureInfo("bg-BG")).ToUpper(); // Specifying Column Range for reading... var range = $"{sheet}!A:C"; var valueRange = new ValueRange(); // Data for another Student... var oblist = new List <object> { model.Date.Day.ToString(), model.Expenditure.ToString(CultureInfo.InvariantCulture), model.ForWhat }; valueRange.Values = new List <IList <object> > { oblist }; // Append the above record... var appendRequest = service.Spreadsheets.Values.Append(valueRange, SpreadsheetId, range); appendRequest.ValueInputOption = SpreadsheetsResource.ValuesResource.AppendRequest.ValueInputOptionEnum.USERENTERED; var appendReponse = appendRequest.Execute(); }
public async Task AddExpenditure(ExpenditureModalBindingModel viewModel, string userId) { var user = await UserManager.FindByIdAsync(userId); var budgetCategory = DbContext.BudgetCategories.FirstOrDefault(n => n.Name == viewModel.Category); if (budgetCategory != null) { var expenditure = new Expenditure { BudgetCategoryId = budgetCategory.Id, Date = viewModel.Date, ForWhat = viewModel.ForWhat, Money = viewModel.Expenditure, SpenderId = user.Id }; DbContext.Expenditures.Add(expenditure); } await DbContext.SaveChangesAsync(); }
public IActionResult AddExpenditureInGoogleSheetsPost(ExpenditureModalBindingModel model) { _googleSheetsService.AddExpenditureInGoogleSheets(model); return(RedirectToAction("GoogleSheets")); }
public async Task <IActionResult> AddExpenditurePost(ExpenditureModalBindingModel model) { await _accountService.AddExpenditure(model, _user.GetUserId(User)); return(RedirectToAction("Index", "Home")); }