public override bool SetApplicationCertificate( NodeId applicationId, byte[] certificate, bool isHttpsCertificate ) { Guid id = GetNodeIdGuid(applicationId); using (gdsdbEntities entities = new gdsdbEntities()) { var results = from x in entities.Applications where x.ApplicationId == id select x; var result = results.SingleOrDefault(); if (result == null) { return(false); } if (isHttpsCertificate) { result.HttpsCertificate = certificate; } else { result.Certificate = certificate; } entities.SaveChanges(); } return(true); }
public override ApplicationRecordDataType GetApplication( NodeId applicationId ) { Guid id = GetNodeIdGuid(applicationId); using (gdsdbEntities entities = new gdsdbEntities()) { var results = from x in entities.Applications where x.ApplicationId == id select x; var result = results.SingleOrDefault(); if (result == null) { return(null); } LocalizedText[] names = null; if (result.ApplicationName != null) { names = new LocalizedText[] { result.ApplicationName }; } StringCollection discoveryUrls = null; if (result.ServerEndpoints != null) { discoveryUrls = new StringCollection(); foreach (var endpoint in result.ServerEndpoints) { discoveryUrls.Add(endpoint.DiscoveryUrl); } } string[] capabilities = null; if (result.ServerCapabilities != null) { capabilities = result.ServerCapabilities.Split(','); } return(new ApplicationRecordDataType() { ApplicationId = new NodeId(result.ApplicationId, NamespaceIndex), ApplicationUri = result.ApplicationUri, ApplicationType = (ApplicationType)result.ApplicationType, ApplicationNames = new LocalizedTextCollection(names), ProductUri = result.ProductUri, DiscoveryUrls = discoveryUrls, ServerCapabilities = capabilities }); } }
public override ApplicationRecordDataType[] FindApplications( string applicationUri ) { using (gdsdbEntities entities = new gdsdbEntities()) { var results = from x in entities.Applications where x.ApplicationUri == applicationUri select x; List <ApplicationRecordDataType> records = new List <ApplicationRecordDataType>(); foreach (var result in results) { LocalizedText[] names = null; if (result.ApplicationName != null) { names = new LocalizedText[] { result.ApplicationName }; } StringCollection discoveryUrls = null; if (result.ServerEndpoints != null) { discoveryUrls = new StringCollection(); foreach (var endpoint in result.ServerEndpoints) { discoveryUrls.Add(endpoint.DiscoveryUrl); } } string[] capabilities = null; if (result.ServerCapabilities != null) { capabilities = result.ServerCapabilities.Split(','); } records.Add(new ApplicationRecordDataType() { ApplicationId = new NodeId(result.ApplicationId, NamespaceIndex), ApplicationUri = result.ApplicationUri, ApplicationType = (ApplicationType)result.ApplicationType, ApplicationNames = new LocalizedTextCollection(names), ProductUri = result.ProductUri, DiscoveryUrls = discoveryUrls, ServerCapabilities = capabilities }); } return(records.ToArray()); } }
public override bool CompleteCertificateRequest( NodeId applicationId, NodeId requestId, out byte[] certificate, out byte[] privateKey) { certificate = null; privateKey = null; Guid reqId = GetNodeIdGuid(requestId); using (gdsdbEntities entities = new gdsdbEntities()) { var request = (from x in entities.CertificateRequests where x.RequestId == reqId select x).SingleOrDefault(); if (request == null) { throw new ServiceResultException(StatusCodes.BadNodeIdUnknown); } if (request.State == (int)CertificateRequestState.New) { return(false); } if (request.State == (int)CertificateRequestState.Rejected) { throw new ServiceResultException(StatusCodes.BadUserAccessDenied, "The certificate request has been rejected by the administrator."); } certificate = request.Certificate; privateKey = request.PrivateKey; if (request.State == (int)CertificateRequestState.Approved) { if (request.AuthorityId != "https") { request.Application.Certificate = certificate; } else { request.Application.HttpsCertificate = certificate; } request.State = (int)CertificateRequestState.Accepted; } entities.SaveChanges(); return(true); } }
public override bool SetApplicationTrustLists( NodeId applicationId, NodeId trustListId, NodeId httpsTrustListId ) { Guid id = GetNodeIdGuid(applicationId); using (gdsdbEntities entities = new gdsdbEntities()) { var result = (from x in entities.Applications where x.ApplicationId == id select x).SingleOrDefault(); if (result == null) { return(false); } result.TrustListId = null; result.HttpsTrustListId = null; if (trustListId != null) { string storePath = trustListId.ToString(); var result2 = (from x in entities.CertificateStores where x.Path == storePath select x).SingleOrDefault(); if (result2 != null) { result.TrustListId = result2.ID; } } if (httpsTrustListId != null) { string storePath = httpsTrustListId.ToString(); var result2 = (from x in entities.CertificateStores where x.Path == storePath select x).SingleOrDefault(); if (result2 != null) { result.HttpsTrustListId = result2.ID; } } entities.SaveChanges(); } return(true); }
public override void Initialize() { using (gdsdbEntities entities = new gdsdbEntities()) { Assembly assembly = typeof(SqlApplicationsDatabase).GetTypeInfo().Assembly; StreamReader istrm = new StreamReader(assembly.GetManifestResourceStream("Opc.Ua.Gds.Server.DB.Tables.sql")); string tables = istrm.ReadToEnd(); entities.Database.Initialize(true); entities.Database.CreateIfNotExists(); var parts = tables.Split(new string[] { "GO" }, System.StringSplitOptions.None); foreach (var part in parts) { entities.Database.ExecuteSqlCommand(part); } entities.SaveChanges(); } }
public override void UnregisterApplication( NodeId applicationId, out byte[] certificate, out byte[] httpsCertificate) { certificate = null; httpsCertificate = null; Guid id = GetNodeIdGuid(applicationId); List <byte[]> certificates = new List <byte[]>(); using (gdsdbEntities entities = new gdsdbEntities()) { var result = (from ii in entities.Applications where ii.ApplicationId == id select ii).SingleOrDefault(); if (result == null) { throw new ArgumentException("A record with the specified application id does not exist.", nameof(applicationId)); } certificate = result.Certificate; httpsCertificate = result.HttpsCertificate; foreach (var entry in new List <CertificateRequest>(result.CertificateRequests)) { entities.CertificateRequests.Remove(entry); } foreach (var entry in new List <ApplicationName>(result.ApplicationNames)) { entities.ApplicationNames.Remove(entry); } foreach (var entry in new List <ServerEndpoint>(result.ServerEndpoints)) { entities.ServerEndpoints.Remove(entry); } entities.Applications.Remove(result); entities.SaveChanges(); m_lastCounterResetTime = DateTime.UtcNow; } }
public override NodeId CreateCertificateRequest( NodeId applicationId, byte[] certificate, byte[] privateKey, string authorityId) { Guid id = GetNodeIdGuid(applicationId); using (gdsdbEntities entities = new gdsdbEntities()) { var application = (from x in entities.Applications where x.ApplicationId == id select x).SingleOrDefault(); if (application == null) { throw new ServiceResultException(StatusCodes.BadNodeIdUnknown); } var request = (from x in application.CertificateRequests where x.AuthorityId == authorityId select x).SingleOrDefault(); bool isNew = false; if (request == null) { request = new CertificateRequest() { RequestId = Guid.NewGuid(), AuthorityId = authorityId }; isNew = true; } request.State = (int)CertificateRequestState.New; request.Certificate = certificate; request.PrivateKey = privateKey; if (isNew) { application.CertificateRequests.Add(request); } entities.SaveChanges(); return(new NodeId(request.RequestId, NamespaceIndex)); } }
public override void ApproveCertificateRequest( NodeId requestId, bool isRejected ) { Guid id = GetNodeIdGuid(requestId); using (gdsdbEntities entities = new gdsdbEntities()) { var request = (from x in entities.CertificateRequests where x.RequestId == id select x).SingleOrDefault(); if (request == null) { throw new ServiceResultException(StatusCodes.BadNodeIdUnknown); } request.State = (int)((isRejected) ? CertificateRequestState.Rejected : CertificateRequestState.Approved); entities.SaveChanges(); } }
public override NodeId RegisterApplication( ApplicationRecordDataType application ) { NodeId appNodeId = base.RegisterApplication(application); Guid applicationId = GetNodeIdGuid(appNodeId); string capabilities = base.ServerCapabilities(application); using (gdsdbEntities entities = new gdsdbEntities()) { Application record = null; if (applicationId != Guid.Empty) { var results = from ii in entities.Applications where ii.ApplicationId == applicationId select ii; record = results.SingleOrDefault(); if (record != null) { var endpoints = from ii in entities.ServerEndpoints where ii.ApplicationId == record.ID select ii; foreach (var endpoint in endpoints) { entities.ServerEndpoints.Remove(endpoint); } var names = from ii in entities.ApplicationNames where ii.ApplicationId == record.ID select ii; foreach (var name in names) { entities.ApplicationNames.Remove(name); } entities.SaveChanges(); } } bool isNew = false; if (record == null) { applicationId = Guid.NewGuid(); record = new Application() { ApplicationId = applicationId }; isNew = true; } record.ApplicationUri = application.ApplicationUri; record.ApplicationName = application.ApplicationNames[0].Text; record.ApplicationType = (int)application.ApplicationType; record.ProductUri = application.ProductUri; record.ServerCapabilities = capabilities; if (isNew) { entities.Applications.Add(record); } entities.SaveChanges(); if (application.DiscoveryUrls != null) { foreach (var discoveryUrl in application.DiscoveryUrls) { entities.ServerEndpoints.Add(new ServerEndpoint() { ApplicationId = record.ID, DiscoveryUrl = discoveryUrl }); } } if (application.ApplicationNames != null && application.ApplicationNames.Count > 1) { foreach (var applicationName in application.ApplicationNames) { entities.ApplicationNames.Add(new ApplicationName() { ApplicationId = record.ID, Locale = applicationName.Locale, Text = applicationName.Text }); } } entities.SaveChanges(); m_lastCounterResetTime = DateTime.UtcNow; return(new NodeId(applicationId, NamespaceIndex));; } }
public override ServerOnNetwork[] QueryServers( uint startingRecordId, uint maxRecordsToReturn, string applicationName, string applicationUri, string productUri, string[] serverCapabilities, out DateTime lastCounterResetTime) { lastCounterResetTime = m_lastCounterResetTime; using (gdsdbEntities entities = new gdsdbEntities()) { var results = from x in entities.ServerEndpoints join y in entities.Applications on x.ApplicationId equals y.ID where ((int)startingRecordId == 0 || (int)startingRecordId < x.ID) orderby x.ID select new { x.ID, y.ApplicationName, y.ApplicationUri, y.ProductUri, x.DiscoveryUrl, y.ServerCapabilities }; List <ServerOnNetwork> records = new List <ServerOnNetwork>(); foreach (var result in results) { if (!String.IsNullOrEmpty(applicationName)) { if (!Match(result.ApplicationName, applicationName)) { continue; } } if (!String.IsNullOrEmpty(applicationUri)) { if (!Match(result.ApplicationUri, applicationUri)) { continue; } } if (!String.IsNullOrEmpty(productUri)) { if (!Match(result.ProductUri, productUri)) { continue; } } string[] capabilities = null; if (result.ServerCapabilities != null) { capabilities = result.ServerCapabilities.Split(','); } if (serverCapabilities != null && serverCapabilities.Length > 0) { bool match = true; for (int ii = 0; ii < serverCapabilities.Length; ii++) { if (capabilities == null || !capabilities.Contains(serverCapabilities[ii])) { match = false; break; } } if (!match) { continue; } } records.Add(new ServerOnNetwork() { RecordId = (uint)result.ID, ServerName = result.ApplicationName, DiscoveryUrl = result.DiscoveryUrl, ServerCapabilities = capabilities }); if (maxRecordsToReturn != 0 && records.Count >= maxRecordsToReturn) { break; } } return(records.ToArray()); } }