public IList<TheaterModelDTO> GetTheaters(string city)
{
IList<TheaterModelDTO> theaterList = new List<TheaterModelDTO>();
IList<Addresses.AddressModelDTO> addressList = new List<Addresses.AddressModelDTO>();
using (var context = new CinemaEntities())
{
var adddresses = (from address in context.Addresses
where address.City == city
select address).ToList();
if (adddresses.Count > 0)
{
foreach (var address in adddresses)
{
var addressRow = new Addresses.AddressModelDTO();
addressRow.AddressID = address.AddressID;
addressRow.ObjectID = address.ObjectID;
addressList.Add(addressRow);
Guid currentTheater = addressRow.ObjectID;
if (addressList != null)
{
using (var context1 = new CinemaEntities())
{
var theaters = (from theater in context1.Theaters
where theater.TheaterID == currentTheater
select theater).ToList();
if (theaters.Count>0)
{
foreach (var theater in theaters)
{
var theaterRow = new TheaterModelDTO();
theaterRow.Name = theater.Name;
theaterRow.TheaterID = theater.TheaterID;
theaterList.Add(theaterRow);
}
}
}
}
}
}
}
return theaterList;
}
public IList <TheaterModelDTO> GetTheaters(string city)
{
IList <TheaterModelDTO> theaterList = new List <TheaterModelDTO>();
IList <Addresses.AddressModelDTO> addressList = new List <Addresses.AddressModelDTO>();
using (var context = new CinemaEntities())
{
var adddresses = (from address in context.Addresses
where address.City == city
select address).ToList();
if (adddresses.Count > 0)
{
foreach (var address in adddresses)
{
var addressRow = new Addresses.AddressModelDTO();
addressRow.AddressID = address.AddressID;
addressRow.ObjectID = address.ObjectID;
addressList.Add(addressRow);
Guid currentTheater = addressRow.ObjectID;
if (addressList != null)
{
using (var context1 = new CinemaEntities())
{
var theaters = (from theater in context1.Theaters
where theater.TheaterID == currentTheater
select theater).ToList();
if (theaters.Count > 0)
{
foreach (var theater in theaters)
{
var theaterRow = new TheaterModelDTO();
theaterRow.Name = theater.Name;
theaterRow.TheaterID = theater.TheaterID;
theaterList.Add(theaterRow);
}
}
}
}
}
}
}
return(theaterList);
}
