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}")); } } } }