public GRNFinishProductsCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRNFinishProduct");
GRNFinishProductsCollec objGRNFinishProductsCollec = new GRNFinishProductsCollec();
for (int i = 0; i < dt.Rows.Count; i++)
{
GRNFinishProducts objGRNFinishProduct = new GRNFinishProducts();
objGRNFinishProduct.FinishProducts = objFinishProduct_DL.Get(Convert.ToString(dt.Rows[i]["FinishProductCode"]));
objGRNFinishProduct.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[i]["GRNNO"]));
objGRNFinishProduct.GrossQty = Convert.ToDecimal(dt.Rows[i]["GrossQty"]);
objGRNFinishProduct.NetQty = Convert.ToDecimal(dt.Rows[i]["NetQty"]);
objGRNFinishProduct.Remarks = Convert.ToString(dt.Rows[i]["Remarks"]);
objGRNFinishProduct.UnitPrice = Convert.ToDecimal(dt.Rows[i]["UnitPrice"]);
objGRNFinishProductsCollec.Add(objGRNFinishProduct);
}
return(objGRNFinishProductsCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public StockGRN Get(long StockID, long GRNNO)
{
GRN_DL objGRNDL = new GRN_DL(Connection);
Stock_DL objStockDL = new Stock_DL(Connection);
StockGRN objStockGRN = new StockGRN();
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_StockID", StockID),
new SqlParameter("@Original_StockGRNNO", GRNNO)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_StockGRNByID", paramList);
objStockGRN.GRN = objGRNDL.Get(Convert.ToInt64(dt.Rows[0]["StockGRNNO"]));
objStockGRN.IssuedQty = Convert.ToInt64(dt.Rows[0]["StockIssuedQty"]);
objStockGRN.Stock = objStockDL.Get(Convert.ToInt64(dt.Rows[0]["StockID"]));
objStockGRN.StockGRNDate = Convert.ToDateTime(dt.Rows[0]["StockDate"]);
return(objStockGRN);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public MRIssueList Get(long MRNO, long StockID, long GRNNO)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@MRNO", MRNO),
new SqlParameter("@StockID", StockID),
new SqlParameter("@GRNNO", GRNNO)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MRIssueListByID", paramList);
MRIssueList objMRIssueList = new MRIssueList();
objMRIssueList.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[0]["GRNNO"]));
objMRIssueList.MR = objMR_DL.Get(Convert.ToInt64(dt.Rows[0]["MRNO"]));
objMRIssueList.Qty = Convert.ToDecimal(dt.Rows[0]["Qty"]);
objMRIssueList.Stock = objStock_DL.Get(Convert.ToInt64(dt.Rows[0]["StockID"]));
return(objMRIssueList);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public MTNTransferList Get(long MTNNO, long StcokID, long GRNNO)
{
MTN_DL objMTN_DL = new MTN_DL(Connection);
Stock_DL objStock_DL = new Stock_DL(Connection);
GRN_DL objGRN_DL = new GRN_DL(Connection);
MTNTransferList objMTNTransferList = new MTNTransferList();
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@Original_MTNNO", MTNNO),
new SqlParameter("@Original_StockID", StcokID),
new SqlParameter("@Original_GRNNO", GRNNO)
};
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_MTNTransferListByID", paramList);
objMTNTransferList.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[0]["GRNNO"]));
objMTNTransferList.MTN = objMTN_DL.Get(Convert.ToInt64(dt.Rows[0]["MTNNO"]));
objMTNTransferList.Stock = objStock_DL.Get(Convert.ToInt64(dt.Rows[0]["StockID"]));
objMTNTransferList.Qty = Convert.ToDecimal(dt.Rows[0]["StockID"]);
return(objMTNTransferList);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
