public static void DisplayAllTeachers()
{
ISession session = NHibernateHelper.GetCurrentSession();
try
{
using (var tx = session.BeginTransaction())
{
var teachers = session.CreateCriteria <Teacher>().List <Teacher>();
foreach (var teacher in teachers)
{
Console.WriteLine("{0} \t{1}, \t{2}", teacher.ID, teacher.FirstName, teacher.LastName);
}
tx.Commit();
}
Console.ReadLine();
}
finally
{
NHibernateHelper.CloseCurrentSession();
}
}
public static bool DeleteUser(int id)
{
ISession session = NHibernateHelper.GetCurrentSession();
try
{
using (var tx = session.BeginTransaction())
{
var stdnt = session.Get <Student>(id);
if (stdnt == null)
{
Console.WriteLine("Theres not user with that ID, try again!");
return(false);
}
Console.WriteLine("Retrieved by ID");
Console.WriteLine("{0} \t{1},\t{2}", stdnt.ID, stdnt.FirstName,
stdnt.LastName);
Console.WriteLine("\nFetch the complete list of again? Y/N");
string entireList = Console.ReadLine();
tx.Commit();
if (entireList == "Y".ToLower())
{
DisplayAllStudents();
}
return(true);
}
}
finally
{
NHibernateHelper.CloseCurrentSession();
}
}