// Function to add Student
public void AddRubricLevels()
{
int z = MyClass.rubricId;
String conURL1 = "Data Source = DESKTOP-RPO4Q5R\\PARVEEN; Initial Catalog = ProjectB ; User ID = mohsin; Password = mohsin123; MultipleActiveResultSets = True";
SqlConnection conn1 = new SqlConnection(conURL1);
conn1.Open();
String cmd1 = "insert into RubricLevel values ('" + z + "','" + richTextBox1.Text + "','" + comboBox1.Text + "')";
String cmd2 = "insert into RubricLevel values ('" + z + "','" + richTextBox2.Text + "','" + comboBox2.Text + "')";
String cmd3 = "insert into RubricLevel values ('" + z + "','" + richTextBox3.Text + "','" + comboBox3.Text + "')";
String cmd4 = "insert into RubricLevel values ('" + z + "','" + richTextBox4.Text + "','" + comboBox4.Text + "')";
SqlCommand cmd01 = new SqlCommand(cmd1, conn1);
SqlCommand cmd02 = new SqlCommand(cmd2, conn1);
SqlCommand cmd03 = new SqlCommand(cmd3, conn1);
SqlCommand cmd04 = new SqlCommand(cmd4, conn1);
int i = cmd01.ExecuteNonQuery();
cmd02.ExecuteNonQuery();
cmd03.ExecuteNonQuery();
cmd04.ExecuteNonQuery();
conn1.Close();
if (i != 0)
{
MessageBox.Show(i + "Record Has Been Saved");
}
frmRubricLevelDetail s1 = new frmRubricLevelDetail();
s1.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
frmRubricLevelDetail r1 = new frmRubricLevelDetail();
r1.Show();
this.Hide();
}
private void btnDetails_Click(object sender, EventArgs e)
{
frmRubricLevelDetail rubriclvl = new frmRubricLevelDetail();
rubriclvl.Show();
this.Hide();
}
private void btnEdit_Click(object sender, EventArgs e)
{
if (comboBox1.Text != "" && richTextBox1.Text != "")
{
SaveData();
frmRubricLevelDetail r1 = new frmRubricLevelDetail();
r1.Show();
this.Hide();
}
}
