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