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