private mPin(ClassQuery cq)
{
ID = cq.GetInt32(0);
SetName = cq.GetString(1);
Context = cq.GetString(2);
if (!cq.IsDBNull(3))
{
ExtensionNumber = cq.GetString(3);
ExtensionDomain = cq.GetString(4);
}
PinNumber = cq.GetString(5);
_originalPin = PinNumber;
}
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;
}
