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