public bool insertSCORE(DTO_Score score)
{
try {
SqlCommand command = new SqlCommand("INSERT INTO Score ( student_id, course_id, student_score ,description)" +
"VALUES ( @student_id, @course_id, @student_score, @description)", this.getConnection);
command.Parameters.Add("@student_id", SqlDbType.Int).Value = score.idStudent;
command.Parameters.Add("@course_id", SqlDbType.Int).Value = score.idCourse;
command.Parameters.Add("@student_score", SqlDbType.Float).Value = score.Score;
command.Parameters.Add("@description", SqlDbType.VarChar).Value = score.desciption;
this.openConnection();
if (command.ExecuteNonQuery() == 1)
{
this.closeConnection();
return(true);
}
else
{
this.closeConnection();
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
private void buttonSave_Click(object sender, EventArgs e)
{
string label = this.datagridSelected.CurrentRow.Cells[0].Value.ToString();
int id_cou = int.Parse(this.BUScourse.getCOURSELabel(label, int.Parse(this.comboSem.Value.ToString())).Rows[0][0].ToString());
int id_stu = int.Parse(this.txtStudentId.Text);
DTO_Score score = new DTO_Score(id_stu, id_cou, 0, "nothing");
if (this.BUSscore.insertSCORE(score))
{
MessageBox.Show("success");
if (this.BUScourse.getCOURSELabelStudent(id_stu, int.Parse(this.comboSem.Value.ToString())) != null)
{
this.datagridSelected.DataSource = this.BUScourse.getCOURSELabelStudent(id_stu, int.Parse(this.comboSem.Value.ToString()));
}
}
else
{
MessageBox.Show("unsuccess");
}
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (this.txtID.Text == "" || this.txtScore.Text == "" || this.txtDescription.Text == "" || this.comboCourse.SelectedItem == "")
{
MessageBox.Show("Field Emty", "Edit Score", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
int student_id = int.Parse(txtID.Text);
int course_id = int.Parse(this.comboCourse.SelectedValue.ToString());
string descrip = txtDescription.Text;
int scoreStudenbt = int.Parse(this.txtScore.Text);
try
{
int id = Convert.ToInt32(txtID.Text);
DTO_Score score = new DTO_Score(student_id, course_id, scoreStudenbt, descrip);
if (scoreStudenbt < 0 || scoreStudenbt > 10)
{
MessageBox.Show("Score error", "Edit Score", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (BUSScore.updateCOURSE(score) == true)
{
MessageBox.Show("score informationg Updated", "Edit Score", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Edit Error", "Edit Score", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Edit Score", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
int idStudent = int.Parse(txtID.Text);
int idCourse = int.Parse(comboCourse.SelectedValue.ToString());
float score = float.Parse(txtScore.Text);
string desciption = txtDescription.Text;
if (score >= 0 && score <= 10)
{
if (BUSScore.getSCOREAStudent(idStudent, idCourse).Rows.Count == 0)
{
DTO_Score Score = new DTO_Score(idStudent, idCourse, score, desciption);
if (BUSScore.insertSCORE(Score))
{
MessageBox.Show("Student score inserted");
}
else
{
MessageBox.Show("Student score is not inserted");
}
}
else
{
MessageBox.Show("Student score is exited" + BUSScore.getSCOREAStudent(idStudent, idCourse).Rows.Count);
}
}
else
{
MessageBox.Show("Score is not correct");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public bool updateCOURSE(DTO_Score score)
{
try { SqlCommand command = new SqlCommand("UPDATE Score SET student_score =@student_score ,description = @description WHERE student_id = @student_id and course_id = @course_id", this.getConnection);
command.Parameters.Add("@student_id", SqlDbType.Int).Value = score.idStudent;
command.Parameters.Add("@course_id", SqlDbType.Int).Value = score.idCourse;
command.Parameters.Add("@student_score", SqlDbType.Float).Value = score.Score;
command.Parameters.Add("@description", SqlDbType.VarChar).Value = score.desciption;
this.openConnection();
if (command.ExecuteNonQuery() == 1)
{
this.closeConnection();
return(true);
}
else
{
this.closeConnection();
return(false);
} }
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
public bool updateCOURSE(DTO_Score score)
{
return(scoreDAL.updateCOURSE(score));
}
public bool insertSCORE(DTO_Score score)
{
return(scoreDAL.insertSCORE(score));
}
