public int DeleteUserPackageRelation(UserPackageRelation userPackageRelation) { int isUpdated = 0; try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { NHibernate.IQuery query = session.CreateQuery("delete from userPackageRelation where Id = :adsid") .SetParameter("adsid", userPackageRelation.Id); isUpdated = query.ExecuteUpdate(); transaction.Commit(); return isUpdated; } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return 0; } } } } catch (Exception ex) { logger.Error("Error : " + ex.StackTrace); Console.WriteLine("Error : " + ex.StackTrace); } return isUpdated; }
public void AddUserPackageRelation(UserPackageRelation userPackageRelation) { try { using (NHibernate.ISession session = SessionFactory.GetNewSession()) { using (NHibernate.ITransaction transaction = session.BeginTransaction()) { session.Save(userPackageRelation); transaction.Commit(); } } } catch (Exception ex) { logger.Error("Error : " + ex.StackTrace); Console.WriteLine("Error : " + ex.StackTrace); } }