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