private void GroupStudentDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            int currentRow        = int.Parse(e.RowIndex.ToString());
            int curentcolumnindex = int.Parse(e.ColumnIndex.ToString());
            int sid = Convert.ToInt32(GroupStudentDataGridView.Rows[currentRow].Cells[1].Value);

            if (curentcolumnindex == 0)
            {
                SqlConnection conn = new SqlConnection(conURL);
                conn.Open();
                String     UpdateCMD     = "UPDATE GroupStudent SET Status = @status WHERE GroupStudent.StudentId = @sid";
                SqlCommand UpdateCommand = new SqlCommand(UpdateCMD, conn);
                UpdateCommand.Parameters.Add(new SqlParameter("status", 4));
                UpdateCommand.Parameters.Add(new SqlParameter("sid", sid));
                int count = UpdateCommand.ExecuteNonQuery();

                String     AddCMD     = "INSERT INTO GroupStudent (GroupId, StudentId, Status, AssignmentDate) VALUES (@gid, @sid, @status, @asgnDate)";
                SqlCommand AddCommand = new SqlCommand(AddCMD, conn);

                AddCommand.Parameters.Add(new SqlParameter("status", 3));
                AddCommand.Parameters.Add(new SqlParameter("sid", sid));
                AddCommand.Parameters.Add(new SqlParameter("gid", groupId));
                AddCommand.Parameters.Add(new SqlParameter("asgnDate", DateTime.Today));

                count = AddCommand.ExecuteNonQuery();
                AddStudentGroup form = new AddStudentGroup(Convert.ToInt32(groupId));
                form.Show();
                this.Hide();
            }
        }
        private void StdGroupDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            int    currentRow        = int.Parse(e.RowIndex.ToString());
            int    curentcolumnindex = int.Parse(e.ColumnIndex.ToString());
            string gid = StdGroupDataGridView.Rows[currentRow].Cells[0].Value.ToString();

            if (curentcolumnindex == 2)
            {
                AddStudentGroup form = new AddStudentGroup(Convert.ToInt32(gid));
                form.Show();
                this.Hide();
            }
            if (curentcolumnindex == 3)
            {
                ViewGroupStudents form = new ViewGroupStudents(Convert.ToInt32(gid));
                form.Show();
                this.Hide();
            }
            if (curentcolumnindex == 4)
            {
                AddEvaluationGroup form = new AddEvaluationGroup(Convert.ToInt32(gid));
                form.Show();
                this.Hide();
            }
            if (curentcolumnindex == 5)
            {
                ViewGroupEvaluation form = new ViewGroupEvaluation(Convert.ToInt32(gid));
                form.Show();
                this.Hide();
            }
            if (curentcolumnindex == 6)
            {
                AddGroupProject form = new AddGroupProject(Convert.ToInt32(gid));
                form.Show();
                this.Hide();
            }
            if (curentcolumnindex == 7)
            {
                ViewGroupProject form = new ViewGroupProject(Convert.ToInt32(gid));
                form.Show();
                this.Hide();
            }

            if (curentcolumnindex == 8)
            {
                SqlConnection conn = new SqlConnection(conURL);
                conn.Open();
                String     DeleteCMD     = "DELETE FROM GroupStudent WHERE GroupStudent.GroupId = @id";
                SqlCommand DeleteCommand = new SqlCommand(DeleteCMD, conn);
                DeleteCommand.Parameters.Add(new SqlParameter("id", Convert.ToInt32(gid)));
                int count = DeleteCommand.ExecuteNonQuery();

                String     DeleteCMD2     = "DELETE FROM GroupEvaluation WHERE GroupEvaluation.GroupId = @id";
                SqlCommand DeleteCommand2 = new SqlCommand(DeleteCMD2, conn);
                DeleteCommand2.Parameters.Add(new SqlParameter("id", Convert.ToInt32(gid)));
                count = DeleteCommand2.ExecuteNonQuery();

                String     DeleteCMD3     = "DELETE FROM GroupProject WHERE GroupProject.GroupId = @id";
                SqlCommand DeleteCommand3 = new SqlCommand(DeleteCMD3, conn);
                DeleteCommand3.Parameters.Add(new SqlParameter("id", Convert.ToInt32(gid)));
                count = DeleteCommand3.ExecuteNonQuery();

                String     DeleteCMD4     = "DELETE FROM [Group] WHERE [Group].Id = @id";
                SqlCommand DeleteCommand4 = new SqlCommand(DeleteCMD4, conn);
                DeleteCommand4.Parameters.Add(new SqlParameter("id", Convert.ToInt32(gid)));
                count = DeleteCommand4.ExecuteNonQuery();

                GroupStudent form = new GroupStudent();
                form.Show();
                this.Hide();
            }
        }