Пример #1
0
        private void btnAssess_Click(object sender, EventArgs e)
        {
            try
            {
                string ID         = this.txtID.Text;
                string courseID   = this.cbbCourse.SelectedValue.ToString();
                double scoreValue = Convert.ToDouble(txtScore.Text);
                string comment    = this.txtComment.Text;
                if (score.insertScore(ID, courseID, scoreValue, comment))
                {
                    MessageBox.Show("Student Score Inserted", "Add Score", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("Student Score Not Inserted", "Add Score", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }

                BindingSource bs = new BindingSource();
                DataTable     dt = StudentProjectController.FillDataSetProject(this.txtID.Text.ToString()).Tables[0];
                bs.DataSource = dt;
                this.dataSearchID.DataSource = bs;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "Add Score", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
Пример #2
0
        private void btnSearch_Click(object sender, EventArgs e)
        {
            BindingSource bs    = new BindingSource();
            Score         score = new Score();

            if (score.createScoreTable() == false)
            {
                DataTable dt = StudentProjectController.FillDataSetProject(this.txtID.Text.ToString()).Tables[0];
                bs.DataSource = dt;
                this.dataSearchID.DataSource = bs;

                dt = StudentController.FillDataSet_getStudentById(this.txtID.Text).Tables[0];

                foreach (DataRow row in dt.Rows)
                {
                    this.label5.Text  = "Name:  " + row[1].ToString();
                    this.label6.Text  = "Email: " + row[6].ToString();
                    this.label7.Text  = "Phone: " + row[7].ToString();
                    this.label8.Text  = "Gender: " + row[4].ToString();
                    this.label9.Text  = "BirthDay: " + DateTime.ParseExact(row[3].ToString(), "dd-MMM-yy hh:mm:ss tt", CultureInfo.InvariantCulture).ToString("dd-MM-yyyy"); //"dd-MM-yyyy"
                    this.label10.Text = "Class: " + row[5].ToString();
                }
                this.cbbCourse.DisplayMember = "PName";
                this.cbbCourse.ValueMember   = "PID";
                this.cbbCourse.DataSource    = StudentProjectController.getInfoProjectName(this.txtID.Text.ToString()).Tables[0];
            }
            ;
        }
Пример #3
0
 private void PrintScoreForm_Load(object sender, EventArgs e)
 {
     dataGridView1.DataSource           = StudentProjectController.getStudentScore().Tables[0];
     this.ListBoxProjects.DisplayMember = "PName";
     this.ListBoxProjects.ValueMember   = "PID";
     ListBoxProjects.DataSource         = StudentProjectController.getProjectName().Tables[0];
     dataGridView1.RowTemplate.Height   = 80;
 }
Пример #4
0
 private void ListBoxProjects_Click(object sender, EventArgs e)
 {
     dataGridView1.DataSource = StudentProjectController.getStudentScore(this.ListBoxProjects.SelectedValue.ToString()).Tables[0];
 }