public ShowInfo BookTickets(BookingInformation bookinginformation) { Bookingdetails obj = new Bookingdetails(); Shows obj1 = new Shows(); var showobj = (from s in context.Shows where s.ShowId == bookinginformation.ShowId select s).FirstOrDefault(); obj.Customerid = bookinginformation.CustomerId; obj.Showid = bookinginformation.ShowId; obj.Paymentmethod = bookinginformation.Paymentmode; obj.Paymentdate = DateTime.Now; obj.Totalprice = bookinginformation.Seatno.Length * (int)showobj.Price; obj.Paymenttime = new TimeSpan(DateTime.Now.Hour, DateTime.Now.Minute, DateTime.Now.Second); context.Bookingdetails.Add(obj); context.SaveChanges(); //-------------------------------------------------- Bookedseat temp; foreach (string seat in bookinginformation.Seatno) { temp = new Bookedseat() { Seatno = seat, Bookingid = obj.Bookingid }; context.Bookedseat.Add(temp); } showobj.BookedSeat += bookinginformation.Seatno.Length; context.SaveChanges(); var ticketNosForInvoice = (from b in context.Bookedseat where b.Bookingid == obj.Bookingid select b).ToArray(); var info = (from s in context.Shows join m in context.Multiplex on s.MultiplexId equals m.MultiplexId join h in context.MultiplexHall on m.MultiplexId equals h.MultiplexId where s.ShowId == showobj.ShowId select new ShowInfo() { MultiplexName = m.MultiplexName, HallName = h.HallName }).FirstOrDefault(); for (int i = 0; i < ticketNosForInvoice.Length; i++) { ticketNosForInvoice[i].Booking = null; } info.Seats = ticketNosForInvoice; var moviename = (from s in context.Shows join m in context.Movie on s.MovieId equals m.MovieId where s.ShowId == showobj.ShowId select m.MovieName).FirstOrDefault(); info.MovieName = moviename; return(info); }
public int AddNew(Register register) { Customer customer = new Customer() { EmailId = register.EmailId, Name = register.Name, Password = register.Password, Phoneno = register.Phoneno }; context.Add(customer); int entry = context.SaveChanges(); return(entry); }