protected void btnDisableDashboardhelp_Click(object sender, EventArgs e)
 {
     try
     {
         SettingProvider objSettingProvider = new SettingProvider();
         objSettingProvider.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.EnableDasboardHelp, "false", GetUsername, GetPortalID.ToString());
         divDashboardHelp.Visible = false;
         ShowMessage("", GetSageMessage("DashboardHelp", "Cancelled"), "", SageMessageType.Success);
     }
     catch (Exception exec)
     {
         ProcessException(exec);
     }
 }
    private void SaveSettings()
    {
        try
        {
            if (txtvalue.Text.Trim() != string.Empty)
            {
                SettingProvider sp = new SettingProvider();
                sp.GoogleAnalyticsAddUpdate(txtvalue.Text, chkIsActive.Checked, GetPortalID, GetUsername);
                HttpRuntime.Cache.Remove(CacheKeys.SageGoogleAnalytics);
                AlertUpdate();
                BindData();
            }
            else
            {
                ShowMessage("", GetSageMessage("WebAnalytics", "PleaseFillJSCodeProvidedByGoogle"), "", SageMessageType.Alert);
            }

        }
        catch (Exception ex)
        {
            ProcessException(ex);
        }
    }
        public string GetSettingsByKeyIndividual(string Key)
        {
            try
            {
                string strValue = string.Empty;
                SettingProvider sep = new SettingProvider();
                Hashtable hst = new Hashtable();
                if (HttpRuntime.Cache[CacheKeys.SageSetting] != null)
                {
                    hst = (Hashtable)HttpRuntime.Cache[CacheKeys.SageSetting];
                }
                else
                {
                    DataTable dt = sep.GetSettingsByPortal("1", string.Empty); //GetSettingsByPortal();
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        for (int i = 0; i < dt.Rows.Count; i++)
                        {
                            hst.Add(dt.Rows[i]["SettingKey"].ToString(), dt.Rows[i]["SettingValue"].ToString());
                        }
                    }
                }
                //need to be cleared when any key is chnaged
                HttpRuntime.Cache.Insert(CacheKeys.SageSetting, hst);//
                strValue = hst[SettingPortal + "." + Key].ToString();
                return strValue;
            }

            catch (Exception e)
            {
                throw e;
            }
        }
 protected void rdRight_CheckedChanged(object sender, EventArgs e)
 {
     divSideBar.Attributes.Remove("style");
     divSideBar.Attributes.Add("style", "float:right");
     divSideBar.Attributes.Add("class", "sideBarRight");
     SettingProvider sageSP = new SettingProvider();
     sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.AdminSidebarPosition, "right", GetUsername, GetPortalID.ToString());
 }
