public static Office GetOffice(int id)
{
Office office;
using (CustomClearviewEntities ctx = new CustomClearviewEntities())
{
OfficeRepository repo = new OfficeRepository(ctx);
office = repo.Find(x => x.OfficeId == id, type => type.Users, type => type.Vendor);
}
return(office);
}