/* Configuración: * Recuerda abrir App.config y agregar la cadena de conexión * la cual obtienes desde el portal de Azure * además, hay que agregar Column Encryption Setting=Enabled * para que autorice las operaciones de encriptación * * También se agregó una referencia a la librería System.Configuration */ private void Add_Click(object sender, EventArgs e) { using (var connection = new SqlConnection()) { connection.ConnectionString = ConfigurationManager.ConnectionStrings["DemoConnectionString"].ToString(); connection.Open(); using (var command = new SqlCommand("AddEmployee", connection)) { command.CommandType = CommandType.StoredProcedure; var lastName = new SqlParameter("@LastName", SqlDbType.VarChar, 32); lastName.Value = LastNameText.Text; var salary = new SqlParameter("@Salary", SqlDbType.Decimal); salary.Value = decimal.Parse(SalaryText.Text); command.Parameters.Add(lastName); command.Parameters.Add(salary); command.ExecuteNonQuery(); MessageBox.Show("Employee added!"); SalaryText.Clear(); LastNameText.Clear(); } } }
private void registerAthleteButton_Click(object sender, EventArgs e) { AthleteCurr.setAttributes(FirstNameText.Text, LastNameText.Text, Convert.ToInt32(AthleteAge.SelectedItem), AthleteLevel.SelectedItem.ToString(), AthleteSex.SelectedItem.ToString()); AthleteCurr.produceAndSetKey(); AthleteCurr.registerCurr(CountryCurr); FirstNameText.Clear(); LastNameText.Clear(); AthleteAge.SelectedIndex = -1; AthleteLevel.SelectedIndex = -1; AthleteSex.SelectedIndex = -1; AthleteCountry.SelectedIndex = -1; }
private void AddButton_Click(object sender, EventArgs e) { listBox1.SelectionMode = SelectionMode.MultiExtended; listBox1.Items.Clear(); if (radioButton1.Checked == true) { if (!String.IsNullOrEmpty(FirstNameText.Text) && !String.IsNullOrEmpty(LastNameText.Text)) { Person.Add(new Male("Mr", FirstNameText.Text, LastNameText.Text)); } else { MessageBox.Show("Enter First and Lastname!"); } } else if (radioButton2.Checked == true) { if (!String.IsNullOrEmpty(FirstNameText.Text) && !String.IsNullOrEmpty(LastNameText.Text)) { Person.Add(new Female("Miss", FirstNameText.Text, LastNameText.Text)); } else { MessageBox.Show("Enter First and Lastname!"); } } else { MessageBox.Show("Enter First and Lastname! \n or Pick Male or Female!"); return; } radioButton1.Checked = false; radioButton2.Checked = false; FirstNameText.Clear(); LastNameText.Clear(); PrintNameLists(); }
private void GetAll_Click(object sender, EventArgs e) { LastNameText.Clear(); people = db.GetAllPeople(); refreshPeopleFoundBox(); }
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!"); } }