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();
}
}
