예제 #1
0
        private void ShowData_Click(object sender, EventArgs e)
        {
            this.Hide();
            Advisor f4 = new Advisor();

            f4.ShowDialog();
            this.Close();
        }
예제 #2
0
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            con1.Open();

            int UP_Row      = int.Parse(e.RowIndex.ToString());
            int UP_RowIndex = int.Parse(e.ColumnIndex.ToString());

            ID1 = Convert.ToInt32(dataGridView1.Rows[UP_Row].Cells[0].Value.ToString());
            int dd = (int)dataGridView1.CurrentRow.Cells[0].Value;

            if (UP_RowIndex == 10)
            {
                if (UP_RowIndex == 1)
                {
                    if (UP_RowIndex == 0)
                    {
                        MessageBox.Show("lala");
                    }
                }
                if (UP_RowIndex != 0)
                {
                    var askfirst1 = MessageBox.Show("Are you sure you want to Update this?", "Update", MessageBoxButtons.YesNo);
                    if (askfirst1 == DialogResult.Yes)
                    {
                        Add_Advisor s = new Add_Advisor(dd);
                        ID = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
                        s.textBox2.Text        = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
                        s.textBox3.Text        = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
                        s.textBox4.Text        = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
                        s.textBox5.Text        = dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString();
                        s.dateTimePicker1.Text = dataGridView1.Rows[e.RowIndex].Cells[5].Value.ToString();
                        s.textBox1.Text        = dataGridView1.Rows[e.RowIndex].Cells[8].Value.ToString();
                        if (dataGridView1.Rows[e.RowIndex].Cells[6].Value.ToString() == "")
                        {
                            s.comboBox1.Text = "";
                        }
                        else if (Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[6].Value) == 1)
                        {
                            s.comboBox1.Text = "Male";
                        }
                        else if (Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[6].Value) == 2)
                        {
                            s.comboBox1.Text = "Female";
                        }
                        if (Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[7].Value) == 6)
                        {
                            s.comboBox2.Text = "Professor";
                        }
                        if (Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[7].Value) == 7)
                        {
                            s.comboBox2.Text = "Associate Professor";
                        }
                        if (Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[7].Value) == 8)
                        {
                            s.comboBox2.Text = "Assisstant Professor";
                        }
                        if (Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[7].Value) == 9)
                        {
                            s.comboBox2.Text = "Lecturer";
                        }
                        if (Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[7].Value) == 10)
                        {
                            s.comboBox2.Text = "Industry Professional";
                        }
                        s.ShowDialog();
                        con1.Close();
                    }
                    else
                    {
                        con1.Close();
                        this.Hide();
                        Advisor f2 = new Advisor();
                        f2.ShowDialog();
                        DisplayAdvisor();
                    }
                }
            }
            else if (UP_RowIndex == 9)
            {
                int URow      = int.Parse(e.RowIndex.ToString());
                int URowIndex = int.Parse(e.ColumnIndex.ToString());
                ID = Convert.ToInt32(dataGridView1.Rows[URow].Cells[0].Value.ToString());

                if (URowIndex == 0)
                {
                    MessageBox.Show("Click on Delete Again");
                }
                if (URowIndex != 0)
                {
                    var askfirst = MessageBox.Show("Are you sure you want to delete this?", "Delete", MessageBoxButtons.YesNo);
                    if (askfirst == DialogResult.Yes)
                    {
                        cmd1 = new SqlCommand("DELETE FROM Person where ID = @Id", con1);
                        cmd2 = new SqlCommand("DELETE FROM Advisor where ID = @Id", con1);
                        cmd2.Parameters.AddWithValue("@Id", ID);
                        cmd1.Parameters.AddWithValue("@Id", ID);
                        cmd2.ExecuteNonQuery();
                        cmd1.ExecuteNonQuery();

                        con1.Close();
                        MessageBox.Show("Deleted Succesfully");

                        this.Hide();
                        Advisor f2 = new Advisor();
                        f2.ShowDialog();
                        this.Close();
                    }
                    else
                    {
                        con1.Close();
                        this.Hide();
                        Advisor f2 = new Advisor();
                        f2.ShowDialog();
                        DisplayAdvisor();
                    }
                }
            }
            else
            {
                con1.Close();
            }
        }