internal static void SetSettingValue(SipProfileSettingTypes type, string value, SipProfile profile)
        {
            Connection conn = ConnectionPoolManager.GetConnection(typeof(SipProfileSetting));

            if (GetSettingValue(type, profile) != null)
            {
                Dictionary <string, object> fields = new Dictionary <string, object>();
                fields.Add("Value", value);
                conn.Update(typeof(SipProfileSetting),
                            fields,
                            new SelectParameter[] {
                    new EqualParameter("Profile", profile),
                    new EqualParameter("SettingType", type)
                });
            }
            else
            {
                SipProfileSetting sps = new SipProfileSetting();
                sps.Profile     = profile;
                sps.SettingType = type;
                sps.Value       = value;
                conn.Save(sps);
            }
            conn.CloseConnection();
        }
 internal static string GetSettingValue(SipProfileSettingTypes type, SipProfile profile)
 {
     string ret = null;
     ClassQuery cq = new ClassQuery("Org.Reddragonit.FreeSwitchConfig.DataCore.DB.Core",
         "Select sps.Value from SipProfileSetting sps WHERE sps.Profile.Name = @profileName AND sps.SettingType = @type");
     IDbDataParameter[] pars = new IDbDataParameter[]{
         cq.CreateParameter("@profileName",profile.Name),
         cq.CreateParameter("@type",type)
     };
     cq.Execute(pars);
     if (cq.Read())
         ret = cq.GetString(0);
     cq.Close();
     return ret;
 }
        internal static string GetSettingValue(SipProfileSettingTypes type, SipProfile profile)
        {
            string     ret = null;
            ClassQuery cq  = new ClassQuery("Org.Reddragonit.FreeSwitchConfig.DataCore.DB.Core",
                                            "Select sps.Value from SipProfileSetting sps WHERE sps.Profile.Name = @profileName AND sps.SettingType = @type");

            IDbDataParameter[] pars = new IDbDataParameter[] {
                cq.CreateParameter("@profileName", profile.Name),
                cq.CreateParameter("@type", type)
            };
            cq.Execute(pars);
            if (cq.Read())
            {
                ret = cq.GetString(0);
            }
            cq.Close();
            return(ret);
        }
 internal static void SetSettingValue(SipProfileSettingTypes type, string value, SipProfile profile)
 {
     Connection conn = ConnectionPoolManager.GetConnection(typeof(SipProfileSetting));
     if (GetSettingValue(type, profile) != null)
     {
         Dictionary<string, object> fields = new Dictionary<string, object>();
         fields.Add("Value", value);
         conn.Update(typeof(SipProfileSetting),
             fields,
             new SelectParameter[]{
             new EqualParameter("Profile",profile),
             new EqualParameter("SettingType",type)
         });
     }
     else
     {
         SipProfileSetting sps = new SipProfileSetting();
         sps.Profile = profile;
         sps.SettingType = type;
         sps.Value = value;
         conn.Save(sps);
     }
     conn.CloseConnection();
 }
 public string this[SipProfileSettingTypes type]
 {
     get { return(SipProfileSetting.GetSettingValue(type, this)); }
     set { SipProfileSetting.SetSettingValue(type, value, this); }
 }
 public string this[SipProfileSettingTypes type]
 {
     get { return SipProfileSetting.GetSettingValue(type, this); }
     set { SipProfileSetting.SetSettingValue(type, value, this); }
 }