public override HYLAN_TASKDC LoadByPrimaryKey(DBConnection Connection, int TASK_TITLE_ID, int JOB_ID)
{
TASK_FIBER_POWER_DIGDC objTASK_FIBER_POWER_DIG = new TASK_FIBER_POWER_DIGDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_TASK_FIBER_POWER_DIGLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_JOB_ID", DbType.Int32, JOB_ID);
dbCommandWrapper.AddInParameter("p_TASK_TITLE_ID", DbType.Int32, TASK_TITLE_ID);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
objTASK_FIBER_POWER_DIG = (Utility.ConvertToObject <TASK_FIBER_POWER_DIGDC>(ds.Tables[0]));
if (ds.Tables.Count > 1)
{
HYLAN_TASKDC hylanTaskDC = (Utility.ConvertToObject <HYLAN_TASKDC>(ds.Tables[1]));
objTASK_FIBER_POWER_DIG.TASK_TITLE_ID = hylanTaskDC.TASK_TITLE_ID;
objTASK_FIBER_POWER_DIG.TASK_NAME = hylanTaskDC.TASK_NAME;
}
return(objTASK_FIBER_POWER_DIG);
}
private int Update(DBConnection Connection, TASK_FIBER_POWER_DIGDC objTASK_FIBER_POWER_DIG)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_TASK_FIBER_POWER_DIGUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_TASK_ID", DbType.Int32, objTASK_FIBER_POWER_DIG.TASK_ID);
dbCommandWrapper.AddInParameter("p_JOB_ID", DbType.Int32, objTASK_FIBER_POWER_DIG.JOB_ID);
dbCommandWrapper.AddInParameter("p_TASK_TITLE_ID", DbType.Int32, objTASK_FIBER_POWER_DIG.TASK_TITLE_ID);
dbCommandWrapper.AddInParameter("p_REQUIRED", DbType.String, objTASK_FIBER_POWER_DIG.REQUIRED);
dbCommandWrapper.AddInParameter("p_EST_START_DATE", DbType.DateTime, objTASK_FIBER_POWER_DIG.EST_START_DATE);
dbCommandWrapper.AddInParameter("p_ACT_START_DATE", DbType.DateTime, objTASK_FIBER_POWER_DIG.ACT_START_DATE);
dbCommandWrapper.AddInParameter("p_ACT_COMPLETION_DATE", DbType.DateTime, objTASK_FIBER_POWER_DIG.ACT_COMPLETION_DATE);
dbCommandWrapper.AddInParameter("p_EST_LENGTH", DbType.Int32, objTASK_FIBER_POWER_DIG.EST_LENGTH);
dbCommandWrapper.AddInParameter("p_ACT_LENGTH", DbType.Int32, objTASK_FIBER_POWER_DIG.ACT_LENGTH);
dbCommandWrapper.AddInParameter("p_ON_HOLD_REASON", DbType.Int32, objTASK_FIBER_POWER_DIG.ON_HOLD_REASON);
dbCommandWrapper.AddInParameter("p_ON_HOLD_OTHER", DbType.String, objTASK_FIBER_POWER_DIG.ON_HOLD_OTHER);
dbCommandWrapper.AddInParameter("p_NOTES", DbType.String, objTASK_FIBER_POWER_DIG.NOTES);
dbCommandWrapper.AddInParameter("p_FIBER_DIG_VAULT", DbType.Int32, objTASK_FIBER_POWER_DIG.FIBER_DIG_VAULT);
dbCommandWrapper.AddInParameter("p_FIBER_DIG_TYPE", DbType.Int32, objTASK_FIBER_POWER_DIG.FIBER_DIG_TYPE);
dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objTASK_FIBER_POWER_DIG.CREATED_ON);
dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objTASK_FIBER_POWER_DIG.CREATED_BY);
dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objTASK_FIBER_POWER_DIG.MODIFIED_ON);
dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objTASK_FIBER_POWER_DIG.MODIFIED_BY);
dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objTASK_FIBER_POWER_DIG.LOCK_COUNTER);
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objTASK_FIBER_POWER_DIG.IsDirty = IsDirty = true;
}
return(updateCount);
}
private int Delete(DBConnection Connection, TASK_FIBER_POWER_DIGDC objTASK_FIBER_POWER_DIG)
{
int deleteCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_TASK_FIBER_POWER_DIGDelete");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_TASK_ID", DbType.Int32, objTASK_FIBER_POWER_DIG.TASK_ID);
if (Connection.Transaction != null)
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(deleteCount);
}
