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