public DataSet Details()
{
int k = 0;
DataTable dt = new DataTable();
dt.Columns.Add("MovieID");
dt.Columns.Add("InvitationNumber");
dt.Columns.Add("LastScreeningDate");
dt.Columns.Add("DateEndOfMovie");
dt.Columns.Add("NumberOfScreenings");
DataTable dt1 = Movies.AllMovies();
for (int i = 0; i < dt1.Rows.Count; i++)
{
string movie = dt1.Rows[i]["MovieID"].ToString();
dt.Rows.Add();
dt.Rows[k]["MovieID"] = movie;
k = k + 1;
}
for (int j = 0; j < dt.Rows.Count; j++)
{
string movie2 = dt.Rows[j]["MovieID"].ToString();
int sum = Invitation.NumOfInviationsForMovieID(movie2);
string lastscreeningdate = Screening.LastScreeningDateForMovieID(movie2);
string dateend = Movies.MovieDateEnd(movie2);
int numofscreenings = Screening.NumOfScreeningForMovieID(movie2);
dt.Rows[j]["InvitationNumber"] = sum;
dt.Rows[j]["LastScreeningDate"] = lastscreeningdate;
dt.Rows[j]["DateEndOfMovie"] = dateend;
dt.Rows[j]["NumberOfScreenings"] = numofscreenings;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
Console.Write(dt.Rows[i][j] + " ");
}
Console.WriteLine();
}
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}