private static Hashtable getStockIDTable() { Hashtable ht = new Hashtable(); StockItemNewDB sidb = new StockItemNewDB(); List <stockitemnew> Silist = sidb.getStockItems(); foreach (stockitemnew si in Silist) { try { string id = si.StockItemID; string key = id.Substring(0, 12); string value = id.Substring(12, 4); if (ht.ContainsKey(key)) { ht[key] = value; } else { ht.Add(key, value); } } catch (Exception ex) { } } return(ht); }
private void ListStockItem() { try { grdList.Rows.Clear(); StockItemNewDB SiDb = new StockItemNewDB(); List <stockitemnew> SIlist = SiDb.getStockItems(); foreach (stockitemnew item in SIlist) { grdList.Rows.Add(item.StockItemID, item.Name, item.Group1Code, item.Group1CodeDescription, item.Unit, getStatusString(item.Status), item.DocumentStatus); } filterGridData(); } catch (Exception) { MessageBox.Show("Error in Stock listing"); } enableBottomButtons(); pnlList.Visible = true; }
private void btnSave_Click(object sender, EventArgs e) { try { stockitemnew si = new stockitemnew(); StockItemNewDB siDB = new StockItemNewDB(); if (cmbStatus.SelectedIndex == -1) { MessageBox.Show("Fill Status Combo"); return; } si.Name = txtDescription.Text; si.Group1Code = cmbGroup1.SelectedItem.ToString().Trim(). Substring(0, cmbGroup1.SelectedItem.ToString().Trim().IndexOf('-')); si.Unit = ((Structures.ComboBoxItem)cmbUnit.SelectedItem).HiddenValue; //si.Status = ComboFIll.getStatusCode(cmbStatus.SelectedItem.ToString()); si.Status = getStatusCode(cmbStatus.SelectedItem.ToString()); System.Windows.Forms.Button btn = sender as System.Windows.Forms.Button; string btnText = btn.Text; if (siDB.validateRegion(si)) { if (btnText.Equals("Update")) { si.StockItemID = txtStockItemID.Text; if (siDB.updateStockItem(si)) { MessageBox.Show("StockItem updated"); closeAllPanels(); //txtSearchGrd.Text = ""; ListStockItem(); } else { MessageBox.Show("Failed to update StockItem"); return; } } else if (btnText.Equals("Save")) { si.StockItemID = CreateStockItemID(si.Group1Code + "0000000000"); si.DocumentStatus = 99; if (siDB.insertStockItem(si)) { MessageBox.Show("StockItem Added"); closeAllPanels(); txtSearchGrd.Text = ""; ListStockItem(); } else { MessageBox.Show("Failed to Insert StockItem"); return; } } } else { MessageBox.Show("StockItem Data Validation failed"); return; } } catch (Exception) { MessageBox.Show("Failed Adding / Editing StockItem"); return; } }