public GRNMaterialsCollec Get() { try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_GRNMaterials"); GRNMaterialsCollec objGRNMatCollec = new GRNMaterialsCollec(); for (int i = 0; i < dt.Rows.Count; i++) { GRNMaterials objGRNMaterial = new GRNMaterials(); objGRNMaterial.GRN = objGRN_DL.Get(Convert.ToInt64(dt.Rows[i]["GRNNO"])); objGRNMaterial.GrossQty = Convert.ToDecimal(dt.Rows[i]["GrossQty"]); objGRNMaterial.Material = objMaterial_DL.Get(Convert.ToString(dt.Rows[i]["MaterialCode"])); objGRNMaterial.NetQty = Convert.ToDecimal(dt.Rows[i]["NetQty"]); objGRNMaterial.Remarks = Convert.ToString(dt.Rows[i]["Remarks"]); objGRNMaterial.UnitPrice = Convert.ToDecimal(dt.Rows[i]["UnitPrice"]); objGRNMatCollec.Add(objGRNMaterial); } return(objGRNMatCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }