public ExceptionTypes GetAllLookups(long?lookupTypeId, out List <DOCMN_LookupMaster> lstDOCMN_LookupMaster)
{
retValue = new ExceptionTypes();
LookupDAL objLookupDAL = new LookupDAL();
return(retValue = objLookupDAL.GetAllLookups(lookupTypeId, out lstDOCMN_LookupMaster));
}
public static IEnumerable <ZipCountyView> GetZipCodesAndCountyFIPSForState(string StateFIPS)
{
List <ZipCountyView> ZipCodesAndCounties = new List <ZipCountyView>();
System.Data.IDataReader reader = LookupDAL.GetZipCodeForStateFips(StateFIPS);
//string CountyFIPS = string.Empty;
while (reader.Read())
{
ZipCodesAndCounties.Add(new ZipCountyView(reader.GetString(0), reader.GetString(1), reader.GetString(2)));
}
return(ZipCodesAndCounties);
}
//TODO: This is a quick fix to a problem I was having on CCF/Add refactor asap. JP
public static IEnumerable <KeyValuePair <string, string> > GetZipCodeForCountyFips2(string CountyFips)
{
var _zipCodes = new List <KeyValuePair <string, string> >();
IDataReader rdrZipCodes = LookupDAL.GetZipCodeForCountyFips(CountyFips);
while (rdrZipCodes.Read())
{
_zipCodes.Add(new KeyValuePair <string, string>(rdrZipCodes.GetInt32(0).ToString(), rdrZipCodes.GetString(1)));
}
return(_zipCodes);
}
public static IEnumerable <KeyValuePair <string, string> > GetCountiesForZipCode(string ZipCode)
{
var _CountyCodes = new List <KeyValuePair <string, string> >();
IDataReader rdrCounty = LookupDAL.GetCountiesByZipCode(ZipCode);
while (rdrCounty.Read())
{
_CountyCodes.Add(new KeyValuePair <string, string>(rdrCounty.GetString(0), rdrCounty.GetString(1)));
}
return(_CountyCodes);
}
public static int GetAgencyID(string AgencyCode, string StateFIPS)
{
IDataReader AgencyData = LookupDAL.GetAgencyByCodeState(AgencyCode, StateFIPS);
try
{
AgencyData.Read();
int AgencyID = int.Parse(AgencyData["AgencyID"].ToString());
AgencyData.Close();
return(AgencyID);
}
finally
{
AgencyData.Close();
}
}
public static IEnumerable <KeyValuePair <int, string> > GetPresenterForState(string StateFIPS)
{
return(LookupDAL.GetPresenterForState(StateFIPS));
}
/// <summary>
/// Get Supervisors(Reviewers) for State Users in a state.
/// </summary>
/// <param name="StateFIPS"></param>
/// <returns></returns>
public static IEnumerable <KeyValuePair <int, string> > GetReviewersForStateScope(string StateFIPS)
{
return(LookupDAL.GetReviewersForStateScope(StateFIPS));
}
public static IEnumerable <KeyValuePair <int, string> > GetClientContactSubmitterForState(string StateFIPS)
{
return(LookupDAL.GetClientContactSubmitterForState(StateFIPS));
}
public static IEnumerable <Agency> GetAgenciesForSubStateRegion(int SubStateRegionId)
{
return(LookupDAL.GetAgenciesForSubStateRegion(SubStateRegionId));
}
public static IEnumerable <KeyValuePair <int, string> > GetPresentorsForState(string StateFIPS, bool IsActive)
{
return(LookupDAL.GetPresentorsForState(StateFIPS, IsActive));
}
public CustomerBusinessEntity GetCustomerById(int ID)
{
LookupDAL lookupDAL = new LookupDAL();
return(lookupDAL.GetCustomerById(ID));
}
public IEnumerable <KeyValuePair <string, string> > GetZipByAgencyIdForReport(int AgencyId, FormType formType)
{
return(LookupDAL.GetZipByAgencyIdForReport(AgencyId, formType));
}
public static IEnumerable <KeyValuePair <string, string> > GetCountyForAgency(int AgencyId)
{
return(LookupDAL.GetCountyForAgency(AgencyId));
}
public IEnumerable <KeyValuePair <int, string> > GetAgencies(string stateFIPS, string countyFIPS, string zip)
{
return(Mapper.Map <IEnumerable <Agency>, IEnumerable <KeyValuePair <int, string> > >(LookupDAL.GetAgencies(stateFIPS, countyFIPS, zip)));
}
/// <summary>
/// Returns the Sub State Regions for State, returned by Data Layer.
/// Caching is currently not supported by this method due to pressing importance of doing it.
/// It is to be noted that each State has its own Sub State Region list and so, once the
/// Caching requirement hits the priority list, this method will be modified to support it.
/// </summary>
/// <param name="StateFIPS"></param>
/// <returns></returns>
public static IDictionary <int, string> GetSubStateRegionsForState(string StateFIPS)
{
return(LookupDAL.GetSubStateRegionsForState(StateFIPS));
}
/// <summary>
/// Returns the CMS Regions, returned by Data Layer.
/// </summary>
/// <param name="StateFIPS"></param>
/// <returns></returns>
public static IDictionary <int, string> GetCMSRegions()
{
return(LookupDAL.GetCMSRegions());
}
public IEnumerable <KeyValuePair <string, string> > GetZipCodeForClientResidenceByState(string stateFIPS)
{
return(LookupDAL.GetZipForClientResidenceByState(stateFIPS));
}
public IEnumerable <KeyValuePair <string, string> > GetZipCodeForCounselorLocationByState(string stateFIPS, FormType formType)
{
return(LookupDAL.GetZipForCounselorLocationByState(stateFIPS, formType));
}
public IEnumerable <KeyValuePair <string, string> > GetZipCodeOfClientResidenceByAgencyIdForReport(int AgencyId)
{
return(LookupDAL.GetZipCodeOfClientResidenceByAgencyIdForReport(AgencyId));
}
/// <summary>
/// Returns Supervisors(Reviewers) for an Agency or Sub State
/// For State Users, refer to GetReviewersForStateScope.
/// </summary>
/// <param name="UserRegionId"></param>
/// <returns></returns>
public static IEnumerable <KeyValuePair <int, string> > GetReviewersByUserRegion(int UserRegionId, Scope UserScope)
{
return(LookupDAL.GetReviewersByUserRegion(UserRegionId, UserScope));
}
public List <LoanTypeEntity> GetLoanTypes()
{
LookupDAL lookupDAL = new LookupDAL();
return(lookupDAL.GetLoanTypes());
}
public IEnumerable <KeyValuePair <string, string> > GetCounties(string stateFIPS)
{
return(LookupDAL.GetCountiesNoMapping(stateFIPS));
}
/// <summary>
/// Returns ShipDirectorID for a given state.
/// </summary>
/// <param name="StateFIPS"></param>
/// <returns></returns>
public static int?GetShipDirectorForState(string StateFIPS)
{
return(LookupDAL.GetShipDirectorForState(StateFIPS));
}
/// <summary>
/// Get StateFIPS of all States that belong to a CMS Region
/// </summary>
/// <returns></returns>
public static IEnumerable <string> GetStatesForCMSRegion(int CMSRegionId)
{
return(LookupDAL.GetStatesForCMSRegion(CMSRegionId));
}
//most proabably not used now..
public IEnumerable <KeyValuePair <string, string> > GetCountyForCounselorLocationByAgencyId(int AgencyId)
{
return(Mapper.Map <IEnumerable <County>, IEnumerable <KeyValuePair <string, string> > >(LookupDAL.GetCountyForCounselorLocationByAgencyId(AgencyId)));
}
//public static IEnumerable<ZipCountyView> GetSubStateRegionForState(string StateFIPS)
//{
// List<ZipCountyView> ZipCodes = new List<ZipCountyView>();
// System.Data.IDataReader reader = LookupDAL.GetZipCodeOfCountyLocationForStateFips(StateFIPS);
// while (reader.Read())
// {
// ZipCodes.Add(new ZipCountyView(reader.GetString(0)));
// }
// return ZipCodes;
//}
public static string GetStateFipsCodeByShortName(string ShortName)
{
return(LookupDAL.GetStateFipsCodeByShortName(ShortName));
}
public static IDictionary <Int32, string> GetAgenciesForState(string StateFIPS, bool Inactive)
{
return(LookupDAL.GetAgenciesForStateLookup(StateFIPS, Inactive));
}
public LookupBO()
{
lookupDAL = new LookupDAL();
}
public List <QuestionEntity> GetQuestions()
{
LookupDAL lookupDAL = new LookupDAL();
return(lookupDAL.GetQuestions());
}