public PeoplesViewModel ReadPerson(int id, string culture) { var person = (from p in context.People where p.Id == id select new PeoplesViewModel { Id = p.Id, BloodClass = p.BloodClass, BirthCity = p.BirthCity, BirthCountry = p.BirthCountry, WorkTel = p.WorkTel, ProviderId = p.ProviderId, EmergencyTel = p.EmergencyTel, BirthDate = p.BirthDate, ExpiryDate = p.ExpiryDate, Familyname = p.Familyname, Gender = p.Gender, localName = HrContext.TrlsName(p.Title + " " + p.FirstName + " " + p.Familyname, culture), Attachments = HrContext.GetAttachments("People", p.Id), BirthDstrct = p.BirthDstrct, Fathername = p.Fathername, FirstName = p.FirstName, HomeTel = p.HomeTel, GFathername = p.GFathername, IssueDate = p.IssueDate, JoinDate = p.JoinDate, IssuePlace = p.IssuePlace, KafeelId = p.KafeelId, InspectDate = p.InspectDate, MaritalStat = p.MaritalStat, MedStatDate = p.MedStatDate, Mobile = p.Mobile, MedicalStat = p.MedicalStat, Rank = p.Rank, MilResDate = p.MilResDate, MilCertGrade = p.MilCertGrade, MilitaryNo = p.MilitaryNo, MilStatDate = p.MilStatDate, NationalId = p.NationalId, MilitaryStat = p.MilitaryStat, Nationality = p.Nationality, PassportNo = p.PassportNo, Profession = p.Profession, RecommenReson = p.RecommenReson, Recommend = p.Recommend, Religion = p.Religion, OtherEmail = p.OtherEmail, Ssn = p.Ssn, QualificationId = p.QualificationId, Title = p.Title, WorkEmail = p.WorkEmail, TaxFamlyCnt = p.TaxFamlyCnt, BnftFamlyCnt = p.BnftFamlyCnt, StartExpDate = p.StartExpDate, EmpStatus = HrContext.GetEmpStatus(p.Id), CreatedTime = p.CreatedTime, ModifiedTime = p.ModifiedTime, ModifiedUser = p.ModifiedUser, CreatedUser = p.CreatedUser, PicUrl = HrContext.GetDocument("EmployeePic", p.Id), HasImage = p.HasImage, IdIssueDate = p.IdIssueDate, VisaNo = p.VisaNo, VarSubAmt = p.VarSubAmt, BasicSubAmt = p.BasicSubAmt, SubscripDate = p.SubscripDate, Address1 = p.Address1, CityId = p.CityId, CountryId = p.CountryId, DistrictId = p.DistrictId, HoAddress = p.HoAddress, Latitude = p.Latitude, Longitude = p.Longitude, TreatCardNo = p.TreatCardNo, Status = p.Status, PaperStatus = p.PaperStatus }).FirstOrDefault(); return(person); }