private void SaveStudentButton_Click(object sender, EventArgs e) { try { Person person = new Person(); try { person.fname = FirstNametext.Text; } catch (ArgumentException) { MessageBox.Show("Please Enter correct first name!"); FirstNametext.Clear(); throw new ArgumentException(); } try { person.lname = LastNameText.Text; } catch (ArgumentException) { MessageBox.Show("Please Enter correct last name!"); LastNameText.Clear(); throw new ArgumentException(); } try { person.Contact = ContactText.Text; } catch (ArgumentException) { MessageBox.Show("Please enter the correct 11 digit contact number"); ContactText.Clear(); throw new ArgumentException(); } try { person.Email = EmailText.Text; } catch (ArgumentException) { MessageBox.Show("Please Enter the email address"); EmailText.Clear(); throw new ArgumentException(); } catch (FormatException) { MessageBox.Show("Please Enter the correct email address"); EmailText.Clear(); throw new ArgumentException(); } try { person.DOB = DOBdateTimePicker.Value; } catch (ArgumentException) { MessageBox.Show("Person Age Must Be Greater Than 18"); DOBdateTimePicker.Value = DateTime.Now; throw new ArgumentException(); } try { person.Gender = GenderComboBox.Text; } catch (ArgumentException) { MessageBox.Show("Please Select the gender From the dropdown list"); throw new ArgumentException(); } Student student = new Student(); try { student.regNo = RegistrationNoText.Text; } catch (ArgumentException) { MessageBox.Show("Please Enter the Registration Number in the Format 1234-XY-567"); RegistrationNoText.Clear(); throw new ArgumentException(); } if (value1 == "add") { SqlConnection connection = new SqlConnection(connString); connection.Open(); string genderid = string.Format("SELECT Id FROM LookUp WHERE Value = '{0}' AND Category = 'GENDER'", person.Gender); SqlCommand cmd = new SqlCommand(genderid, connection); int id = (Int32)cmd.ExecuteScalar(); String cmdtext = String.Format("INSERT INTO Person(FirstName, LastName, Contact, Email, DateOfBirth, Gender) values('{0}','{1}', '{2}', '{3}', '{4}', '{5}' )", person.fname, person.lname, person.Contact, person.Email, person.DOB, id); cmd.CommandText = cmdtext; cmd.ExecuteNonQuery(); string getid = string.Format("SELECT id FROM Person WHERE Email = '{0}'", person.Email); cmd.CommandText = getid; id = (Int32)cmd.ExecuteScalar(); string addStudent = string.Format("INSERT INTO Student(Id, RegistrationNo) values('{0}' , '{1}')", id, student.regNo); cmd.CommandText = addStudent; cmd.ExecuteNonQuery(); MessageBox.Show("Student Added"); connection.Close(); } else if (value1 == "edit") { SqlConnection connection = new SqlConnection(connString); connection.Open(); string getGenderId = string.Format("SELECT Id FROM LookUp WHERE Value = '{0}' AND Category = 'GENDER'", GenderComboBox.Text); SqlCommand cmd = new SqlCommand(getGenderId, connection); int gender = (Int32)cmd.ExecuteScalar(); string update = string.Format("UPDATE Student SET RegistrationNo = '{0}' WHERE Id = '{1}'", RegistrationNoText.Text, IDStudent); cmd.CommandText = update; cmd.ExecuteNonQuery(); cmd.CommandText = string.Format("UPDATE Person SET FirstName = '{0}', LastName = '{1}', Contact = '{2}', Email = '{3}', " + "DateOfBirth = '{4}', Gender = '{5}' WHERE Id = '{6}'", FirstNametext.Text, LastNameText.Text, ContactText.Text, EmailText.Text, DOBdateTimePicker.Value, gender, IDStudent); cmd.ExecuteNonQuery(); MessageBox.Show("Student Updated!"); connection.Close(); } ManageStudentsForm form = new ManageStudentsForm(); this.Close(); form.Show(); } catch (Exception) { MessageBox.Show("Student not saved. Please try again!"); } }
private void AddAdvisor1_Click(object sender, EventArgs e) { try { Person person = new Person(); try { person.fname = FirstNametext.Text; } catch (ArgumentException) { MessageBox.Show("Please Enter correct first name!"); FirstNametext.Clear(); throw new ArgumentException(); } try { person.lname = LastNameText.Text; } catch (ArgumentException) { MessageBox.Show("Please Enter correct last name!"); LastNameText.Clear(); throw new ArgumentException(); } try { person.Contact = ContactText.Text; } catch (ArgumentException) { MessageBox.Show("Please enter the correct 11 digit contact number"); ContactText.Clear(); throw new ArgumentException(); } try { person.Email = EmailText.Text; } catch (ArgumentException) { MessageBox.Show("Please Enter the email address"); EmailText.Clear(); throw new ArgumentException(); } catch (FormatException) { MessageBox.Show("Please Enter the correct email address"); EmailText.Clear(); throw new ArgumentException(); } try { person.DOB = DOBdateTimePicker.Value; } catch (ArgumentException) { MessageBox.Show("Person Age Must Be Greater Than 18"); DOBdateTimePicker.Value = DateTime.Now; throw new ArgumentException(); } try { person.Gender = GenderComboBox.Text; } catch (ArgumentException) { MessageBox.Show("Please Select the gender From the dropdown list"); throw new ArgumentException(); } Advisor advisor = new Advisor(); try { advisor.designation = designationComboBox.Text; } catch (ArgumentException) { MessageBox.Show("Please select designation from the dropdown list"); designationComboBox.ResetText(); throw new ArgumentException(); } try { advisor.salary = SalaryTextBox.Text; } catch { MessageBox.Show("Please enter the salary in digits"); throw new ArgumentException(); } if (value1 == "add") { SqlConnection connection = new SqlConnection(connString); connection.Open(); string genderid = string.Format("SELECT Id FROM LookUp WHERE Value = '{0}' AND Category = 'GENDER'", GenderComboBox.Text); SqlCommand cmd = new SqlCommand(genderid, connection); int id = (Int32)cmd.ExecuteScalar(); String cmdtext = String.Format("INSERT INTO Person(FirstName, LastName, Contact, Email, DateOfBirth, Gender) values('{0}','{1}', '{2}', '{3}', '{4}', '{5}' )", FirstNametext.Text, LastNameText.Text, ContactText.Text, EmailText.Text, DOBdateTimePicker.Value, id); cmd.CommandText = cmdtext; cmd.ExecuteNonQuery(); string getid = string.Format("SELECT id FROM Person WHERE Email = '{0}'", EmailText.Text); cmd.CommandText = getid; id = (Int32)cmd.ExecuteScalar(); cmd.CommandText = string.Format("SELECT Id FROM Lookup WHERE Value = '{0}' AND Category = 'DESIGNATION'", designationComboBox.Text); int desig = (Int32)cmd.ExecuteScalar(); string addStudent = string.Format("INSERT INTO Advisor(Id, Designation, Salary) values('{0}' , '{1}', '{2}')", id, desig, SalaryTextBox.Text); cmd.CommandText = addStudent; cmd.ExecuteNonQuery(); MessageBox.Show("Advisor Added"); connection.Close(); } else if (value1 == "edit") { SqlConnection connection = new SqlConnection(connString); connection.Open(); string getGenderId = string.Format("SELECT Id FROM LookUp WHERE Value = '{0}' AND Category = 'GENDER'", GenderComboBox.Text); SqlCommand cmd = new SqlCommand(getGenderId, connection); int gender = (Int32)cmd.ExecuteScalar(); cmd.CommandText = String.Format("SELECT Id FROM Lookup WHERE Value = '{0}' AND Category = 'DESIGNATION'", designationComboBox.Text); int desig = (Int32)cmd.ExecuteScalar(); cmd.CommandText = string.Format("UPDATE Person SET FirstName = '{0}', LastName = '{1}', Contact = '{2}', Email = '{3}', " + "DateOfBirth = '{4}', Gender = '{5}' WHERE Id = '{6}'", FirstNametext.Text, LastNameText.Text, ContactText.Text, EmailText.Text, DOBdateTimePicker.Value, gender, IDadvisor); cmd.ExecuteNonQuery(); cmd.CommandText = string.Format("UPDATE Advisor SET Designation = '{0}', Salary = '{1}' " + "WHERE Id = '{2}'", desig, int.Parse(SalaryTextBox.Text), IDadvisor); cmd.ExecuteNonQuery(); MessageBox.Show("Advisor Updated!"); connection.Close(); } ManageAdvisors form = new ManageAdvisors(); this.Close(); form.Show(); } catch (Exception) { MessageBox.Show("Advisor not saved. Please try again!"); } }