/* 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();
}
