public OperationResult Create(Info_Empleados Empleados)
{
using (SqlConnection conn = new SqlConnection(connect))
{
conn.Open();
SqlTransaction Transaction = conn.BeginTransaction();
using (SqlCommand cmd = new SqlCommand("CreateEmpleado", conn, Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("Nombre_Completo", Empleados.Nombre_Completo);
cmd.Parameters.AddWithValue("Cedula", Empleados.Cedula);
cmd.Parameters.AddWithValue("Sueldo_Bruto", Empleados.Sueldo_Bruto);
try
{
cmd.ExecuteNonQuery();
Transaction.Commit();
return(new OperationResult()
{
Result = true, Message = "Empleado Registrado!"
});
}
catch (Exception ex)
{
Transaction.Rollback();
return(new OperationResult(false, $"Se ha producido un error, {ex.Message}"));
}
}
}
}
public OperationResult Update(Info_Empleados UEmpleados, string Cedula)
{
using (SqlConnection conn = new SqlConnection(connect))
{
conn.Open();
SqlTransaction Transaction = conn.BeginTransaction();
using (SqlCommand cmd = new SqlCommand("UpdateEmpleado", conn, Transaction))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("Nombre_Completo", UEmpleados.Nombre_Completo);
cmd.Parameters.AddWithValue("Sueldo_Bruto", UEmpleados.Sueldo_Bruto);
cmd.Parameters.AddWithValue("Cedula", Cedula);
try
{
if (cmd.ExecuteNonQuery() == 0)
{
return(new OperationResult(false, $"No se encontro el empleado con la cedula '{Cedula}'"));
}
Transaction.Commit();
return(new OperationResult()
{
Result = true, Message = "Empleado actualizado con exito!"
});
}
catch (Exception ex)
{
Transaction.Rollback();
return(new OperationResult(false, $"Ha ocurrido un error. {ex.Message}"));
}
}
}
}