private int GetAdjustmentSum(Item i) { Discrepency dMonthly = EFBroker_Discrepancy.GetPendingMonthlyDiscrepancyByItemCode(i.ItemCode); List <Discrepency> dList = EFBroker_Discrepancy.GetPendingDiscrepanciesByItemCode(i.ItemCode); int adjustment = 0; if (dMonthly == null) { foreach (Discrepency d in dList) { adjustment += (int)d.AdjustmentQty; } } else { adjustment = (int)dMonthly.AdjustmentQty; foreach (Discrepency d in dList) { if ((int)d.DiscrepencyID > dMonthly.DiscrepencyID) { adjustment += (int)d.AdjustmentQty; } } } return(adjustment); }
private void ShowAll() { List <Item> iList = new List <Item>(); iList = EFBroker_Item.GetActiveItemList(); Dictionary <Item, String> displayItems = new Dictionary <Item, String>(); foreach (Item i in iList) { //If a monthly inventory check discrepancy is not yet approved, the sum of only //discrepancies starting from the monthly one will be displayed Discrepency dMonthly = EFBroker_Discrepancy.GetPendingMonthlyDiscrepancyByItemCode(i.ItemCode); List <Discrepency> dList = EFBroker_Discrepancy.GetPendingDiscrepanciesByItemCode(i.ItemCode); if (dMonthly == null) { string adjStr = GetAdjustmentsString(dList); displayItems.Add(i, adjStr); } else { string adjStr = GetPartialAdjustmentsString(dList, dMonthly); displayItems.Add(i, adjStr); } } gvItemList.DataSource = displayItems; gvItemList.DataBind(); foreach (GridViewRow row in gvItemList.Rows) { HyperLink link = row.FindControl("hlkDesc") as HyperLink; Label lbl = row.FindControl("lblItemCodeItem") as Label; string itemCode = lbl.Text; link.NavigateUrl = LoginController.AddItemDiscrepancyURI + "?itemCode=" + itemCode; } }
protected void BtnSearch_Click(object sender, EventArgs e) { //Search button Dictionary <Item, String> searchResults = new Dictionary <Item, String>(); string search = txtSearch.Text.ToLower(); List <Item> iList = EFBroker_Item.SearchItemsByItemCodeOrDesc(search); foreach (Item i in iList) { //If a monthly inventory check discrepancy is not yet approved, the sum of only //discrepancies starting from the monthly one will be displayed Discrepency dMonthly = EFBroker_Discrepancy.GetPendingMonthlyDiscrepancyByItemCode(i.ItemCode); List <Discrepency> dList = EFBroker_Discrepancy.GetPendingDiscrepanciesByItemCode(i.ItemCode); if (dMonthly == null) { string adjStr = GetAdjustmentsString(dList); searchResults.Add(i, adjStr); } else { string adjStr = GetPartialAdjustmentsString(dList, dMonthly); searchResults.Add(i, adjStr); } } gvItemList.DataSource = searchResults; gvItemList.DataBind(); foreach (GridViewRow row in gvItemList.Rows) { HyperLink link = row.FindControl("hlkDesc") as HyperLink; Label lbl = row.FindControl("lblItemCodeItem") as Label; string itemCode = lbl.Text; link.NavigateUrl = LoginController.AddItemDiscrepancyURI + "?itemCode=" + itemCode; } }