private void InsertProjectAdvsior_Click_1(object sender, EventArgs e) { AssignAdvisorToProject form = new AssignAdvisorToProject(null, null, null, "add"); form.Show(); this.Close(); }
private void ProjectAdvisorsGrid_CellClick_1(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex == ProjectAdvisorsGrid.NewRowIndex || e.RowIndex < 0) { return; } if (e.ColumnIndex == ProjectAdvisorsGrid.Columns["AdvisorUnAssignButton"].Index) { int i = e.RowIndex; string Ptitle = ProjectAdvisorsGrid.Rows[i].Cells[0].Value.ToString(); string dialog = string.Format("Remove Advisor '{0}' from project {1}?", ProjectAdvisorsGrid.Rows[i].Cells[1].Value.ToString(), Ptitle); DialogResult dialogResult = MessageBox.Show(dialog, "Remove Advisor", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { string query = string.Format("SELECT Advisor.Id FROM Advisor JOIN Person ON Advisor.Id = Person.Id " + "WHERE CONCAT(FirstName,' ', LastName) = '{0}'", ProjectAdvisorsGrid.Rows[i].Cells[1].Value.ToString()); SqlConnection con = new SqlConnection(connString); con.Open(); SqlCommand cmd = new SqlCommand(query, con); int Aid = (Int32)cmd.ExecuteScalar(); cmd.CommandText = string.Format("SELECT Id FROM Project WHERE Title = '{0}'", Ptitle); int pid = (Int32)cmd.ExecuteScalar(); cmd.CommandText = string.Format("DELETE FROM ProjectAdvisor WHERE AdvisorId = '{0}'AND ProjectId = '{1}'", Aid, pid); cmd.ExecuteNonQuery(); ProjectAdvisorsGrid.Rows.RemoveAt(i); MessageBox.Show(String.Format("Advisor removed from the project {0}!", Ptitle)); con.Close(); } else { MessageBox.Show(String.Format("Advisor not removed from the project {0}!", Ptitle)); } } else if (e.ColumnIndex == ProjectAdvisorsGrid.Columns["AdvisorEditButton"].Index) { int i = e.RowIndex; string Ptitle = ProjectAdvisorsGrid.Rows[i].Cells[0].Value.ToString(); string aName = ProjectAdvisorsGrid.Rows[i].Cells[1].Value.ToString(); string aRole = ProjectAdvisorsGrid.Rows[i].Cells[2].Value.ToString(); AssignAdvisorToProject form = new AssignAdvisorToProject(Ptitle, aName, aRole, "edit"); form.Show(); this.Close(); } }