private void AssessmentComponent_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'projectBDataSet5.AssessmentComponent' table. You can move, or remove it, as needed.
this.assessmentComponentTableAdapter1.Fill(this.projectBDataSet5.AssessmentComponent);
// TODO: This line of code loads data into the 'projectBDataSet4.AssessmentComponent' table. You can move, or remove it, as needed.
this.assessmentComponentTableAdapter.Fill(this.projectBDataSet4.AssessmentComponent);
btn_AssessmentComponent.BackColor = Color.Gray;
btn_AssessmentComponent.Enabled = false;
btn_Update.Enabled = false;
btn_Add.Enabled = true;
AssessmentComponents ass = new AssessmentComponents();
ass.AddAssessmentTitleToCombobox(cmb_AssessmentTitle);
ass.AddRubricDetailsToCombobox(cmb_RubricDetails);
DataTable dt = ass.ShowInGrid();
int count = dt.Rows.Count;
for (int i = 0; i < count; i++)
{
string s = ass.getAssessmentTitleFromId(Convert.ToInt32(dt.Rows[i][6]));
string s1 = ass.getRubricDetailFromId(Convert.ToInt32(dt.Rows[i][2]));
dataGridView1.Rows[i].Cells[3].Value = s1;
dataGridView1.Rows[i].Cells[2].Value = s;
}
}
private void btn_Update_Click(object sender, EventArgs e)
{
AssessmentComponents ass = new AssessmentComponents();
lbl_ErrorName.Text = ass.ValidName(txt_Name.Text);
lbl_ErrorName.ForeColor = System.Drawing.Color.Red;
lbl_ErrorName.Refresh();
lbl_ErrorTotalMarks.Text = ass.ValidTotalMarks(txt_TotalMarks.Text);
lbl_ErrorTotalMarks.ForeColor = System.Drawing.Color.Red;
lbl_ErrorTotalMarks.Refresh();
if (lbl_ErrorName.Text == "" || lbl_ErrorTotalMarks.Text == "")
{
ass.name = txt_Name.Text;
ass.totalMarks = Convert.ToInt32(txt_TotalMarks.Text);
ass.AssessmentId = ass.getAssessmentIdFromTitle(cmb_AssessmentTitle.Text);
ass.RubricId = ass.getRubricIdFromDetails(cmb_RubricDetails.Text);
ass.Edit(id);
DataTable dt = ass.ShowInGrid();
int count = dt.Rows.Count;
dataGridView1.DataSource = dt;
for (int i = 0; i < count; i++)
{
string s = ass.getAssessmentTitleFromId(Convert.ToInt32(dt.Rows[i][6]));
string s1 = ass.getRubricDetailFromId(Convert.ToInt32(dt.Rows[i][2]));
dataGridView1.Rows[i].Cells[3].Value = s1;
dataGridView1.Rows[i].Cells[2].Value = s;
}
txt_Name.Clear();
txt_TotalMarks.Clear();
cmb_AssessmentTitle.Text = "";
cmb_RubricDetails.Text = "";
btn_Add.Enabled = true;
btn_Update.Enabled = false;
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string value = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].FormattedValue.ToString();
if (value == "Edit")
{
string id1 = dataGridView1.Rows[e.RowIndex].Cells[0].FormattedValue.ToString();
id = Convert.ToInt32(id1);
txt_Name.Text = dataGridView1.Rows[e.RowIndex].Cells[1].FormattedValue.ToString();
cmb_AssessmentTitle.Text = dataGridView1.Rows[e.RowIndex].Cells[2].FormattedValue.ToString();
cmb_RubricDetails.Text = dataGridView1.Rows[e.RowIndex].Cells[3].FormattedValue.ToString();
txt_TotalMarks.Text = dataGridView1.Rows[e.RowIndex].Cells[6].FormattedValue.ToString();
btn_Update.Enabled = true;
btn_Add.Enabled = false;
}
else if (value == "Delete")
{
string id1 = dataGridView1.Rows[e.RowIndex].Cells[0].FormattedValue.ToString();
id = Convert.ToInt32(id1);
AssessmentComponents ass = new AssessmentComponents();
ass.Delete(id);
DataTable dt = ass.ShowInGrid();
int count = dt.Rows.Count;
dataGridView1.DataSource = dt;
for (int i = 0; i < count; i++)
{
string s = ass.getAssessmentTitleFromId(Convert.ToInt32(dt.Rows[i][6]));
string s1 = ass.getRubricDetailFromId(Convert.ToInt32(dt.Rows[i][2]));
dataGridView1.Rows[i].Cells[3].Value = s1;
dataGridView1.Rows[i].Cells[2].Value = s;
}
}
}