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