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