// Adding Assessment Component MEnu
private void btnAddAssessmentComponent_Click(object sender, EventArgs e)
{
//Showing Added RUbric Details in combobox And Adding this against this rubric
SqlConnection Connection = new SqlConnection(constr);
Connection.Open();
if (Connection.State == ConnectionState.Open)
{
string query = "select Id,Details from dbo.Rubric";
SqlDataAdapter t = new SqlDataAdapter(query, Connection);
DataTable dtatbl = new DataTable();
t.Fill(dtatbl);
cmboboxRubricDetails.DataSource = dtatbl;
cmboboxRubricDetails.DisplayMember = "Details";
cmboboxRubricDetails.ValueMember = "id";
}
Connection.Close();
//Showing Added Assessment Titles in combobox And Adding this against this Assessment
SqlConnection Connection1 = new SqlConnection(constr);
Connection1.Open();
if (Connection1.State == ConnectionState.Open)
{
string query = "select Id,Title from dbo.Assessment";
SqlDataAdapter t = new SqlDataAdapter(query, Connection1);
DataTable dtatbl = new DataTable();
t.Fill(dtatbl);
combboxListOfAssessment.DataSource = dtatbl;
combboxListOfAssessment.DisplayMember = "Title";
combboxListOfAssessment.ValueMember = "id";
}
Connection1.Close();
ListOfAddedAssessmentComponentDataGridView.Hide();
lblTitle.Hide();
txtTitle.Hide();
lblDateCreated.Hide();
dtpDateCreated.Hide();
lblTotalMarks.Hide();
txtTotalMarks.Hide();
lblTotalWeightage.Hide();
txtTotalWeightage.Hide();
btnADD.Hide();
ListOfAddedAssessmentsDataGridView.Hide();
lblName.Show();
txtName.Show();
lblRubricDetails.Show();
cmboboxRubricDetails.Show();
lblAssessments.Show();
combboxListOfAssessment.Show();
lblTotalMarksAC.Show();
txtTotalMarksAC.Show();
lblDateCreatedAC.Show();
dtpDateCreatedAC.Show();
btnADDComponent.Show();
}
//Showing Ad Assessment Menu
private void btnAddAssessment_Click_1(object sender, EventArgs e)
{
ListOfAddedAssessmentComponentDataGridView.Hide();
lblTitle.Show();
txtTitle.Show();
lblDateCreated.Show();
dtpDateCreated.Show();
lblTotalMarks.Show();
txtTotalMarks.Show();
lblTotalWeightage.Show();
txtTotalWeightage.Show();
btnADD.Show();
ListOfAddedAssessmentsDataGridView.Hide();
lblName.Hide();
txtName.Hide();
lblRubricDetails.Hide();
cmboboxRubricDetails.Hide();
lblAssessments.Hide();
combboxListOfAssessment.Hide();
lblTotalMarksAC.Hide();
txtTotalMarksAC.Hide();
lblDateCreatedAC.Hide();
dtpDateCreatedAC.Hide();
btnADDComponent.Hide();
}
//Showing List Of Added Assessments By datagridview and Hiding other Things Except this
private void btnListOfAddedAssessment_Click(object sender, EventArgs e)
{
ListOfAddedAssessmentComponentDataGridView.Hide();
lblTitle.Hide();
txtTitle.Hide();
lblDateCreated.Hide();
dtpDateCreated.Hide();
lblTotalMarks.Hide();
txtTotalMarks.Hide();
lblTotalWeightage.Hide();
txtTotalWeightage.Hide();
btnADD.Hide();
lblName.Hide();
txtName.Hide();
lblRubricDetails.Hide();
cmboboxRubricDetails.Hide();
lblAssessments.Hide();
combboxListOfAssessment.Hide();
lblTotalMarksAC.Hide();
txtTotalMarksAC.Hide();
lblDateCreatedAC.Hide();
dtpDateCreatedAC.Hide();
btnADDComponent.Hide();
ListOfAddedAssessmentsDataGridView.Show();
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT * FROM dbo.Assessment", con))
{
cmd.CommandType = CommandType.Text;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
ListOfAddedAssessmentsDataGridView.DataSource = dt;
}
}
}
}
}
//On Load just Showing Add Assessment Menu
private void AddAssessmentForm_Load(object sender, EventArgs e)
{
ListOfAddedAssessmentComponentDataGridView.Hide();
ListOfAddedAssessmentsDataGridView.Hide();
lblName.Hide();
txtName.Hide();
lblRubricDetails.Hide();
cmboboxRubricDetails.Hide();
lblAssessments.Hide();
combboxListOfAssessment.Hide();
lblTotalMarksAC.Hide();
txtTotalMarksAC.Hide();
lblDateCreatedAC.Hide();
dtpDateCreatedAC.Hide();
btnADDComponent.Hide();
}
