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); }
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))); }
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); }
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 common.clsWeb GetWeb(SqlDataReader drToRead) { // Set the Web and Page objects drToRead.Read(); clsWeb = new common.clsWeb(); clsWeb.WebID = int.Parse(drToRead["web_id"].ToString()); clsWeb.WebIDParent = int.Parse(drToRead["web_id_parent"].ToString()); clsWeb.WebGUID = drToRead["web_guid"].ToString(); clsWeb.Title = drToRead["web_title"].ToString(); clsWeb.MailFromAddress = drToRead["web_mail_from"].ToString(); clsWeb.PageFooter = drToRead["page_footer"].ToString(); clsWeb.PageIDHome = int.Parse(drToRead["page_id_home"].ToString()); clsWeb.PathToStylesheet = drToRead["path_to_stylesheet"].ToString(); clsWeb.PathToDocs = drToRead["path_to_docs"].ToString(); clsWeb.PathToImages = drToRead["path_to_images"].ToString(); clsWeb.Status = (common.Status) int.Parse(drToRead["web_status"].ToString()); clsWeb.Roles = this.GetRoles(clsWeb); clsWeb.Domains = this.GetDomains(clsWeb); clsPage = new common.clsPage(); clsPage.PageID = int.Parse(drToRead["page_id"].ToString()); clsPage.PageIDParent = int.Parse(drToRead["page_id_parent"].ToString()); clsPage.WebID = clsWeb.WebID; clsPage.WizardID = (drToRead["wizard_id"].ToString().Length > 0) ? int.Parse(drToRead["wizard_id"].ToString()) : 0; clsPage.SortOrder = int.Parse(drToRead["sort_order"].ToString()); clsPage.ShowOnMenu = bool.Parse(drToRead["yn_showonmenu"].ToString()); clsPage.IsNewsPage = bool.Parse(drToRead["yn_news"].ToString()); clsPage.IsNewsArchive = bool.Parse(drToRead["yn_news_archive"].ToString()); clsPage.Title = drToRead["page_title"].ToString(); clsPage.ControlID = (drToRead["control_id"].ToString().Length > 0) ? int.Parse(drToRead["control_id"].ToString()) : 0; clsPage.Control = (drToRead["page_control"].ToString().Length > 0) ? drToRead["page_control"].ToString() : null; clsPage.Image = (drToRead["page_image"].ToString().Length > 0) ? drToRead["page_image"].ToString() : null; clsPage.Body = (drToRead["page_body"].ToString().Length > 0) ? drToRead["page_body"].ToString() : null; clsPage.Roles = this.GetRoles(clsPage); drToRead.Close(); clsWeb.Page = clsPage; return(clsWeb); }
public common.clsPage WebPage_Update(common.clsPage Page, common.clsUser User) { return(this.SetWebPage(Page, User)); }
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 common.clsWeb GetWeb(SqlDataReader drToRead) { // Set the Web and Page objects drToRead.Read(); clsWeb = new common.clsWeb(); clsWeb.WebID = int.Parse(drToRead["web_id"].ToString()); clsWeb.WebIDParent = int.Parse(drToRead["web_id_parent"].ToString()); clsWeb.WebGUID = drToRead["web_guid"].ToString(); clsWeb.Title = drToRead["web_title"].ToString(); clsWeb.MailFromAddress = drToRead["web_mail_from"].ToString(); clsWeb.PageFooter = drToRead["page_footer"].ToString(); clsWeb.PageIDHome = int.Parse(drToRead["page_id_home"].ToString()); clsWeb.PathToStylesheet = drToRead["path_to_stylesheet"].ToString(); clsWeb.PathToDocs = drToRead["path_to_docs"].ToString(); clsWeb.PathToImages = drToRead["path_to_images"].ToString(); clsWeb.Status = (common.Status) int.Parse(drToRead["web_status"].ToString()); clsWeb.Roles = this.GetRoles(clsWeb); clsWeb.Domains = this.GetDomains(clsWeb); clsPage = new common.clsPage(); clsPage.PageID = int.Parse(drToRead["page_id"].ToString()); clsPage.PageIDParent = int.Parse(drToRead["page_id_parent"].ToString()); clsPage.WebID = clsWeb.WebID; clsPage.WizardID = (drToRead["wizard_id"].ToString().Length > 0) ? int.Parse(drToRead["wizard_id"].ToString()) : 0; clsPage.SortOrder = int.Parse(drToRead["sort_order"].ToString()); clsPage.ShowOnMenu = bool.Parse(drToRead["yn_showonmenu"].ToString()); clsPage.IsNewsPage = bool.Parse(drToRead["yn_news"].ToString()); clsPage.IsNewsArchive = bool.Parse(drToRead["yn_news_archive"].ToString()); clsPage.Title = drToRead["page_title"].ToString(); clsPage.ControlID = (drToRead["control_id"].ToString().Length > 0) ? int.Parse(drToRead["control_id"].ToString()) : 0; clsPage.Control = (drToRead["page_control"].ToString().Length > 0) ? drToRead["page_control"].ToString() : null; clsPage.Image = (drToRead["page_image"].ToString().Length > 0) ? drToRead["page_image"].ToString() : null; clsPage.Body = (drToRead["page_body"].ToString().Length > 0) ? drToRead["page_body"].ToString() : null; clsPage.Roles = this.GetRoles(clsPage); drToRead.Close(); clsWeb.Page = clsPage; return clsWeb; }
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; }