public IActionResult Post([Bind("MovieID, CinemaID, ScheduleDate, SessionTime")] PostSchedule schedule) { PostSchedule schedule1 = schedule; List <PostSchedule> indatabase = new List <PostSchedule>(); sqlcmd = "INSERT INTO Session VALUES (@MovieID, @CinemaID, @ScheduleDate)"; var time = schedule1.SessionTime.Split(' '); var dateTime = time.Select(x => DateTime.Parse(x)); foreach (var date in dateTime) { indatabase.Add(new PostSchedule() { CinemaID = schedule1.CinemaID, MovieID = schedule1.MovieID, ScheduleDate = schedule1.ScheduleDate.AddHours(date.Hour).AddMinutes(date.Minute) }); } foreach (var item in indatabase) { _testBase.Execute <PostSchedule>(sqlcmd, item); } return(RedirectToAction(nameof(Index))); }
public IActionResult Edit(int id, [Bind("MovieName, CinemaName, SessionTime")] Schedule schedule) { PostSchedule post = new PostSchedule() { MovieID = Convert.ToInt32(schedule.MovieName), CinemaID = Convert.ToInt32(schedule.CinemaName), ScheduleDate = schedule.SessionTime }; sqlcmd = $"Update Session set MovieID = @MovieID," + $" CinemaID = @CinemaID," + $" SessionDate = @ScheduleDate where SessionID = {id}"; _testBase.Execute <PostSchedule>(sqlcmd, post); return(RedirectToAction(nameof(Index))); }