public byte AgregarCliente(ClienteClass client)
{
try
{
conectar();
string qry = "sp_Clientes";
_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("@num_emp", SqlDbType.Int);
param2.Value = client.num_emp;
var param3 = _comandosql.Parameters.Add("@nom", SqlDbType.VarChar, 60);
param3.Value = client.nom;
var param4 = _comandosql.Parameters.Add("@ape", SqlDbType.VarChar, 60);
param4.Value = client.ape;
var param5 = _comandosql.Parameters.Add("@fec_nac", SqlDbType.Date);
param5.Value = client.fec_nac;
var param6 = _comandosql.Parameters.Add("@curp", SqlDbType.Char, 18);
param6.Value = client.curp;
var param7 = _comandosql.Parameters.Add("@correo_e", SqlDbType.VarChar, 60);
param7.Value = client.correo_e;
var param8 = _comandosql.Parameters.Add("@contra", SqlDbType.Char, 8);
param8.Value = client.contra;
var param9 = _comandosql.Parameters.Add("@dom", SqlDbType.VarChar, 128);
param9.Value = client.dom.getAssembled();
_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 ModificarCliente(ClienteClass newclient, ClienteClass oldclient)
{
try
{
conectar();
string qry = "sp_Clientes";
_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("@id_cl", SqlDbType.BigInt);
param2.Value = oldclient.id_cl;
if (newclient.nom != oldclient.nom)
{
var param3 = _comandosql.Parameters.Add("@nom", SqlDbType.VarChar, 60);
param3.Value = newclient.nom;
}
if (newclient.ape != oldclient.ape)
{
var param4 = _comandosql.Parameters.Add("@ape", SqlDbType.VarChar, 60);
param4.Value = newclient.ape;
}
if (newclient.fec_nac != oldclient.fec_nac)
{
var param5 = _comandosql.Parameters.Add("@fec_nac", SqlDbType.Date);
param5.Value = newclient.fec_nac;
}
if (newclient.curp != oldclient.curp)
{
var param6 = _comandosql.Parameters.Add("@curp", SqlDbType.Char, 18);
param6.Value = newclient.curp;
}
if (newclient.dom != oldclient.dom)
{
var param7 = _comandosql.Parameters.Add("@dom", SqlDbType.VarChar, 128);
param7.Value = newclient.dom.getAssembled();
}
if (newclient.correo_e != oldclient.correo_e)
{
var param8 = _comandosql.Parameters.Add("@correo_e", SqlDbType.VarChar, 60);
param8.Value = newclient.correo_e;
}
if (newclient.contra != oldclient.contra)
{
var param9 = _comandosql.Parameters.Add("@contra", SqlDbType.Char, 8);
param9.Value = newclient.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();
}
}
