/// <summary>
/// HasRegistration method implementation
/// </summary>
internal static bool HasRegistration(SQLServerHost host, string upn)
{
string request = "SELECT ID, UPN FROM REGISTRATIONS WHERE UPN=@UPN";
SqlConnection con = new SqlConnection(host.ConnectionString);
SqlCommand sql = new SqlCommand(request, con);
SqlParameter prm = new SqlParameter("@UPN", SqlDbType.VarChar);
sql.Parameters.Add(prm);
prm.Value = upn;
con.Open();
try
{
SqlDataReader rd = sql.ExecuteReader();
return(rd.Read());
}
catch (Exception ex)
{
DataLog.WriteEntry(ex.Message, System.Diagnostics.EventLogEntryType.Error, 5000);
throw new Exception(ex.Message);
}
finally
{
con.Close();
}
}
/// <summary>
/// HasNotification method implementation
/// </summary>
internal static bool HasNotification(SQLServerHost host, string regid)
{
string request = "SELECT REGISTRATIONID FROM NOTIFICATIONS WHERE REGISTRATIONID=@REGISTRATIONID";
SqlConnection con = new SqlConnection(host.ConnectionString);
SqlCommand sql = new SqlCommand(request, con);
SqlParameter prm = new SqlParameter("@REGISTRATIONID", SqlDbType.BigInt);
sql.Parameters.Add(prm);
prm.Value = regid;
con.Open();
try
{
SqlDataReader rd = sql.ExecuteReader();
return(rd.Read());
}
catch (Exception ex)
{
DataLog.WriteEntry(ex.Message, System.Diagnostics.EventLogEntryType.Error, 5000);
throw new Exception(ex.Message);
}
finally
{
con.Close();
}
}
/// <summary>
/// Update method implmentation
/// </summary>
public void Load(PSHost host)
{
ManagementService.Initialize(host, true);
MFAConfig cfg = ManagementService.Config;
SQLServerHost sql = cfg.Hosts.SQLServerHost;
IsDirty = cfg.IsDirty;
ConnectionString = sql.ConnectionString;
}
/// <summary>
/// Update method implmentation
/// </summary>
public void Load(PSHost host)
{
ManagementAdminService.Initialize(host, true);
MFAConfig cfg = ManagementAdminService.ADFSManager.ReadConfiguration(host);
SQLServerHost sql = cfg.Hosts.SQLServerHost;
IsDirty = cfg.IsDirty;
ConnectionString = sql.ConnectionString;
}
/// <summary>
/// Update method implmentation
/// </summary>
public void Update(PSHost host)
{
ManagementService.Initialize(host, true);
MFAConfig cfg = ManagementService.Config;
SQLServerHost sql = cfg.Hosts.SQLServerHost;
cfg.IsDirty = IsDirty;
if (!ManagementService.CheckRepositoryAttribute(ConnectionString, 2))
{
throw new ArgumentException(string.Format("Invalid ConnectionString {0} !", ConnectionString));
}
sql.ConnectionString = ConnectionString;
ManagementService.ADFSManager.WriteConfiguration(host);
}
/// <summary>
/// Update method implmentation
/// </summary>
public void Update(PSHost host)
{
ManagementAdminService.Initialize(true);
MFAConfig cfg = ManagementAdminService.ADFSManager.Config;
SQLServerHost sql = cfg.Hosts.SQLServerHost;
cfg.IsDirty = IsDirty;
sql.ConnectionString = ConnectionString;
ManagementAdminService.ADFSManager.WriteConfiguration(host);
using (MailSlotClient mailslot = new MailSlotClient())
{
mailslot.SendNotification(0xAA);
}
}
/// <summary>
/// Update method implmentation
/// </summary>
public void Load(PSHost host)
{
ManagementService.Initialize(host, true);
MFAConfig cfg = ManagementService.Config;
SQLServerHost sql = cfg.Hosts.SQLServerHost;
IsDirty = cfg.IsDirty;
ConnectionString = sql.ConnectionString;
MaxRows = sql.MaxRows;
IsAlwaysEncrypted = sql.IsAlwaysEncrypted;
ThumbPrint = sql.ThumbPrint;
KeyName = sql.KeyName;
CertReuse = sql.CertReuse;
CertificateValidity = sql.CertificateValidity;
}
/// <summary>
/// Update method implmentation
/// </summary>
public void Update(PSHost host)
{
ManagementService.Initialize(host, true);
MFAConfig cfg = ManagementService.Config;
SQLServerHost sql = cfg.Hosts.SQLServerHost;
cfg.IsDirty = IsDirty;
if (!ManagementService.CheckSQLConnection(ConnectionString))
{
throw new ArgumentException(string.Format("Invalid ConnectionString {0} !", ConnectionString));
}
sql.ConnectionString = ConnectionString;
sql.MaxRows = MaxRows;
sql.IsAlwaysEncrypted = IsAlwaysEncrypted;
sql.ThumbPrint = ThumbPrint;
sql.KeyName = KeyName;
sql.CertReuse = CertReuse;
sql.CertificateValidity = CertificateValidity;
ManagementService.ADFSManager.WriteConfiguration(host);
}
/// <summary>
/// ADDSKeysRepositoryService constructor
/// </summary>
public SQLKeysRepositoryService(MFAConfig cfg)
{
_host = cfg.Hosts.SQLServerHost;
_connectionstring = _host.ConnectionString;
}
/// <summary>
/// BaseSQLAdminService constructor
/// </summary>
public SQLDataRepositoryService(SQLServerHost host, int deliverywindow = 3000) : base()
{
_host = host;
_connectionstring = _host.ConnectionString;
_deliverywindow = deliverywindow;
}
