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