Line 119: select q).ToList(); */
Line 120:
Line 121: var Result = (idc.EventLocations.Join(idc.Cities, el => el.CityId, c => c.ID, (el, c) => new { el.id, StartDate = el.StartDate, el.RegClosingDate, el.EndDate, el.CountryId, el.EventId, el.CityId, CityName = c.Name }).Join(idc.Countries, eloc => eloc.CountryId, con => con.Id, (eloc, con) => new { eloc.id, eloc.CountryId, eloc.EventId, eloc.RegClosingDate, eloc.EndDate, eloc.StartDate, eloc.CityId, eloc.CityName, CountryName = con.Name })).Join(idc.Events, elocc => elocc.EventId, EvenId => EvenId.Id, (elocc, EvenId) => new { elocc.id, elocc.StartDate, elocc.EndDate, elocc.RegClosingDate, elocc.EventId, elocc.CityName, elocc.CountryName, EvenId.Picture }).Where(a => a.EventId == Convert.ToInt64(eventid)).OrderBy(b => b.RegClosingDate).ToList();
Line 122:
Line 123: int cnt = Result.Count();
|