private void InsertProject_Click_1(object sender, EventArgs e)
{
AddProject form = new AddProject("", "", "add");
form.Show();
this.Hide();
}
private void Projects_CellClick_1(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == Projects.NewRowIndex || e.RowIndex < 0)
{
return;
}
if (e.ColumnIndex == Projects.Columns["ProjectDeleteButton"].Index)
{
int i = e.RowIndex;
String Title = Projects.Rows[i].Cells[0].Value.ToString();
string Description = Projects.Rows[i].Cells[1].Value.ToString();
string dialog = string.Format("Delete Project '{0}' and all its information?", Title);
DialogResult dialogResult = MessageBox.Show(dialog, "Delete Project", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
SqlConnection connection = new SqlConnection(connString);
connection.Open();
string getid = string.Format("SELECT Id FROM Project WHERE Title = '{0}' AND Description = '{1}'", Title, Description);
SqlCommand cmd = new SqlCommand(getid, connection);
int id = (Int32)cmd.ExecuteScalar();
string del = string.Format("DELETE FROM ProjectAdvisor WHERE ProjectId = '{0}'", id);
cmd.CommandText = del;
cmd.ExecuteNonQuery();
cmd.CommandText = string.Format("DELETE FROM GroupProject WHERE ProjectId = '{0}'", id);
cmd.ExecuteNonQuery();
string del0 = String.Format("DELETE FROM Project WHERE Title = '{0}' AND Description = '{1}'", Title, Description);
cmd.CommandText = del0;
cmd.ExecuteNonQuery();
Projects.Rows.RemoveAt(i);
MessageBox.Show("Project deleted successfully!");
connection.Close();
}
else if (dialogResult == DialogResult.No)
{
MessageBox.Show("Project not deleted!");
}
}
if (e.ColumnIndex == Projects.Columns["ProjectEditButton"].Index)
{
int i = e.RowIndex;
string Title = Projects.Rows[i].Cells[0].Value.ToString();
string Description = Projects.Rows[i].Cells[1].Value.ToString();
AddProject form = new AddProject(Title, Description, "edit");
form.Show();
this.Hide();
}
}