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