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); }
public void VipPrice(int VipCost) { DataTable dt = Screening.RetrieveCinemaIDTable(); DataTable dt2 = Screening.ScreeningDates(); for (int i = 0; i < dt.Rows.Count; i++) { string sScreeningID = dt2.Rows[i]["ScreeningID"].ToString(); int iScreeningID = int.Parse(sScreeningID); string sCinemaID = dt.Rows[i]["CinemaID"].ToString(); int iCinemaID = int.Parse(sCinemaID); string kind = CinemaClass.CinemaKind(iCinemaID); if (kind == "vip") { int normalPrice = Screening.RetrieveScreeningPrice(iScreeningID); int sum = normalPrice + (normalPrice * VipCost / (100)); Screening.InputPrice(sum, iScreeningID); } } }
public bool IsSeatFree(int SeatNumber, int ScreeningID)//checked { bool flag; int i; i = 0; flag = true;//true-Free False-Taken DataTable dt = CinemaClass.RetrieveSeatsUnAvilable(ScreeningID); while ((flag == true) && (i < dt.Rows.Count)) { string sSeat = dt.Rows[i][0].ToString(); int iSeat = int.Parse(sSeat); if (iSeat == SeatNumber) { flag = false; } i = i + 1; } return(flag); }