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);
}
}
