public GetContactInfo GetContactInfo(int yearlyMaintenanceId) { GetContactInfo getContactInfo = new GetContactInfo(); IEnumerable <GetContactInfo> data; data = (from yearly in _ObjContext.YearlyMaintainence where yearly.YearlyMaintainenceId == yearlyMaintenanceId select new GetContactInfo { ShowStart = yearly.ShowStartDate, ShowEnd = yearly.ShowEndDate, ShowLocation = yearly.Location, contactInfo = (from contactInfo in _ObjContext.AAYHSContact where contactInfo.YearlyMaintainenceId == yearlyMaintenanceId select new ContactInfo { AAYHSContactId = contactInfo.AAYHSContactId, Email1 = contactInfo.Email1, Email2 = contactInfo.Email2, Phone1 = contactInfo.Phone1, Phone2 = contactInfo.Phone2, exhibitorSponsorConfirmationResponse = (from address in _ObjContext.AAYHSContactAddresses where contactInfo.ExhibitorSponsorConfirmationAddressId == address.AAYHSContactAddressId && address.IsDeleted == false select new ExhibitorSponsorConfirmationResponse { AAYHSContactAddressId = address.AAYHSContactAddressId, Address = address.Address, City = address.City, StateId = address.StateId, ZipCode = address.ZipCode }).FirstOrDefault(), exhibitorSponsorRefundStatementResponse = (from address in _ObjContext.AAYHSContactAddresses where contactInfo.ExhibitorSponsorRefundStatementAddressId == address.AAYHSContactAddressId && address.IsDeleted == false select new ExhibitorSponsorRefundStatementResponse { AAYHSContactAddressId = address.AAYHSContactAddressId, Address = address.Address, City = address.City, StateId = address.StateId, ZipCode = address.ZipCode }).FirstOrDefault(), exhibitorConfirmationEntriesResponse = (from address in _ObjContext.AAYHSContactAddresses where contactInfo.ExhibitorConfirmationEntriesAddressId == address.AAYHSContactAddressId && address.IsDeleted == false select new ExhibitorConfirmationEntriesResponse { AAYHSContactAddressId = address.AAYHSContactAddressId, Address = address.Address, City = address.City, StateId = address.StateId, ZipCode = address.ZipCode }).FirstOrDefault() }).FirstOrDefault() }); getContactInfo = data.FirstOrDefault(); return(getContactInfo); }
public GetContactInfo GetContactInfo(int yearlyMaintenanceId) { IEnumerable <GetContactInfo> data; GetContactInfo getContactInfo = new GetContactInfo(); data = (from contactInfo in _ObjContext.AAYHSContact where contactInfo.YearlyMaintainenceId == yearlyMaintenanceId select new GetContactInfo { contactInfo = (from info in _ObjContext.AAYHSContact where info.YearlyMaintainenceId == yearlyMaintenanceId select new ContactInfo { AAYHSContactId = info.AAYHSContactId, Email1 = info.Email1, Email2 = info.Email2, Phone1 = info.Phone1, Phone2 = info.Phone2, Location = info.Location, Address = info.Address, City = info.City, State = info.State, Zipcode = info.ZipCode }).FirstOrDefault(), exhibitorSponsorConfirmationResponse = (from address in _ObjContext.AAYHSContactAddresses where contactInfo.ExhibitorSponsorConfirmationAddressId == address.AAYHSContactAddressId && address.IsDeleted == false select new ExhibitorSponsorConfirmationResponse { AAYHSContactAddressId = address.AAYHSContactAddressId, Address = address.Address, City = address.City, StateId = address.StateId, ZipCode = address.ZipCode, Phone = address.Phone, Email = address.Email }).FirstOrDefault(), exhibitorSponsorRefundStatementResponse = (from address in _ObjContext.AAYHSContactAddresses where contactInfo.ExhibitorSponsorRefundStatementAddressId == address.AAYHSContactAddressId && address.IsDeleted == false select new ExhibitorSponsorRefundStatementResponse { AAYHSContactAddressId = address.AAYHSContactAddressId, Address = address.Address, City = address.City, StateId = address.StateId, ZipCode = address.ZipCode, Phone = address.Phone, Email = address.Email }).FirstOrDefault(), exhibitorConfirmationEntriesResponse = (from address in _ObjContext.AAYHSContactAddresses where contactInfo.ExhibitorConfirmationEntriesAddressId == address.AAYHSContactAddressId && address.IsDeleted == false select new ExhibitorConfirmationEntriesResponse { AAYHSContactAddressId = address.AAYHSContactAddressId, Address = address.Address, City = address.City, StateId = address.StateId, ZipCode = address.ZipCode, Phone = address.Phone, Email = address.Email }).FirstOrDefault() }); getContactInfo = data.FirstOrDefault(); return(getContactInfo); }