/*public List<DataTypes.Good> getAllItems()
{
List<DataTypes.Good> list = new List<DataTypes.Good>();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM Items", connection);
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DataTypes.Good goodey = new DataTypes.Good();
goodey.id = Convert.ToInt32(reader["ID"].ToString());
goodey.imageURL = reader["ImageURL"].ToString();
goodey.name = reader["ProductName"].ToString();
goodey.price = Convert.ToDouble(reader["Price"].ToString());
list.Add(goodey);
}
return list;
} */
public List<DataTypes.Sale> getSales(int skip = 0, int count = 0)
{
List<DataTypes.Sale> list = new List<DataTypes.Sale>();
string sqlString = @"SELECT * FROM Sales ";
if (skip != 0 || count != 0)
sqlString += @"WHERE ID BETWEEN " + (skip+1) + " AND " + (skip+count) + " AND ACTIVE = YES";
else sqlString += @" WHERE ACTIVE = YES";
OleDbCommand cmd = new OleDbCommand(sqlString, connection);
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DataTypes.Sale sale = new DataTypes.Sale();
sale.id = Convert.ToInt32(reader["ID"].ToString());
sale.name = reader["SaleName"].ToString();
sale.value = Convert.ToInt32(reader["SaleValue"].ToString());
list.Add(sale);
}
return list;
}
private void saleClickCallback(int id)
{
DataTypes.Sale sale = new DataTypes.Sale();
if (id != 0) sale = db.getSaleById(id);
saleValue = sale.value;
saleName = sale.name;
this.Dispose();
}
public DataTypes.Sale getSaleById(int saleId)
{
DataTypes.Sale sale = new DataTypes.Sale();
string sqlStr = @"SELECT * FROM Sales WHERE ID = " + saleId + " AND Active = YES";
OleDbCommand cmd = new OleDbCommand(sqlStr, connection);
OleDbDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
sale.id = Convert.ToInt32(reader["ID"].ToString());
sale.value = Convert.ToInt32(reader["SaleValue"].ToString());
sale.name = reader["SaleName"].ToString();
}
else return null;
return sale;
}
