public List <Clases.proveedores> Consulta8(ref List <Clases.Rubro> rubros) { string query = "SELECT DISTINCT prov.nombre, r.nombre FROM proveedores as prov , productos as p , rubro as r, compras as c WHERE prov.idProveedores = c.idProveedor AND c.idProductos = p.idProductos and p.idRubro = r.idRubro"; List <Clases.proveedores> list = new List <Clases.proveedores>(); MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection); commandDatabase.CommandTimeout = 60; MySqlDataReader reader; try { databaseConnection.Open(); reader = commandDatabase.ExecuteReader(); while (reader.Read()) { Clases.proveedores prov = new Clases.proveedores(); Clases.Rubro rubro = new Clases.Rubro(); prov.Nombre = Convert.ToString(reader.GetValue(0)); rubro.Nombre = Convert.ToString(reader.GetValue(1)); rubros.Add(rubro); list.Add(prov); } databaseConnection.Close(); return(list); } catch (Exception) { return(list); } }
public List <Clases.Rubro> Consulta9(ref List <Clases.vendedores> vendedores) { string query = "SELECT DISTINCT vendedores.nombre as Vendedor, r.nombre AS Rubro FROM vendedores, ventas AS v, productos as p , rubro AS r where NOT(vendedores.idVendedores = v.idVendedor AND v.idProducto = p.idProductos and p.idRubro = r.idRubro) ORDER BY vendedores.nombre ASC"; List <Clases.Rubro> list = new List <Clases.Rubro>(); MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection); commandDatabase.CommandTimeout = 60; MySqlDataReader reader; try { databaseConnection.Open(); reader = commandDatabase.ExecuteReader(); while (reader.Read()) { Clases.vendedores vend = new Clases.vendedores(); Clases.Rubro rubro = new Clases.Rubro(); vend.Nombre = Convert.ToString(reader.GetValue(0)); rubro.Nombre = Convert.ToString(reader.GetValue(1)); vendedores.Add(vend); list.Add(rubro); } databaseConnection.Close(); return(list); } catch (Exception) { return(list); } }
public List <Clases.Rubro> ConsultaRubroCarga() { string query = "SELECT * FROM Rubro"; List <Clases.Rubro> list = new List <Clases.Rubro>(); MySqlCommand commandDatabase = new MySqlCommand(query, databaseConnection); commandDatabase.CommandTimeout = 60; MySqlDataReader reader; try { databaseConnection.Open(); reader = commandDatabase.ExecuteReader(); while (reader.Read()) { Clases.Rubro Rubro = new Clases.Rubro(); Rubro.IdRubro = Convert.ToInt32(reader.GetValue(0)); Rubro.Nombre = Convert.ToString(reader.GetValue(1)); list.Add(Rubro); } databaseConnection.Close(); return(list); } catch (Exception) { return(list); } }