/// <summary> /// Read Current Page subtabs /// </summary> /// <param name="PageID">The page ID.</param> /// <returns>PagesBox</returns> public static PagesBox GetPageSettingsPagesBox(int PageID) { // Create Instance of Connection and Command Object using (SqlConnection myConnection = Config.SqlConnectionString) { using (SqlCommand myCommand = new SqlCommand("rb_GetTabSettings", myConnection)) { // Mark the Command as a SPROC myCommand.CommandType = CommandType.StoredProcedure; //PageID passed type FIXED by Bill Anderson (reedtek) //see: http://sourceforge.net/tracker/index.php?func=detail&aid=813789&group_id=66837&atid=515929 // Add Parameters to SPROC SqlParameter parameterPageID = new SqlParameter("@PageID", SqlDbType.Int); parameterPageID.Value = PageID; myCommand.Parameters.Add(parameterPageID); // The new paramater "PortalLanguage" has been added to sp rb_GetPageSettings // Onur Esnaf SqlParameter parameterPortalLanguage = new SqlParameter("@PortalLanguage", SqlDbType.NVarChar, 12); parameterPortalLanguage.Value = Thread.CurrentThread.CurrentUICulture.Name; myCommand.Parameters.Add(parameterPortalLanguage); // Open the database connection and execute the command myConnection.Open(); using (SqlDataReader result = myCommand.ExecuteReader(CommandBehavior.CloseConnection)) { PagesBox tabs = new PagesBox(); try { while (result.Read()) { PageStripDetails tabDetails = new PageStripDetails(); tabDetails.PageID = (int)result["PageID"]; Hashtable cts = new PageSettings().GetPageCustomSettings(tabDetails.PageID); tabDetails.PageImage = cts["CustomMenuImage"].ToString(); tabDetails.ParentPageID = Int32.Parse("0" + result["ParentPageID"]); tabDetails.PageName = (string)result["PageName"]; tabDetails.PageOrder = (int)result["PageOrder"]; tabDetails.AuthorizedRoles = (string)result["AuthorizedRoles"]; tabs.Add(tabDetails); } } finally { result.Close(); //by Manu, fixed bug 807858 } return(tabs); } } } }
/// <summary> /// Add /// </summary> /// <param name="t">The t.</param> /// <returns></returns> public int Add(PageStripDetails t) { return(InnerList.Add(t)); }