public void OrderingTicket(int showtimeID, int customerID, int seatID, int ticketTypeID, string status)
{
using (CinemaEntities database = new CinemaEntities())
{
Ticket newTicket = database.Ticket.Create();
//obecna data
DateTime myDateTime = DateTime.Now;
//format daty poprawny do sql
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm");
newTicket.Ticket_ID = Convert.ToInt32(database.sp_getSeqTicketID().FirstOrDefault());
newTicket.Customer_ID = customerID;
newTicket.Showtime_ID = showtimeID;
newTicket.Seat_ID = seatID;
newTicket.Ticket_Type_ID = ticketTypeID;
newTicket.Status = status;
newTicket.Date = DateTime.Parse(sqlFormattedDate);
database.Ticket.Add(newTicket);
database.SaveChanges();
}
}