public DataSet GetLocationStocksByItem(LocationStocks locationStocks) { try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Location_GetLocationStocksByItem); db.AddInParameter(dbCommand, "@iItemId", DbType.Int32, locationStocks.ItemId); return(db.ExecuteDataSet(dbCommand)); } catch (System.Exception ex) { throw ex; return(null); } }
/// <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; } }
public DataSet GetLocationStocksByItem(LocationStocks locationStocks) { try { Database db = DatabaseFactory.CreateDatabase(Constant.Database_Connection_Name); DbCommand dbCommand = db.GetStoredProcCommand(Constant.SP_Location_GetLocationStocksByItem); db.AddInParameter(dbCommand, "@iItemId", DbType.Int32, locationStocks.ItemId); return db.ExecuteDataSet(dbCommand); } catch (System.Exception ex) { throw ex; return null; } }