private MonthlyExpenses calculateMonthlyExpenses(MonthlyExpenses monthly, string fileName) { fileName = fileName + ".sqlite"; if (File.Exists(Path.Combine(folderPath, fileName))) { connection = db.createDBConnection(Path.Combine(folderPath, fileName), connection); db.connectToDB(connection); string sql = "SELECT * from dailyExpenses"; SQLiteCommand sqlCommand = new SQLiteCommand(sql, connection); SQLiteDataReader reader = sqlCommand.ExecuteReader(); while (reader.Read()) { dailyExpenses temp = new dailyExpenses(); temp.date = reader["date"].ToString(); temp.transportationExpense = Convert.ToDouble(reader["transportation"]); temp.mealExpense = Convert.ToDouble(reader["meal"]); temp.othersExpense = Convert.ToDouble(reader["others"]); monthly.daily.Add(temp); monthly.mealExpense += temp.mealExpense; monthly.othersExpense += temp.othersExpense; monthly.transportationExpense += temp.transportationExpense; } } else { monthly.mealExpense = 0.0; monthly.othersExpense = 0.0; monthly.transportationExpense = 0.0; } return(monthly); }
float convertCategoriesToPercentage(double categoryExpenses, MonthlyExpenses expenses) { float total = (float)expenses.mealExpense + (float)expenses.othersExpense + (float)expenses.transportationExpense; float percentage = (float)categoryExpenses / total * 100; return(percentage); }
public void Add(Expense expense) { Validate(expense); ReservedForExpenses[expense.Name] = 0; MonthlyExpenses.Add(expense); }
private void Validate(Expense expense) { if (MonthlyExpenses.Any(e => e.Name.ToLower() == expense.Name.ToLower())) { throw new ArgumentException("Can't add expense {0} because an expanse with a matching name exists", expense.Name); } }
public IActionResult Upsert(int?id = 0) { MonthlyExpenses Expenses = new MonthlyExpenses(); JsonResult result = new JsonResult(new { }); if (id == 0) { result.Value = new { Data = true, message = "Its Insert Call" }; return(result); } Expenses = _unitOfWork.MonthlyExpenses.Get(id); if (Expenses == null) { result.Value = new { Data = "Not Found" }; return(result); } result.Value = new { Data = Expenses, message = "Its Update Call" }; return(result); }
public ActionResult Update(DateTime date, string name, string category, double amount, int?dueDate) { if (!dueDates.Any(n => n.Name == name)) { var newExpenseDueDate = new ExpenseDetails { Name = name, DueDate = dueDate }; db.Save(newExpenseDueDate); } var formData = new MonthlyExpenses { Date = date, Name = name, Category = category, Amount = amount }; db.Save(formData); var returnYear = date.Year > DateTime.Now.Year ? DateTime.Now.Year : date.Year; return(RedirectToAction("YearSummary/" + returnYear)); }
public void computeMonthlyChart(int month, int year) { MonthlyExpenses monthExpense = new MonthlyExpenses(); string filename = generateDailyFilename(month, year); textBox1.Text = "Current Month Expenses Chart"; monthExpense = calculateMonthlyExpenses(monthExpense, filename); if (monthExpense.transportationExpense == 0.0 && monthExpense.mealExpense == 0.0 && monthExpense.othersExpense == 0.0) { // do nothing } else { clearAllPieInfo(); createPieInfo("Transportation", convertCategoriesToPercentage(monthExpense.transportationExpense, monthExpense), Color.Aqua); createPieInfo("Meal", convertCategoriesToPercentage(monthExpense.mealExpense, monthExpense), Color.Red); createPieInfo("Others", convertCategoriesToPercentage(monthExpense.othersExpense, monthExpense), Color.Purple); } }
public IActionResult Upsert(MonthlyExpenses Expenses) { JsonResult result = new JsonResult(new { }); if (Expenses.ExpensesId == 0) { Expenses.CreatedById = 2; Expenses.CreatedDate = DateTime.Now; _unitOfWork.MonthlyExpenses.Add(Expenses); } else { Expenses.CreatedById = 2; Expenses.CreatedDate = DateTime.Now; _unitOfWork.MonthlyExpenses.Update(Expenses); } _unitOfWork.Save(); result.Value = new { Data = true }; return(result); }
static void Main(string[] args) { var rooms = new CompositeAsset(); rooms.Add(new Room { MonthlyRent = 10000 }); rooms.Add(new Room { MonthlyRent = 15000 }); rooms.Add(new Room { MonthlyRent = 9000 }); var gruppe1 = new CompositeAsset(); gruppe1.Add(new CEO { HiredDate = new DateTime(), HoursWorkedThisMonth = 300, MontlySalary = 100000 }); gruppe1.Add(new StudentEmployee { HiredDate = new DateTime(), HourRate = 120, HoursWorkedThisMonth = 100 }); gruppe1.Add(new StudentEmployee { HiredDate = new DateTime(), HourRate = 10, HoursWorkedThisMonth = 400 }); var assets = new CompositeAsset(); assets.Add(rooms); assets.Add(gruppe1); var monthlycacl = new MonthlyExpenses(); monthlycacl.ShowMonthly(assets); var dates = new HiredDates(); dates.PrintDates(assets); //var Employees = new Employees(); //var Emp1 = new Employee("Kalle", 5.400, 20, 100); //var Emp2 = new Employee("Kasper", 15293.1, 40, 5); //var Emp3 = new Employee("Kristian", 100.0, 14, 10); //var Emp4 = new Leader("Peter", 500.0, 20, 130); //Employees.AddEmployee(Emp1); //Employees.AddEmployee(Emp2); //Employees.AddEmployee(Emp3); //Employees.AddEmployee(Emp4); //var SalaryRepport = new SalaryRepport(); //var VacationRepport = new VacationRepport(); //var SickRepport = new SickRepport(); //Employees.Accept(SalaryRepport); //Console.WriteLine(""); //Employees.Accept(VacationRepport); //Console.WriteLine(""); //Employees.Accept(SickRepport); //Emp4.Accept(SalaryRepport); //Console.ReadKey(); }
public decimal MonthlyTotal() { return(MonthlyExpenses.Sum(expense => expense.Amount) + MonthlyTransfers.Sum(transfer => transfer.Amount)); }