public List <PhoneNumber> GetPhoneNumbers(string officerKey)
{
var returnVal = new List <PhoneNumber>();
using (var dbContext = new EasySpeedyMortgagesEntities())
{
returnVal = (from p in dbContext.PhoneNumbers
join op in dbContext.Officers_PhoneNumbers on p.id equals op.phone_number_id
join o in dbContext.Officers on op.officer_id equals o.id
where o.officer_key == officerKey
select p)
.ToList();
}
return(returnVal);
}
// todo: this returns too much info for just the officer dropdown. return only needed fields.
public static Officer GetOfficer(string officerKey)
{
Officer officer = null;
using (var context = new EasySpeedyMortgagesEntities())
{
officer = (from o in context.GetOfficer(officerKey)
select new Officer()
{
biography = o.biography,
biography_title = o.biography_title,
description = o.description,
id = o.id,
image = o.image ?? EsmGlobals.MissingImageFilename,
officer_name = o.officer_name,
nmls_number = o.nmls_number,
officer_key = o.officer_key
})
.FirstOrDefault();
}
return(officer);
}
public EsmMail(EasySpeedyMortgagesEntities dbContext)
{
_dbContext = dbContext;
}
public HomeController()
{
_db = new EasySpeedyMortgagesEntities();
}
public InitialBorrowerInfoDataModel()
{
_db = new EasySpeedyMortgages.EasySpeedyMortgagesEntities();
}
public ShortApplicationDataModel()
{
_db = new EasySpeedyMortgages.EasySpeedyMortgagesEntities();
}
public LoanOfficerDataModel()
{
_db = new EasySpeedyMortgages.EasySpeedyMortgagesEntities();
_db.Configuration.LazyLoadingEnabled = false;
_db.Configuration.AutoDetectChangesEnabled = false;
}