Example #5
0
 private Hashtable GetPortals()
 {
     
     Hashtable hstAll = new Hashtable();
     if (HttpContext.Current.Cache["Portals"] != null)
     {
         hstAll = (Hashtable)HttpContext.Current.Cache["Portals"];
     }
     else
     {
         SettingProvider objSP = new SettingProvider();
         List<SagePortals> sagePortals = objSP.PortalGetList();
         foreach (SagePortals portal in sagePortals)
         {
             hstAll.Add(portal.SEOName.ToLower().Trim(), portal.PortalID);
         }
     }
     HttpContext.Current.Cache.Insert("Portals", hstAll);
     return hstAll;
 }
 /// <summary>
 /// Get PortalID And Respective Name List
 /// </summary>
 /// <returns>PortalID And PortalName</returns>
 public Hashtable GetPortals()
 {
     Hashtable hstAll = new Hashtable();
     if (HttpRuntime.Cache[CacheKeys.Portals] != null)
     {
         hstAll = (Hashtable)HttpRuntime.Cache[CacheKeys.Portals];
     }
     else
     {
         SettingProvider objSP = new SettingProvider();
         List<SagePortals> sagePortals = objSP.PortalGetList();
         foreach (SagePortals portal in sagePortals)
         {
             hstAll.Add(portal.SEOName.Replace("https://", "").Replace("http://", "").ToLower().Trim(), portal.PortalID);
         }
     }
     HttpRuntime.Cache.Insert(CacheKeys.Portals, hstAll);
     return hstAll;
 }
        private Hashtable GetAllSettings()
        {

            SettingProvider objSettingProvider = new SettingProvider();
            DataSet objData = objSettingProvider.GetAllSettings(GetPortalID.ToString(), string.Empty);
            Hashtable hstall = new Hashtable();
            DataTable dt = new DataTable();
            if (objData != null && objData.Tables != null && objData.Tables[0] != null)
            {
                dt = objData.Tables[0];
            }
            if (dt != null && dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    try
                    {
                        hstall.Add(dt.Rows[i]["SettingKey"].ToString(), dt.Rows[i]["SettingValue"].ToString());
                    }
                    catch
                    {
                        throw;
                    }

                }
            }
            return hstall;
        }
 protected void rptrTemplates_ItemCommand(object source, RepeaterCommandEventArgs e)
 {
     if (e.CommandName.Equals("Activate"))
     {
         int TemplateID = int.Parse(e.CommandArgument.ToString());
         Label lbl = (Label)e.Item.FindControl("lblTemplateTitle");
         SettingProvider sageSP = new SettingProvider();
         sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.PortalCssTemplate, lbl.Text, GetUsername, GetPortalID.ToString());
         SageFrameConfig sfConfig = new SageFrameConfig();
         sfConfig.ResetSettingKeys(GetPortalID);
         BindTemplate();
     }
     else if (e.CommandName.Equals("DeleteTemplate"))
     {
         string[] args = e.CommandArgument.ToString().Split('_');
         string templateName = args[0];
         if (templateName.ToLower() == "default")
         {
             ShowMessage(SageMessageTitle.Notification.ToString(), GetSageMessage("TemplateManagement", "TemplateCannotDeleted"), "", SageMessageType.Alert);
         }
         else
         {
             if (DeleteTemplate(Int32.Parse(args[1].ToString())))
             {
                 string templateFolderPath = HttpContext.Current.Server.MapPath("~/") + "Templates\\" + args[0];
                 DeleteDirectory(templateFolderPath);
                 BindTemplate();
                 PanelVisibility(false, true);
             }
         }
     }
 }
 /// <summary>
 /// Return boolean setting value based upon individual key. 
 /// </summary>
 /// <param name="settingKey">Application setting key.</param>
 /// <returns>SettingValue based upon individual key.</returns>
 public bool GetSettingBoolValueByIndividualKey(string settingKey)
 {
     bool value = false;
     try
     {
         SettingProvider objSetting = new SettingProvider();
         KeyValue objValue = objSetting.GetSettingValueByIndividualKey(settingKey, GetPortalID);
         if (objValue != null && objValue.Value != null)
         {
             value = bool.Parse(objValue.Value);
         }
     }
     catch (Exception e)
     {
         throw e;
     }
     return value;
 }
 /// <summary>
 /// Return string SettingValue based on application setting key.
 /// </summary>
 /// <param name="settingKey">Application setting key.</param>
 /// <returns>SettingValue based on application setting key.</returns>
 public string GetSettingValueByIndividualKey(string settingKey)
 {
     string value = string.Empty;
     try
     {
         SettingProvider objSetting = new SettingProvider();
         KeyValue objValue = objSetting.GetSettingValueByIndividualKey(settingKey, GetPortalID);
         if (objValue != null && objValue.Value != null)
         {
             value = objValue.Value;
         }
     }
     catch (Exception e)
     {
         throw e;
     }
     return value;
 }
        private void SaveSettings()
        {
            try
            {
                StringBuilder sbSettingKey = new StringBuilder();
                StringBuilder sbSettingValue = new StringBuilder();
                StringBuilder sbSettingType = new StringBuilder();

                //Collecting Setting Values
                sbSettingKey.Append(SageFrameSettingKeys.SuperUserPortalId + ",");
                sbSettingValue.Append(ddlHostPortal.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.SuperUserTitle                
                sbSettingKey.Append(SageFrameSettingKeys.SuperUserTitle + ",");
                sbSettingValue.Append(txtHostTitle.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.SuperUserURL
                sbSettingKey.Append(SageFrameSettingKeys.SuperUserURL + ",");
                sbSettingValue.Append(txtHostUrl.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.SuperUserEmail
                sbSettingKey.Append(SageFrameSettingKeys.SuperUserEmail + ",");
                sbSettingValue.Append(txtHostEmail.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.SuperUserCopyright
                sbSettingKey.Append(SageFrameSettingKeys.SuperUserCopyright + ",");
                sbSettingValue.Append(chkCopyright.Checked + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.UseCustomErrorMessages
                sbSettingKey.Append(SageFrameSettingKeys.UseCustomErrorMessages + ",");
                sbSettingValue.Append(chkUseCustomErrorMessages.Checked + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.SageFrameCSS
                sbSettingKey.Append(SageFrameSettingKeys.SageFrameCSS + ",");
                sbSettingValue.Append(ddlTemplate.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.PaymentProcessor
                //sbSettingKey.Append(SageFrameSettingKeys.PaymentProcessor + ",");
                //sbSettingValue.Append(ddlPaymentProcessor.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.ProcessorUserId
                //sbSettingKey.Append(SageFrameSettingKeys.ProcessorUserId + ",");
                //sbSettingValue.Append(txtPaymentProcessorUserID.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.ProcessorPassword
                //sbSettingKey.Append(SageFrameSettingKeys.ProcessorPassword + ",");
                //sbSettingValue.Append(txtPaymentProcessorPassword.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.SuperUserFee
                //sbSettingKey.Append(SageFrameSettingKeys.SuperUserFee + ",");
                //sbSettingValue.Append(txtHostingFee.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.SuperUserCurrency
                //sbSettingKey.Append(SageFrameSettingKeys.SuperUserCurrency + ",");
                //sbSettingValue.Append(ddlHostingCurrency.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.SuperUserSpace
                //sbSettingKey.Append(SageFrameSettingKeys.SuperUserSpace + ",");
                //sbSettingValue.Append(txtHostingSpace.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.PageQuota
                //sbSettingKey.Append(SageFrameSettingKeys.PageQuota + ",");
                //sbSettingValue.Append(txtPageQuota.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.UserQuota
                //sbSettingKey.Append(SageFrameSettingKeys.UserQuota + ",");
                //sbSettingValue.Append(txtUserQuota.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.DemoPeriod
                //sbSettingKey.Append(SageFrameSettingKeys.DemoPeriod + ",");
                //sbSettingValue.Append(txtDemoPeriod.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.DemoSignup
                //sbSettingKey.Append(SageFrameSettingKeys.DemoSignup + ",");
                //sbSettingValue.Append(chkAnonymousDemoSignup.Checked + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.UseFriendlyUrls
                sbSettingKey.Append(SageFrameSettingKeys.UseFriendlyUrls + ",");
                sbSettingValue.Append(chkUseFriendlyUrls.Checked + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.ProxyServer
                //sbSettingKey.Append(SageFrameSettingKeys.ProxyServer + ",");
                //sbSettingValue.Append(txtProxyServer.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.ProxyPort
                //sbSettingKey.Append(SageFrameSettingKeys.ProxyPort + ",");
                //sbSettingValue.Append(txtProxyPort.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.ProxyUsername
                //sbSettingKey.Append(SageFrameSettingKeys.ProxyUsername + ",");
                //sbSettingValue.Append(txtProxyUsername.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.ProxyPassword
                //sbSettingKey.Append(SageFrameSettingKeys.ProxyPassword + ",");
                //sbSettingValue.Append(txtProxyPassword.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.WebRequestTimeout
                //sbSettingKey.Append(SageFrameSettingKeys.WebRequestTimeout + ",");
                //sbSettingValue.Append(txtWebRequestTimeOut.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.SMTPServer
                sbSettingKey.Append(SageFrameSettingKeys.SMTPServer + ",");
                sbSettingValue.Append(txtSMTPServerAndPort.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.SMTPAuthentication
                sbSettingKey.Append(SageFrameSettingKeys.SMTPAuthentication + ",");
                sbSettingValue.Append(rblSMTPAuthentication.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.SMTPEnableSSL
                sbSettingKey.Append(SageFrameSettingKeys.SMTPEnableSSL + ",");
                sbSettingValue.Append(chkSMTPEnableSSL.Checked + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.SMTPUsername
                sbSettingKey.Append(SageFrameSettingKeys.SMTPUsername + ",");
                sbSettingValue.Append(txtSMTPUserName.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.SMTPPassword
                sbSettingKey.Append(SageFrameSettingKeys.SMTPPassword + ",");
                sbSettingValue.Append(txtSMTPPassword.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.jQueryDebug
                //sbSettingKey.Append(SageFrameSettingKeys.jQueryDebug + ",");
                //sbSettingValue.Append(chkUseJQueryDebugVersion.Checked + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.jQuerySuperUsered
                //sbSettingKey.Append(SageFrameSettingKeys.jQuerySuperUsered + ",");
                //sbSettingValue.Append(chkUseHostedJQueryVersion.Checked + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                ////SageFrameSettingKeys.jQueryUrl
                //sbSettingKey.Append(SageFrameSettingKeys.jQueryUrl + ",");
                //sbSettingValue.Append(txtHostedJQueryURL.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.FileExtensions
                sbSettingKey.Append(SageFrameSettingKeys.FileExtensions + ",");
                sbSettingValue.Append(txtFileExtensions.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                //SageFrameSettingKeys.HelpURL
                sbSettingKey.Append(SageFrameSettingKeys.HelpURL + ",");
                sbSettingValue.Append(txtHelpUrl.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SuperUser + ",");

                string SettingTypes = sbSettingType.ToString();
                if (SettingTypes.Contains(","))
                {
                    SettingTypes = SettingTypes.Remove(SettingTypes.LastIndexOf(","));
                }
                string SettingKeys = sbSettingKey.ToString();
                if (SettingKeys.Contains(","))
                {
                    SettingKeys = SettingKeys.Remove(SettingKeys.LastIndexOf(","));
                }
                string SettingValues = sbSettingValue.ToString();
                if (SettingValues.Contains(","))
                {
                    SettingValues = SettingValues.Remove(SettingValues.LastIndexOf(","));
                }
                SettingProvider sageSP = new SettingProvider();
                sageSP.SaveSageSettings(SettingTypes, SettingKeys, SettingValues, GetUsername, "1");
                HttpContext.Current.Cache.Remove("SageSetting");               
                BindData();
                ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("PortalSettings", "SettingUpdatedSuccessfully"), "", SageMessageType.Success);
            }
            catch (Exception ex)
            {
                ProcessException(ex);
                lblError.Text = ex.Message;
            }
        }
        private void SavePortalSettings()
        {
            try
            {
                SettingProvider sageSP = new SettingProvider();
                //Add Single Key Values that may contain Comma values so need to be add sepratly
                #region "Single Key Value Add/Updatge"

                //SageFrameSettingKeys.PageTitle
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.PageTitle,
                    txtPortalTitle.Text.Trim(), GetUsername, GetPortalID.ToString());

                //SageFrameSettingKeys.MetaDescription
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.MetaDescription,
                    txtDescription.Text, GetUsername, GetPortalID.ToString());

                //SageFrameSettingKeys.MetaKeywords
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.MetaKeywords,
                    txtKeyWords.Text, GetUsername, GetPortalID.ToString());

                //SageFrameSettingKeys.PortalLogoTemplate
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.PortalLogoTemplate,
                    txtLogoTemplate.Text.Trim(), GetUsername, GetPortalID.ToString());

                //SageFrameSettingKeys.PortalCopyright
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.PortalCopyright,
                    txtCopyright.Text.Trim(), GetUsername, GetPortalID.ToString());

                //SageFrameSettingKeys.PortalTimeZone
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.PortalTimeZone,
                    ddlPortalTimeZone.SelectedItem.Value, GetUsername, GetPortalID.ToString());

                #endregion

                //For Multiple Keys and Values
                #region "Multiple Key Value Add/Update"

                StringBuilder sbSettingKey = new StringBuilder();
                StringBuilder sbSettingValue = new StringBuilder();
                StringBuilder sbSettingType = new StringBuilder();

                //Collecting Setting Values
                

                //SageFrameSettingKeys.SiteAdminEmailAddress
                sbSettingKey.Append(SageFrameSettingKeys.SiteAdminEmailAddress + ",");
                sbSettingValue.Append(txtSiteAdminEmailAddress.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalUserProfileMaxImageSize
                //sbSettingKey.Append(SageFrameSettingKeys.PortalUserProfileMaxImageSize + ",");
                //sbSettingValue.Append(txtPortalUserProfileMaxImageSize.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                ////SageFrameSettingKeys.PortalUserProfileMediumImageSize
                //sbSettingKey.Append(SageFrameSettingKeys.PortalUserProfileMediumImageSize + ",");
                //sbSettingValue.Append(txtPortalUserProfileMediumImageSize.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                ////SageFrameSettingKeys.PortalUserProfileSmallImageSize
                //sbSettingKey.Append(SageFrameSettingKeys.PortalUserProfileSmallImageSize + ",");
                //sbSettingValue.Append(txtPortalUserProfileSmallImageSize.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");


                ////SageFrameSettingKeys.PortalSearchEngine
                //sbSettingKey.Append(SageFrameSettingKeys.PortalSearchEngine + ",");
                //sbSettingValue.Append(ddlSearchEngine.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                
                //SageFrameSettingKeys.PortalGoogleAdSenseID
                sbSettingKey.Append(SageFrameSettingKeys.PortalGoogleAdSenseID + ",");
                sbSettingValue.Append(txtPortalGoogleAdSenseID.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalCssTemplate
                sbSettingKey.Append(SageFrameSettingKeys.PortalCssTemplate + ",");
                sbSettingValue.Append(ddlTemplate.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");


                //SageFrameSettingKeys.PortalShowProfileLink
                sbSettingKey.Append(SageFrameSettingKeys.PortalShowProfileLink + ",");
                sbSettingValue.Append(rblPortalShowProfileLink.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.RememberCheckbox
                sbSettingKey.Append(SageFrameSettingKeys.RememberCheckbox + ",");
                sbSettingValue.Append(chkEnableRememberme.Checked + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                
                ////SageFrameSettingKeys.PortalShowSubscribe
                //sbSettingKey.Append(SageFrameSettingKeys.PortalShowSubscribe + ",");
                //sbSettingValue.Append(rblPortalShowSubscribe.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                
                //SageFrameSettingKeys.PortalShowLogo
                //sbSettingKey.Append(SageFrameSettingKeys.PortalShowLogo + ",");
                //sbSettingValue.Append(rblPortalShowLogo.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                
                //SageFrameSettingKeys.PortalShowFooterLink
                //sbSettingKey.Append(SageFrameSettingKeys.PortalShowFooterLink + ",");
                //sbSettingValue.Append(rblPortalShowFooterLink.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                
                ////SageFrameSettingKeys.PortalShowFooter
                //sbSettingKey.Append(SageFrameSettingKeys.PortalShowFooter + ",");
                //sbSettingValue.Append(rblPortalShowFooter.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                
                ////SageFrameSettingKeys.PortalShowBreadCrum
                //sbSettingKey.Append(SageFrameSettingKeys.PortalShowBreadCrum + ",");
                //sbSettingValue.Append(rblPortalShowBreadCrum.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                
                ////SageFrameSettingKeys.PortalShowCopyRight
                //sbSettingKey.Append(SageFrameSettingKeys.PortalShowCopyRight + ",");
                //sbSettingValue.Append(rblPortalShowCopyRight.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                
                ////SageFrameSettingKeys.PortalShowLoginStatus
                //sbSettingKey.Append(SageFrameSettingKeys.PortalShowLoginStatus + ",");
                //sbSettingValue.Append(rblPortalShowLoginStatus.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalUserRegistration
                sbSettingKey.Append(SageFrameSettingKeys.PortalUserRegistration + ",");
                sbSettingValue.Append(rblUserRegistration.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

               
                //SageFrameSettingKeys.IsPortalMenuIsImage
                sbSettingKey.Append(SageFrameSettingKeys.IsPortalMenuIsImage + ",");
                sbSettingValue.Append(rblIsPortalMenuIsImage.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalMenuImageExtension
                sbSettingKey.Append(SageFrameSettingKeys.PortalMenuImageExtension + ",");
                sbSettingValue.Append(txtPortalMenuImageExtension.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");



                //SageFrameSettingKeys.PlortalLoginpage
                sbSettingKey.Append(SageFrameSettingKeys.PlortalLoginpage + ",");
                sbSettingValue.Append(ddlLoginPage.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalUserActivation
                sbSettingKey.Append(SageFrameSettingKeys.PortalUserActivation + ",");
                sbSettingValue.Append(ddlPortalUserActivation.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalRegistrationPage
                sbSettingKey.Append(SageFrameSettingKeys.PortalRegistrationPage + ",");
                sbSettingValue.Append(ddlUserRegistrationPage.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalForgetPassword
                sbSettingKey.Append(SageFrameSettingKeys.PortalForgetPassword + ",");
                sbSettingValue.Append(ddlPortalForgetPassword.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");
                
                //SageFrameSettingKeys.PortalPageNotAccessible
                sbSettingKey.Append(SageFrameSettingKeys.PortalPageNotAccessible + ",");
                sbSettingValue.Append(ddlPortalPageNotAccessible.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalPageNotFound
                sbSettingKey.Append(SageFrameSettingKeys.PortalPageNotFound + ",");
                sbSettingValue.Append(ddlPortalPageNotFound.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                
                //SageFrameSettingKeys.PortalPasswordRecovery
                sbSettingKey.Append(SageFrameSettingKeys.PortalPasswordRecovery + ",");
                sbSettingValue.Append(ddlPortalPasswordRecovery.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //PortalUserProfilePage
                sbSettingKey.Append(SageFrameSettingKeys.PortalUserProfilePage + ",");
                sbSettingValue.Append(ddlPortalUserProfilePage.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //PortalDefaultPage
                sbSettingKey.Append(SageFrameSettingKeys.PortalDefaultPage + ",");
                sbSettingValue.Append(ddlPortalDefaultPage.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                ////SageFrameSettingKeys.PortalCurrency
                //sbSettingKey.Append(SageFrameSettingKeys.PortalCurrency + ",");
                //sbSettingValue.Append(ddlCurrency.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                ////SageFrameSettingKeys.PortalPaymentProcessor
                //sbSettingKey.Append(SageFrameSettingKeys.PortalPaymentProcessor + ",");
                //sbSettingValue.Append(ddlPaymentProcessor.SelectedItem.Value + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                ////SageFrameSettingKeys.PortalProcessorUserId
                //sbSettingKey.Append(SageFrameSettingKeys.PortalProcessorUserId + ",");
                //sbSettingValue.Append(txtProcessorUserId.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                ////SageFrameSettingKeys.PortalProcessorPassword
                //sbSettingKey.Append(SageFrameSettingKeys.PortalProcessorPassword + ",");
                //sbSettingValue.Append(txtProcessorPassword.Text.Trim() + ",");
                //sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalDefaultLanguage
                sbSettingKey.Append(SageFrameSettingKeys.PortalDefaultLanguage + ",");
                sbSettingValue.Append(ddlDefaultLanguage.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                string SettingTypes = sbSettingType.ToString();
                if (SettingTypes.Contains(","))
                {
                    SettingTypes = SettingTypes.Remove(SettingTypes.LastIndexOf(","));
                }
                string SettingKeys = sbSettingKey.ToString();
                if (SettingKeys.Contains(","))
                {
                    SettingKeys = SettingKeys.Remove(SettingKeys.LastIndexOf(","));
                }
                string SettingValues = sbSettingValue.ToString();
                if (SettingValues.Contains(","))
                {
                    SettingValues = SettingValues.Remove(SettingValues.LastIndexOf(","));
                }
                

                sageSP.SaveSageSettings(SettingTypes, SettingKeys, SettingValues, GetUsername, GetPortalID.ToString());
                HttpContext.Current.Cache.Remove("SageSetting");
                BindData();

                #endregion

                ShowMessage(SageMessageTitle.Information.ToString(), GetSageMessage("PortalSettings", "PortalSettingIsSavedSuccessfully"), "", SageMessageType.Success);
            }
            catch (Exception ex)
            {
                ProcessException(ex);
            }
        }       
 /// <summary>
 /// Added by bj to change the Portal
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void btnPortalSave_Click(object sender, EventArgs e)
 {
     int portalID = GetPortalID;
     if (int.Parse(ddlPortalName.SelectedItem.Value) != 1)
     {
         SettingProvider sageSP = new SettingProvider();
         sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.SuperUserPortalId,
             ddlPortalName.SelectedItem.Value, GetUsername, portalID.ToString());
         sageSP.ChangePortal(int.Parse(ddlPortalName.SelectedItem.Value));
         BindPortal();
         HttpRuntime.Cache.Remove(CacheKeys.Portals);
         HttpRuntime.Cache.Remove(CacheKeys.SageSetting);
         Response.Redirect(Request.Url.ToString());
     }
     else
     {
         ShowMessage("Current Portal", "", "The portal you want to make Parent is existing parent portal", SageMessageType.Alert);
     }
 }
 private void BindSitePortal()
 {
     try
     {
         SettingProvider spr = new SettingProvider();
         DataTable dt = spr.GetAllPortals();
         ddlPortalName.DataSource = dt;
         ddlPortalName.DataTextField = "Name";
         ddlPortalName.DataValueField = "PortalID";
         ddlPortalName.DataBind();
         if (ddlPortalName.Items.Count > 0)
         {
             ddlPortalName.SelectedIndex = ddlPortalName.Items.IndexOf(ddlPortalName.Items.FindByValue(pagebase.GetSettingsByKey(SageFrameSettingKeys.SuperUserPortalId)));
         }
         if (ddlPortalName.Items.Count <= 1)
         {
             ddlPortalName.Visible = false;
             btnPortalSave.Visible = false;
         }
         else
         {
             ddlPortalName.Visible = true;
             btnPortalSave.Visible = true;
         }
     }
     catch (Exception ex)
     {
         ProcessException(ex);
     }
 }
 public void ResetSettingKeys(int PortalID)
 {
     SettingProvider sep = new SettingProvider();
     Hashtable hst = new Hashtable();
     DataTable dt = sep.GetSettingsByPortal(PortalID.ToString(), string.Empty);
     if (dt != null && dt.Rows.Count > 0)
     {
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             hst.Add(dt.Rows[i]["SettingKey"].ToString(), dt.Rows[i]["SettingValue"].ToString());
         }
     }
     //need to be cleared when any key is chnaged
     HttpRuntime.Cache.Insert(CacheKeys.SageSetting, hst);//
 }
 /// <summary>
 /// Return integer setting value based upon application setting key.
 /// </summary>
 /// <param name="settingKey">Application setting key.</param>
 /// <returns>setting value based upon application setting key.</returns>
 public int GetSettingIntValueByIndividualKey(string settingKey)
 {
     int value = 0;
     try
     {
         SettingProvider objSetting = new SettingProvider();
         KeyValue objValue = objSetting.GetSettingValueByIndividualKey(settingKey, GetPortalID);
         if (objValue != null && objValue.Value != null)
         {
             value = int.Parse(objValue.Value);
         }
     }
     catch (Exception e)
     {
         throw e;
     }
     return value;
 }
        private void SetPortalCofig()
        {
            Hashtable hstPortals = GetPortals();
            SageUserControl suc = new SageUserControl();
            int portalID = 1;

            #region "Get Portal SEO Name and PortalID"
            if (string.IsNullOrEmpty(Request.QueryString["ptSEO"]))
            {
                if (string.IsNullOrEmpty(PortalSEOName))
                {
                    PortalSEOName = GetDefaultPortalName(hstPortals, 1);// 1 is for Default Portal
                }
                else if (!hstPortals.ContainsKey(PortalSEOName.ToLower().Trim()))
                {
                    PortalSEOName = GetDefaultPortalName(hstPortals, 1);// 1 is for Default Portal
                }
                else
                {
                    portalID = int.Parse(hstPortals[PortalSEOName.ToLower().Trim()].ToString());
                }
            }
            else
            {
                PortalSEOName = Request.QueryString["ptSEO"].ToString().ToLower().Trim();
                portalID = Int32.Parse(Request.QueryString["ptlid"].ToString());
            }
            #endregion

            suc.SetPortalSEOName(PortalSEOName.ToLower().Trim());
            Session[SessionKeys.SageFrame_PortalSEOName] = PortalSEOName.ToLower().Trim();
            Session[SessionKeys.SageFrame_PortalID] = portalID;
            string tempName = /*activeTemplate;// */ TemplateController.GetActiveTemplate(currentportalID).TemplateSeoName;
            string tempPath = Decide.IsTemplateDefault(tempName) ? Utils.GetTemplatePath_Default(tempName) : Utils.GetTemplatePath(tempName);
            if (!Directory.Exists(tempPath))
            {
                tempName = "default";
            }
            Globals.sysHst[ApplicationKeys.ActiveTemplate + "_" + currentportalID] = tempName;
            //Globals.sysHst[ApplicationKeys.ActivePagePreset + "_" + currentportalID] = LoadActivePagePreset() || PresetHelper.LoadActivePagePreset(tempName, GetPageSEOName(Request.Url.ToString()));            
            LoadActivePagePreset();
            suc.SetPortalID(portalID);
            SetPortalID(portalID);
            #region "Set user credentials for modules"
            if (SecurityPolicy.GetUser(GetPortalID) != string.Empty)
            {
                SettingProvider objSP = new SettingProvider();
                SageFrameConfig sfConfig = new SageFrameConfig();
                if (SecurityPolicy.GetUser(GetPortalID) != string.Empty)
                {
                    string strRoles = string.Empty;

                    List<SageUserRole> sageUserRolles = objSP.RoleListGetByUsername(SecurityPolicy.GetUser(GetPortalID), currentportalID);
                    if (sageUserRolles != null)
                    {
                        foreach (SageUserRole userRole in sageUserRolles)
                        {
                            strRoles += userRole.RoleId + ",";
                        }
                    }
                    if (strRoles.Length > 1)
                    {
                        strRoles = strRoles.Substring(0, strRoles.Length - 1);
                    }
                    if (strRoles.Length > 0)
                    {
                        SetUserRoles(strRoles);
                    }
                }
            }
            #endregion
        }
 private void BindPortalSetting()
 {
     Hashtable hst = new Hashtable();
     SettingProvider sep = new SettingProvider();
     DataTable dt = sep.GetSettingsByPortal(GetPortalID.ToString(), string.Empty); //GetSettingsByPortal();
     if (dt != null && dt.Rows.Count > 0)
     {
         for (int i = 0; i < dt.Rows.Count; i++)
         {
             hst.Add(dt.Rows[i]["SettingKey"].ToString(), dt.Rows[i]["SettingValue"].ToString());
         }
     }
     HttpContext.Current.Cache.Insert("SageSetting", hst);
 }
 private void BindSitePortal()
 {
     try
     {
         SettingProvider spr = new SettingProvider();
         ddlHostPortal.DataSource = spr.GetAllPortals();
         ddlHostPortal.DataTextField = "Name";
         ddlHostPortal.DataValueField = "PortalID";
         ddlHostPortal.DataBind();
     }
     catch (Exception ex)
     {
         ProcessException(ex);
     }
 }
    protected void LoginButton_Click(object sender, EventArgs e)
    {
        MembershipController member = new MembershipController();
        RoleController role = new RoleController();
        UserInfo user = member.GetUserDetails(GetPortalID, UserName.Text);
        if (user.UserExists && user.IsApproved)
        {
            if (!(string.IsNullOrEmpty(UserName.Text) && string.IsNullOrEmpty(PasswordAspx.Text)))
            {
                if (PasswordHelper.ValidateUser(user.PasswordFormat, PasswordAspx.Text, user.Password, user.PasswordSalt))
                {
                    string userRoles = role.GetRoleNames(user.UserName, GetPortalID);
                    strRoles += userRoles;
                    if (strRoles.Length > 0)
                    {
                        SetUserRoles(strRoles);
                        SessionTracker sessionTracker = (SessionTracker)Session["Tracker"];
                        sessionTracker.PortalID = GetPortalID.ToString();
                        sessionTracker.Username = UserName.Text;
                        Session["Tracker"] = sessionTracker;
                        SageFrame.Web.SessionLog SLog = new SageFrame.Web.SessionLog();
                        SLog.SessionTrackerUpdateUsername(sessionTracker, sessionTracker.Username, GetPortalID.ToString());

                        if (Request.QueryString["ReturnUrl"] != null)
                        {
                            FormsAuthentication.SetAuthCookie(UserName.Text, RememberMe.Checked);
                            string PageNotFoundPage = Path.Combine(this.Request.ApplicationPath.ToString(), pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalPageNotFound) + ".aspx").Replace("\\", "/"); ;
                            string UserRegistrationPage = Path.Combine(this.Request.ApplicationPath.ToString(), pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalRegistrationPage) + ".aspx").Replace("\\", "/"); ;
                            string PasswordRecoveryPage = Path.Combine(this.Request.ApplicationPath.ToString(), pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalPasswordRecovery) + ".aspx").Replace("\\", "/"); ;
                            string ForgotPasswordPage = Path.Combine(this.Request.ApplicationPath.ToString(), pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalForgotPassword) + ".aspx").Replace("\\", "/"); ;
                            string PageNotAccessiblePage = Path.Combine(this.Request.ApplicationPath.ToString(), pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalPageNotAccessible) + ".aspx").Replace("\\", "/"); ;

                            string ReturnUrlPage = Request.QueryString["ReturnUrl"].Replace("%2f", "-").ToString();

                            if (ReturnUrlPage == PageNotFoundPage || ReturnUrlPage == UserRegistrationPage || ReturnUrlPage == PasswordRecoveryPage || ReturnUrlPage == ForgotPasswordPage || ReturnUrlPage == PageNotAccessiblePage)
                            {
                                Response.Redirect("~/" + pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalDefaultPage) + ".aspx", false);
                            }
                            else
                            {
                                Response.Redirect(ResolveUrl(Request.QueryString["ReturnUrl"].ToString()), false);
                            }
                        }
                        else
                        {
                            FormsAuthentication.SetAuthCookie(UserName.Text, RememberMe.Checked);
                            if (IsUseFriendlyUrls)
                            {
                                if (GetPortalID > 1)
                                {
                                    Response.Redirect("~/portal/" + GetPortalSEOName + "/" + "Single-Address-Checkout.aspx", false);
                                }
                                else
                                {
                                    Response.Redirect("~/" + "Single-Address-Checkout" + ".aspx", false);
                                }
                            }
                            else if (!IsUseFriendlyUrls)
                            {
                                if (GetPortalID > 1)
                                {
                                    Response.Redirect("~/portal/" + GetPortalSEOName + "/" + "Single-Address-Checkout", false);
                                }
                                else
                                {
                                    Response.Redirect("~/" + "Single-Address-Checkout", false);
                                }
                            }
                            else
                            {
                                Response.Redirect(ResolveUrl("~/Default.aspx?ptlid=" + GetPortalID + "&ptSEO=" + GetPortalSEOName + "&pgnm=" + pagebase.GetSettingsByKey(SageFrameSettingKeys.PortalDefaultPage)), false);
                            }
                        }

                        //update Cart for that User in AspxCommerce
                        //TODO:: get customerID from userNAme 
                        int customerID = GetCustomerID;
                        if (customerID == 0)
                        {
                            SettingProvider objSP = new SettingProvider();
                            CustomerGeneralInfo sageUserCust = objSP.CustomerIDGetByUsername(user.UserName, GetPortalID, GetStoreID);
                            if (sageUserCust != null)
                            {
                                customerID = sageUserCust.CustomerID;
                            }
                        }
                        UpdateCartAnonymoususertoRegistered(GetStoreID, GetPortalID, customerID, sessionCode);
                    }
                    else
                    {
                        FailureText.Text = GetSageMessage("UserLogin", "Youarenotauthenticatedtothisportal");//"You are not authenticated to this portal!";
                    }
                }
                else
                {
                    FailureText.Text = GetSageMessage("UserLogin", "UsernameandPasswordcombinationdoesntmatched");//"Username and Password combination doesn't matched!";
                }
            }
        }
        else
        {
            FailureText.Text = GetSageMessage("UserLogin", "UserDoesnotExist");
        }
    }
        private void SavePortalSettings()
        {
            try
            {
                SettingProvider sageSP = new SettingProvider();
                //Add Single Key Values that may contain Comma values so need to be add sepratly
                #region "Single Key Value Add/Updatge"

                //SageFrameSettingKeys.PageTitle
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.PageTitle,
                    txtPortalTitle.Text.Trim(), GetUsername, GetPortalID.ToString());

                //SageFrameSettingKeys.MetaDescription
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.MetaDescription,
                    txtDescription.Text, GetUsername, GetPortalID.ToString());

                //SageFrameSettingKeys.MetaKeywords
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.MetaKeywords,
                    txtKeyWords.Text, GetUsername, GetPortalID.ToString());

                //SageFrameSettingKeys.PortalLogoTemplate
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.PortalLogoTemplate,
                    txtLogoTemplate.Text.Trim(), GetUsername, GetPortalID.ToString());

                //SageFrameSettingKeys.PortalCopyright
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.PortalCopyright,
                    txtCopyright.Text.Trim(), GetUsername, GetPortalID.ToString());

                //SageFrameSettingKeys.PortalTimeZone
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.PortalTimeZone,
                    ddlPortalTimeZone.SelectedItem.Value, GetUsername, GetPortalID.ToString());

                //SageFrameSettingKeys.Message Setting       
                string mt = rdbDefault.Checked == true ? rdbDefault.Value : rdbCustom.Value;
                sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.MessageTemplate,
                    mt, GetUsername, GetPortalID.ToString());

                #endregion

                //For Multiple Keys and Values
                #region "Multiple Key Value Add/Update"

                StringBuilder sbSettingKey = new StringBuilder();
                StringBuilder sbSettingValue = new StringBuilder();
                StringBuilder sbSettingType = new StringBuilder();

                //Collecting Setting Values
                ///Super user settings
                StringBuilder sbSettingKey_super = new StringBuilder();
                StringBuilder sbSettingValue_super = new StringBuilder();
                StringBuilder sbSettingType_super = new StringBuilder();


                //SageFrameSettingKeys.SiteAdminEmailAddress
                sbSettingKey.Append(SageFrameSettingKeys.SiteAdminEmailAddress + ",");
                sbSettingValue.Append(txtSiteAdminEmailAddress.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalGoogleAdSenseID
                sbSettingKey.Append(SageFrameSettingKeys.PortalGoogleAdSenseID + ",");
                sbSettingValue.Append(txtPortalGoogleAdSenseID.Text.Trim() + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");


                //SageFrameSettingKeys.PortalShowProfileLink
                sbSettingKey.Append(SageFrameSettingKeys.PortalShowProfileLink + ",");
                sbSettingValue.Append(rblPortalShowProfileLink.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.RememberCheckbox
                sbSettingKey.Append(SageFrameSettingKeys.RememberCheckbox + ",");
                sbSettingValue.Append(chkEnableRememberme.Checked + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //CssJs Optimization
                sbSettingKey.Append(SageFrameSettingKeys.OptimizeCss + ",");
                sbSettingValue.Append(chkOptCss.Checked + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                sbSettingKey.Append(SageFrameSettingKeys.OptimizeJs + ",");
                sbSettingValue.Append(chkOptJs.Checked + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                sbSettingKey.Append(SageFrameSettingKeys.EnableLiveFeeds + ",");
                sbSettingValue.Append(chkLiveFeeds.Checked + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.ShowSideBar
                sbSettingKey.Append(SageFrameSettingKeys.ShowSideBar + ",");
                sbSettingValue.Append(chkShowSidebar.Checked + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SSL
                sbSettingKey.Append(SageFrameSettingKeys.UseSSL + ",");
                sbSettingValue.Append(cbUseSSL.Checked + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalUserRegistration
                sbSettingKey.Append(SageFrameSettingKeys.PortalUserRegistration + ",");
                sbSettingValue.Append(rblUserRegistration.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");


                //SageFrameSettingKeys.PortalLoginpage
                sbSettingKey.Append(SageFrameSettingKeys.PortalLoginpage + ",");
                sbSettingValue.Append(ddlLoginPage.SelectedItem.Value.StartsWith("sf") ? string.Format("sf/{0},", ddlLoginPage.SelectedItem.Value) : string.Format("{0},", ddlLoginPage.SelectedItem.Value));
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalUserActivation
                sbSettingKey.Append(SageFrameSettingKeys.PortalUserActivation + ",");
                sbSettingValue.Append(ddlPortalUserActivation.SelectedItem.Value.StartsWith("sf") ? string.Format("sf/{0},", ddlPortalUserActivation.SelectedItem.Value) : string.Format("{0},", ddlPortalUserActivation.SelectedItem.Value));
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalRegistrationPage
                sbSettingKey.Append(SageFrameSettingKeys.PortalRegistrationPage + ",");
                sbSettingValue.Append(ddlUserRegistrationPage.SelectedItem.Value.StartsWith("sf") ? string.Format("sf/{0},", ddlUserRegistrationPage.SelectedItem.Value) : string.Format("{0},", ddlUserRegistrationPage.SelectedItem.Value));
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalForgotPassword
                sbSettingKey.Append(SageFrameSettingKeys.PortalForgotPassword + ",");
                sbSettingValue.Append(ddlPortalForgotPassword.SelectedItem.Value.StartsWith("sf") ? string.Format("sf/{0},", ddlPortalForgotPassword.SelectedItem.Value) : string.Format("{0},", ddlPortalForgotPassword.SelectedItem.Value));
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalPageNotAccessible
                sbSettingKey.Append(SageFrameSettingKeys.PortalPageNotAccessible + ",");
                sbSettingValue.Append(ddlPortalPageNotAccessible.SelectedItem.Value.StartsWith("sf") ? string.Format("sf/{0},", ddlPortalPageNotAccessible.SelectedItem.Value) : string.Format("{0},", ddlPortalPageNotAccessible.SelectedItem.Value));
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.PortalPageNotFound
                sbSettingKey.Append(SageFrameSettingKeys.PortalPageNotFound + ",");
                sbSettingValue.Append(ddlPortalPageNotFound.SelectedItem.Value.StartsWith("sf") ? string.Format("sf/{0},", ddlPortalPageNotFound.SelectedItem.Value) : string.Format("{0},", ddlPortalPageNotFound.SelectedItem.Value));
                sbSettingType.Append(SettingType.SiteAdmin + ",");


                //SageFrameSettingKeys.PortalPasswordRecovery
                sbSettingKey.Append(SageFrameSettingKeys.PortalPasswordRecovery + ",");
                sbSettingValue.Append(ddlPortalPasswordRecovery.SelectedItem.Value.StartsWith("sf") ? string.Format("sf/{0},", ddlPortalPasswordRecovery.SelectedItem.Value) : string.Format("{0},", ddlPortalPasswordRecovery.SelectedItem.Value));
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //PortalUserProfilePage
                sbSettingKey.Append(SageFrameSettingKeys.PortalUserProfilePage + ",");
                sbSettingValue.Append(ddlPortalUserProfilePage.SelectedItem.Value.StartsWith("sf") ? string.Format("sf/{0},", ddlPortalUserProfilePage.SelectedItem.Value) : string.Format("{0},", ddlPortalUserProfilePage.SelectedItem.Value));
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //PortalDefaultPage
                sbSettingKey.Append(SageFrameSettingKeys.PortalDefaultPage + ",");
                sbSettingValue.Append(ddlPortalDefaultPage.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");


                //SageFrameSettingKeys.PortalDefaultLanguage
                sbSettingKey.Append(SageFrameSettingKeys.PortalDefaultLanguage + ",");
                sbSettingValue.Append(ddlDefaultLanguage.SelectedItem.Value + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //Added by Bj for OpenID conumer key and Secret key

                //SageFrameSettingKeys.FaceBookConsumerKey
                sbSettingKey.Append(SageFrameSettingKeys.ShowOpenID + ",");
                sbSettingValue.Append(chkOpenID.Checked + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.FaceBookConsumerKey
                sbSettingKey.Append(SageFrameSettingKeys.FaceBookConsumerKey + ",");
                sbSettingValue.Append(txtFacebookConsumerKey.Text + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.FaceBokkSecretkey
                sbSettingKey.Append(SageFrameSettingKeys.FaceBookSecretkey + ",");
                sbSettingValue.Append(txtFaceBookSecretKey.Text + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.LinkedInConsumerKey
                sbSettingKey.Append(SageFrameSettingKeys.LinkedInConsumerKey + ",");
                sbSettingValue.Append(txtLinkedInConsumerKey.Text + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.LinkedInSecretKey
                sbSettingKey.Append(SageFrameSettingKeys.LinkedInSecretKey + ",");
                sbSettingValue.Append(txtLinkedInSecretKey.Text + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");


                //SageFrameSettingKeys.EnableCDN
                bool enableCDN = chkEnableCDN.Checked == true ? true : false;
                sbSettingKey.Append(SageFrameSettingKeys.EnableCDN + ",");
                sbSettingValue.Append(enableCDN + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");

                //SageFrameSettingKeys.EnableSessionTracker
                bool enableSessionTracker = chkSessionTracker.Checked == true ? true : false;
                sbSettingKey.Append(SageFrameSettingKeys.EnableSessionTracker + ",");
                sbSettingValue.Append(enableSessionTracker + ",");
                sbSettingType.Append(SettingType.SiteAdmin + ",");


                //SageFrameSettingKeys.EnableDasboardHelp                    
                sbSettingKey_super.Append(SageFrameSettingKeys.EnableDasboardHelp + ",");
                sbSettingValue_super.Append(chkDashboardHelp.Checked + ",");
                sbSettingType_super.Append(SettingType.SiteAdmin + ",");

                RoleController _role = new RoleController();
                string[] roles = _role.GetRoleNames(GetUsername, GetPortalID).ToLower().Split(',');
                if (roles.Contains(SystemSetting.SUPER_ROLE[0].ToLower()))
                {
                    ///Superuser Settings 
                    //Collecting Setting Values
                    sbSettingKey_super.Append(SageFrameSettingKeys.SuperUserPortalId + ",");
                    sbSettingValue_super.Append(ddlHostPortal.SelectedItem.Value + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.SuperUserTitle                
                    sbSettingKey_super.Append(SageFrameSettingKeys.SuperUserTitle + ",");
                    sbSettingValue_super.Append(txtHostTitle.Text.Trim() + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.SuperUserURL
                    sbSettingKey_super.Append(SageFrameSettingKeys.SuperUserURL + ",");
                    sbSettingValue_super.Append(txtHostUrl.Text.Trim() + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.SuperUserEmail
                    sbSettingKey_super.Append(SageFrameSettingKeys.SuperUserEmail + ",");
                    sbSettingValue_super.Append(txtHostEmail.Text.Trim() + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.SuperUserCopyright
                    sbSettingKey_super.Append(SageFrameSettingKeys.SuperUserCopyright + ",");
                    sbSettingValue_super.Append(chkCopyright.Checked + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.UseCustomErrorMessages
                    sbSettingKey_super.Append(SageFrameSettingKeys.UseCustomErrorMessages + ",");
                    sbSettingValue_super.Append(chkUseCustomErrorMessages.Checked + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");


                    //SageFrameSettingKeys.UseFriendlyUrls
                    sbSettingKey_super.Append(SageFrameSettingKeys.UseFriendlyUrls + ",");
                    sbSettingValue_super.Append(true + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");



                    //SageFrameSettingKeys.SMTPServer
                    sbSettingKey_super.Append(SageFrameSettingKeys.SMTPServer + ",");
                    sbSettingValue_super.Append(txtSMTPServerAndPort.Text.Trim() + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.SMTPAuthentication
                    sbSettingKey_super.Append(SageFrameSettingKeys.SMTPAuthentication + ",");
                    sbSettingValue_super.Append(rblSMTPAuthentication.SelectedItem.Value + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.SMTPEnableSSL
                    sbSettingKey_super.Append(SageFrameSettingKeys.SMTPEnableSSL + ",");
                    sbSettingValue_super.Append(chkSMTPEnableSSL.Checked + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.SMTPUsername
                    sbSettingKey_super.Append(SageFrameSettingKeys.SMTPUsername + ",");
                    sbSettingValue_super.Append(txtSMTPUserName.Text.Trim() + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.SMTPPassword
                    sbSettingKey_super.Append(SageFrameSettingKeys.SMTPPassword + ",");
                    sbSettingValue_super.Append(txtSMTPPassword.Text.Trim() + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");


                    //SageFrameSettingKeys.FileExtensions
                    sbSettingKey_super.Append(SageFrameSettingKeys.FileExtensions + ",");
                    sbSettingValue_super.Append(txtFileExtensions.Text.Trim() + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.HelpURL
                    sbSettingKey_super.Append(SageFrameSettingKeys.HelpURL + ",");
                    sbSettingValue_super.Append(txtHelpUrl.Text.Trim() + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.SettingPageExtension
                    sbSettingKey_super.Append(SageFrameSettingKeys.SettingPageExtension + ",");
                    sbSettingValue_super.Append(txtPageExtension.Text.Trim() + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.Scheduler
                    sbSettingKey_super.Append(SageFrameSettingKeys.Scheduler + ",");
                    sbSettingValue_super.Append(txtScheduler.Checked + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                    //SageFrameSettingKeys.UserAgentMode
                    int userAgent = rdBtnPC.Checked == true ? 1 : (rdBtnMobile.Checked == true ? 2 : 3);
                    sbSettingKey_super.Append(SageFrameSettingKeys.UserAgentMode + ",");
                    sbSettingValue_super.Append(userAgent + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");




                    //SageFrameSettingKeys.ServerCookieExpiration
                    sbSettingKey_super.Append(SageFrameSettingKeys.ServerCookieExpiration + ",");
                    sbSettingValue_super.Append(txtServerCookieExpiration.Text + ",");
                    sbSettingType_super.Append(SettingType.SuperUser + ",");

                }
                string SettingTypes = sbSettingType.ToString();
                if (SettingTypes.Contains(","))
                {
                    SettingTypes = SettingTypes.Remove(SettingTypes.LastIndexOf(","));
                }
                string SettingKeys = sbSettingKey.ToString();
                if (SettingKeys.Contains(","))
                {
                    SettingKeys = SettingKeys.Remove(SettingKeys.LastIndexOf(","));
                }
                string SettingValues = sbSettingValue.ToString();
                if (SettingValues.Contains(","))
                {
                    SettingValues = SettingValues.Remove(SettingValues.LastIndexOf(","));
                }
                string SettingTypes_super = sbSettingType_super.ToString();
                if (SettingTypes_super.Contains(","))
                {
                    SettingTypes_super = SettingTypes_super.Remove(SettingTypes_super.LastIndexOf(","));
                }
                string SettingKeys_super = sbSettingKey_super.ToString();
                if (SettingKeys_super.Contains(","))
                {
                    SettingKeys_super = SettingKeys_super.Remove(SettingKeys_super.LastIndexOf(","));
                }
                string SettingValues_super = sbSettingValue_super.ToString();
                if (SettingValues_super.Contains(","))
                {
                    SettingValues_super = SettingValues_super.Remove(SettingValues_super.LastIndexOf(","));
                }

                sageSP.SaveSageSettings(SettingTypes, SettingKeys, SettingValues, GetUsername, GetPortalID.ToString());
                if (roles.Contains(SystemSetting.SUPER_ROLE[0].ToLower()))
                {
                    sageSP.SaveSageSettings(SettingTypes_super, SettingKeys_super, SettingValues_super, GetUsername, "1");
                }
                HttpRuntime.Cache.Remove(CacheKeys.SageSetting);
                BindData();
                #endregion
                ShowMessage("", GetSageMessage("PortalSettings", "PortalSettingIsSavedSuccessfully"), "", SageMessageType.Success);
            }
            catch (Exception ex)
            {
                ProcessException(ex);
            }
        }
 private void SetPortalCofig()
 {
     Hashtable hstPortals = GetPortals();
     SageUserControl suc = new SageUserControl();
     suc.PagePath = PagePath;
     int portalID = 1;
     #region "Get Portal SEO Name and PortalID"
     if (string.IsNullOrEmpty(Request.QueryString["ptSEO"]))
     {
         if (string.IsNullOrEmpty(PortalSEOName))
         {
             PortalSEOName = GetDefaultPortalName(hstPortals, 1);// 1 is default parent PortalID 
         }
         else if (!hstPortals.ContainsKey(PortalSEOName.ToLower().Trim()))
         {
             PortalSEOName = GetDefaultPortalName(hstPortals, 1);
         }
         else
         {
             portalID = int.Parse(hstPortals[PortalSEOName.ToLower().Trim()].ToString());
         }
     }
     else
     {
         PortalSEOName = Request.QueryString["ptSEO"].ToString().ToLower().Trim();
         portalID = Int32.Parse(Request.QueryString["ptlid"].ToString());
     }
     #endregion
     suc.SetPortalSEOName(PortalSEOName.ToLower().Trim());
     Session[SessionKeys.SageFrame_PortalSEOName] = PortalSEOName.ToLower().Trim();
     Session[SessionKeys.SageFrame_PortalID] = portalID;
     Session[SessionKeys.SageFrame_AdminTheme] = ThemeHelper.GetAdminTheme(GetPortalID, GetUsername);
     Globals.sysHst[ApplicationKeys.ActiveTemplate + "_" + portalID] = TemplateController.GetActiveTemplate(GetPortalID).TemplateSeoName;
     Globals.sysHst[ApplicationKeys.ActivePagePreset + "_" + portalID] = PresetHelper.LoadActivePagePreset(GetActiveTemplate, GetPageSEOName(Request.Url.ToString()));
     suc.SetPortalID(portalID);
     SetPortalID(portalID);
     #region "Set user credentials for modules"
     SecurityPolicy objSecurity = new SecurityPolicy();
     if (objSecurity.GetUser(GetPortalID) != string.Empty)
     {
         SettingProvider objSP = new SettingProvider();
         SageFrameConfig sfConfig = new SageFrameConfig();
         string strRoles = string.Empty;
         List<SageUserRole> sageUserRolles = objSP.RoleListGetByUsername(objSecurity.GetUser(GetPortalID), GetPortalID);
         if (sageUserRolles != null)
         {
             foreach (SageUserRole userRole in sageUserRolles)
             {
                 strRoles += userRole.RoleId + ",";
             }
         }
         if (strRoles.Length > 1)
         {
             strRoles = strRoles.Substring(0, strRoles.Length - 1);
         }
         if (strRoles.Length > 0)
         {
             SetUserRoles(strRoles);
         }
     }
     #endregion
 }
Example #23
0
 /// <summary>
 /// Set google analytics
 /// </summary>
 private void SetGoogleAnalytics()
 {
     try
     {
         if (!IsAdmin())
         {
             Hashtable hst = new Hashtable();
             if (HttpRuntime.Cache[CacheKeys.SageGoogleAnalytics] != null)
             {
                 hst = (Hashtable)HttpRuntime.Cache[CacheKeys.SageGoogleAnalytics];
             }
             else
             {
                 SettingProvider sp = new SettingProvider();
                 List<GoogleAnalyticsInfo> objList = sp.GetGoogleAnalyticsActiveOnlyByPortalID(GetPortalID);
                 foreach (GoogleAnalyticsInfo objl in objList)
                 {
                     hst.Add("SageGoogleAnalytics_" + objl.PortalID, objl.GoogleJSCode);
                 }
                 HttpRuntime.Cache.Insert(CacheKeys.SageGoogleAnalytics, hst);
             }
             if (hst != null && hst.Count > 0 && hst.ContainsKey("SageGoogleAnalytics_" + GetPortalID))
             {
                 Literal LitSageScript = Page.Header.FindControl("LitSageScript") as Literal;
                 if (LitSageScript != null)
                 {
                     string strGoogleJS = hst["SageGoogleAnalytics_" + GetPortalID].ToString();
                     if (!strGoogleJS.Contains("<script type=\"text/javascript\">"))
                     {
                         strGoogleJS = "<script type=\"text/javascript\">" + strGoogleJS + "</script>";
                     }
                     LitSageScript.Text += strGoogleJS;
                 }
             }
         }
     }
     catch
     {
     }
 }
    private void BindData()
    {
        try
        {
            txtvalue.Text = "";
            SettingProvider sp = new SettingProvider();
            GoogleAnalyticsInfo objGA = new GoogleAnalyticsInfo();
            objGA = sp.GetGoogleAnalyticsByPortalID(GetPortalID);
            if (objGA != null && objGA.GoogleJSCode != null)
            {
                txtvalue.Text = objGA.GoogleJSCode;
                chkIsActive.Checked = objGA.IsActive;
            }
        }
        catch (Exception ex)
        {
            ProcessException(ex);
        }

    }
Example #25
0
        private void SetPortalCofig()
        {
            Hashtable hstPortals = GetPortals();
            SageUserControl suc = new SageUserControl();

            suc.PagePath = PagePath;
            int portalID = 1;
            //ptlid=-9&ptSEO=contruction&pgnm=faqs
            if (string.IsNullOrEmpty(Request.QueryString["ptSEO"]))
            {
                if (string.IsNullOrEmpty(PortalSEOName))
                {
                    PortalSEOName = "default";
                }
                else if (!hstPortals.ContainsKey(PortalSEOName.ToLower().Trim()))
                {
                    PortalSEOName = "default";
                }
                else
                {
                    portalID = int.Parse(hstPortals[PortalSEOName.ToLower().Trim()].ToString());
                }
            }
            else
            {
                PortalSEOName = Request.QueryString["ptSEO"].ToString().ToLower().Trim();
                portalID = Int32.Parse(Request.QueryString["ptlid"].ToString());
            }
            suc.SetPortalSEOName(PortalSEOName.ToLower().Trim());
            Session["SageFrame.PortalSEOName"] = PortalSEOName.ToLower().Trim();
            Session["SageFrame.PortalID"] = portalID;
            suc.SetPortalID(portalID);
            SetPortalID(portalID);

            int storeID = portalID;
            //TODO:: set StoreID According the URL HERE
            Session["SageFrame.StoreID"] = storeID;
            suc.SetStoreID(storeID);
            SetStoreID(storeID);

            if (HttpContext.Current.User != null)
            {
                SettingProvider objSP = new SettingProvider();
                int customerID = 0;
                if (Membership.GetUser() != null)
                {
                    string strRoles = string.Empty;
                    //RolesManagementDataContext dbRole = new RolesManagementDataContext(SystemSetting.SageFrameConnectionString);
                    //var userRoles = dbRole.sp_RoleGetByUsername(HttpContext.Current.User.Identity.Name, GetPortalID).ToList();
                    //foreach (var userRole in userRoles)
                    //{
                    //    strRoles += userRole.RoleId + ",";
                    //}
                    List<SageUserRole> sageUserRolles = objSP.RoleListGetByUsername(HttpContext.Current.User.Identity.Name, GetPortalID);
                    if (sageUserRolles != null)
                    {
                        foreach (SageUserRole userRole in sageUserRolles)
                        {
                            strRoles += userRole.RoleId + ",";
                        }
                    }
                    if (strRoles.Length > 1)
                    {
                        strRoles = strRoles.Substring(0, strRoles.Length - 1);
                    }
                    if (strRoles.Length > 0)
                    {
                        SetUserRoles(strRoles);
                    }

                    //TO Get Customer Details

                    CustomerGeneralInfo sageUserCust = objSP.CustomerIDGetByUsername(HttpContext.Current.User.Identity.Name, GetPortalID, GetStoreID);
                    if (sageUserCust != null)
                    {
                        customerID = sageUserCust.CustomerID;
                    }
                    Session["SageFrame.CustomerID"] = customerID;
                    suc.SetCustomerID(customerID);
                    SetCustomerID(customerID);
                }
                else
                {
                    //TO Get Customer Details
                    CustomerGeneralInfo sageUserCust = objSP.CustomerIDGetByUsername("anonymoususer", GetPortalID, GetStoreID);
                    if (sageUserCust != null)
                    {
                        customerID = sageUserCust.CustomerID;
                    }
                    Session["SageFrame.CustomerID"] = customerID;
                    suc.SetCustomerID(customerID);
                    SetCustomerID(customerID);
                }
            }
        }
 protected void rdTemplate_SelectedIndexChanged(object sender, EventArgs e)
 {
     string themeCss = rdTemplate.SelectedValue;
     SettingProvider sageSP = new SettingProvider();
     sageSP.SaveSageSetting(SettingType.SiteAdmin.ToString(), SageFrameSettingKeys.DefaultAdminTheme, themeCss, GetUsername, GetPortalID.ToString());
 }