private void btnDelete_Click(object sender, EventArgs e) { try { manageStudent mys = new manageStudent(); managestudentdetails mysd = new managestudentdetails(); mys.getStudentId(this.enId); DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete " + mys.firstName + " " + mys.lastName, "Confirm Option", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { if (mysd.deleteStudent(this.enId.ToString()) == true) { if (mys.deleteStudent(this.enId) == true) { MessageBox.Show("student deleted success", "input error", MessageBoxButtons.OK, MessageBoxIcon.Information); string sql = "SELECT enrolmentId,firstName,lastName,gender FROM wizstudents ORDER BY systemId DESC "; this.fillStudents(sql); } else { MessageBox.Show("failed to delete student", "input error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } catch (Exception ex) { MessageBox.Show("application error dgvStudents_CellDoubleClick() " + ex); } }
private void btnSave_Click(object sender, EventArgs e) { try { var enrID = Convert.ToInt32(this.txtEnroiD.Text); var firstName = this.txtFirstName.Text; var mdlName = this.txtMidName.Text; var lastName = this.tXTSurname.Text; var DOB = this.txtDob.Value.ToShortDateString(); string sex = ""; var classId = Convert.ToInt32(this.cmbClassRoom.SelectedValue); if (this.rdbMale.Checked == true) { sex = "M"; } if (this.metroRadioButton2.Checked == true) { sex = "F"; } /*other information*/ var address = this.txtAddress.Text; var phone = this.txtPhone.Text; var gurdFname = this.txtGuardianFname.Text; var gurdSname = this.txtGuardianSurname.Text; var gurdPhone = this.txtMobileNumbe.Text; var email = this.txtEmail.Text; var rel = this.txtRel.Text; /*validate required field*/ if (enrID.ToString() == "") { MessageBox.Show("Enrollmend Id is required", "input error", MessageBoxButtons.OK, MessageBoxIcon.Error); this.txtEnroiD.Focus(); } else if (firstName == "") { MessageBox.Show("firstName is required", "input error", MessageBoxButtons.OK, MessageBoxIcon.Error); this.txtFirstName.Focus(); } else if (lastName == "") { MessageBox.Show("lastName is required", "input error", MessageBoxButtons.OK, MessageBoxIcon.Error); this.tXTSurname.Focus(); } else { manageStudent myS = new manageStudent(); if (myS.checkExists(enrID) == 0) { if (myS.setStudent(enrID, firstName, mdlName, lastName, classId, DOB, sex) == true) { managestudentdetails mydetails = new managestudentdetails(); if (mydetails.setStudentDetails(enrID, address, gurdFname, gurdSname, rel, gurdPhone, email) == true) { MessageBox.Show("student enrolled succesifully", "System notifification", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { myS.deleteStudent(enrID); MessageBox.Show("failed to add student to system try again ", "System notifification", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } } else { MessageBox.Show("enrollmentId already in system", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch (Exception ex) { MessageBox.Show("application error frmStudentDetails_Load()" + ex); } }