public List <EntitieVentaItem> GetItems(int idVenta, String pez)
{
List <EntitieVentaItem> items = new List <EntitieVentaItem>();
String query = "SELECT VI.* " +
"FROM Venta_Items VI " +
"JOIN Ventas V " +
"ON V.ID_Venta = VI.ID_Venta " +
"LEFT JOIN Peces P " +
"ON VI.ID_Pez = P.ID_Pez ";
Boolean whereAdded = false;
if (idVenta > 0)
{
query += "WHERE VI.ID_Venta = " + idVenta + " ";
whereAdded = true;
}
if (!pez.Equals(String.Empty))
{
if (whereAdded)
{
query += "AND VI.Nombre_Pez LIKE '%" + pez + "%' ";
}
else
{
query += "WHERE VI.Nombre_Pez LIKE '%" + pez + "%' ";
whereAdded = true;
}
}
DataTable dt = ManagerDatabase.Instance.ExecuteQuery(query);
for (int i = 0; i < dt.Rows.Count; i++)
{
EntitieVentaItem item = new EntitieVentaItem(
Convert.ToInt32(dt.Rows[i][0]),
Convert.ToInt32(dt.Rows[i][1]),
Convert.ToInt32(dt.Rows[i][2]),
dt.Rows[i][3].ToString(),
Convert.ToDecimal(dt.Rows[i][4]),
Convert.ToInt32(dt.Rows[i][5]),
Convert.ToDecimal(dt.Rows[i][6]));
items.Add(item);
}
return(items);
}
public List <EntitieVentaItem> GetItemsByIdVenta(int idVenta)
{
List <EntitieVentaItem> items = new List <EntitieVentaItem>();
DataTable dt = ManagerDatabase.Instance.ExecuteQuery("SELECT * FROM Venta_Items WHERE ID_Venta = " + idVenta);
for (int i = 0; i < dt.Rows.Count; i++)
{
EntitieVentaItem item = new EntitieVentaItem(
Convert.ToInt32(dt.Rows[i][0]),
Convert.ToInt32(dt.Rows[i][1]),
Convert.ToInt32(dt.Rows[i][2]),
dt.Rows[i][3].ToString(),
Convert.ToDecimal(dt.Rows[i][4]),
Convert.ToInt32(dt.Rows[i][5]),
Convert.ToDecimal(dt.Rows[i][6]));
items.Add(item);
}
return(items);
}
