public PRPDBatchActivityInstructions.PRPDBatchActivityInstructionsCollec Get() { try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PRPDBatchActivityInstructions"); PRPDBatchActivityInstructions.PRPDBatchActivityInstructionsCollec objCollec = new PRPDBatchActivityInstructions.PRPDBatchActivityInstructionsCollec(); PRPDBatchActivityInstructions obj = new PRPDBatchActivityInstructions(); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { obj.PRPDBatchActivityInstructionsID = Convert.ToInt64(dt.Rows[i]["PRPDBatchActivityInstructionsID"]); obj.PRPDBatch = objPRPDBatch_DL.Get(Convert.ToString(dt.Rows[i]["PRPDBatchID"])); obj.Machine = objMachine_DL.Get(Convert.ToString(dt.Rows[i]["MachineID"])); obj.Activity = objMainActivity_DL.Get(Convert.ToInt64(dt.Rows[i]["ActivityID"])); obj.ActivityID = Convert.ToInt64(dt.Rows[i]["ActivityID"]); obj.MachineCode = Convert.ToString(dt.Rows[i]["MachineID"]); obj.ParticleSize = Convert.ToString(dt.Rows[i]["ParticleSize"]); obj.InstructionDesc = Convert.ToString(dt.Rows[i]["InstructionDesc"]); objCollec.Add(obj); } } return(objCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }