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