/// <summary> /// Method for populating the DataDridView /// </summary> public void populateDataGridView(int projectId) { this.projectId = projectId; if (DbConnector.OpenSQLConnection()) // Open connection to the database { // Connection opened ModuleDataAccess module = new ModuleDataAccess(); dgvModule.AutoGenerateColumns = false; // To only show the columns needed dgvModule.DataSource = module.GetAllModules(projectId); ProjectDataAccess project = new ProjectDataAccess(); projectName = project.FindProject(projectId).ProjectName; for (int i = 0; i < dgvModule.RowCount; i++) { dgvModule.Rows[i].Cells[2].Value = projectName; } txtSearchModules.Text = ""; Modules_Tab_Child.getInstance().clearModuleText(); } else { // Connection could not be opened MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } DbConnector.CloseSQLConnection(); // Close connection to the database }
/// <summary> /// Populate the datagridview with search result /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSearchModules_Click(object sender, EventArgs e) { if (DbConnector.OpenSQLConnection()) // Open connection to the database { // Connection opened ModuleDataAccess module = new ModuleDataAccess(); dgvModule.AutoGenerateColumns = false; // To only show the columns needed dgvModule.DataSource = module.SearchModules(txtSearchModules.Text.Trim()); if (dgvModule.RowCount != 0) { ProjectDataAccess project = new ProjectDataAccess(); var result = project.FindProject(Convert.ToInt32(dgvModule.Rows[0].Cells[1].Value)).ProjectName; for (int i = 0; i < dgvModule.RowCount; i++) { dgvModule.Rows[i].Cells[2].Value = result; } } } else { // Connection could not be opened MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } DbConnector.CloseSQLConnection(); // Close connection to the database }
/// <summary> /// Handles DataGridView button click events /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvProject_CellContentClick(object sender, DataGridViewCellEventArgs e) { var Column = ((DataGridView)sender).Columns[e.ColumnIndex]; if (Column is DataGridViewButtonColumn && e.RowIndex >= 0) { if (Column.Index == 9) // Modules button { Modules_Tab.getInstance().BringToFront(); Modules_Tab.getInstance().populateDataGridView(Convert.ToInt32(dgvProject.Rows[e.RowIndex].Cells[0].Value)); } else if (Column.Index == 10) // Update button { if (DbConnector.OpenSQLConnection()) // Open connection to the database { // Connection opened ProjectDataAccess project = new ProjectDataAccess(); var result = project.FindProject(Convert.ToInt32(dgvProject.Rows[e.RowIndex].Cells[0].Value)); if (result != null) { Projects_Tab_Child.getInstance().BringToFront(); Projects_Tab_Child.getInstance().changeView(result); } } else { // Connection could not be opened MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } DbConnector.CloseSQLConnection(); // Close connection to the database } else if (Column.Index == 11) // Delete button { if (MessageBox.Show("Are you sure you want to delete this record?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { if (DbConnector.OpenSQLConnection()) // Open connection to the database { // Connection opened ProjectDataAccess project = new ProjectDataAccess(); if (project.DeleteProject(Convert.ToInt32(dgvProject.Rows[e.RowIndex].Cells[0].Value))) { // Record deleted successfully MessageBox.Show("Record has been deleted successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); populateDataGridView(); } else { // Record was not deleted MessageBox.Show("The record could not be deleted", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { // Connection could not be opened MessageBox.Show("Connection to the database could not be established", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } DbConnector.CloseSQLConnection(); // Close connection to the database } } } }