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); } }
public RPDBatchActivityInstructions Get(long ID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@RPDBatchActivityInstructionsID", ID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_RPDBatchActivityInstructions_By_ID", paramList); RPDBatchActivityInstructions obj = new RPDBatchActivityInstructions(); if (dt.Rows.Count > 0) { obj.ID = Convert.ToInt64(dt.Rows[0]["RPDBatchActivityInstructionsID"]); obj.RPDBatch = objRPDBatch_DL.Get(Convert.ToString(dt.Rows[0]["BatchNo"])); obj.Activity = objMainActivity_DL.Get(Convert.ToInt64(dt.Rows[0]["ActivityID"])); obj.Machine = objMachine_DL.Get(Convert.ToString(dt.Rows[0]["MachineID"])); obj.ParticleSize = Convert.ToString(dt.Rows[0]["ParticleSize"]); obj.Description = Convert.ToString(dt.Rows[0]["InstructionDesc"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public ActivityMachineCollec Get(Activity objActivity) { ActivityMachineCollec objActivityMachineCollec = new ActivityMachineCollec(); Activity_DL objActivityDL = new Activity_DL(Connection); Machine_DL objMachineDL = new Machine_DL(Connection); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@ActID", objActivity.ActivityID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_ActivityMachine_By_ActID", paramList); for (int i = 0; i < dt.Rows.Count; i++) { ActivityMachine obj = new ActivityMachine(); if (dt.Rows[i]["ActID"] != null) { obj.Activity = objActivityDL.Get(Convert.ToInt64(dt.Rows[i]["ActID"])); } if (dt.Rows[i]["MachineID"] != null) { obj.Machine = objMachineDL.Get(Convert.ToString(dt.Rows[i]["MachineID"])); } obj.EstimatedHour = Convert.ToDecimal(dt.Rows[i]["EstimatedHours"]); objActivityMachineCollec.Add(obj); } return(objActivityMachineCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }