public static void LoadProduct(IProgress<ProductItem> progress)
{
try
{
using (MySqlDataReader data = DB.Instance.SelectReader(
@"SELECT * FROM inventory limit 100;"
))
{
if (data != null)
{
while (data.Read())
{
var item = new Item(
data.GetUInt16(0),
data.GetString(1),
data.GetUInt16(2),
data.GetUInt16(3),
data.GetDecimal(4),
data.GetUInt16(5),
data.GetInt16(6),
data.GetString(7));
var productitem = new ProductItem(item);
progress.Report(productitem);
#if DEBUG
Console.WriteLine(item);
#endif
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Browser()
{
InitializeComponent();
try
{
using (MySqlDataReader data = DB.Instance.selectReader(@"SELECT inventory.id, inventory.title, category.title, cost FROM inventory left join category on inventory.category_id = category.id;"))
{
if (data != null)
{
while (data.Read())
{
var p = new ProductItem(data.GetUInt16(0), data.GetString(1), "", data.GetDecimal(3), Role.Instance.AddToShopCart);
p.Dock = DockStyle.Top;
tlpProduct.Controls.Add(p);
}
}
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
