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);
}
}
