public ClientSeverityActionInfo GetClientSeverityAction(int clientID, int severityLevelID) { try { using (var db = new MyDbContext()) { db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; var clientAction = db.RmsClientSeverityActions.Include("RmsSeverityLevel").FirstOrDefault(w => w.ClientId == clientID && w.SeverityLevelId == severityLevelID); if (clientAction == null) { throw new Exception("ClientSeverityAction (clientID: " + clientID + ", severityLevelID: " + severityLevelID + ") Not Found."); } ClientSeverityActionInfo ret = new ClientSeverityActionInfo(clientAction); return(ret); } } catch (Exception ex) { throw new RMSWebException(this, "0500", "GetClientSeverityActions failed. " + ex.Message, ex, false); } }
public List <ClientSeverityActionInfo> ListClientSeverityActions(int clientID) { try { using (var db = new MyDbContext()) { db.Configuration.ProxyCreationEnabled = false; db.Configuration.LazyLoadingEnabled = false; var listOfType = db.RmsClientSeverityActions.Include("RmsSeverityLevel").Where(w => w.ClientId == clientID); List <RmsClientSeverityAction> lists = new List <RmsClientSeverityAction>(listOfType.ToList()); List <ClientSeverityActionInfo> listResult = new List <ClientSeverityActionInfo>(); foreach (var clientSeverityAction in lists) { ClientSeverityActionInfo info = new ClientSeverityActionInfo(clientSeverityAction); listResult.Add(info); } return(listResult); } } catch (Exception ex) { throw new RMSWebException(this, "0500", "ListClientSeverityActions failed. " + ex.Message, ex, false); } }