public static int AgregarRef(MySqlConnection conexion, Refrigerios re)
{
int retorno = 0;
MySqlCommand comando = new MySqlCommand(String.Format("INSERT INTO refrigerios ( ref_nombre, ref_contenido) VALUES ('{0}', '{1}')", re.nombre, re.contenido_ref), conexion);
retorno = comando.ExecuteNonQuery();
return(retorno);
}
public static int ModificarRef(MySqlConnection conexion, Refrigerios re)
{
int retorno = 0;
MySqlCommand comando = new MySqlCommand(String.Format("UPDATE refrigerios SET ref_nombre='{1}', ref_contenido='{2}' WHERE id_ref='{0}' ", re.id_ref, re.nombre, re.contenido_ref), conexion);
retorno = comando.ExecuteNonQuery();
return(retorno);
}
public static int EliminarRef(MySqlConnection conexion, Refrigerios re)
{
int retorno = 0;
MySqlCommand comando = new MySqlCommand(String.Format("DELETE FROM refrigerios WHERE id_ref='{0}' ", re.id_ref), conexion);
retorno = comando.ExecuteNonQuery();
return(retorno);
}
public static int ExisteRef(MySqlConnection conexion, Refrigerios re)
{
int id_ref = 0;
MySqlCommand comando = new MySqlCommand(String.Format("SELECT id_ref FROM refrigerios WHERE ref_nombre='{0}' AND ref_contenido='{1}' ", re.nombre, re.contenido_ref), conexion);
MySqlDataReader leer = comando.ExecuteReader();
while (leer.Read())
{
id_ref = leer.GetInt32(0);
}
return(id_ref);
}
