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);
}
}
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];
}
;
}
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;
}
private void ListBoxProjects_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = StudentProjectController.getStudentScore(this.ListBoxProjects.SelectedValue.ToString()).Tables[0];
}
