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