public void comoboxvalues() { StudentResultClass SR = new StudentResultClass(); ListofClasses lt1 = new ListofClasses(); SR.addRubricname(); int length = lt1.Cloname.Count(); RubricLSelection.Items.Clear(); for (int i = 0; i < length; i++) { RubricLSelection.Items.Add(lt1.Cloname.ElementAt(i)); } SR.addStudentname(); int length1 = lt1.Studentname.Count(); StudentName1.Items.Clear(); for (int i = 0; i < length1; i++) { StudentName1.Items.Add(lt1.Studentname.ElementAt(i)); } SR.AddASSname(); int length3 = lt1.Assessment1.Count(); AssessmentSel.Items.Clear(); for (int i = 0; i < length3; i++) { AssessmentSel.Items.Add(lt1.Assessment1.ElementAt(i)); } }
/// <summary> /// This function used to insert the StudentResult record in StudentResult List /// </summary> /// <param name="query">Query to retrieve the data from database</param> public void StudentResultRecord(string query) { try { SqlCommand command = new SqlCommand(query, conn); conn.Open(); SqlDataReader reader; reader = command.ExecuteReader(); if (reader.HasRows) { ListofClasses Lt1 = new ListofClasses(); Lt1.RemoveFromSTR(); while (reader.Read()) { StudentResultClass SRC = new StudentResultClass(); SRC.StudentId1 = Convert.ToInt32(reader[0]); SRC.AssessmentComId1 = Convert.ToInt32(reader[1]); SRC.RubricMeasurement1 = Convert.ToInt32(reader[2]); SRC.EvaluationDate1 = Convert.ToDateTime(reader[3]); Lt1.AddSTRList(SRC); } } } catch (Exception ex) { throw (ex); } finally { conn.Close(); } }
private void My_Own_Load() { StudentResultClass Acc = new StudentResultClass(); ListofClasses lt1 = new ListofClasses(); Acc.Record(); StudentResultRecord.DataSource = null; AssessmentSelection.Text = ""; AssessmentSel.Text = ""; StudentResultRecord.DataSource = lt1.STR1; comoboxvalues(); }
public void AssessmentComponent(string ASSValue) { StudentResultClass SR = new StudentResultClass(); ListofClasses lt1 = new ListofClasses(); SR.addAssessmentname(ASSValue); int length2 = lt1.ASSname1.Count(); AssessmentSelection.Items.Clear(); for (int i = 0; i < length2; i++) { AssessmentSelection.Items.Add(lt1.ASSname1.ElementAt(i)); } }
private void ADD_Click(object sender, EventArgs e) { StudentResultClass SR = new StudentResultClass(); string Rubric = RubricLSelection.GetItemText(RubricLSelection.SelectedItem); string assessment = AssessmentSelection.GetItemText(AssessmentSelection.SelectedItem); string student = StudentName1.GetItemText(StudentName1.SelectedItem); SR.ADD(student, assessment, Rubric, EvaluateDate.Value); StudentResultRecord.DataSource = null; RubricLSelection.Text = ""; AssessmentSelection.Text = ""; StudentName1.Text = ""; EvaluateDate.ResetText(); My_Own_Load(); }
private void StudentResultRecord_CellContentClick(object sender, DataGridViewCellEventArgs e) { StudentResultClass STR = new StudentResultClass(); ListofClasses lt = new ListofClasses(); int index = StudentResultRecord.CurrentCell.RowIndex; DataGridViewRow r = StudentResultRecord.Rows[index]; int STUid = Convert.ToInt32(r.Cells[0].Value); int ASSid = Convert.ToInt32(r.Cells[1].Value); if (StudentResultRecord.Columns[e.ColumnIndex].Name == "DeleteSr") { DialogResult result = MessageBox.Show("Do You Want to delete data against the id ?" + STUid, "Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (result.Equals(DialogResult.OK)) { STR.Delete(STUid, ASSid); StudentResultRecord.DataSource = null; My_Own_Load(); if (ADD.Visible == false) { ADD.Visible = true; } } else { return; } } if (StudentResultRecord.Columns[e.ColumnIndex].Name == "EditSR") { StudentResultClass SC = new StudentResultClass(); comoboxvalues(); StudentName1.Text = SC.RegistrationNoStudent(Convert.ToInt32(r.Cells[0].Value)); int rubricid = Convert.ToInt32(r.Cells[2].Value); RubricLSelection.SelectedText = SC.NameofRubricId(rubricid); int ASS = Convert.ToInt32(r.Cells[1].Value); AssessmentSelection.SelectedText = SC.NameofASSComId(ASS); AssessmentSel.SelectedText = SC.NameofASSId(ASS); EvaluateDate.Value = Convert.ToDateTime(r.Cells[3].Value); globalindex = Convert.ToInt32(r.Cells[0].Value); globalindex2 = Convert.ToInt32(r.Cells[1].Value); if (ADD.Visible) { ADD.Visible = false; } } }
private void Save_Click(object sender, EventArgs e) { string Rubric = RubricLSelection.GetItemText(RubricLSelection.SelectedItem); string assessment = AssessmentSelection.GetItemText(AssessmentSelection.SelectedItem); string assessmentCom = AssessmentSel.GetItemText(AssessmentSel.SelectedItem); string stdentName = StudentName1.GetItemText(StudentName1.SelectedItem); StudentResultClass Rub = new StudentResultClass(); Rub.Edit(globalindex, globalindex2, stdentName, assessment, Rubric, EvaluateDate.Value); StudentResultRecord.DataSource = null; AssessmentSel.Text = ""; RubricLSelection.Text = ""; AssessmentSelection.Text = ""; StudentName1.Text = ""; EvaluateDate.ResetText(); My_Own_Load(); ADD.Visible = true; }
/// <summary> /// This function used to Add tne Student Result in the StudentResultList /// </summary> /// <param name="SR">Indicate the object of type StudentResultClass</param> public void AddSTRList(StudentResultClass SR) { STR.Add(SR); }