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;
}
}
