private void mnuViewAll_Click(object sender, EventArgs e) { //passes the data grid view to the ViewAll function and refreshes the data grid view on the form clsAssessment objAssessment = new clsAssessment(); objAssessment.ViewAll(dgvAssessment); }
private void btnSearch_Click(object sender, EventArgs e) { if (!clsValidation.ValidateTextBoxForNumeric(txtAssessmentID)) { txtAssessmentID.Focus(); return; } //creates an assessment object with only the id value clsAssessment objAssessment = new clsAssessment(Convert.ToInt32(txtAssessmentID.Text)); //runs the search function for the created object bool valid = objAssessment.Search(); //if an assessment was found in the Search function, then set the form elements to the supplied values if (valid) { txtAssessmentName.Text = objAssessment.AssessmentName; cmbUnitID.Text = objAssessment.UnitID.ToString(); cmbUnitName.Text = objAssessment.UnitName; cmbTeacherID.Text = objAssessment.TeacherID.ToString(); cmbTeacherName.Text = objAssessment.TeacherFirstName + " " + objAssessment.TeacherLastName; dtpStartDate.Value = DateTime.Parse(objAssessment.StartDate); dtpDueDate.Value = DateTime.Parse(objAssessment.DueDate); } }
private void AssessmentForm_Load(object sender, EventArgs e) { //passes the comboboxes that need to be popluated from the database and passes the data grid view //then runs the Load and ViewAll functions upon loading the form clsAssessment objAssessment = new clsAssessment(); ComboBox[] cmb = new ComboBox[] { cmbUnitID, cmbUnitName, cmbTeacherID, cmbTeacherName }; objAssessment.Load(cmb); objAssessment.ViewAll(dgvAssessment); //loaded = true; }
private void mnuUpdate_Click(object sender, EventArgs e) { #region Validation Area if (!clsValidation.ValidateTextBoxForNumeric(txtAssessmentID)) { txtAssessmentID.Focus(); return; } if (!clsValidation.ValidateComboBox(cmbUnitName)) { return; } if (!clsValidation.ValidateComboBox(cmbTeacherName)) { return; } if (!clsValidation.ValidateTextBox(txtAssessmentName)) { txtAssessmentName.Focus(); return; } if (!clsValidation.ValidateDate(dtpStartDate)) { return; } if (!clsValidation.ValidateDate(dtpDueDate)) { return; } if (!clsValidation.ValidateDateStartVsEnd(dtpStartDate, dtpDueDate)) { return; } #endregion //create an assessment object with all values clsAssessment objAssessment = new clsAssessment(Convert.ToInt32(txtAssessmentID.Text), txtAssessmentName.Text, Convert.ToInt32(cmbUnitID.Text), Convert.ToInt32(cmbTeacherID.Text), dtpStartDate.Value.ToString("yyyy-MM-dd"), dtpDueDate.Value.ToString("yyyy-MM-dd")); //run the Update value for the created object objAssessment.Update(); MessageBox.Show("Assessment successfully updated"); //refresh the data grid view objAssessment.ViewAll(dgvAssessment); }
private void mnuDelete_Click(object sender, EventArgs e) { if (!clsValidation.ValidateTextBoxForNumeric(txtAssessmentID)) { txtAssessmentID.Focus(); return; } //create and assessment object with only the id clsAssessment objAssessment = new clsAssessment(Convert.ToInt32(txtAssessmentID.Text)); //run the Delete function objAssessment.Delete(); MessageBox.Show("Assessment successfully deleted"); //refresh the data grid view objAssessment.ViewAll(dgvAssessment); }
private void mnuAdd_Click(object sender, EventArgs e) { #region Validation Area if (!clsValidation.ValidateComboBox(cmbUnitName)) { return; } if (!clsValidation.ValidateComboBox(cmbTeacherName)) { return; } if (!clsValidation.ValidateTextBox(txtAssessmentName)) { txtAssessmentName.Focus(); return; } if (!clsValidation.ValidateForAlphabet(txtAssessmentName)) { txtAssessmentName.Focus(); return; } if (!clsValidation.ValidateDate(dtpStartDate)) { return; } if (!clsValidation.ValidateDate(dtpDueDate)) { return; } if (!clsValidation.ValidateDateStartVsEnd(dtpStartDate, dtpDueDate)) { return; } #endregion //create an assessment object with the supplied values clsAssessment objAssessment = new clsAssessment(txtAssessmentName.Text, Convert.ToInt32(cmbUnitID.Text), Convert.ToInt32(cmbTeacherID.Text), dtpStartDate.Value.ToString("yyyy-MM-dd"), dtpDueDate.Value.ToString("yyyy-MM-dd")); //run the Add function for the object created objAssessment.Add(); MessageBox.Show("Assessment successfully added"); //refresh the data grid view objAssessment.ViewAll(dgvAssessment); }