private void Search() { try { Location loc = new Location(); loc.BranchCode = ""; loc.BranchName = ""; loc.IsActive = true; DataSet dsBranch = new LocationsDAO().SearchLocation(loc); //DataSet dsBranch = new LocationsDAO().GetAllBranches(); if (dsBranch != null && dsBranch.Tables.Count > 0) { gvBranches.DataSource = dsBranch; gvBranches.DataBind(); trGrid.Visible = true; trNoRecords.Visible = false; } else { trNoRecords.Visible = true; trGrid.Visible = false; } } catch (Exception ex) { throw ex; } }
/// <summary> /// Generates the transfer details for the invoice /// </summary> /// <returns></returns> private bool GenerateTransferNote() { try { bool result = true; foreach (DataRow dr in ObjInv.DsInvoiceDetails.Tables[0].Rows) { if (dr["ItemId"] == null)//If Group item { continue; } Int32 itemId = Int32.Parse(dr["ItemId"].ToString().Trim()); Item item = new Item(); item.ItemId = itemId; item.GetItemsByItemIDAndBranchID(Int32.Parse(Constant.MainStoreId));//Gets stock for main store only Int32 itemCount = Int32.Parse(dr["Quantity"].ToString().Trim()); Int32 TransferQty = (Int32)item.QuantityInHand - (item.InvoicedQty + itemCount); if (TransferQty >= 0) { continue; } else { TransferQty = TransferQty * -1;// Make TransferQty possitive value } LocationStocks locStock = new LocationStocks(); locStock.ItemId = itemId; DataSet dsItemSummary = new LocationsDAO().GetLocationStocksByItem(locStock); foreach (DataRow drIS in dsItemSummary.Tables[0].Rows) { Int32 branchId = Int32.Parse(drIS["BranchId"].ToString().Trim()); if (branchId.ToString()==Constant.MainStoreId) { continue; } Int32 Stock = Int32.Parse(drIS["QuantityInHand"].ToString().Trim()); if (Stock - TransferQty >= 0) { txtTransferNote.Value += String.Format(Constant.MSG_Invoice_Transfer_Details, item.ItemCode, drIS["BranchCode"].ToString().Trim(), TransferQty.ToString()); break; } else { txtTransferNote.Value += String.Format(Constant.MSG_Invoice_Transfer_Details, item.ItemCode, drIS["BranchCode"].ToString().Trim(), Stock.ToString()); TransferQty = TransferQty - Stock; continue; } } if (TransferQty > 0) { result = false; break; } else { result = true; } } return result; } catch (Exception ex) { throw ex; } }