Example #1
0
        private void Manage_Group_Evaluation_Click(object sender, EventArgs e)
        {
            this.Hide();
            ManageEvaluation f1 = new ManageEvaluation();

            f1.ShowDialog();
            this.Close();
        }
Example #2
0
        private void Back_Click(object sender, EventArgs e)
        {
            con1.Close();
            this.Hide();
            ManageEvaluation f2 = new ManageEvaluation();

            f2.ShowDialog();
        }
Example #3
0
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            con.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 == 4)
            {
                if (UP_RowIndex == 1)
                {
                    if (UP_RowIndex == 0)
                    {
                        MessageBox.Show("Click Again");
                    }
                }
                if (UP_RowIndex != 0)
                {
                    var askfirst1 = MessageBox.Show("Are you sure you want to add this Evaluation Id?", "Add", MessageBoxButtons.YesNo);
                    if (askfirst1 == DialogResult.Yes)
                    {
                        FromGroupStudent t = new FromGroupStudent();
                        ManageEvaluation s = new ManageEvaluation(dd);
                        ID = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString());
                        //s.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
                        s.textBox1.Text = t.Flags.ToString();
                        s.Flagg2        = 0;
                        s.ShowDialog();
                        con.Close();
                        this.Close();
                    }
                    else
                    {
                        con.Close();
                        this.Hide();
                        FromEvaluation f2 = new FromEvaluation();
                        f2.ShowDialog();
                    }
                }
            }
            else
            {
                MessageBox.Show("Click on add button");
            }
        }
Example #4
0
        private void Insert_Click(object sender, EventArgs e)
        {
            bool a = G_Id();

            if (a == false)
            {
                bool b = P_Id();
                if (b == false)
                {
                    bool d = Group_Exists(Convert.ToInt32(textBox1.Text), Convert.ToInt32(comboBox1.Text));
                    if (d == false)
                    {
                        if (Flagg2 == 0)
                        {
                            con.Open();
                            DateTime time = DateTime.Now;
                            cmd2 = new SqlCommand("insert into [GroupProject]([GroupId], ProjectId, AssignmentDate) values ('" + textBox1.Text + "','" + comboBox1.Text + "', @time)", con);
                            cmd2.Parameters.AddWithValue("@time", time);
                            cmd2.ExecuteNonQuery();
                            MessageBox.Show("Inserted Successfully");
                            con.Close();
                            this.Hide();
                            ManageGroupProject f4 = new ManageGroupProject();
                            f4.ShowDialog();
                            this.Close();
                        }

                        if (Flagg2 > 0)
                        {
                            con.Open();
                            DateTime time = DateTime.Now;
                            cmd2 = new SqlCommand("UPDATE [GroupProject] set GroupId = @GroupId, ProjectId = @ProjectId, AssignmentDate = @AssignmentDate WHERE GroupId = @d1 AND [ProjectId] = @d2", con);
                            cmd2.Parameters.AddWithValue("@d1", Flagg2);
                            cmd2.Parameters.AddWithValue("@d2", ID1);
                            cmd2.Parameters.AddWithValue("@GroupId", Convert.ToInt32(textBox1.Text));
                            cmd2.Parameters.AddWithValue("@ProjectId", Convert.ToInt32(comboBox1.Text));
                            cmd2.Parameters.AddWithValue("@AssignmentDate", time);
                            cmd2.ExecuteNonQuery();
                            MessageBox.Show("Updated Successfully");
                            con.Close();
                            this.Hide();
                            ManageGroupProject f4 = new ManageGroupProject();
                            f4.ShowDialog();
                            this.Close();
                        }
                    }
                    else
                    {
                        MessageBox.Show("This Project Id is already assigned to this group");
                    }
                    if (Flagg2 > 0)
                    {
                        con.Open();
                        DateTime time = DateTime.Now;
                        cmd2 = new SqlCommand("UPDATE GroupEvaluation SET GroupId = @GroupId, EvaluationId = @EvaluationId, ObtainedMarks = @ObtainedMarks, EvaluationDate = @EvaluationDate WHERE GroupId = @d1 AND EvaluationId = @d2", con);
                        cmd2.Parameters.AddWithValue("@d1", Flagg2);
                        cmd2.Parameters.AddWithValue("@d2", ID1);
                        cmd2.Parameters.AddWithValue("@GroupId", Convert.ToInt32(textBox1.Text));
                        cmd2.Parameters.AddWithValue("@EvaluationId", Convert.ToInt32(comboBox1.Text));

                        cmd2.Parameters.AddWithValue("@EvaluationDate", time);
                        cmd2.ExecuteNonQuery();
                        MessageBox.Show("Updated successfully Successfully");
                        con.Close();
                        this.Hide();
                        ManageEvaluation f4 = new ManageEvaluation();
                        f4.ShowDialog();
                        this.Close();
                    }
                }
                else
                {
                    MessageBox.Show("Select Evaluation Id");
                }
            }
            else
            {
                MessageBox.Show("Add Group");
            }
        }
Example #5
0
        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            con.Open();
            int URow      = int.Parse(e.RowIndex.ToString());
            int URowIndex = int.Parse(e.ColumnIndex.ToString());

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

            if (URowIndex == 5)
            {
                int d1 = (int)dataGridView1.CurrentRow.Cells[0].Value;
                if (URowIndex == 0)
                {
                    MessageBox.Show("Click again");
                    con.Close();
                }
                if (URowIndex != 0)
                {
                    var askfirst1 = MessageBox.Show("Are you sure you want to Update this?", "Update", MessageBoxButtons.YesNo);
                    if (askfirst1 == DialogResult.Yes)
                    {
                        Flagg2         = ID;
                        textBox1.Text  = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
                        comboBox1.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
                        textBox3.Text  = dataGridView1.Rows[e.RowIndex].Cells[3].Value.ToString();
                        con.Close();
                    }
                    else
                    {
                        Flagg2 = 0;
                        con.Close();
                        this.Hide();
                        ManageEvaluation f2 = new ManageEvaluation();
                        f2.ShowDialog();
                    }
                }
            }
            else if (URowIndex == 6)
            {
                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 [GroupEvaluation] WHERE GroupId = @d1 AND EvaluationId = @d2", con);
                        cmd1.Parameters.AddWithValue("@d1", ID);
                        cmd1.Parameters.AddWithValue("@d2", ID1);
                        cmd1.ExecuteNonQuery();

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

                        this.Hide();
                        ManageEvaluation f2 = new ManageEvaluation();
                        f2.ShowDialog();
                        this.Close();
                    }
                    else
                    {
                        con.Close();
                        this.Hide();
                        ManageEvaluation f2 = new ManageEvaluation();
                        f2.ShowDialog();
                    }
                }
                else
                {
                    Flagg2 = 0;
                    con.Close();
                }
            }
        }