/// <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));
}
}