private void btn_submit_Click(object sender, EventArgs e)
{
if (txt_name.Text != "" && txt_marks.Text != "" && cmb_clo.Text != "" && cmb_rubric.Text != "")
{
SqlConnection conn = new SqlConnection("Data Source=DESKTOP-M9PBVHQ;Initial Catalog=ProjectB;Integrated Security=True");
if (update == 1)
{
if (cmb_assessID.Text != "")
{
conn.Open();
string RubricID = (cmb_rubric.SelectedItem as ComboboxItem).Value.ToString();
string Assess_id = (cmb_assessID.SelectedItem as ComboboxItem).Value.ToString();
string query2 = "Update AssessmentComponent set Name = '" + txt_name.Text + " ', RubricId = '" + RubricID + " ', TotalMarks = '" + txt_marks.Text + " ' , DateCreated = '" + this.date + " ' , DateUpdated = '" + DateTime.Today + " ', AssessmentId = '" + Assess_id + " ' where Id = '" + this.id + "'";
SqlCommand update_command = new SqlCommand(query2, conn);
int j = update_command.ExecuteNonQuery();
if (j != 0)
{
MessageBox.Show("Component Record Updated Successfully");
assessment_comp ff = new assessment_comp();
ff.Close();
assess_comp_detail ss = new assess_comp_detail(assess_id);
ss.Show();
this.Hide();
}
conn.Close();
}
else
{
error_msg.Show();
}
}
else
{
cmb_assessID.Hide();
conn.Open();
string RubricId = (cmb_rubric.SelectedItem as ComboboxItem).Value.ToString();
string query = "Insert into AssessmentComponent (Name,RubricId,TotalMarks,DateCreated,DateUpdated,AssessmentId) values('" + txt_name.Text + "','" + RubricId + "','" + txt_marks.Text + "', '" + DateTime.Today + "','" + DateTime.Today + "', '" + this.assess_id + "')";
SqlCommand command = new SqlCommand(query, conn);
int i = command.ExecuteNonQuery();
if (i != 0)
{
MessageBox.Show("Assessment Component Record Inserted Successfully");
assessment_comp f = new assessment_comp();
f.Close();
assess_comp_detail s = new assess_comp_detail(assess_id);
this.Hide();
s.Show();
}
conn.Close();
}
}
else
{
error_msg.Show();
}
}
