override public void setMonthAndYears(ReportDialogBox view, Building apartment) { List <String> months = new List <String>(); List <String> years = new List <String>(); string selectQuery = "SELECT DISTINCT MONTH(" + TABLE_OUTGOING_TRANSACTION.KEY_DATE + "), YEAR(" + TABLE_OUTGOING_TRANSACTION.KEY_DATE + ") FROM " + Util.VIEWS.EXPENSE_REPORT_VIEW + " WHERE " + TABLE_EXPENSES.KEY_APARTMENT_ID + " = '" + apartment.getID() + "'"; connection.Open(); using (SqlCommand command = new SqlCommand(selectQuery, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { if (Convert.ToInt32(reader[0]) != DateTime.Now.Month || Convert.ToInt32(reader[1]) != DateTime.Now.Year) { int month = Convert.ToInt32(reader[0]); months.Add(miscFunctions.ToMonthName(month)); years.Add(reader[1].ToString()); } } } } connection.Close(); view.setMonths(months); view.setYears(years); }
public override void generateReprt(ReportDialogBox view, Building apartment, int month, int year) { int incomeSum = 0, expenseSum = 0; view.exportPdf(generateIncomeReport(apartment, month, year, ref incomeSum), generateExpenseReport(apartment, month, year, ref expenseSum), incomeSum, expenseSum); }
virtual public void setMonthAndYears(ReportDialogBox view, Building apartment) { }
virtual public void generateReprt(ReportDialogBox view, Building apartment, int month, int year) { }