/// <summary> /// Returns a List of Effective Years /// </summary> /// <returns></returns> public IList <int> GetEffectiveYears() { using (var context = new DataModel.UWWorkbookContext()) { IList <int> years = context.Programs.Select(p => p.EffectiveDate.Value.Year).Distinct().OrderBy(p => p).ToList(); return(years); } }
/// <summary> /// Returns a list of programs /// </summary> /// <returns></returns> public IList <DataContract.Program> GetPrograms(int underwriterId, int effectiveYear) { using (var context = new DataModel.UWWorkbookContext()) { IList <DataModel.Program> dmPrograms = context.Programs.Where( p => p.UnderwriterID == underwriterId && p.Year == effectiveYear).ToList(); var dcPrograms = Mapper.Map <IList <DataContract.Program> >(dmPrograms); return(dcPrograms); } }
/// <summary> /// Returns a dictionary containing all Underwriters. /// </summary> /// <returns></returns> public Dictionary <int, string> GetUnderwriters() { using (var context = new DataModel.UWWorkbookContext()) { var uwList = context.Programs.OrderBy(p => p.UnderwriterName) .Select(p => new { UnderwriterID = p.UnderwriterID, UnderwriterName = p.UnderwriterName }) .Distinct() .ToList(); var uwDictionary = uwList.OrderBy(p => p.UnderwriterName).ToDictionary(u => u.UnderwriterID, u => u.UnderwriterName); return(uwDictionary); } }
/// <summary> /// Gets Program by ID /// </summary> /// <param name="programId"></param> /// <returns></returns> public DataContract.Program GetProgramById(int programId) { try { using (var context = new DataModel.UWWorkbookContext()) { var program = context.Programs.Where(p => p.ProgramID == programId).FirstOrDefault(); if (program == null) { throw new FaultException <ServiceException>( ExceptionManager.HandleException(string.Format("Program ID {0} was not found.", programId))); } DataContract.Program dcProgram = Mapper.Map <DataContract.Program>(program); return(dcProgram); } } catch (Exception ex) { throw new FaultException <ServiceException>(ExceptionManager.HandleException(ex)); } }