public bool delete_proveedor(ClassEntidadProveedor proveedor)
{
try
{
cnn = conectar();
cmd = new MySqlCommand("sp_proveedor_del", cnn);
cmd.CommandType = CommandType.StoredProcedure;
p = new MySqlParameter("?_idproveedor", MySqlDbType.Int64);
p.Value = proveedor.getidproveedor;
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);
dr = cmd.ExecuteReader();
dr.Close();
cnn.Close();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
throw;
}
}
public bool insert_proveedor(ClassEntidadProveedor proveedor)
{
try
{
cnn = conectar();
cmd = new MySqlCommand("sp_proveedor_in", cnn);
cmd.CommandType = CommandType.StoredProcedure;
p = new MySqlParameter("?_razon_social", MySqlDbType.VarChar);
p.Value = proveedor.getrazonsocial;
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);
p = new MySqlParameter("?_nit", MySqlDbType.VarChar);
p.Value = proveedor.getnit;
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);
p = new MySqlParameter("?_telefono", MySqlDbType.VarChar);
p.Value = proveedor.gettelefono;
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);
p = new MySqlParameter("?_correo", MySqlDbType.VarChar);
p.Value = proveedor.getcorreo;
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);
p = new MySqlParameter("?_direccion", MySqlDbType.VarChar);
p.Value = proveedor.getdireccion;
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);
p = new MySqlParameter("?_idtipo_persona", MySqlDbType.Int64);
p.Value = proveedor.getidtipopersona;
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);
p = new MySqlParameter("?_idciudad", MySqlDbType.Int64);
p.Value = proveedor.getidciudad;
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);
dr = cmd.ExecuteReader();
dr.Close();
cnn.Close();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
throw;
}
}
