private void btnAddRubricLevel_Click(object sender, EventArgs e)
{
if (btnAddRubricLevel.Text == "Add Rubric Level")
{
bool IsCorrectNumber = false;
IsCorrectNumber = isDigit(txtMeasurementLevel.Text);
if (IsCorrectNumber == true)
{
conn.Open();
String cmd = String.Format("INSERT INTO RubricLevel(RubricId, Details, MeasurementLevel) values('{0}','{1}','{2}')", Convert.ToInt32(cmbRubricID.Text), txtDetails.Text, Convert.ToInt32(txtMeasurementLevel.Text));
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("0", 1));
SqlDataReader reader = command.ExecuteReader();
MessageBox.Show("Added Successfully");
txtDetails.Text = "";
txtMeasurementLevel.Text = "";
cmbRubricID.Text = "";
conn.Close();
}
}
else
{
if (isDigit(txtMeasurementLevel.Text))
{
conn.Open();
int RubriciD = Convert.ToInt32(cmbRubricID.Text);
string Detail = txtDetails.Text;
int MeasurementLevel = Convert.ToInt32(txtMeasurementLevel.Text);
string cmd = String.Format("UPDATE RubricLevel SET RubricId = @RubricID, Details = @Detail, MeasurementLevel = @level WHERE Id = @ID");
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@Detail", Detail));
command.Parameters.Add(new SqlParameter("@RubricID", RubriciD));
command.Parameters.Add(new SqlParameter("@level", MeasurementLevel));
command.Parameters.Add(new SqlParameter("Id", Convert.ToInt32(lblHide.Text)));
SqlDataReader reader = command.ExecuteReader();
txtDetails.Text = "";
txtMeasurementLevel.Text = "";
cmbRubricID.Text = "";
conn.Close();
btnAddRubricLevel.Text = "Add Rubric Level";
TabAddRubricLevel.Hide();
TabViewRubricLevel.Show();
cmd = "SELECT * FROM RubricLevel";
command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("0", 1));
conn.Open();
reader = command.ExecuteReader();
SqlDataAdapter adapter = new SqlDataAdapter(cmd, conn);
DataTable table = new DataTable();
adapter.Fill(table);
gridRubricLevel.DataSource = table;
conn.Close();
}
}
}
private void gridRubricLevel_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int ID = ID = Convert.ToInt32(gridRubricLevel.Rows[e.RowIndex].Cells[0].Value);
var element = gridRubricLevel.Columns["Delete"].Index;
var update = gridRubricLevel.Columns["Update"].Index;
if (e.ColumnIndex == element)
{
string cmd;
cmd = "Delete from StudentResult where RubricMeasurementId = @id";
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@id", ID));
conn.Open();
SqlDataReader reader = command.ExecuteReader();
conn.Close();
cmd = String.Format("DELETE FROM RubricLevel WHERE Id = @id");
command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@id", ID));
conn.Open();
reader = command.ExecuteReader();
conn.Close();
cmd = "SELECT * FROM RubricLevel";
command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("0", 1));
conn.Open();
reader = command.ExecuteReader();
SqlDataAdapter adapter = new SqlDataAdapter(cmd, conn);
DataTable table = new DataTable();
adapter.Fill(table);
gridRubricLevel.DataSource = table;
conn.Close();
}
else if (e.ColumnIndex == gridRubricLevel.Columns["Update"].Index)
{
lblHide.Hide();
var item = gridRubricLevel.Rows[e.RowIndex].Cells[0].Value;
string cmd = String.Format("SELECT * FROM RubricLevel WHERE Id = @item");
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@item", item));
conn.Open();
SqlDataReader reader = command.ExecuteReader();
Student s = new Student();
btnAddRubricLevel.Text = "Update Rubric";
while (reader.Read())
{
lblHide.Text = Convert.ToString(reader[0]);
cmbRubricID.Text = Convert.ToString(reader[1]);
txtDetails.Text = Convert.ToString(reader[2]);
txtMeasurementLevel.Text = Convert.ToString(reader[3]);
}
TabAddRubricLevel.Show();
conn.Close();
}
}
