private void cmdSave_Click(object sender, EventArgs e)
{
try {
if (!is_invalid()) //validate data
{
if (!is_editMode()) //check either new student is going to added
{
string queryPerson = string.Format("insert into Person(FirstName,LastName,Contact,Email,DateOfBirth,Gender) values('{0}','{1}','{2}','{3}','{4}',(select Id from Lookup where Value='{5}'))",
txtBxFirstName.Text, txtBxLastName.Text, txtBxContact.Text, txtBxEmail.Text, Convert.ToDateTime(dateTimePickerDOB.Value), cmbBxGender.Text);
DataBaseConnection.getInstance().executeQuery(queryPerson);
string queryStudent = string.Format("insert into Student(Id,RegistrationNo) values((select max(Id) from Person),'{0}')", txtBxReg.Text);
DataBaseConnection.getInstance().executeQuery(queryStudent);
MessageBox.Show("Added Success");
}
else // student is being updated
{
string queryPerson = string.Format("update Person set FirstName='{0}',LastName='{1}',Contact='{2}',Email='{3}',DateOfBirth='{4}',Gender=(select Id from Lookup where Value='{5}') where Id='{6}'",
txtBxFirstName.Text, txtBxLastName.Text, txtBxContact.Text, txtBxEmail.Text, Convert.ToDateTime(dateTimePickerDOB.Value), cmbBxGender.Text, GeneralID.selectedObjectid);
DataBaseConnection.getInstance().executeQuery(queryPerson);
string queryStudent = string.Format("update Student set RegistrationNo='{0}' where Id='{1}'", txtBxReg.Text, GeneralID.selectedObjectid);
DataBaseConnection.getInstance().executeQuery(queryStudent);
MessageBox.Show("Update Success");
GeneralID.selectedObjectid = 0; //reset it to zero after successfull update
}
Show_Students showStudent = new Show_Students();
this.Hide();
showStudent.Show();
}
}
catch (Exception ex)
{
MessageBox.Show("added failed" + ex.ToString());
}
}
private void showStudentsToolStripMenuItem_Click(object sender, EventArgs e)
{
Show_Students showStudent = new Show_Students();
this.Hide();
showStudent.Show();
}
private void cmdCancel_Click(object sender, EventArgs e)
{
GeneralID.selectedObjectid = 0; //reset it to zero after successfull update
Show_Students showStudent = new Show_Students();
this.Hide();
showStudent.Show();
}
