public void AddShowtime(int movieID, int screenID, string date, string technology) { using (CinemaEntities database = new CinemaEntities()) { Showtime showtime = database.Showtime.Create(); showtime.Showtime_ID = Convert.ToInt32(database.sp_getSeqShowtimeID().FirstOrDefault()); showtime.Movie_ID = movieID; showtime.Screen_ID = screenID; showtime.Date = DateTime.Parse(date); showtime.Technology = technology; database.Showtime.Add(showtime); database.SaveChanges(); } }