public List<DataTypes.Good> getGoods(int skip = 0, int count = 0)
{
List<DataTypes.Good> list = new List<DataTypes.Good>();
string sqlString ;
if (skip != 0) sqlString = @"SELECT TOP " + count + " * FROM Items WHERE ID NOT IN (SELECT TOP " + skip + " ID FROM Items WHERE Type=" + "\'" + "Food" + "\'" + ") AND Type=" + "\'" + "Food" + "\'";
else sqlString = @"SELECT TOP " + count + " * FROM Items WHERE Type=" + "\'" + "Food" + "\'";
OleDbCommand cmd = new OleDbCommand(sqlString, 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 DataTypes.Good getItemById(int itemId)
{
DataTypes.Good goodey = new DataTypes.Good();
string sqlStr = @"SELECT * FROM Items WHERE ID = " + itemId;
OleDbCommand cmd = new OleDbCommand(sqlStr, connection);
OleDbDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
goodey.id = Convert.ToInt32(reader["ID"].ToString());
goodey.imageURL = reader["ImageURL"].ToString();
goodey.name = reader["ProductName"].ToString();
goodey.price = Convert.ToDouble(reader["Price"].ToString());
}
else return null;
return goodey;
}
