private void btnRegister_Click(object sender, EventArgs e)
{
if (!IsAnyTextBoxEmpty())
{
bool IsConnnected = DatabaseConnection.start();
bool ISValidStudent = true;
Student student = new Student();
try
{
student.FirstName = txtFirstName.Text;
}
catch (ArgumentException)
{
ISValidStudent = false;
lblFNameWarning.Visible = true;
}
try
{
student.LastName = txtLastName.Text;
}
catch (ArgumentException)
{
ISValidStudent = false;
lblLNameWarning.Visible = true;
}
try
{
student.RegistrationNo = txtRegNo.Text;
}
catch (ArgumentException)
{
ISValidStudent = false;
lblRegWarning.Visible = true;
}
try
{
student.Email = txtEmail.Text;
}
catch (ArgumentException)
{
ISValidStudent = false;
lblEmailWarning.Visible = true;
}
if (ISValidStudent)
{
string StudentGender = "0";
if (cmbGender.Text == "Male")
{
StudentGender = "1";
}
string day = cmbDay.Text;
string month = cmbMonth.SelectedIndex.ToString();
string year = cmbYear.Text;
string studentDOB = year + " - " + month + " - " + day;
bool IsException = false;
DatabaseConnection.createStatement("select * from Student where RegistrationNo = '" + txtRegNo.Text + " '");
SqlDataReader r = DatabaseConnection.getData();
if (r.Read())
{
IsException = true;
MessageBox.Show("This Registration Number already exists");
}
if (!IsException)
{
try
{
DatabaseConnection.createStatement("INSERT INTO Person ( FirstName, LastName, Contact, Email, DateOfBirth, Gender)" +
" VALUES('" + txtFirstName.Text + "' , '" + txtLastName.Text + "', '" + txtContactNo.Text + "', '" + txtEmail.Text + "', '" + studentDOB + "' ," + StudentGender + "); ");
DatabaseConnection.performAction();
}
catch (SqlException)
{
IsException = true;
lblDOBwarning.Visible = true;
}
}
if (!IsException)
{
DatabaseConnection.createStatement("Select @@identity as id from Person");
SqlDataReader reader = DatabaseConnection.getData();
string id = "0";
while (reader.Read())
{
id = (reader["id"].ToString());
}
DatabaseConnection.createStatement("INSERT INTO Student (Id, RegistrationNo) VALUES (" + id + ", '" + txtRegNo.Text + "') ");
DatabaseConnection.performAction();
if (!IsException)
{
MessageBox.Show("Student added");
ManageStudent manageStudent = ManageStudent.GetInstance();
manageStudent.Show();
this.Hide();
}
}
}
}
}