private void PopulateFields()
{
// Bind the lookups first
ABC abc = new ABC();
abc.LoadAll();
radioGroupABC.Properties.Items.Clear();
while(!abc.EOF){
radioGroupABC.Properties.Items.Add(new RadioGroupItem(abc.ID, abc.Description));
abc.MoveNext();
}
radioGroupVEN.Properties.Items.Clear();
VEN ven = new VEN();
ven.LoadAll();
while (!ven.EOF)
{
radioGroupVEN.Properties.Items.Add(new RadioGroupItem(ven.ID, ven.Description));
ven.MoveNext();
}
if(itemId != 0)
{
Item itm = new Item();
//itm.LoadByPrimaryKey(itemId);
DataTable dtItem = itm.GetItemById(itemId);
txtItemName.Text = itm.FullItemName;//String.Format("{0} - {1} - {2}", dtItem.Rows[0]["ItemName"], dtItem.Rows[0]["DosageForm"], dtItem.Rows[0]["Strength"]);
ckExculed.Checked = (!itm.IsColumnNull("IsInHospitalList"))?itm.IsInHospitalList:false;
chkProcessDecimal.Checked = (!itm.IsColumnNull("ProcessInDecimal")) ? itm.ProcessInDecimal : false;
if (!itm.IsColumnNull("ABCID"))
{
radioGroupABC.EditValue = itm.GetColumn("ABCID");
}
if (!itm.IsColumnNull("VENID"))
{
radioGroupVEN.EditValue = itm.GetColumn("VENID");
}
Supplier sup = new Supplier();
sup.LoadAll();
ItemSupplier itmSup = new ItemSupplier();
itmSup.GetSuppliersAndMarkThoseUsed(itemId);
while(!itmSup.EOF)
{
lstSuppliers.Items.Add(itmSup.GetColumn("CompanyName"),Convert.ToBoolean(itmSup.GetColumn("IsUsed")));
itmSup.MoveNext();
}
BLL.Program prog = new BLL.Program();
prog.GetSubPrograms();
ItemProgram progItem = new ItemProgram();
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);
}
}
}
private void cboPrograms_SelectedIndexChanged(object sender, EventArgs e)
{
lstPrograms.Items.Clear();
BLL.Program prog = new BLL.Program();
ItemProgram progItem = new ItemProgram();
if (cboPrograms.SelectedValue != null)
{
prog.GetSubProgramsByParentId(Convert.ToInt32(cboPrograms.SelectedValue));
}
else
{
prog.GetSubPrograms();
}
foreach (DataRowView dv in prog.DefaultView)
{
bool check = false;
check = progItem.CheckIfExists(itemId, Convert.ToInt32(dv["ID"]));
lstPrograms.Items.Add(dv["Name"],check);
}
}