public IList <RangeUpdateModel> PrepExpenseUpdate(CategoriesExpense expenses, DateTime effectiveDate)
{
var expenseRange = GetExpenseRangeString(effectiveDate);
var update = new RangeUpdateModel();
update.Dimension = DimensionEnums.Columns;
update.Range = expenseRange;
update.Values = new List <IList <object> > {
new List <object> {
expenses.DailyFood,
expenses.Gifts,
expenses.Medical,
expenses.Health,
expenses.Necessities,
expenses.Transportation,
expenses.Personal,
expenses.Fun,
expenses.Utilities,
expenses.Travel,
expenses.Debt,
expenses.Electronics,
expenses.Goals,
expenses.Rent,
expenses.Car,
expenses.Restaurants,
expenses.Appartment,
expenses.Investment,
expenses.Other
},
};
return(new List <RangeUpdateModel> {
update
});
}
public IList <RangeUpdateModel> PrepExpenseCategoryProjectionUpdate(CategoriesExpense expenses, UserEnum user)
{
var expenseUpdateModel = new RangeUpdateModel();
expenseUpdateModel.Range = user == UserEnum.Green ?
_sheetDetails.GreenExpenseProjectionRange :
_sheetDetails.RedExpenseProjectionRange;
expenseUpdateModel.Dimension = DimensionEnums.Columns;
// TODO: use order-safe enum
expenseUpdateModel.Values = new List <IList <object> > {
new List <object> {
expenses.DailyFood,
expenses.Gifts,
expenses.Medical,
expenses.Health,
expenses.Necessities,
expenses.Transportation,
expenses.Personal,
expenses.Fun,
expenses.Utilities,
expenses.Travel,
expenses.Debt,
expenses.Electronics,
expenses.Goals,
expenses.Rent,
expenses.Car,
expenses.Restaurants,
expenses.Appartment,
expenses.Investment,
expenses.Other
},
};
return(new List <RangeUpdateModel> {
expenseUpdateModel
});
}
public CategoriesPersonal LoadProjections()
{
var rawExpense = LoadRange(_sheetDetails.ExpenseProjectionRange);
var expense = new CategoriesExpense();
if (rawExpense != null && rawExpense.Count > 0)
{
expense.DailyFood = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.DailyFood][0].ToString(), NumberStyles.Currency);
expense.Gifts = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Gifts][0].ToString(), NumberStyles.Currency);
expense.Medical = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Medical][0].ToString(), NumberStyles.Currency);
expense.Health = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Health][0].ToString(), NumberStyles.Currency);
expense.Necessities = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Necessities][0].ToString(), NumberStyles.Currency);
expense.Transportation = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Transportation][0].ToString(), NumberStyles.Currency);
expense.Personal = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Personal][0].ToString(), NumberStyles.Currency);
expense.Fun = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Fun][0].ToString(), NumberStyles.Currency);
expense.Utilities = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Utilities][0].ToString(), NumberStyles.Currency);
expense.Travel = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Travel][0].ToString(), NumberStyles.Currency);
expense.Debt = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Debt][0].ToString(), NumberStyles.Currency);
expense.Electronics = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Electronics][0].ToString(), NumberStyles.Currency);
expense.Goals = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Goals][0].ToString(), NumberStyles.Currency);
expense.Rent = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Rent][0].ToString(), NumberStyles.Currency);
expense.Car = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Car][0].ToString(), NumberStyles.Currency);
expense.Restaurants = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Restaurants][0].ToString(), NumberStyles.Currency);
expense.Appartment = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Appartment][0].ToString(), NumberStyles.Currency);
expense.Investment = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Investment][0].ToString(), NumberStyles.Currency);
expense.Other = decimal
.Parse(rawExpense[(int)CategoriesExpenseProjectionEnum.Other][0].ToString(), NumberStyles.Currency);
}
var rawIncome = LoadRange(_sheetDetails.IncomeProjectionRange);
var income = new CategoriesIncome();
if (rawIncome != null && rawIncome.Count > 0)
{
income.Savings = decimal
.Parse(rawExpense[(int)CategoriesIncomeProjectionEnum.Savings][0].ToString(), NumberStyles.Currency);
income.Paycheck = decimal
.Parse(rawExpense[(int)CategoriesIncomeProjectionEnum.Paycheck][0].ToString(), NumberStyles.Currency);
income.Bonus = decimal
.Parse(rawExpense[(int)CategoriesIncomeProjectionEnum.Bonus][0].ToString(), NumberStyles.Currency);
income.Personal = decimal
.Parse(rawExpense[(int)CategoriesIncomeProjectionEnum.Personal][0].ToString(), NumberStyles.Currency);
income.Gifts = decimal
.Parse(rawExpense[(int)CategoriesIncomeProjectionEnum.Gifts][0].ToString(), NumberStyles.Currency);
income.Other = decimal
.Parse(rawExpense[(int)CategoriesIncomeProjectionEnum.Other][0].ToString(), NumberStyles.Currency);
}
return(new CategoriesPersonal
{
Expense = expense,
Income = income,
RawExpense = rawExpense,
RawIncome = rawIncome
});
}
private CategoriesPersonal LoadPersonalCategories(UserEnum user)
{
string expenseRange = null;
string incomeRange = null;
switch (user)
{
case UserEnum.Green:
expenseRange = _sheetDetails.GreenExpenseCategoriesRange;
incomeRange = _sheetDetails.GreenIncomeCategoriesRange;
break;
case UserEnum.Red:
expenseRange = _sheetDetails.RedExpenseCategoriesRange;
incomeRange = _sheetDetails.RedIncomeCategoriesRange;
break;
default: break;
}
// load expense categories
var rawExpense = LoadRange(expenseRange);
var expense = new CategoriesExpense();
if (rawExpense != null && rawExpense.Count > 0)
{
expense.Total = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Total][0].ToString());
expense.DailyFood = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.DailyFood][0].ToString());
expense.Gifts = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Gifts][0].ToString());
expense.Medical = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Medical][0].ToString());
expense.Health = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Health][0].ToString());
expense.Necessities = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Necessities][0].ToString());
expense.Transportation = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Transportation][0].ToString());
expense.Personal = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Personal][0].ToString());
expense.Fun = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Fun][0].ToString());
expense.Utilities = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Utilities][0].ToString());
expense.Travel = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Travel][0].ToString());
expense.Debt = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Debt][0].ToString());
expense.Electronics = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Electronics][0].ToString());
expense.Goals = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Goals][0].ToString());
expense.Rent = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Rent][0].ToString());
expense.Car = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Car][0].ToString());
expense.Restaurants = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Restaurants][0].ToString());
expense.Appartment = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Appartment][0].ToString());
expense.Investment = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Investment][0].ToString());
expense.Other = decimal
.Parse(rawExpense[(int)CategoriesExpenseRowEnum.Other][0].ToString());
}
// load income categories
var rawIncome = LoadRange(incomeRange);
var income = new CategoriesIncome();
if (rawIncome != null && rawIncome.Count > 0)
{
income.Total = decimal
.Parse(rawIncome[(int)CategoriesIncomeRowEnum.Total][0].ToString());
income.Savings = decimal
.Parse(rawIncome[(int)CategoriesIncomeRowEnum.Savings][0].ToString());
income.Paycheck = decimal
.Parse(rawIncome[(int)CategoriesIncomeRowEnum.Paycheck][0].ToString());
income.Bonus = decimal
.Parse(rawIncome[(int)CategoriesIncomeRowEnum.Bonus][0].ToString());
income.Personal = decimal
.Parse(rawIncome[(int)CategoriesIncomeRowEnum.Personal][0].ToString());
income.Gifts = decimal
.Parse(rawIncome[(int)CategoriesIncomeRowEnum.Gifts][0].ToString());
income.Refund = decimal
.Parse(rawIncome[(int)CategoriesIncomeRowEnum.Refund][0].ToString());
income.Payment = decimal
.Parse(rawIncome[(int)CategoriesIncomeRowEnum.Payment][0].ToString());
income.Other = decimal
.Parse(rawIncome[(int)CategoriesIncomeRowEnum.Other][0].ToString());
}
return(new CategoriesPersonal
{
Expense = expense,
RawExpense = rawExpense,
Income = income,
RawIncome = rawIncome
});
}
