/// <summary>
/// Populates the fields based on the supplied itemID or categoryID
/// </summary>
private void PopulateFields()
{
if (_itemId == 0)
{
return;
}
Items itm = new Items();
DataTable dtItem = itm.GetItemById(_itemId);
txtItemName.Text = dtItem.Rows[0]["ItemName"].ToString() + " - " + dtItem.Rows[0]["Unit"].ToString() + " - " + dtItem.Rows[0]["Strength"].ToString();
ckExculed.Checked = itm.IsInHospitalList;
chkNeedExpiryBatch.Checked = itm.NeedExpiryBatch;
if (dtItem.Rows[0]["Pediatric"] != DBNull.Value)
{
chkIsVaccine.Checked = itm.Pediatric;
}
txtText.Text = itm.StockCodeDACA ?? string.Empty;
txtQuantityPerPack.Text = itm.Cost ?? string.Empty;
try
{
if (dtItem.Rows[0]["ABC"].ToString() == "A")
{
rdA.Checked = true;
}
else if (dtItem.Rows[0]["ABC"].ToString() == "B")
{
rdB.Checked = true;
}
else if (dtItem.Rows[0]["ABC"].ToString() == "C")
{
rdC.Checked = true;
}
}
catch { }
try
{
if (dtItem.Rows[0]["VEN"].ToString() == "V")
{
rdV.Checked = true;
}
else if (dtItem.Rows[0]["VEN"].ToString() == "E")
{
rdE.Checked = true;
}
else if (dtItem.Rows[0]["VEN"].ToString() == "N")
{
rdN.Checked = true;
}
}
catch { }
//ItemShelf itmShelf = new ItemShelf();
//DataTable dtSlf = itmShelf.GetLocationByItem(itm.ID);
//lstBinLocation.DataSource = dtSlf;
var unit = new ItemUnit();
var itemunits = unit.LoadFromSQl(_itemId);
itemunitbindingSource.DataSource = itemunits;
if (VisibilitySetting.HandleUnits == 2)
{
listBox1.Visible = true;
}
else if (VisibilitySetting.HandleUnits == 3)
{
listBox1.Visible = true;
}
else if (VisibilitySetting.HandleUnits == 1)
{
listBox1.Hide();
}
Supplier sup = new Supplier();
sup.GetActiveSuppliers();
ItemSupplier itmSup = new ItemSupplier();
itm.GetItemsBySupplier(_itemId);
foreach (DataRowView dv in sup.DefaultView)
{
bool check = false;
check = itmSup.CheckIfExist(_itemId, Convert.ToInt32(dv["ID"]));
object obj = dv["CompanyName"];
lstSuppliers.Items.Add(obj, check);
}
Programs prog = new Programs();
prog.GetSubPrograms();
ProgramProduct progItem = new ProgramProduct();
//lstPrograms.Items.Clear();
//foreach (DataRowView dv in prog.DefaultView)
//{
// bool check = false;
// check = progItem.CheckIfExists(_itemId, Convert.ToInt32(dv["ID"]));
// lstPrograms.Items.Add(dv["Name"], check);
//}
foreach (DataRow dr in prog.DefaultView.ToTable().Rows)
{
bool check = false;
check = progItem.CheckIfExists(_itemId, Convert.ToInt32(dr["ID"]));
if (Convert.ToString(dr["Name"]) != "All Programs")
{
rdSubProgram.Properties.Items.Add(new DevExpress.XtraEditors.Controls.RadioGroupItem(dr["ID"], dr["Name"].ToString()));
}
if (check)
{
rdSubProgram.EditValue = Convert.ToInt32(dr["ID"]);
}
}
ReceivingUnits dus = new ReceivingUnits();
dus.GetActiveDispensaries();
lstDUs.Items.Clear();
DUsItemList duItem = new DUsItemList();
foreach (DataRowView drDus in dus.DefaultView)
{
bool check = false;
check = duItem.CheckIfExsits(_itemId, Convert.ToInt32(drDus["ID"]));
lstDUs.Items.Add(drDus["Name"], check);
}
}
/// <summary>
/// Saves the item policy
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
var itm = new Items();
var itmSup = new ItemSupplier();
if (_itemId != 0)
{
itm.LoadByPrimaryKey(_itemId);
}
else
{
itm.AddNew();
var prodCate = new ProductsCategory();
prodCate.AddNew();
prodCate.ItemId = itm.ID;
prodCate.SubCategoryID = Convert.ToInt32(_categoryId);
prodCate.Save();
}
//if (rdA.Checked || rdB.Checked || rdC.Checked)
// itm.ABC = ((rdA.Checked) ? 1 : (rdB.Checked) ? 2 : 3);
//if (rdV.Checked || rdE.Checked || rdN.Checked)
// itm.VEN = ((rdV.Checked) ? 1 : (rdE.Checked) ? 2 : 3);
itm.IsInHospitalList = ckExculed.Checked;
//itm.NeedExpiryBatch = chkNeedExpiryBatch.Checked;
string valid = ValidateFields();
if (valid == "true")
{
itm.NeedExpiryBatch = chkNeedExpiryBatch.Checked;
itm.Pediatric = chkIsVaccine.Checked; //wrong coulmn name but used to identify the vaccine items
itm.StockCodeDACA = txtText.Text;
itm.Cost = txtQuantityPerPack.Text;
itm.Save();
}
else
{
XtraMessageBox.Show(valid, "Validation", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
//TODO: To add categories
//Needs some modification on edit
// this will only add the suppliers
//do some thing on edit
itmSup.DeleteAllSupForItem(itm.ID);
Supplier sup = new Supplier();
foreach (object t in lstSuppliers.CheckedItems)
{
sup.GetSupplierByName(t.ToString());
itmSup.AddNew();
itmSup.ItemID = itm.ID;
itmSup.SupplierID = sup.ID;
itmSup.Save();
}
var progItm = new ProgramProduct();
progItm.DeleteAllProgramsForItem(_itemId);
var prog = new Programs();
//prog.AddNew();
//prog.Name = cboPrograms.Text;
//prog.Save();
//foreach (object t in lstPrograms.CheckedItems)
//{
// prog.GetProgramByName(t.ToString());
// progItm.AddNew();
// progItm.ItemID = itm.ID;
// progItm.ProgramID = prog.ID;
// progItm.StoreID = (progItm.ProgramID == 1000) ? 8 : 9;
// progItm.Save();
//}
if (rdSubProgram.EditValue != null)
{
progItm.AddNew();
progItm.ItemID = itm.ID;
progItm.ProgramID = Convert.ToInt32(rdSubProgram.EditValue);
progItm.StoreID = 9;
progItm.Save();
}
var duItem = new DUsItemList();
var dus = new ReceivingUnits();
foreach (object t in lstDUs.CheckedItems)
{
dus.GetDUByName(t.ToString());
duItem.AddNew();
duItem.DUID = dus.ID;
duItem.ItemID = _itemId;
try
{
duItem.Save();
}
catch
{
}
}
XtraMessageBox.Show("Item Detail is Saved Successfully!", "Confirmation", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}