/// <summary>
/// Создание нового сеанса
/// </summary>
/// <param name="newdate"></param>
/// <param name="filmId"></param>
/// <param name="cinemaId"></param>
public static void Insert(DateTime? newdate, int? filmId, int? cinemaId)
{
using (var ctx = new test5Entities())
{
Debug.Assert(newdate != null, "newdate != null");
Debug.Assert(cinemaId != null, "cinemaId != null");
Debug.Assert(filmId != null, "filmId != null");
var i = new session
{
start = newdate.Value,
cinema_id = cinemaId.Value,
film_id = filmId.Value
};
ctx.session.Add(i);
ctx.SaveChanges();
}
}
/// <summary>
/// Удаление сеанса
/// </summary>
/// <param name="sessionId"></param>
public static void Delete(int? sessionId)
{
using (var ctx = new test5Entities())
{
var s = ctx.session.FirstOrDefault(i => i.session_id == sessionId.Value);
if (s != null)
{
ctx.session.Remove(s);
ctx.SaveChanges();
}
}
}
/// <summary>
/// Изменение сеанса
/// </summary>
/// <param name="sessionId"></param>
/// <param name="newdate"></param>
/// <param name="filmId"></param>
/// <param name="cinemaId"></param>
public static void Update(int? sessionId, DateTime newdate, int? filmId, int? cinemaId)
{
using (var ctx = new test5Entities())
{
var s = ctx.session.FirstOrDefault(i => i.session_id==sessionId.Value);
if (s != null)
{
Debug.Assert(filmId != null, "filmId != null");
s.film_id = filmId.Value;
Debug.Assert(cinemaId != null, "cinemaId != null");
s.cinema_id = cinemaId.Value;
s.start = newdate;
ctx.SaveChanges();
}
}
}
