private void button1_Click(object sender, EventArgs e) { AddRubric s = new AddRubric(); this.Hide(); s.Show(); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "Edit") { Class1.id = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value); this.Hide(); AddRubric registerStudent = new AddRubric(); registerStudent.Show(); } if (dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString() == "Delete") { int stdId = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[0].Value); if (MessageBox.Show("Do you want to delete " + dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString() + "?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { con.Open(); SqlCommand command = new SqlCommand("DELETE FROM Rubric WHERE Id = '" + stdId + "'", con); command.ExecuteNonQuery(); con.Close(); this.rubricTableAdapter.Fill(this.projectBDataSet.Rubric); } } }
/// <summary> /// This fn. is also in two parts. It also do two things one is that ifthe /// btn text is add than it adds the dta to the rubric table and if it /// is ipdate it updates the data. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void button1_Click(object sender, EventArgs e) { SqlConnection connection = new SqlConnection(constring); bool flag = false; if (button1.Text == "Add Rubric") { if (txtDetails.Text == "") { MessageBox.Show("Rubric details cannot be null"); flag = true; } if (comboCloNo.Text == "") { MessageBox.Show("CLOID cannot be null"); flag = true; } if (txtRubricId.Text == "") { MessageBox.Show("Rubric ID cannot be null"); flag = true; } bool isExist = false; string query2 = "SELECT CloId, COUNT(CloId) FROM Rubric GROUP BY CloId HAVING COUNT(CloId) >= 4"; SqlCommand cmd1 = new SqlCommand(query2, connection); connection.Open(); SqlDataReader reader = cmd1.ExecuteReader(); while (reader.Read()) { int id = Convert.ToInt32(comboCloNo.Text); if (id == Convert.ToInt32(comboCloNo.Text)) { isExist = true; MessageBox.Show("More than 4 rubrics can't be added against 1 Clo"); break; } } connection.Close(); bool isExist1 = false; string query3 = "SELECT Id FROM Rubric"; SqlCommand cmd2 = new SqlCommand(query3, connection); connection.Open(); SqlDataReader reader1 = cmd2.ExecuteReader(); while (reader1.Read()) { int id = Convert.ToInt32(txtRubricId.Text); if (id == Convert.ToInt32(txtRubricId.Text)) { isExist1 = true; MessageBox.Show("Rubric Id should be Unique;"); break; } } connection.Close(); if (isExist == false && isExist1 == false && flag == false) { string qeury = "insert into dbo.Rubric(Id, Details,CloId) values('" + this.txtRubricId.Text + "','" + txtDetails.Text + "','" + this.comboCloNo.Text + "')"; SqlConnection conDataBase = new SqlConnection(constring); SqlCommand cmdDataBase = new SqlCommand(qeury, conDataBase); SqlDataReader myreader; conDataBase.Open(); myreader = cmdDataBase.ExecuteReader(); MessageBox.Show("Rubric has been Saved"); txtRubricId.Text = ""; txtDetails.Text = ""; comboCloNo.Text = ""; while (myreader.Read()) { } using (SqlConnection sqlcon = new SqlConnection(constring)) { sqlcon.Open(); SqlDataAdapter sqlDA = new SqlDataAdapter("Select * from dbo.Rubric", sqlcon); DataTable dtbl = new DataTable(); sqlDA.Fill(dtbl); dataRubric.DataSource = dtbl; } AddRubric.Hide(); tab2.Show(); } } if (button1.Text == "Update") { connection.Open(); string Qeury = "Update dbo.Rubric Set Id ='" + txtRubricId.Text + "',Details='" + txtDetails.Text + "',CLoId='" + comboCloNo.Text + "' Where Id ='" + id + "' "; SqlCommand cmd = new SqlCommand(Qeury, connection); cmd.ExecuteNonQuery(); MessageBox.Show("Rubric is Updated"); button1.Text = "Add Rubric"; txtRubricId.Text = ""; txtDetails.Text = ""; comboCloNo.Text = ""; AddRubric.Hide(); tab2.Show(); using (SqlConnection sqlcon = new SqlConnection(constring)) { sqlcon.Open(); SqlDataAdapter sqlDA = new SqlDataAdapter("Select * from dbo.Rubric", sqlcon); DataTable dtbl = new DataTable(); sqlDA.Fill(dtbl); dataRubric.DataSource = dtbl; } } }
private void dataRubric_CellContentClick(object sender, DataGridViewCellEventArgs e) { SqlConnection connection = new SqlConnection(constring); connection.Open(); if (e.ColumnIndex == dataRubric.Columns["Delete"].Index) { try { int[] rubric_level = new int[4]; int j = 0; int[] assessment_componenT = new int[100]; int row = e.RowIndex; id = Convert.ToInt32(dataRubric.Rows[e.RowIndex].Cells[0].Value); String d = "SELECT Id FROM dbo.RubricLevel where RubricId ='" + id + "'"; SqlCommand com1 = new SqlCommand(d, connection); com1.Parameters.Add(new SqlParameter("0", 1)); SqlDataReader r2 = com1.ExecuteReader(); while (r2.Read()) { rubric_level[j] = Convert.ToInt32(r2[0]); j++; } r2.Close(); int s = rubric_level[0]; int v = rubric_level[1]; String del = "SELECT Id FROM dbo.AssessmentComponent where RubricId ='" + id + "'"; SqlCommand com11 = new SqlCommand(del, connection); com11.Parameters.Add(new SqlParameter("0", 1)); SqlDataReader r3 = com11.ExecuteReader(); while (r3.Read()) { assessment_componenT[j] = Convert.ToInt32(r3[0]); j++; } r3.Close(); int s1 = assessment_componenT[1]; int s2 = assessment_componenT[0]; int s3 = assessment_componenT[2]; foreach (int a in rubric_level) { int delete = a; string Qeury0 = "Delete from dbo.StudentResult where RubricMeasurementId = '" + a + "'"; SqlCommand cmd0 = new SqlCommand(Qeury0, connection); cmd0.ExecuteNonQuery(); } foreach (int a in assessment_componenT) { int delete = a; string Qeury1 = "Delete from dbo.StudentResult where AssessmentComponentId = '" + a + "'"; SqlCommand cmd1 = new SqlCommand(Qeury1, connection); cmd1.ExecuteNonQuery(); } string Qeury2 = "Delete from dbo.RubricLevel where RubricId = '" + id + "'"; SqlCommand cmd3 = new SqlCommand(Qeury2, connection); cmd3.ExecuteNonQuery(); string Qeury4 = "Delete from dbo.AssessmentComponent where RubricId = '" + id + "'"; SqlCommand cmd4 = new SqlCommand(Qeury4, connection); cmd4.ExecuteNonQuery(); string qeury5 = "Delete from dbo.Rubric where Id = '" + id + "'"; SqlCommand cmd5 = new SqlCommand(qeury5, connection); cmd5.ExecuteNonQuery(); MessageBox.Show("Rubric Deleted"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } if (e.ColumnIndex == dataRubric.Columns["edit"].Index) { string temp = dataRubric.Rows[e.RowIndex].Cells[0].FormattedValue.ToString(); id = Convert.ToInt32(temp); txtRubricId.Text = dataRubric.Rows[e.RowIndex].Cells[0].FormattedValue.ToString(); comboCloNo.Text = dataRubric.Rows[e.RowIndex].Cells[2].FormattedValue.ToString(); txtDetails.Text = dataRubric.Rows[e.RowIndex].Cells[1].FormattedValue.ToString(); button1.Text = "Update"; tab2.Hide(); AddRubric.Show(); } }