public DataSet RetrieveSeatsAvilable(int ScreeningID)//checked
{
DataTable dtUnAvilable = CinemaClass.RetrieveSeatsUnAvilable(ScreeningID);
int iCinemaID = Screening.RetrieveCinemaID(ScreeningID);
DataTable dt2 = new DataTable();
DataColumn dc = new DataColumn();
dc.ColumnName = "freeSeats";
dt2.Columns.Add(dc);
int seats = CinemaClass.NumberOfSeatsInCinema(iCinemaID);
for (int i = 0; i < seats; i++)
{
//Console.WriteLine(i);
int z = i + 1;
int j = 0;
bool flag = true;
while ((j < dtUnAvilable.Rows.Count) && (flag == true))
{
string snum = dtUnAvilable.Rows[j][0].ToString();
int num = int.Parse(snum);
if (z == num)
{
flag = false;
}
j = j + 1;
}
if (flag == true)
{
DataRow dr = dt2.NewRow();
dr["freeSeats"] = z;
dt2.Rows.Add(dr);
}
}
for (int i = 0; i < dt2.Rows.Count; i++)
{
for (int j = 0; j < dt2.Columns.Count; j++)
{
Console.Write(dt2.Rows[i][j] + " ");
}
Console.WriteLine();
}
//Console.WriteLine(dt2.Rows[2][0]);
//Console.WriteLine(dt2.Rows[0][0]);
//Console.ReadKey();
//Console.WriteLine(dt2.Rows.Count);
DataSet ds = new DataSet();
ds.Tables.Add(dt2);
return(ds);
//ds.Tables.Add
}
public DataSet TickectInvitationTable(int ScreeningID)//checked
{
DataSet ds = RetrieveSeatsAvilable(ScreeningID);
DataTable dt = ds.Tables[0];
bool flag;
int iCinemaID = Screening.RetrieveCinemaID(ScreeningID);
int seats = CinemaClass.NumberOfSeatsInCinema(iCinemaID);
DataTable dt2 = new DataTable();
dt2.Columns.Add("Seat");
dt2.Columns.Add("Status");
for (int i = 0; i < seats; i++)
{
int z = i + 1;
flag = false;
dt2.Rows.Add();
dt2.Rows[i]["Seat"] = z;
int j = 0;
while ((j < dt.Rows.Count) & (flag == false))
{
string sSeat = dt.Rows[j]["freeSeats"].ToString();
int seat = int.Parse(sSeat);
if (seat == z)
{
dt2.Rows[i]["Status"] = "Free";
flag = true;
}
else
{
dt2.Rows[i]["Status"] = "Taken";
}
j = j + 1;
}
}
//for (int i = 0; i < dt2.Rows.Count; i++)
//{
// for (int j = 0; j < dt2.Columns.Count; j++)
// {
// Console.Write(dt2.Rows[i][j] + " ");
// }
// Console.WriteLine();
//}
DataSet ds2 = new DataSet();
ds2.Tables.Add(dt2);
return(ds2);
}
