Esempio n. 1
0
        private void AddProject_Click(object sender, EventArgs e)
        {
            AddProject E5 = new AddProject();

            E5.Show();
            this.Hide();
        }
Esempio n. 2
0
        private void dataGridView1_CellContentClick_1(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 id = Convert.ToInt32(dataGridView1.Rows[currentRow].Cells[2].Value.ToString());

            if (currentColumnIndex == 0)
            {
                AddProject fe = new AddProject(id);
                fe.Show();
                this.Hide();
            }

            if (currentColumnIndex == 1)
            {
                var confirmResult = MessageBox.Show("Are you sure to delete this item ??",
                                                    "Confirm Delete!!",
                                                    MessageBoxButtons.YesNo);
                if (confirmResult == DialogResult.Yes)
                {
                    SqlCommand cmd1;
                    SqlCommand cmd2;
                    SqlCommand cmd3;
                    string     deleteproject    = "DELETE FROM Project Where Id = @num";
                    string     deleteprojectadv = "DELETE FROM ProjectAdvisor Where ProjectId = @num";
                    string     deletegrouppr    = "DELETE FROM GroupProject Where ProjectId = @num";
                    cmd1 = new SqlCommand(deleteproject, con);
                    cmd2 = new SqlCommand(deleteprojectadv, con);
                    cmd3 = new SqlCommand(deletegrouppr, con);
                    cmd1.Parameters.AddWithValue("@num", id);
                    cmd2.Parameters.AddWithValue("@num", id);
                    cmd3.Parameters.AddWithValue("@num", id);
                    cmd3.ExecuteNonQuery();
                    cmd2.ExecuteNonQuery();
                    cmd1.ExecuteNonQuery();
                    con.Close();
                    MessageBox.Show("Record deleted succesfully");
                    ManageProject fm = new ManageProject();
                    this.Close();
                    fm.Show();
                }
            }
        }