public DataTable getNewData(QueryType option, QueryData paramContainer, SelectedDataSource dataSource) { MySqlCommand command = null; if (option == QueryType.SINGLE_MONTH) { switch (dataSource) { //Grid view case SelectedDataSource.DYNAMIC_DATASOURCE_1: command = SQLCommandBuilder.getSingleMonthCommand(sqlStatementSingleMonthExpenses, paramContainer); break; //Pie chart case SelectedDataSource.DYNAMIC_DATASOURCE_2: command = SQLCommandBuilder.getSingleMonthCommand(sqlStatementExpenseTypeSumSingle, paramContainer); break; //Column chart case SelectedDataSource.STATIC_DATASOURCE: command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalExpenses, paramContainer); break; default: break; } } else if (option == QueryType.MULTIPLE_MONTHS) { switch (dataSource) { //Grid view case SelectedDataSource.DYNAMIC_DATASOURCE_1: command = SQLCommandBuilder.getMultipleMonthsCommand(sqlStatementMultipleMonthsExpenses, paramContainer); break; //Pie chart case SelectedDataSource.DYNAMIC_DATASOURCE_2: command = SQLCommandBuilder.getMultipleMonthsCommand(sqlStatementExpenseTypeSumMultiple, paramContainer); break; //Column chart case SelectedDataSource.STATIC_DATASOURCE: command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalExpenses, paramContainer); break; default: break; } } else if (option == QueryType.MONTHLY_TOTALS) { command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalExpenses, paramContainer); } return(DBConnectionManager.getData(command)); }
//The method returns a DataTable object using the provided arguments to decide the actual SQl query that will be executed(the query type(single/multiple months) and the data source that will be populated with data are taken into account for this decision) public DataTable getNewData(QueryType option, QueryData paramContainer, SelectedDataSource dataSource) { //Creates a MySqlCommand object tht will be populated with the actual command object selected after analyzing the previously mentioned arguments inside the if/else and switch block MySqlCommand command = null; //Single month query //The specific SQL query from which the command will be created is selected based on the data source and the type of data that needs to be displayed if (option == QueryType.SINGLE_MONTH) { switch (dataSource) { case SelectedDataSource.DYNAMIC_DATASOURCE_1: command = SQLCommandBuilder.getSingleMonthCommand(sqlStatementSingleMonthIncomes, paramContainer); break; case SelectedDataSource.DYNAMIC_DATASOURCE_2: command = SQLCommandBuilder.getSingleMonthCommand(sqlStatementIncomeTypeSumSingle, paramContainer); break; case SelectedDataSource.STATIC_DATASOURCE: command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalIncomes, paramContainer); break; default: break; } //Multiple months query } else if (option == QueryType.MULTIPLE_MONTHS) { switch (dataSource) { case SelectedDataSource.DYNAMIC_DATASOURCE_1: command = SQLCommandBuilder.getMultipleMonthsCommand(sqlStatementMultipleMonthsIncomes, paramContainer); break; case SelectedDataSource.DYNAMIC_DATASOURCE_2: command = SQLCommandBuilder.getMultipleMonthsCommand(sqlStatementIncomeTypeSumMultiple, paramContainer); break; case SelectedDataSource.STATIC_DATASOURCE: command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalIncomes, paramContainer); break; default: break; } //Monthly totals query } else if (option == QueryType.MONTHLY_TOTALS) { command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalIncomes, paramContainer); } //The data is retrieved by passing the previously obtained command to the DBConnectionManger's getData() method return(DBConnectionManager.getData(command)); }
public DataTable getNewData(QueryType option, QueryData paramContainer, SelectedDataSource dataSource) { MySqlCommand command = null; if (option == QueryType.SINGLE_MONTH) { switch (dataSource) { case SelectedDataSource.DYNAMIC_DATASOURCE_1: command = SQLCommandBuilder.getSingleMonthCommand(sqlStatementSingleMonthSavings, paramContainer); break; case SelectedDataSource.DYNAMIC_DATASOURCE_2: command = SQLCommandBuilder.getSingleMonthCommand(sqlStatementSavingsValueSumSingle, paramContainer); break; case SelectedDataSource.STATIC_DATASOURCE: command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalSavings, paramContainer); break; default: break; } } else if (option == QueryType.MULTIPLE_MONTHS) { switch (dataSource) { case SelectedDataSource.DYNAMIC_DATASOURCE_1: command = SQLCommandBuilder.getMultipleMonthsCommand(sqlStatementMultipleMonthsSavings, paramContainer); break; case SelectedDataSource.DYNAMIC_DATASOURCE_2: command = SQLCommandBuilder.getMultipleMonthsCommand(sqlStatementSavingsValueSumMultiple, paramContainer); break; case SelectedDataSource.STATIC_DATASOURCE: command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalSavings, paramContainer); break; default: break; } //Obtinere comanda pentru extragere date pentru fiecare luna a unui an } else if (option == QueryType.MONTHLY_TOTALS) { command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalSavings, paramContainer); } return(DBConnectionManager.getData(command)); }
public DataTable getNewData(QueryType option, QueryData paramContainer, SelectedDataSource dataSource) { MySqlCommand command = null; if (option == QueryType.SINGLE_MONTH) { switch (dataSource) { case SelectedDataSource.DYNAMIC_DATASOURCE_1: command = SQLCommandBuilder.getSingleMonthCommand(sqlStatementSingleMonthDebts, paramContainer); break; case SelectedDataSource.DYNAMIC_DATASOURCE_2: command = SQLCommandBuilder.getSingleMonthCommand(sqlStatementDebtValueSumForCreditorSingle, paramContainer); break; case SelectedDataSource.STATIC_DATASOURCE: command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalDebts, paramContainer); break; default: break; } } else if (option == QueryType.MULTIPLE_MONTHS) { switch (dataSource) { case SelectedDataSource.DYNAMIC_DATASOURCE_1: command = SQLCommandBuilder.getMultipleMonthsCommand(sqlStatementMultipleMonthsDebts, paramContainer); break; case SelectedDataSource.DYNAMIC_DATASOURCE_2: command = SQLCommandBuilder.getMultipleMonthsCommand(sqlStatementDebtValueSumForCreditorMultiple, paramContainer); break; case SelectedDataSource.STATIC_DATASOURCE: command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalDebts, paramContainer); break; default: break; } } else if (option == QueryType.MONTHLY_TOTALS) { command = SQLCommandBuilder.getMonthlyTotalsCommand(sqlStatementMonthlyTotalDebts, paramContainer); } return(DBConnectionManager.getData(command)); }
//Metoda prin care modelul aduce date din DB public DataTable getNewData(QueryType option, QueryData paramContainer, SelectedDataSource dataSource) { MySqlCommand command = null; if (option == QueryType.SINGLE_MONTH) { switch (dataSource) { case SelectedDataSource.DYNAMIC_DATASOURCE_1: command = SQLCommandBuilder.getSingleMonthCommand(sqlStatementSummarySingle, paramContainer); break; case SelectedDataSource.DYNAMIC_DATASOURCE_2: break; case SelectedDataSource.STATIC_DATASOURCE: break; default: break; } } else if (option == QueryType.MULTIPLE_MONTHS) { switch (dataSource) { case SelectedDataSource.DYNAMIC_DATASOURCE_1: command = SQLCommandBuilder.getMultipleMonthsCommand(sqlStatementSummaryMultiple, paramContainer); break; case SelectedDataSource.DYNAMIC_DATASOURCE_2: break; case SelectedDataSource.STATIC_DATASOURCE: break; default: break; } } //In cazul modelelor care nu utilizeaza toate cele trei data tables definite in interfata IModel comanda SQL ramane cu valoarea null si //astfel nu se va mai executa metoda de extragere a datelor din DB if (command == null) { return(null); } return(DBConnectionManager.getData(command)); }
private MySqlCommand getCorrectSqlCommandForDataDisplay(QueryType option, QueryData paramContainer) { //Retrieving data from the Querydata object(container object) int userID = paramContainer.UserID; String tableName = paramContainer.TableName; int selectedMonth = 0; //If single month data is requested then the value of the month from the QueryData object will be retrieved if (option == QueryType.SINGLE_MONTH) { selectedMonth = paramContainer.Month; } int selectedYear = paramContainer.Year; switch (tableName) { //Creates the correct SQL command based on the dateTimePicker selection(single month command/full year command) case "Incomes": if (option == QueryType.SINGLE_MONTH) { return(SQLCommandBuilder.getSingleMonthCommand(sqlStatementSelectSingleMonthIncomes, new QueryData.Builder(userID).addMonth(selectedMonth).addYear(selectedYear).build())); } else if (option == QueryType.FULL_YEAR) { return(SQLCommandBuilder.getFullYearRecordsCommand(sqlStatementSelectFullYearIncomes, new QueryData.Builder(userID).addYear(selectedYear).build())); //CHANGE } else { return(null); } case "General expenses": if (option == QueryType.SINGLE_MONTH) { return(SQLCommandBuilder.getSingleMonthCommand(sqlStatementSelectSingleMonthGeneralExpenses, new QueryData.Builder(userID).addMonth(selectedMonth).addYear(selectedYear).build())); } else if (option == QueryType.FULL_YEAR) { return(SQLCommandBuilder.getFullYearRecordsCommand(sqlStatementSelectFullYearGeneralExpenses, new QueryData.Builder(userID).addYear(selectedYear).build())); } else { return(null); } case "Saving accounts expenses": if (option == QueryType.SINGLE_MONTH) { return(SQLCommandBuilder.getSingleMonthCommand(sqlStatementSelectSingleMonthSavingAccountExpenses, new QueryData.Builder(userID).addMonth(selectedMonth).addYear(selectedYear).build())); } else if (option == QueryType.FULL_YEAR) { return(SQLCommandBuilder.getFullYearRecordsCommand(sqlStatementSelectFullYearSavingAccountExpenses, new QueryData.Builder(userID).addYear(selectedYear).build())); } else { return(null); } case "Debts": if (option == QueryType.SINGLE_MONTH) { return(SQLCommandBuilder.getSingleMonthCommand(sqlStatementSelectSingleMonthDebts, new QueryData.Builder(userID).addMonth(selectedMonth).addYear(selectedYear).build())); } else if (option == QueryType.FULL_YEAR) { return(SQLCommandBuilder.getFullYearRecordsCommand(sqlStatementSelectFullYearDebts, new QueryData.Builder(userID).addYear(selectedYear).build())); } else { return(null); } case "Savings": if (option == QueryType.SINGLE_MONTH) { return(SQLCommandBuilder.getSingleMonthCommand(sqlStatementSelectSingleMonthSavings, new QueryData.Builder(userID).addMonth(selectedMonth).addYear(selectedYear).build())); } else if (option == QueryType.FULL_YEAR) { return(SQLCommandBuilder.getFullYearRecordsCommand(sqlStatementSelectFullYearSavings, new QueryData.Builder(userID).addYear(selectedYear).build())); } else { return(null); } default: return(null); } }