コード例 #1
0
        private void Cancel_Click(object sender, EventArgs e)
        {
            this.Hide();
            MarkEvaluationGroup datap = new MarkEvaluationGroup();

            datap.ShowDialog();
            this.Close();// close the form
        }
コード例 #2
0
 private void Cancel_Click(object sender, EventArgs e)
 {
     this.Hide();
     if (buffer > 0)
     {
         GroupProject gp = new GroupProject();
         gp.ShowDialog();
     }
     else
     {
         MarkEvaluationGroup mg = new MarkEvaluationGroup();
         mg.ShowDialog();
     }
     this.Close();
 }
コード例 #3
0
        private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(conURL);

            // connection opens
            con.Open();

            int ID = buffer;

            if (ID < 0)
            {
                try
                {
                    // here check whether boxes are empty for not
                    if (String.IsNullOrEmpty(comboBoxNames.Text) || String.IsNullOrEmpty(textBoxMarks.Text) || Convert.ToInt32(textBoxMarks.Text) < 0)
                    {
                        MessageBox.Show("Fill all boxes must and Marks should'nt be negative");
                    }
                    else
                    {
                        string     cmdText1 = "SELECT TotalMarks FROM Evaluation where Name = @Name";
                        SqlCommand c1       = new SqlCommand(cmdText1, con);
                        c1.Parameters.Add(new SqlParameter("@Name", comboBoxNames.Text));

                        SqlDataReader reader1 = c1.ExecuteReader();

                        while (reader1.Read())
                        {
                            if (Convert.ToInt32(reader1["TotalMarks"]) >= Convert.ToInt32(textBoxMarks.Text))
                            {
                                // command store in string then execute it by passing into sqlcommand object
                            }
                            else
                            {
                                throw new ArgumentNullException();
                            }
                        }
                        reader1.Close();
                        string cmdText = "INSERT INTO GroupEvaluation (GroupId, EvaluationId, ObtainedMarks , EvaluationDate) VALUES (@GroupId,(SELECT Id FROM Evaluation where Name = @Name), @ObtainedMarks, @EvaluationDate)";

                        SqlCommand c = new SqlCommand(cmdText, con);

                        c.Parameters.Add(new SqlParameter("@Name", comboBoxNames.Text));
                        c.Parameters.Add(new SqlParameter("@ObtainedMarks", textBoxMarks.Text));
                        c.Parameters.Add(new SqlParameter("@GroupId", MarkEvaluationGroup.groupId));

                        c.Parameters.Add(new SqlParameter("@EvaluationDate", DateTime.Now));

                        //execute it
                        int result = c.ExecuteNonQuery();
                        if (result < 0)
                        {
                            MessageBox.Show("Error");
                        }


                        // show dialog box if added in table of database
                        MessageBox.Show("Successfully Added!!");
                        con.Close();
                        this.Hide();
                        MarkEvaluationGroup datap = new MarkEvaluationGroup();
                        datap.ShowDialog();
                        this.Close(); // close the form
                    }
                }

                catch (Exception)
                {
                    MessageBox.Show("Enter Name in correct Format!!. Name should be from drop down list.. Obtained Marks should be less then total Marks");
                }
            }

            else
            {
                try
                {
                    // here check whether boxes are empty for not
                    if (String.IsNullOrEmpty(comboBoxNames.Text) || String.IsNullOrEmpty(textBoxMarks.Text) || Convert.ToInt32(textBoxMarks.Text) < 0)
                    {
                        MessageBox.Show("Fill all boxes must and Marks should'nt be negative");
                    }
                    // check all validations here
                    if (!String.IsNullOrEmpty(comboBoxNames.Text) && !String.IsNullOrEmpty(textBoxMarks.Text) && Convert.ToInt32(textBoxMarks.Text) >= 0)
                    {
                        string     cmdText1 = "SELECT TotalMarks FROM Evaluation where Name = @Name";
                        SqlCommand c1       = new SqlCommand(cmdText1, con);
                        c1.Parameters.Add(new SqlParameter("@Name", comboBoxNames.Text));

                        SqlDataReader reader1 = c1.ExecuteReader();

                        while (reader1.Read())
                        {
                            if (Convert.ToInt32(reader1["TotalMarks"]) >= Convert.ToInt32(textBoxMarks.Text))
                            {
                                // command store in string then execute it by passing into sqlcommand object
                            }
                            else
                            {
                                throw new ArgumentNullException();
                            }
                        }
                        reader1.Close();
                        string     cmdText2 = "Update GroupEvaluation SET EvaluationId = (SELECT Id FROM Evaluation where Name = @Name), ObtainedMarks = @ObtainedMarks WHERE EvaluationId = @EvaluationId AND GroupId = @GroupId";
                        SqlCommand c2       = new SqlCommand(cmdText2, con);
                        c2.Parameters.Add(new SqlParameter("@EvaluationId", ID));
                        c2.Parameters.Add(new SqlParameter("@GroupId", MarkEvaluationGroup.groupId));
                        c2.Parameters.Add(new SqlParameter("@Name", comboBoxNames.Text));
                        c2.Parameters.Add(new SqlParameter("@ObtainedMarks", textBoxMarks.Text));

                        c2.ExecuteNonQuery();
                        MessageBox.Show("Successfully Updated!!");
                        con.Close();
                        this.Hide();
                        MarkEvaluationGroup datap = new MarkEvaluationGroup();
                        datap.ShowDialog();
                        this.Close(); // close the form
                    }

                    else
                    {
                        throw new ArgumentNullException();
                    }
                }


                catch (Exception)
                {
                    MessageBox.Show("Enter Name in correct Format!!. Name should be from drop down list.. Obtained Marks should be less then total Marks");
                }
            }
        }
コード例 #4
0
        private void button3_Click(object sender, EventArgs e)
        {
            MarkEvaluationGroup eg = new MarkEvaluationGroup();

            eg.ShowDialog();
        }