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