/* 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 AddEmployeeSubmit_Click(object sender, RoutedEventArgs e) { string[] Data = new string[5]; Data[0] = IDText.GetLineText(0); Data[1] = NameText.GetLineText(0); Data[2] = PhoneText.GetLineText(0); Data[3] = AddressText.GetLineText(0); Data[4] = SexText.GetLineText(0); string EID = Data[0]; string Salary = SalaryText.GetLineText(0); string StartDate = StartDateText.GetLineText(0); string ManagerID = ManagerText.GetLineText(0); MakePerson P = new MakePerson(Data, cn); MakeEmployee E = new MakeEmployee(EID, Salary, StartDate, ManagerID, cn); try { P.CreatePerson(); } catch (OleDbException ex) { ErrorWindow Error = new ErrorWindow(ex.Message); Error.ShowDialog(); return; } try { E.CreateEmployee(); } catch (OleDbException ex) { try { P.DeletePerson(); } catch (OleDbException ex2) { } ErrorWindow Error = new ErrorWindow(ex.Message); Error.ShowDialog(); return; } this.Close(); }
private void AddEmployeeSubmit_Click(object sender, RoutedEventArgs e) { string[] Data = new string[9]; Data[0] = IDText.GetLineText(0); Data[1] = NameText.GetLineText(0); Data[2] = PhoneText.GetLineText(0); Data[3] = AddressText.GetLineText(0); Data[4] = SexText.GetLineText(0); Data[5] = Data[0]; Data[6] = SalaryText.GetLineText(0); Data[7] = StartDateText.GetLineText(0); Data[8] = ManagerText.GetLineText(0); aec.createEmployee(Data).ShowDialog(); this.Close(); }