/// <summary>
/// Updates a TOCBAK record and returns the number of records affected
/// </summary>
public static int Update(TOCBAKDO DO)
{
SqlParameter _TOCID = new SqlParameter("TOCID", SqlDbType.Int);
SqlParameter _ParentTOCID = new SqlParameter("ParentTOCID", SqlDbType.Int);
SqlParameter _Description = new SqlParameter("Description", SqlDbType.VarChar);
SqlParameter _NavigateUrl = new SqlParameter("NavigateUrl", SqlDbType.VarChar);
SqlParameter _Instructions = new SqlParameter("Instructions", SqlDbType.VarChar);
SqlParameter _Active = new SqlParameter("Active", SqlDbType.Bit);
SqlParameter _DisplayOrder = new SqlParameter("DisplayOrder", SqlDbType.SmallInt);
_TOCID.Value = DO.TOCID;
_ParentTOCID.Value = DO.ParentTOCID;
_Description.Value = DO.Description;
_NavigateUrl.Value = DO.NavigateUrl;
_Instructions.Value = DO.Instructions;
_Active.Value = DO.Active;
_DisplayOrder.Value = DO.DisplayOrder;
SqlParameter[] _params = new SqlParameter[] {
_TOCID,
_ParentTOCID,
_Description,
_NavigateUrl,
_Instructions,
_Active,
_DisplayOrder
};
string pid = ConfigurationManager.AppSettings["PID"];
return DataCommon.ExecuteScalar(String.Format("[{0}].[TOCBAK_Update]", pid), _params, pid);
}
/// <summary>
/// Gets all TOCBAK records
/// </summary>
public static TOCBAKDO[] GetAll()
{
string pid = ConfigurationManager.AppSettings["PID"];
SafeReader sr = DataCommon.ExecuteSafeReader(String.Format("[{0}].[TOCBAK_GetAll]", pid), new SqlParameter[] { }, pid);
List<TOCBAKDO> objs = new List<TOCBAKDO>();
while(sr.Read()){
TOCBAKDO obj = new TOCBAKDO();
obj.TOCID = sr.GetInt32(sr.GetOrdinal("TOCID"));
obj.ParentTOCID = sr.GetInt32(sr.GetOrdinal("ParentTOCID"));
obj.Description = sr.GetString(sr.GetOrdinal("Description"));
obj.NavigateUrl = sr.GetString(sr.GetOrdinal("NavigateUrl"));
obj.Instructions = sr.GetString(sr.GetOrdinal("Instructions"));
obj.Active = sr.GetBoolean(sr.GetOrdinal("Active"));
if (sr.IsDBNull(sr.GetOrdinal("DisplayOrder"))) { obj.DisplayOrder = null; } else { obj.DisplayOrder = sr.GetInt16(sr.GetOrdinal("DisplayOrder")); }
objs.Add(obj);
}
return objs.ToArray();
}
/// <summary>
/// Deletes a TOCBAK record
/// </summary>
public static int Delete(TOCBAKDO DO)
{
SqlParameter[] _params = new SqlParameter[] {
};
string pid = ConfigurationManager.AppSettings["PID"];
return DataCommon.ExecuteScalar(String.Format("[{0}].[TOCBAK_Delete]", pid), _params, pid);
}
