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);
}
