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