public string[] GetRoles(common.clsWeb Web)
{
spParams = new object[1];
spParams.SetValue(Web.WebID, 0);
return this.GetRoles( data.SqlHelper.ExecuteReader(this.strConn, "prc_ROLE_WEB_sel", spParams) );
}
public DataSet GetWebMenu(common.clsUser User)
{
spParams = new object[2];
spParams.SetValue(User.WebID, 0);
spParams.SetValue(User.UserID, 1);
return data.SqlHelper.ExecuteDataset(this.strConn, "prc_WEB_MENU_sel", spParams);
}
private string[] GetRoles(common.clsPage Page)
{
spParams = new object[1];
spParams.SetValue(Page.PageID, 0);
return this.GetRoles( data.SqlHelper.ExecuteReader(this.strConn, "prc_ROLE_WEB_PAGE_sel", spParams) );
}
private common.clsPage SetWebPage(common.clsPage Page, common.clsUser User)
{
string strPageRoles = this.GetSqlSplitString(Page.Roles);
// Try to insert/update WEB_PAGE
common.clsPage clsPage = new common.clsPage();
spParams = new object[13];
spParams.SetValue(Page.PageID, 0);
spParams.SetValue(Page.PageIDParent, 1);
spParams.SetValue(Page.WebID, 2);
spParams.SetValue(Page.SortOrder, 3);
spParams.SetValue(Page.ShowOnMenu, 4);
spParams.SetValue(Page.IsNewsPage, 5);
spParams.SetValue(Page.IsNewsArchive, 6);
spParams.SetValue(Page.Title, 7);
spParams.SetValue(Page.Image, 8);
spParams.SetValue(Page.ControlID, 9);
spParams.SetValue(Page.Body, 10);
spParams.SetValue(strPageRoles, 11);
spParams.SetValue(User.UserID, 12);
// Read data out to populate the return Page object
dr = data.SqlHelper.ExecuteReader(this.strConn, "prc_WEB_PAGE_ins_upd", spParams);
dr.Read();
boolResult = bool.Parse(dr["Result"].ToString());
strMessage = "\r\t\t" + dr["MessageOut"].ToString() + "<br>";
Page.PageID = int.Parse(dr["page_id"].ToString());
dr.Close();
clsPage.PageID = Page.PageID;
clsPage.PageIDParent = Page.PageIDParent;
clsPage.WebID = Page.WebID;
clsPage.SortOrder = Page.SortOrder;
clsPage.ShowOnMenu = Page.ShowOnMenu;
clsPage.IsNewsPage = Page.IsNewsPage;
clsPage.IsNewsArchive = Page.IsNewsArchive;
clsPage.Title = Page.Title;
clsPage.Image = Page.Image;
clsPage.ControlID = Page.ControlID;
clsPage.Body = Page.Body;
return clsPage;
}
private string[] GetDomains(common.clsWeb Web)
{
spParams = new object[1];
spParams.SetValue(Web.WebID, 0);
SqlDataReader drDomains = data.SqlHelper.ExecuteReader(this.strConn, "prc_WEB_HOST_sel", spParams);
StringBuilder sbDomains = new StringBuilder("");
string strDomains;
string[] arrDomains;
while(drDomains.Read()) { sbDomains.Append(drDomains["web_host_url"].ToString() + "|"); }
drDomains.Close();
strDomains = sbDomains.ToString();
if (strDomains.Length > 0)
{
strDomains = strDomains.Remove(strDomains.Length-1, 1);
arrDomains = strDomains.Split(new char[]{'|'});
return arrDomains;
}
return new string[0];
}
public common.clsWeb Web_Update(common.clsWeb Web, common.clsUser User)
{
string strWebHosts = this.GetSqlSplitString(Web.Domains);
string strWebRoles = this.GetSqlSplitString(Web.Roles);
// Try to insert new Web
spParams = new object[7];
spParams.SetValue(Web.WebID, 0);
spParams.SetValue(User.UserID, 1);
spParams.SetValue(Web.Title, 2);
spParams.SetValue(Web.MailFromAddress, 3);
spParams.SetValue(Web.PageFooter, 4);
spParams.SetValue(strWebHosts, 5);
spParams.SetValue(strWebRoles, 6);
// Read data out to set the return Web object
dr = data.SqlHelper.ExecuteReader(this.strConn, "prc_WEB_ins_upd", spParams);
dr.Read();
boolResult = bool.Parse(dr["Result"].ToString());
strMessage = "\r\r\t" + dr["MessageOut"].ToString() + "<br>";
Web.WebID = int.Parse(dr["web_id"].ToString());
Web.WebGUID = dr["web_guid"].ToString();
common.clsPage clsPage = new common.clsPage();
clsPage.PageID = int.Parse(dr["page_id"].ToString());
clsPage.PageIDParent = clsPage.PageID;
Web.Page = clsPage;
dr.Close();
return Web;
}
public bool Web_Delete(common.clsWeb Web)
{
spParams = new object[1];
spParams.SetValue(Web.WebID, 0);
this.GetSqlTransResult( data.SqlHelper.ExecuteReader(strConn, "prc_WEB_del", spParams) );
return boolResult;
}
public common.clsPage WebPage_Update(common.clsPage Page, common.clsUser User)
{
return this.SetWebPage(Page, User);
}
public bool WebPage_Delete(common.clsPage Page)
{
spParams = new object[1];
spParams.SetValue(Page.PageID, 0);
this.GetSqlTransResult( data.SqlHelper.ExecuteReader(strConn, "prc_WEB_PAGE_del", spParams) );
return boolResult;
}
