private void txtItemName_TextChanged(object sender, EventArgs e)
{
if (cboStores.SelectedValue != null && (cboYear.SelectedItem != null))
{
Items itm = new Items();
int storeId = (cboStores.SelectedValue != null) ? Convert.ToInt32(cboStores.SelectedValue) : 0;
DataTable dtItm = new DataTable();
if (txtItemName.Text != "")
{
dtItm = ((ckExclude.Checked && ckExcNeverIssued.Checked) ? itm.GetReceivedNotIssuedItemsByKeyword(storeId, txtItemName.Text) : ((ckExclude.Checked) ? itm.ExcludeNeverReceivedItemsByKeyword(storeId, txtItemName.Text) : itm.GetItemByKeywordInList(txtItemName.Text)));
}
else
{
dtItm = ((ckExclude.Checked && ckExcNeverIssued.Checked) ? itm.GetReceivedNotIssuedItems(storeId, Convert.ToInt32(lkCommodityTypes.EditValue)) : ((ckExclude.Checked) ? itm.ExcludeNeverReceivedItems(storeId, Convert.ToInt32(lkCommodityTypes.EditValue)) : itm.GetAllItems(1)));
}
PopulateItemList(dtItm);
}
}
private void ckExcNeverIssued_CheckedChanged(object sender, EventArgs e)
{
if (cboStores.SelectedValue != null && (cboYear.SelectedItem != null))
{
Items itm = new Items();
int storeId = (cboStores.SelectedValue != null) ? Convert.ToInt32(cboStores.SelectedValue) : 0;
DataTable dtItm = new DataTable();
dtItm = ((ckExclude.Checked && ckExcNeverIssued.Checked) ? itm.GetReceivedNotIssuedItems(storeId,Convert.ToInt32(lkCommodityTypes.EditValue)) : ((ckExclude.Checked) ? itm.ExcludeNeverReceivedItems(storeId, Convert.ToInt32(lkCommodityTypes.EditValue)) : itm.GetAllItems(1)));
PopulateItemList(dtItm);
}
}
private void PopulateByProgram()
{
if (cboSubProgram.SelectedValue != null && cboStores.SelectedValue != null)
{
Items itm = new Items();
DataTable dtItem = new DataTable();
if (Convert.ToInt32(cboSubProgram.SelectedValue) > 0)
{
dtItem = ((ckExclude.Checked) ? itm.ExcludeNeverReceivedItemsByProgram(Convert.ToInt32(cboSubProgram.SelectedValue), Convert.ToInt32(cboStores.SelectedValue)) : itm.GetItemsByProgram(Convert.ToInt32(cboSubProgram.SelectedValue)));
}
else
{
dtItem = (((ckExcNeverIssued.Checked && ckExclude.Checked) ? itm.GetReceivedNotIssuedItems(Convert.ToInt32(cboStores.SelectedValue),Convert.ToInt32(lkCommodityTypes.EditValue)) : (ckExclude.Checked) ? itm.ExcludeNeverReceivedItems(Convert.ToInt32(cboStores.SelectedValue), Convert.ToInt32(lkCommodityTypes.EditValue)) : itm.GetAllItems(1)));
}
PopulateItemList(dtItem);
}
}
private void LoadInventoryItems()
{
dtDate.Value = DateTime.Now;
DateTime dtCurent;
dtDate.CustomFormat = "MM/dd/yyyy";
dtCurent = ConvertDate.DateConverter(dtDate.Text);
int year = dtCurent.Year;
var itm = new Items();
DataTable dtItm;
switch (VisibilitySetting.HandleUnits)
{
case 1:
if (ckExclude == null || (!ckExclude.Checked))
dtItm = itm.ExcludeNeverReceivedItems(Convert.ToInt32(cboStores.EditValue),
Convert.ToInt32(lkCommodityTypes.EditValue));
else dtItm = itm.GetAllItems(1, Convert.ToInt32(lkCommodityTypes.EditValue));
PopulateItemList(dtItm, year);
dtDate.CustomFormat = "MMMM dd, yyyy";
break;
case 2:
if (ckExclude == null || (!ckExclude.Checked))
dtItm = itm.ExcludeNeverReceivedItemsForHandlingUnit(Convert.ToInt32(cboStores.EditValue),
Convert.ToInt32(lkCommodityTypes.EditValue));
else dtItm = itm.GetAllItems(1, Convert.ToInt32(lkCommodityTypes.EditValue));
PopulateItemList(dtItm, year);
dtDate.CustomFormat = "MMMM dd, yyyy";
break;
case 3:
if (ckExclude == null || (!ckExclude.Checked)) dtItm = itm.ExcludeNeverReceivedItemsForHandlingUnit(Convert.ToInt32(cboStores.EditValue), Convert.ToInt32(lkCommodityTypes.EditValue));
else dtItm = itm.GetAllItems(1, Convert.ToInt32(lkCommodityTypes.EditValue));
PopulateItemList(dtItm, year);
dtDate.CustomFormat = "MMMM dd, yyyy";
break;
}
}
private void rdDrug_CheckedChanged(object sender, EventArgs e)
{
if (cboStores.SelectedValue != null && cboYear.SelectedItem != null)
{
Items itm = new Items();
int storeId = Convert.ToInt32(cboStores.SelectedValue);
DataTable dtItem = new DataTable();
dtItem = ((ckExclude.Checked) ? itm.ExcludeNeverReceivedItems(storeId,Convert.ToInt32(lkCommodityTypes.EditValue)) : itm.GetAllItems(1));
PopulateItemList(dtItem);
PopulateCatTree();
lblState.Text = "All Items";
}
}
private void PopulateByProgram()
{
if (cboSubProgram.SelectedValue != null && cboStores.SelectedValue != null)
{
Items itm = new Items();
DataTable dtItem;
if (Convert.ToInt32(cboSubProgram.SelectedValue) > 0)
{
if (rdDrug.EditValue!=null)
dtItem = ((ckExclude.Checked) ? itm.ExcludeNeverReceivedItemsByProgram(Convert.ToInt32(cboSubProgram.SelectedValue), Convert.ToInt32(cboStores.SelectedValue)) : itm.GetItemsByProgram(Convert.ToInt32(cboSubProgram.SelectedValue)));
else
dtItem = ((ckExclude.Checked) ? itm.ExcludeNeverReceivedSuppliesByProgram(Convert.ToInt32(cboSubProgram.SelectedValue), Convert.ToInt32(cboStores.SelectedValue)) : itm.GetSupplyByProgram(Convert.ToInt32(cboSubProgram.SelectedValue)));
}
else
{
if (rdDrug.EditValue!=null)
dtItem = ((ckExclude.Checked) ? itm.ExcludeNeverReceivedItems(Convert.ToInt32(cboStores.SelectedValue),Convert.ToInt32(lkCommodityTypes.EditValue)) : itm.GetAllItems(1));
else
dtItem = ((ckExclude.Checked) ? itm.ExcludeNeverReceivedSupply(Convert.ToInt32(cboStores.SelectedValue)) : itm.GetAllSupply());
}
PopulateItemList(dtItem);
}
}
private void cboStores_SelectedIndexChanged(object sender, EventArgs e)
{
if (cboStores.SelectedValue != null)
{
Items itm = new Items();
int storeId = Convert.ToInt32(cboStores.SelectedValue);
DataTable dtItem = new DataTable();
dtItem = ((ckExclude.Checked && ckExcNeverIssued.Checked) ? itm.GetReceivedNotIssuedItems(storeId,Convert.ToInt32(lkCommodityTypes.EditValue)) : ((ckExclude.Checked) ? itm.ExcludeNeverReceivedItems(storeId,Convert.ToInt32(lkCommodityTypes.EditValue)) : itm.GetAllItems(1,Convert.ToInt32(lkCommodityTypes.EditValue))));
PopulateItemList(dtItem);
lblState.Text = "All Items";
}
}
private void btnSearchByDate_Click(object sender, EventArgs e)
{
Items itm = new Items();
DataTable dtItm = new DataTable();
if (dtFrom.Value < dtTo.Value)
{
int storeId = Convert.ToInt32(cboStores.SelectedValue);
dtItm = ((ckExclude.Checked) ? itm.ExcludeNeverReceivedItems(storeId,Convert.ToInt32(lkCommodityTypes.EditValue)) : itm.GetAllItems(1));
PopulateItemListByDateRange(dtItm);
}
}
