public IQueryable <CompanyViewModel> GetAllCompanies(string culture) { var lang = culture.Split('-')[0]; var result = context.Companies.Select(company => new CompanyViewModel { Id = company.Id, SearchName = company.SearchName != null ? company.SearchName : "", Name = company.Name, LocalName = HrContext.TrlsName(company.Name, culture), LogoUrl = HrContext.GetCompanyDoc("Company", company.Id, 1), Purpose = HrContext.GetLookUpCode("Purpose", company.Purpose.Value, culture), Country = lang == "ar" ? company.Country.NameAr : company.Country.Name, Email = company.Email, WebSite = company.WebSite, Attachement = HrContext.GetDoc("CompanyLogo", company.Id) }); return(result); }