public Boolean insert(clsTipoPrecios tp)
{
try
{
con.conectarBD();
cmd = new MySqlCommand("guardaTipoPrecio", con.conector);
cmd.CommandType = CommandType.StoredProcedure;
MySqlParameter oparm;
oparm = cmd.Parameters.AddWithValue("sigla", tp.Sigla);
oparm = cmd.Parameters.AddWithValue("descripcion", tp.Descripcion);
oparm = cmd.Parameters.AddWithValue("codalmacen", tp.CodAlmacen);
oparm = cmd.Parameters.AddWithValue("codusu", tp.User1);
oparm = cmd.Parameters.AddWithValue("newid", 0);
oparm.Direction = ParameterDirection.Output;
int x = cmd.ExecuteNonQuery();
tp.CodTipoPrecioNuevo = Convert.ToInt32(cmd.Parameters["newid"].Value);
if (x != 0)
{
return(true);
}
else
{
return(false);
}
}
catch (MySqlException ex)
{
throw ex;
}
finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); }
}
public Boolean Update(clsTipoPrecios tp)
{
try
{
con.conectarBD();
cmd = new MySqlCommand("updateTipoPrecio", con.conector);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("cod", tp.CodTipoPrecio);
cmd.Parameters.AddWithValue("siglaTP", tp.Sigla);
cmd.Parameters.AddWithValue("descrip", tp.Descripcion);
cmd.Parameters.AddWithValue("almacen", tp.CodAlmacen);
cmd.Parameters.AddWithValue("codusu", tp.User1);
int x = cmd.ExecuteNonQuery();
if (x != 0)
{
return(true);
}
else
{
return(false);
}
}
catch (MySqlException ex)
{
throw ex;
}
finally { con.conector.Dispose(); cmd.Dispose(); con.desconectarBD(); }
}
public Boolean update(clsTipoPrecios tp)
{
try {
return(it.Update(tp));
}catch (Exception ex) {
DevComponents.DotNetBar.MessageBoxEx.Show("Se encontró el siguiente problema: " + ex.Message, "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
}
