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"));
}
