Esempio n. 1
0
 public int BookSeats(CoreModels.BookingInfo bookSeats)
 {
     using (var database = new Database("BookMyShow"))
     {
         return(Convert.ToInt16(database.Insert("BookingInfo", "Id", bookSeats.Map <DataModels.BookingInfo>())));
     }
 }
Esempio n. 2
0
        public CoreModels.SeatsInfo GetSeatsInfo(CoreModels.BookingInfo bookingInfo)
        {
            List <CoreModels.BookingInfo> bookedSeats = GetBookedSeats(bookingInfo);

            CoreModels.SeatsInfo seatsInfo = new CoreModels.SeatsInfo();
            seatsInfo.PremiumSeats  = new List <CoreModels.Seat>();
            seatsInfo.StandardSeats = new List <CoreModels.Seat>();
            CoreModels.Theater theater;
            List <string>      unavailableSeats = new List <string>();

            foreach (var bookedSeat in bookedSeats)
            {
                var seats = bookedSeat.SeatsBooked.Split(',');
                unavailableSeats.AddRange(seats);
            }
            using (var database = new Database("bookMyShow"))
            {
                theater = database.FirstOrDefault <DataModels.Theater>("select * from Theaters where Id=@0", bookingInfo.TheaterId).Map <CoreModels.Theater>();
            }
            seatsInfo.NoOfPremiumRows  = theater.NoOfPremiumRows;
            seatsInfo.NoOfStandardRows = theater.NoOfStandardRows;

            char row = 'A';

            seatsInfo.PremiumSeats = CreateSeats(row, theater.NoOfPremiumRows, theater.NoOfSeatsPerRow, unavailableSeats);
            row = Convert.ToChar('A' + theater.NoOfPremiumRows);
            seatsInfo.StandardSeats = CreateSeats(row, theater.NoOfStandardRows, theater.NoOfSeatsPerRow, unavailableSeats);

            return(seatsInfo);
        }
Esempio n. 3
0
 public List <CoreModels.BookingInfo> GetBookedSeats(CoreModels.BookingInfo bookingInfo)
 {
     DataModels.BookingInfo dMbookingInfo = bookingInfo.Map <DataModels.BookingInfo>();
     using (var database = new Database("BookMyShow"))
     {
         return(database.Fetch <DataModels.BookingInfo>("Select * from BookingInfo where MovieId=@0 AND TheaterId=@1 AND ShowDate=@2 AND ShowTime=@3", dMbookingInfo.MovieId, dMbookingInfo.TheaterId, dMbookingInfo.ShowDate, dMbookingInfo.ShowTime).MapCollection <List <DataModels.BookingInfo>, List <CoreModels.BookingInfo> >());
     }
 }