public IList <PerformanceModelDTO> GetPerformances(Guid theaterId)
{
IList <PerformanceModelDTO> performancesList = new List <PerformanceModelDTO>();
using (var context = new CinemaEntities())
{
var performances = (from performance in context.Perfomances.Include("Room")
where performance.TheaterID == theaterId
select performance).ToList();
foreach (var perform in performances)
{
var performanceRow = new PerformanceModelDTO();
performanceRow.PerformanceID = perform.PerfomanceID;
string date = perform.Date.ToString("yyyy'/'MM'/'dd");
performanceRow.Date = date; //(DateTime)perform.Date;
TimeSpan time = (TimeSpan)perform.StartingTime;
performanceRow.StartingTime = string.Format("{0:hh\\:mm}", time); // (TimeSpan)perform.StartingTime;
performanceRow.Title = perform.Movie.Title;
performanceRow.Price = perform.Price;
performanceRow.RoomNumber = perform.Room.RoomNumber;
performanceRow.Duration = perform.Duration;;
performancesList.Add(performanceRow);
}
}
return(performancesList);
}
public IList<PerformanceModelDTO> GetPerformances(Guid theaterId)
{
IList<PerformanceModelDTO> performancesList = new List<PerformanceModelDTO>();
using (var context = new CinemaEntities())
{
var performances = (from performance in context.Perfomances.Include("Room")
where performance.TheaterID == theaterId
select performance).ToList();
foreach (var perform in performances)
{
var performanceRow = new PerformanceModelDTO();
performanceRow.PerformanceID = perform.PerfomanceID;
string date = perform.Date.ToString("yyyy'/'MM'/'dd");
performanceRow.Date = date;//(DateTime)perform.Date;
TimeSpan time = (TimeSpan)perform.StartingTime;
performanceRow.StartingTime = string.Format("{0:hh\\:mm}", time);// (TimeSpan)perform.StartingTime;
performanceRow.Title = perform.Movie.Title;
performanceRow.Price = perform.Price;
performanceRow.RoomNumber = perform.Room.RoomNumber;
performanceRow.Duration = perform.Duration; ;
performancesList.Add(performanceRow);
}
}
return performancesList;
}
public IList<PerformanceModelDTO> GetPerformances(Guid theaterId)
{
IList<PerformanceModelDTO> performancesList = new List<PerformanceModelDTO>();
IList<RoomModelDTO>roomsList=new List<RoomModelDTO>();
using (var context1 = new CinemaEntities())
{
var rooms = (from room in context1.Rooms
where room.TheaterID == theaterId
select room).ToList();
if (rooms.Count > 0)
{
foreach (var room in rooms)
{
var roomRow = new RoomModelDTO();
roomRow.RoomNumber = room.RoomID;
roomRow.RoomNumber = room.RoomNumber;
roomsList.Add(roomRow);
if (roomsList != null)
{
using (var context = new CinemaEntities())
{
var performances = (from performance in context.Perfomances
where performance.TheaterID == theaterId
select performance).ToList();
foreach (var perform in performances)
{
var performanceRow = new PerformanceModelDTO();
performanceRow.PerformanceID = perform.PerfomanceID;
performanceRow.Tilte = perform.Movie.Title;
performanceRow.Price = perform.Price;
//performanceRow.Room.RoomNumber = perform.Room.RoomNumber;
performanceRow.Duration = perform.Duration; ;
performancesList.Add(performanceRow);
}
}
}
}
}
} return performancesList;
}
public IList <PerformanceModelDTO> GetPerformances(Guid theaterId)
{
IList <PerformanceModelDTO> performancesList = new List <PerformanceModelDTO>();
IList <RoomModelDTO> roomsList = new List <RoomModelDTO>();
using (var context1 = new CinemaEntities())
{
var rooms = (from room in context1.Rooms
where room.TheaterID == theaterId
select room).ToList();
if (rooms.Count > 0)
{
foreach (var room in rooms)
{
var roomRow = new RoomModelDTO();
roomRow.RoomNumber = room.RoomID;
roomRow.RoomNumber = room.RoomNumber;
roomsList.Add(roomRow);
if (roomsList != null)
{
using (var context = new CinemaEntities())
{
var performances = (from performance in context.Perfomances
where performance.TheaterID == theaterId
select performance).ToList();
foreach (var perform in performances)
{
var performanceRow = new PerformanceModelDTO();
performanceRow.PerformanceID = perform.PerfomanceID;
performanceRow.Tilte = perform.Movie.Title;
performanceRow.Price = perform.Price;
//performanceRow.Room.RoomNumber = perform.Room.RoomNumber;
performanceRow.Duration = perform.Duration;;
performancesList.Add(performanceRow);
}
}
}
}
}
} return(performancesList);
}