public List <WebsiteMonitoringInfo> ListWebsiteMonitoringsByClient(int clientID) { try { using (var db = new MyDbContext()) { db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; var listOfType = db.RmsWebsiteMonitorings.Include("RmsClient").Where(w => w.ClientId == clientID); var lWebsitemotorings = new List <RmsWebsiteMonitoring>(listOfType.ToList()); List <WebsiteMonitoringInfo> lWebsiteMonitoringInfos = new List <WebsiteMonitoringInfo>(); List <RmsListOfValue> lListOfValues = new List <RmsListOfValue>(); if (lWebsitemotorings != null && lWebsitemotorings.Count > 0) { var dbSetLOV = db.RmsListOfValues; lListOfValues = new List <RmsListOfValue>(dbSetLOV.ToList()); } foreach (var rmsWebsiteMonitoring in lWebsitemotorings) { WebsiteMonitoringInfo _temp = new WebsiteMonitoringInfo(); _temp.InitInhertedProperties(rmsWebsiteMonitoring); _temp.ClientCode = rmsWebsiteMonitoring.RmsClient.ClientCode; _temp.ClientIPAddress = rmsWebsiteMonitoring.RmsClient.IpAddress; var rmsListOfValue = lListOfValues.FirstOrDefault(f => f.ListName == "WebsiteMonitoringType" && f.ItemId == rmsWebsiteMonitoring.WebsiteMonitoringTypeId); _temp.WebsiteMonitoringTypeValue = rmsListOfValue != null ? rmsListOfValue.ItemValue : null; rmsListOfValue = lListOfValues.FirstOrDefault(f => f.ListName == "WebsiteMonitoringProtocol" && f.ItemId == rmsWebsiteMonitoring.WebsiteMonitoringProtocolId); _temp.WebsiteMonitoringProtocolValue = rmsListOfValue != null ? rmsListOfValue.ItemValue : null; lWebsiteMonitoringInfos.Add(_temp); } return(lWebsiteMonitoringInfos); } } catch (Exception ex) { throw new RMSWebException(this, "0500", "ListWebsiteMonitoringsByClient failed. " + ex.Message, ex, false); } }
public WebsiteMonitoringInfo GetWebsiteMonitoring(int websiteMonitoringID) { try { using (var db = new MyDbContext()) { db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; var rmsWebsiteMonitoring = db.RmsWebsiteMonitorings.Include("RmsClient").First(w => w.WebsiteMonitoringId == websiteMonitoringID); if (rmsWebsiteMonitoring == null) { return(null); } List <RmsListOfValue> lListOfValues = new List <RmsListOfValue>(); var dbSetLOV = db.RmsListOfValues; lListOfValues = new List <RmsListOfValue>(dbSetLOV.ToList()); WebsiteMonitoringInfo _temp = new WebsiteMonitoringInfo(); _temp.InitInhertedProperties(rmsWebsiteMonitoring); _temp.ClientCode = rmsWebsiteMonitoring.RmsClient.ClientCode; _temp.ClientIPAddress = rmsWebsiteMonitoring.RmsClient.IpAddress; var rmsListOfValue = lListOfValues.FirstOrDefault(f => f.ListName == "WebsiteMonitoringType" && f.ItemId == rmsWebsiteMonitoring.WebsiteMonitoringTypeId); _temp.WebsiteMonitoringTypeValue = rmsListOfValue != null ? rmsListOfValue.ItemValue : null; rmsListOfValue = lListOfValues.FirstOrDefault(f => f.ListName == "WebsiteMonitoringProtocol" && f.ItemId == rmsWebsiteMonitoring.WebsiteMonitoringProtocolId); _temp.WebsiteMonitoringProtocolValue = rmsListOfValue != null ? rmsListOfValue.ItemValue : null; return(_temp); } } catch (Exception ex) { throw new RMSWebException(this, "0500", "GetWebsiteMonitoring failed. " + ex.Message, ex, false); } }