public void Add(int _pageid, int _applicationid) { if (logging == true) { oLog.Add("Add application page " + oPage.GetName(_pageid) + " and application " + oApplication.GetName(_applicationid)); } arParams = new SqlParameter[2]; arParams[0] = new SqlParameter("@pageid", _pageid); arParams[1] = new SqlParameter("@applicationid", _applicationid); SqlHelper.ExecuteNonQuery(dsn, CommandType.StoredProcedure, "pr_addAppPage", arParams); }
public void Update(int _id, string _placeholder, int _pageid, int _display, int _enabled) { Pages oPage = new Pages(user, dsn); if (logging == true) { oLog.Add("Update page control on page " + oPage.GetName(_pageid)); } arParams = new SqlParameter[5]; arParams[0] = new SqlParameter("@id", _id); arParams[1] = new SqlParameter("@placeholder", _placeholder); arParams[2] = new SqlParameter("@pageid", _pageid); arParams[3] = new SqlParameter("@display", _display); arParams[4] = new SqlParameter("@enabled", _enabled); SqlHelper.ExecuteNonQuery(dsn, CommandType.StoredProcedure, "pr_updatePageControl", arParams); }
public int Add(int _schemaid, string _placeholder, int _pageid, int _display, int _enabled) { Pages oPage = new Pages(user, dsn); if (logging == true) { oLog.Add("Add page control to page " + oPage.GetName(_pageid)); } arParams = new SqlParameter[6]; arParams[0] = new SqlParameter("@schemaid", _schemaid); arParams[1] = new SqlParameter("@placeholder", _placeholder); arParams[2] = new SqlParameter("@pageid", _pageid); arParams[3] = new SqlParameter("@display", _display); arParams[4] = new SqlParameter("@enabled", _enabled); arParams[5] = new SqlParameter("@id", SqlDbType.Int); arParams[5].Direction = ParameterDirection.Output; SqlHelper.ExecuteNonQuery(dsn, CommandType.StoredProcedure, "pr_addPageControl", arParams); return(Int32.Parse(arParams[5].Value.ToString())); }