public List <Det_promotor> get_cantidades(int promotor, string Fecha1, string Fecha2)
{
string query = "select tbadetticket.descripcion, tbaproductos.codigo, tbadetticket.cantidad,sum(tbadetticket.total) as vendido from tbadetticket inner join tbaproductos on tbadetticket.id_producto=tbaproductos.id inner join tbatickets on tbadetticket.id_ticket=tbatickets.folio";
if (Fecha1 == Fecha2)
{
query = query + " where tbatickets.atendio='" + promotor + "' and DATE_FORMAT(tbatickets.fecha,'%Y-%m-%d')='" + Fecha1 + "' group by tbaproductos.codigo order by tbadetticket.cantidad";
}
else
{
query = query + " where tbatickets.atendio='" + promotor + "' and DATE_FORMAT(tbatickets.fecha,'%Y-%m-%d') BETWEEN '" + Fecha1 + "' and '" + Fecha2 + "' group by tbaproductos.codigo order by tbadetticket.cantidad";
}
MySqlDataReader data = runQuery(query);
List <Det_promotor> result = new List <Det_promotor>();
if (data.HasRows)
{
while (data.Read())
{
Det_promotor item = build_promotor(data);
result.Add(item);
}
}
return(result);
}
private Det_promotor build_promotor(MySqlDataReader data)
{
Det_promotor item = new Det_promotor(
data.GetString("codigo"),
data.GetString("descripcion"),
data.GetDouble("cantidad"),
data.GetDouble("vendido")
);
return(item);
}
