/// <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> /// Handles DataGridView button click events /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgvModule_CellContentClick(object sender, DataGridViewCellEventArgs e) { var Column = ((DataGridView)sender).Columns[e.ColumnIndex]; if (Column is DataGridViewButtonColumn && e.RowIndex >= 0) { if (Column.Index == 6) // Update button { if (DbConnector.OpenSQLConnection()) // Open connection to the database { // Connection opened ModuleDataAccess module = new ModuleDataAccess(); var result = module.FindModule(Convert.ToInt32(dgvModule.Rows[e.RowIndex].Cells[0].Value)); if (result != null) { Modules_Tab_Child.getInstance().BringToFront(); Modules_Tab_Child.getInstance().changeView(result, projectId, projectName); } } 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 == 7) // 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 ModuleDataAccess module = new ModuleDataAccess(); if (module.DeleteModule(Convert.ToInt32(dgvModule.Rows[e.RowIndex].Cells[0].Value))) { // Record deleted successfully MessageBox.Show("Record has been deleted successfully", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); populateDataGridView(Convert.ToInt32(dgvModule.Rows[e.RowIndex].Cells[1].Value)); } 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 } } } }
/// <summary> /// Setup navigation between tabs /// </summary> private void SetupNavigation() { navAdapter.AddTab(Home_Tab.getInstance(), true); navAdapter.AddTab(Users_Tab.getInstance(), false); navAdapter.AddTab(Projects_Tab.getInstance(), false); navAdapter.AddTab(Defects_Tab.getInstance(), false); panelTabs_Holder.Controls.Add(Users_Tab_Child.getInstance()); Users_Tab_Child.getInstance().Dock = DockStyle.Fill; panelTabs_Holder.Controls.Add(Projects_Tab_Child.getInstance()); Projects_Tab_Child.getInstance().Dock = DockStyle.Fill; panelTabs_Holder.Controls.Add(Modules_Tab.getInstance()); Modules_Tab.getInstance().Dock = DockStyle.Fill; panelTabs_Holder.Controls.Add(Modules_Tab_Child.getInstance()); Modules_Tab_Child.getInstance().Dock = DockStyle.Fill; panelTabs_Holder.Controls.Add(Defects_Tab_Child.getInstance()); Defects_Tab_Child.getInstance().Dock = DockStyle.Fill; panelTabs_Holder.Controls.Add(Defects_Tab_Child2.getInstance()); Defects_Tab_Child2.getInstance().Dock = DockStyle.Fill; }
/// <summary> /// Navigate to Add Module view /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddNewModule_Click(object sender, EventArgs e) { Modules_Tab_Child.getInstance().BringToFront(); Modules_Tab_Child.getInstance().changeView(null, projectId, projectName); }