public RPDActivityMachineCollec Get()
{
try
{
DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_RPDActivityMachine");
RPDActivityMachineCollec objCollec = new RPDActivityMachineCollec();
RPDActivityMachine obj = new RPDActivityMachine();
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
obj.ActivityID = Convert.ToString(dt.Rows[i]["ActID"]);
obj.MachineCode = Convert.ToString(dt.Rows[i]["MachineID"]);
obj.CostPerMachineHour = Convert.ToDecimal(dt.Rows[i]["CostPerMachineHour"]);
obj.CostPerManHour = Convert.ToDecimal(dt.Rows[i]["CostPerManHour"]);
objCollec.Add(obj);
}
}
return(objCollec);
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Add(RPDActivityMachine objRPDActivityMachine)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@ActID", objRPDActivityMachine.ActivityID),
new SqlParameter("@MachineID", objRPDActivityMachine.MachineCode),
new SqlParameter("@CostPerMachineHour", objRPDActivityMachine.CostPerMachineHour),
new SqlParameter("@CostPerManHour", objRPDActivityMachine.CostPerManHour)
};
return(Execute.RunSP_RowsEffected(Connection, "SPADD_RPDActivityMachine", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public int Update(RPDActivityMachine objRPDActivityMachine, long Original_ActID, string Original_MachineCode)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@ActID", objRPDActivityMachine.ActivityID),
new SqlParameter("@MachineID", objRPDActivityMachine.MachineCode),
new SqlParameter("@CostPerMachineHour", objRPDActivityMachine.CostPerMachineHour),
new SqlParameter("@CostPerManHour", objRPDActivityMachine.CostPerManHour),
new SqlParameter("@Original_ActID", objRPDActivityMachine.ActivityID),
new SqlParameter("@Original_MachineID", objRPDActivityMachine.MachineCode)
};
return(Execute.RunSP_RowsEffected(Connection, "SPUPDATE_RPDActivityMachine", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
