private void Cancel_Click(object sender, EventArgs e) { this.Hide(); PersonStudent ps = new PersonStudent(); ps.ShowDialog(); this.Close(); }
// goes to manage students private void Mstudents_Click(object sender, EventArgs e) { PersonStudent st = new PersonStudent(); st.ShowDialog(); }
// when save button clicks private void button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(conURL); // connection opens con.Open(); if (buffer < 0) // for creation of new data { try { // here check whether boxes are empty for not if (String.IsNullOrEmpty(textBoxName.Text) || String.IsNullOrEmpty(textBoxEmail.Text) || String.IsNullOrEmpty(textBoxRegNo.Text)) { MessageBox.Show("Fill First Name, Email, Reg No must"); } else { // if all validations are true, then insert data if (isalphaTest(textBoxName.Text) && (String.IsNullOrEmpty(textBoxLast.Text) || (!String.IsNullOrEmpty(textBoxLast.Text) && (isalphaTest(textBoxLast.Text)))) && isRegNovalid(textBoxRegNo.Text) && (String.IsNullOrEmpty(textBoxContact.Text) || (!String.IsNullOrEmpty(textBoxContact.Text) && contactNoValid(textBoxContact.Text)))) { string val = ""; bool isCheck = male.Checked; if (isCheck) { val = male.Text; } bool isCheck2 = female.Checked; if (isCheck2) { val = female.Text; } System.Text.RegularExpressions.Regex expr = new System.Text.RegularExpressions.Regex(@"^[a-zA-Z][\w\.-]{2,28}[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"); if (expr.IsMatch(textBoxEmail.Text)) { string cmdText = "INSERT INTO Person (FirstName,LastName, Contact, Email, DateOfBirth, Gender ) VALUES (@FirstName,@LastName, @Contact, @Email, @DateOfBirth, (SELECT Id FROM Lookup WHERE Category = 'Gender' AND Value = @Value))"; SqlCommand c = new SqlCommand(cmdText, con); c.Parameters.Add(new SqlParameter("@FirstName", textBoxName.Text)); c.Parameters.Add(new SqlParameter("@LastName", textBoxLast.Text)); c.Parameters.Add(new SqlParameter("@Contact", textBoxContact.Text)); c.Parameters.Add(new SqlParameter("@Email", textBoxEmail.Text)); c.Parameters.Add(new SqlParameter("@DateOfBirth", dateTimePicker1.Text)); c.Parameters.Add(new SqlParameter("@Value", val)); //execute it int result = c.ExecuteNonQuery(); if (result < 0) { MessageBox.Show("Error"); } string cmdText3 = "INSERT INTO Student (Id, RegistrationNo) VALUES((SELECT Id FROM Person WHERE Email = @Email AND Contact = @Contact AND FirstName = @FirstName), @RegistrationNo)"; SqlCommand c3 = new SqlCommand(cmdText3, con); c3.Parameters.Add(new SqlParameter("@FirstName", textBoxName.Text)); c3.Parameters.Add(new SqlParameter("@Contact", textBoxContact.Text)); c3.Parameters.Add(new SqlParameter("@Email", textBoxEmail.Text)); c3.Parameters.Add(new SqlParameter("@RegistrationNo", textBoxRegNo.Text)); c3.ExecuteNonQuery(); // connection closed // show dialog box if added in table of database MessageBox.Show("Successfully Added"); con.Close(); this.Hide(); PersonStudent datap = new PersonStudent(); datap.ShowDialog(); this.Close(); // close the form } else { throw new ArgumentNullException(); } } else { throw new ArgumentNullException(); } } } catch (Exception) { MessageBox.Show("Enter Name, Email, RegNo in correct Format!! RegNo pattern be like '2016-CE-72' or 2016-IME-999' Name should be all alphabets, no extra spaces. email should have at least 4 chars before @. contact should have digits"); } } else // for updation of data { try { if (isalphaTest(textBoxName.Text) && (String.IsNullOrEmpty(textBoxLast.Text) || (!String.IsNullOrEmpty(textBoxLast.Text) && (isalphaTest(textBoxLast.Text)))) && isRegNovalid(textBoxRegNo.Text.ToString()) && (String.IsNullOrEmpty(textBoxContact.Text) || (!String.IsNullOrEmpty(textBoxContact.Text) && contactNoValid(textBoxContact.Text)))) { string val = ""; bool isCheck = male.Checked; if (isCheck) { val = male.Text; } bool isCheck2 = female.Checked; if (isCheck2) { val = female.Text; } System.Text.RegularExpressions.Regex expr = new System.Text.RegularExpressions.Regex(@"^[a-zA-Z][\w\.-]{2,28}[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$"); if (expr.IsMatch(textBoxEmail.Text)) { string cmdText2 = "Update Person SET FirstName = @FirstName ,LastName =@LastName , Contact = @Contact, Email = @Email, DateOfBirth = @DateOfBirth, Gender = (SELECT Id FROM Lookup WHERE Category = 'GENDER' AND Value = @Value) WHERE Id = @Id"; SqlCommand c2 = new SqlCommand(cmdText2, con); c2.Parameters.Add(new SqlParameter("@Id", buffer)); c2.Parameters.Add(new SqlParameter("@FirstName", textBoxName.Text)); c2.Parameters.Add(new SqlParameter("@LastName", textBoxLast.Text)); c2.Parameters.Add(new SqlParameter("@Contact", textBoxContact.Text)); c2.Parameters.Add(new SqlParameter("@Email", textBoxEmail.Text)); c2.Parameters.Add(new SqlParameter("@DateOfBirth", dateTimePicker1.Text)); c2.Parameters.Add(new SqlParameter("@Value", val)); c2.ExecuteNonQuery(); string cmdText3 = "Update Student SET RegistrationNo = @RegistrationNo WHERE Id = @Id"; SqlCommand c3 = new SqlCommand(cmdText3, con); c3.Parameters.Add(new SqlParameter("@Id", buffer)); c3.Parameters.Add(new SqlParameter("@RegistrationNo", textBoxRegNo.Text)); c3.ExecuteNonQuery(); MessageBox.Show("Successfully Updated!!"); con.Close(); this.Hide(); PersonStudent datap = new PersonStudent(); datap.ShowDialog(); this.Close(); // close the form } else { throw new ArgumentNullException(); } } else { throw new ArgumentNullException(); } } catch (Exception) { MessageBox.Show("Enter Name, Email, RegNo in correct Format!! RegNo pattern be like '2016-CE-72' or 2016-IME-999' Name should be all alphabets, no extra spaces. email should have at least 4 chars before @. contact should have digits"); } } }