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