public byte AgregarEmpleado(EmpleadoClass emp)
{
try
{
conectar();
string qry = "sp_Empleados";
_comandosql = new SqlCommand(qry, _conexion);
_comandosql.CommandType = CommandType.StoredProcedure;
_comandosql.CommandTimeout = 9000;
var param1 = _comandosql.Parameters.Add("@proc", SqlDbType.VarChar, 16);
param1.Value = "insert";
var param2 = _comandosql.Parameters.Add("@id_adm", SqlDbType.SmallInt);
param2.Value = emp.id_admin;
var param3 = _comandosql.Parameters.Add("@nom", SqlDbType.VarChar, 60);
param3.Value = emp.nom;
var param4 = _comandosql.Parameters.Add("@ape", SqlDbType.VarChar, 60);
param4.Value = emp.ape;
var param5 = _comandosql.Parameters.Add("@fec_nac", SqlDbType.Date);
param5.Value = emp.fec_nac;
var param6 = _comandosql.Parameters.Add("@curp", SqlDbType.Char, 18);
param6.Value = emp.curp;
var param7 = _comandosql.Parameters.Add("@rfc", SqlDbType.Char, 13);
param7.Value = emp.rfc;
var param8 = _comandosql.Parameters.Add("@correo_e", SqlDbType.VarChar, 60);
param8.Value = emp.correo_e;
var param9 = _comandosql.Parameters.Add("@contra", SqlDbType.Char, 8);
param9.Value = emp.contra;
_adaptador.InsertCommand = _comandosql;
if (_comandosql.ExecuteNonQuery() == 0)
{
return(1);
}
return(0);
}
catch (SqlException e)
{
MessageBox.Show(e.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(10);
}
finally
{
desconectar();
}
}
public byte ModificarEmpleado(EmpleadoClass newemp, EmpleadoClass oldemp)
{
try
{
conectar();
string qry = "sp_Empleados";
_comandosql = new SqlCommand(qry, _conexion);
_comandosql.CommandType = CommandType.StoredProcedure;
_comandosql.CommandTimeout = 9000;
var param1 = _comandosql.Parameters.Add("@proc", SqlDbType.VarChar, 16);
param1.Value = "update";
var param2 = _comandosql.Parameters.Add("@num_emp", SqlDbType.Int);
param2.Value = oldemp.num_emp;
if (newemp.nom != oldemp.nom)
{
var param3 = _comandosql.Parameters.Add("@nom", SqlDbType.VarChar, 60);
param3.Value = newemp.nom;
}
if (newemp.ape != oldemp.ape)
{
var param4 = _comandosql.Parameters.Add("@ape", SqlDbType.VarChar, 60);
param4.Value = newemp.ape;
}
if (newemp.fec_nac != oldemp.fec_nac)
{
var param5 = _comandosql.Parameters.Add("@fec_nac", SqlDbType.Date);
param5.Value = newemp.fec_nac;
}
if (newemp.rfc != oldemp.rfc)
{
var param6 = _comandosql.Parameters.Add("@rfc", SqlDbType.Char, 13);
param6.Value = newemp.rfc;
}
if (newemp.curp != oldemp.curp)
{
var param7 = _comandosql.Parameters.Add("@curp", SqlDbType.Char, 18);
param7.Value = newemp.curp;
}
if (newemp.correo_e != oldemp.correo_e)
{
var param8 = _comandosql.Parameters.Add("@correo_e", SqlDbType.VarChar, 60);
param8.Value = newemp.correo_e;
}
if (newemp.contra != oldemp.contra)
{
var param9 = _comandosql.Parameters.Add("@contra", SqlDbType.Char, 8);
param9.Value = newemp.contra;
}
_adaptador.UpdateCommand = _comandosql;
if (_comandosql.ExecuteNonQuery() == 0)
{
return(1);
}
return(0);
}
catch (SqlException e)
{
MessageBox.Show(e.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(10);
}
finally
{
desconectar();
}
}