//private void UpdateList()
//{
// try
// {
// dbConnect connect = new dbConnect();
// lstInventoryItems.Clear();
// noinventory = false;
// connect.ExecuteQuery(string.Format("Select * from InventoryHistory where [Date] = #{0}# Order by Inventory_ID",Convert.ToDateTime(dtPick.Text)), lstInventoryItems);
// if (lstInventoryItems.Count == 0)
// {
// noinventory = true;
// connect.ExecuteQuery(string.Format("Select * from Inventory Order by Inventory_ID"), lstInventoryItems);
// SaveHistory();
// UpdateList();
// return;
// }
// lstProduct.Items.Clear();
// foreach (clsTransactionItem fi in lstInventoryItems)
// {
// if (noinventory) fi.Quantity = 0;
// lstProduct.Items.Add(string.Format("{0} : {1}",fi.Description ,fi.Quantity));
// }
// connect.Close();
// }
// catch { }
//}
//private void SaveHistory()
//{
// try
// {
// dbConnect connect = new dbConnect();
// //lstInventoryItems.Clear();
// //connect.ExecuteQuery("Select * from Inventory Order by Inventory_ID", lstInventoryItems);
// //lstProduct.Items.Clear();
// foreach (clsPurchasedItem fi in lstInventoryItems)
// {
// //lstProduct.Items.Add(string.Format("{0} : {1}", fi.Description, fi.Quantity));
// fi.Qty = 0;
// fi.TransDate = Convert.ToDateTime(dtPick.Text);
// fi.SaveHistory();
// }
// connect.Close();
// }
// catch { }
//}
private void btnOk_Click(object sender, EventArgs e)
{
try
{
if (txtDesc.Text.Trim() != "" && Convert.ToInt32(txtAmount.Text) > 0)
{
clsTransactionItem item = new clsTransactionItem();
if (lstProduct.SelectedIndex > -1)
{
item.ORNumber = lstInventoryItems[lstProduct.SelectedIndex].ORNumber;
}
item.Description = txtDesc.Text;
item.Amount = Convert.ToInt32(txtAmount.Text);
item.Quantity = Convert.ToInt32(txtQty.Text);
item.BarCode = txtCode.Text;
item.TransDate = Convert.ToDateTime(dtPick.Text);
item.SaveHistory();
//UpdateList();
ClearFields();
}
else
{
MessageBox.Show("Fill-out the form correctly.", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtDesc.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (lstProduct.SelectedIndex > -1)
{
clsTransactionItem proditem = new clsTransactionItem();
proditem.Delete(lstInventoryItems[lstProduct.SelectedIndex].ORNumber);
//UpdateList();
ClearFields();
if (lstProduct.Items.Count > 0)
{
lstProduct.SelectedIndex = 0;
}
}
}
