public static List <classes.Item> getAllItems() { List <classes.Item> items = new List <classes.Item>(); try { SQLiteDataReader dr = executeReader("select * from _item where itemDeleted=0"); if (dr != null) { classes.Item tmpItem = null; while (dr.Read()) { tmpItem = new classes.Item(); tmpItem.init(ref dr); if (tmpItem.inited) { items.Add(tmpItem); } tmpItem = null; } } } catch (Exception ex) { throw new Exception("Unable to retrieve stock items from database."); } return(items); }
public static classes.Item findItem(String code, String name) { classes.Item item = null; try { SQLiteDataReader dr = Job.Database.executeReader("select * from _item where itemName LIKE '" + name + "' or itemCode LIKE '" + code + "' limit 1"); if (dr != null) { if (dr.Read()) { item = new classes.Item(); item.init(ref dr); return(item.inited ? item : null); } } } catch (Exception ex) { throw new Exception("Unable to find item data by code/name."); } return(item); }