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);
}
