public static void Create(Movie newMovie)
{
Movie tryRead = Read(newMovie.Title);
if (tryRead != new Movie())
{
using (var session = NHibernateHelpers.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
var Movie = new Movie
{
Title = newMovie.Title,
Runtime = newMovie.Runtime,
ReleaseYear = newMovie.ReleaseYear,
};
session.Save(Movie);
transaction.Commit();
MessageBox.Show("Created Movie: " + Movie.Title);
}
}
}
else
{
MessageBox.Show("Already Exists! Movie: " + newMovie.Title);
}
}
public static void Update(Movie newMovie)
{
using (var session = NHibernateHelpers.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
session.SaveOrUpdate(newMovie);
transaction.Commit();
MessageBox.Show("Updated Movie: " + newMovie.Title);
}
}
}
public static void Delete(Movie existingMovie)
{
using (var session = NHibernateHelpers.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
session.Delete(existingMovie);
transaction.Commit();
MessageBox.Show("Deleted Movie: " + existingMovie.Title);
}
}
}
public static Movie Read(string MovieTitle)
{
using (var session = NHibernateHelpers.OpenSession())
{
Movie MovieQuery = new Movie();
try
{
MovieQuery = (from movie in session.Query <Movie>()
where movie.Title == MovieTitle
select movie).Single();
}
catch (Exception exception)
{
return(new Movie());
}
//NhQueryProvider.cs
MessageBox.Show("Read Movie: " + MovieQuery.Title);
return(MovieQuery);
}
}
