private InventoryItem ItemReader(IDataReader aReader) { InventoryItem aItem = new InventoryItem(); try { aItem.ItemId = Convert.ToInt32(aReader["II_id"]); } catch { } try { aItem.ItemName = aReader["II_name"].ToString(); } catch { } try { aItem.UnitName = aReader["unit_name"].ToString(); } catch { } return aItem; }
public List<InventoryItem> GetItemByCategory(int categoryId) { List<InventoryItem> aItems = new List<InventoryItem>(); try { this.OpenConnection(); string sqlComm = String.Format(SqlQueries.GetQuery(Query.GetItemByCategory), categoryId); IDataReader aReader = this.ExecuteReader(sqlComm); if (aReader != null) { while (aReader.Read()) { InventoryItem aItem = new InventoryItem(); aItem = ItemReader(aReader); aItems.Add(aItem); } } } catch (Exception ex) { throw new Exception("GetItemByCategory()",ex); } finally { this.CloseConnection(); } return aItems; }
private void cmbProductName_SelectedIndexChanged(object sender, EventArgs e) { if (cmbProductName.SelectedIndex >= 0) { unitLabel.Visible = true; InventoryItem aInventoryItem = new InventoryItem(); aInventoryItem = (InventoryItem)cmbProductName.SelectedItem; unitLabel.Text = aInventoryItem.UnitName; } }
private void AddFinishedtoRawProductList() { try { // FinishedRawProductListDAO finishedRawProductDAO = new FinishedRawProductListDAO(); FinishedRawProductListDAO finishedRawProductDAO = new FinishedRawProductListDAO(); // CFinishedRawProductList cfinishedproduct = new CFinishedRawProductList(); if (isModifyRawProduct && txtRawQnty.Tag != null) { cFinishedProductList = txtRawQnty.Tag as CFinishedRawProductList; } else { cFinishedProductList = new CFinishedRawProductList(); } InventoryItem aInventoryItem = new InventoryItem(); aInventoryItem = (InventoryItem)cmbProductName.SelectedItem; // cFinishedProductList.FinishedProductID = m_iCat3ID; // cFinishedProductList.RawProductID = cCategory3sList[cmbProductName.SelectedIndex].Category3ID; // cFinishedProductList.RawProductName = cCategory3sList[cmbProductName.SelectedIndex].Category3Name; cFinishedProductList.FinishedProductID = m_iCat3ID; cFinishedProductList.RawProductID = aInventoryItem.ItemId; cFinishedProductList.RawProductName = aInventoryItem.ItemName; //try { cFinishedProductList.Qnty = Convert.ToInt32(txtRawQnty.Text); } //catch (Exception e) //{ //} try { cFinishedProductList.Qnty = Convert.ToDouble(txtRawQnty.Text); } catch (Exception e) { } cFinishedProductList.Remarks = ""; if (isModifyRawProduct) { finishedRawProductDAO.FinishedRawProductListUpdate(cFinishedProductList); } else { try { finishedRawProductDAO.FinishedRawProductListInsert(cFinishedProductList); } catch { } } RefreshFinishedRawProduct(); LoadDataGrid(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }