private void GridAssessmentComponent_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int ID = Convert.ToInt32(GridAssessmentComponent.Rows[e.RowIndex].Cells[0].Value);
var element = GridAssessmentComponent.Columns["Delete"].Index;
var update = GridAssessmentComponent.Columns["Update"].Index;
if (e.ColumnIndex == element)
{
string cmd = String.Format("DELETE FROM StudentResult where AssessmentComponentId = @id");
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@id", ID));
conn.Open();
SqlDataReader reader = command.ExecuteReader();
conn.Close();
cmd = "Delete from AssessmentComponent 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 AssessmentComponent";
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);
GridAssessmentComponent.DataSource = table;
conn.Close();
}
else if (e.ColumnIndex == GridAssessmentComponent.Columns["Update"].Index)
{
lblHide.Hide();
var item = GridAssessmentComponent.Rows[e.RowIndex].Cells[0].Value;
string cmd = String.Format("SELECT * FROM AssessmentComponent 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();
btnAddAssessmentComponent.Text = "Update Assessment Component";
while (reader.Read())
{
lblHide.Text = Convert.ToString(reader[0]);
txtName.Text = Convert.ToString(reader[1]);
cmbRubricId.Text = Convert.ToString(reader[2]);
txtTotalMarks.Text = Convert.ToString(reader[3]);
cmbAssessmentId.Text = Convert.ToString(reader[6]);
}
TabAddAssessmentComponent.Show();
conn.Close();
}
}
private void btnAddAssessmentComponent_Click(object sender, EventArgs e)
{
bool isValidTotalMarks = isDigit(txtTotalMarks.Text);
bool IsValidRubricId = isDigit(cmbRubricId.Text);
bool isValidAssessmentId = isDigit(cmbAssessmentId.Text);
if (btnAddAssessmentComponent.Text == "Add Assessment Component")
{
if (IsValidRubricId && isValidAssessmentId && isValidTotalMarks)
{
conn.Open();
String cmd = String.Format("INSERT INTO AssessmentComponent(Name, RubricId, TotalMarks, DateCreated, DateUpdated, AssessmentId) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}' )", txtName.Text, Convert.ToInt32(cmbRubricId.Text), Convert.ToInt32(txtTotalMarks.Text), DateTime.Now, DateTime.Now, Convert.ToInt32(cmbAssessmentId.Text));
SqlCommand command = new SqlCommand(cmd, conn);
SqlDataReader reader = command.ExecuteReader();
txtName.Text = "";
txtTotalMarks.Text = "";
cmbRubricId.Text = "";
cmbAssessmentId.Text = "";
MessageBox.Show("Added Successfully");
conn.Close();
}
else
{
if (isValidAssessmentId == false)
{
MessageBox.Show("Invalid Assessment Id");
}
if (IsValidRubricId == false)
{
MessageBox.Show("Invalid Rubric Id");
}
if (isValidTotalMarks == false)
{
MessageBox.Show("Invalid Total Marks");
}
}
}
else
{
if (IsValidRubricId && isValidAssessmentId && isValidTotalMarks)
{
conn.Open();
string cmd = String.Format("UPDATE AssessmentComponent SET Name = @name, RubricId = @RubricId, TotalMarks = @mark, DateUpdated = @date, AssessmentId = @AssessmentId WHERE Id = @ID");
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@name", txtName.Text));
command.Parameters.Add(new SqlParameter("@RubricId", Convert.ToInt32(cmbRubricId.Text)));
command.Parameters.Add(new SqlParameter("@mark", Convert.ToInt32(txtTotalMarks.Text)));
command.Parameters.Add(new SqlParameter("@date", DateTime.Now));
command.Parameters.Add(new SqlParameter("@AssessmentId", Convert.ToInt32(cmbAssessmentId.Text)));
command.Parameters.Add(new SqlParameter("@ID", Convert.ToInt32(lblHide.Text)));
SqlDataReader reader = command.ExecuteReader();
txtName.Text = "";
txtTotalMarks.Text = "";
cmbAssessmentId.Text = "";
cmbRubricId.Text = "";
conn.Close();
btnAddAssessmentComponent.Text = "Add Assessment Component";
TabAddAssessmentComponent.Hide();
TabViewAssessmentComponent.Show();
cmd = "SELECT * FROM AssessmentComponent";
command = new SqlCommand(cmd, conn);
conn.Open();
reader = command.ExecuteReader();
SqlDataAdapter adapter = new SqlDataAdapter(cmd, conn);
DataTable table = new DataTable();
adapter.Fill(table);
GridAssessmentComponent.DataSource = table;
conn.Close();
}
else
{
if (isValidAssessmentId == false)
{
MessageBox.Show("Invalid Assessment Id");
}
if (IsValidRubricId == false)
{
MessageBox.Show("Invalid Rubric Id");
}
if (isValidTotalMarks == false)
{
MessageBox.Show("Invalid Total Marks");
}
}
}
}
