public Shows GetShowDetailsByCriteria(int movieId, short cityId, DateTime fromDate, DateTime toDate)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter()
{
ParameterName = "@MovieId", Value = movieId
});
param.Add(new SqlParameter()
{
ParameterName = "@CityId", Value = cityId
});
param.Add(new SqlParameter()
{
ParameterName = "@FromDate", Value = fromDate
});
param.Add(new SqlParameter()
{
ParameterName = "@ToDate", Value = toDate
});
DataSet ds = Select(StoredProcedureName.GET_SHOW_LIST, param);
Shows showDetails = new Shows();
List <DayWiseShowDetails> showList = new List <DayWiseShowDetails>();
List <CinemaDetails> cinemaList = null;
DateTime currentDate = fromDate;
int cinemaId = 0;
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
while (currentDate <= toDate)
{
DayWiseShowDetails currentDayDetails = new DayWiseShowDetails();
currentDayDetails.ShowDate = currentDate;
cinemaList = new List <CinemaDetails>();
foreach (DataRow currentCinema in ds.Tables[0].Rows)
{
if (Convert.ToDateTime(currentCinema["ShowDate"]).ToShortDateString() == currentDate.ToShortDateString())
{
cinemaId = currentCinema["CinemaId"].ToIntSafe();
if (cinemaList.Select(c => c.CinemaId).Contains(cinemaId))
{
continue;
}
string cinemaName = currentCinema["CinemaName"].ToStringSafe();
CinemaDetails cinema = new CinemaDetails {
CinemaId = cinemaId, CinemaName = cinemaName
};
string filter = "CinemaId=" + currentCinema["CinemaId"].ToString() + " and " + "ShowDate='" + currentDayDetails.ShowDate + "'";
cinema.ShowList = ds.Tables[0].Select(filter).ConvertToList <ShowDetails>();
cinemaList.Add(cinema);
}
}
if (cinemaList != null)
{
currentDayDetails.CinemaList = cinemaList;
}
showList.Add(currentDayDetails);
TimeSpan duration = new TimeSpan(1, 0, 0, 0);
currentDate = currentDate.Add(duration);
}
}
if (showList != null)
{
showDetails.ShowList = showList;
}
return(showDetails);
}
public CinemaShows GetShowDetailsByCinemaId(int cinemaId, DateTime fromDate, DateTime toDate)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter()
{
ParameterName = "@CinemaId", Value = cinemaId
});
param.Add(new SqlParameter()
{
ParameterName = "@FromDate", Value = fromDate
});
param.Add(new SqlParameter()
{
ParameterName = "@ToDate", Value = toDate
});
DataSet ds = Select(StoredProcedureName.GET_SHOW_LIST_BY_CINEMA_ID, param);
CinemaShows showDetails = new CinemaShows();
List <DayWiseShowDetails> showList = new List <DayWiseShowDetails>();
List <CinemaMovieDetails> movieList = null;
DateTime currentDate = fromDate;
int movieId = 0;
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
while (currentDate <= toDate)
{
DayWiseShowDetails currentDayDetails = new DayWiseShowDetails();
currentDayDetails.ShowDate = currentDate;
movieList = new List <CinemaMovieDetails>();
foreach (DataRow currentMovie in ds.Tables[0].Rows)
{
if (Convert.ToDateTime(currentMovie["ShowDate"]).ToShortDateString() == currentDate.ToShortDateString())
{
movieId = currentMovie["MovieId"].ToIntSafe();
if (movieList.Select(c => c.MovieId).Contains(movieId))
{
continue;
}
string movieName = currentMovie["MovieName"].ToStringSafe();
CinemaMovieDetails movie = new CinemaMovieDetails {
MovieId = movieId, MovieName = movieName
};
string filter = "MovieId=" + currentMovie["MovieId"].ToString() + " and " + "ShowDate='" + currentDayDetails.ShowDate + "'";
movie.ShowList = ds.Tables[0].Select(filter).ConvertToList <ShowDetails>();
movieList.Add(movie);
}
}
if (movieList != null)
{
currentDayDetails.MovieList = movieList;
}
showList.Add(currentDayDetails);
TimeSpan duration = new TimeSpan(1, 0, 0, 0);
currentDate = currentDate.Add(duration);
}
}
if (showList != null)
{
showDetails.ShowList = showList;
}
return(showDetails);
}
