private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SqlConnection con = new SqlConnection(conURL);
con.Open();
int currentRow = int.Parse(e.RowIndex.ToString());
int currentColumnIndex = int.Parse(e.ColumnIndex.ToString());
string advemail = dataGridView1.Rows[currentRow].Cells[4].Value.ToString();
if (currentColumnIndex == 0)
{
var confirmResult = MessageBox.Show("Are you sure to delete this item ??",
"Confirm Delete!!",
MessageBoxButtons.YesNo);
if (confirmResult == DialogResult.Yes)
{
string delete = "DELETE FROM ProjectAdvisor Where AdvisorId = @val1 AND ProjectId = @val2";
SqlCommand cmd = new SqlCommand(delete, con);
string email = string.Format("SELECT Id FROM Person WHERE Email = '{0}'", advemail);
SqlCommand cmd1 = new SqlCommand(email, con);
int advid = (Int32)cmd1.ExecuteScalar();
cmd.Parameters.AddWithValue("@val1", advid);
cmd.Parameters.AddWithValue("@val2", flag);
cmd.ExecuteNonQuery();
MessageBox.Show("Record deleted succesfully");
ManageProjectAdvisors_2 form = new ManageProjectAdvisors_2(flag);
this.Close();
form.Show();
}
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
SqlConnection con = new SqlConnection(conURL);
con.Open();
int currentRow = int.Parse(e.RowIndex.ToString());
int currentColumnIndex = int.Parse(e.ColumnIndex.ToString());
int prid = Convert.ToInt32(dataGridView1.Rows[currentRow].Cells[2].Value.ToString());
if (currentColumnIndex == 0)
{
ManageProjectAdvisors_1 form = new ManageProjectAdvisors_1(prid);
this.Close();
form.Show();
}
if (currentColumnIndex == 1)
{
ManageProjectAdvisors_2 form1 = new ManageProjectAdvisors_2(prid);
this.Close();
form1.Show();
}
}