public int AddUserRefRelation(UserRefRelation userRefRelation)
{
int res = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
session.Save(userRefRelation);
transaction.Commit();
res = 1;
}
}
logger.Error("Coming out of AddUserRefRelation");
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
logger.Error("UserRefRelationRepository>>AddUserRefRelation" + ex.Message);
}
return res;
}
public int UpdateUserRefRelation(UserRefRelation userRefRelation)
{
int i = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
i = session.CreateQuery("Update UserRefRelation set ReferenceUserId =:referenceUserId, RefereeUserId =: refereeUserId , ReferenceUserEmail=:referenceUserEmail,RefereeUserEmail =:refereeUserEmail,EntryDate =:entryDate where Id = :id")
.SetParameter("referenceUserId", userRefRelation.ReferenceUserId)
.SetParameter("refereeUserId", userRefRelation.RefereeUserId)
.SetParameter("referenceUserEmail", userRefRelation.ReferenceUserEmail)
.SetParameter("refereeUserEmail", userRefRelation.RefereeUserEmail)
.SetParameter("entryDate", userRefRelation.EntryDate)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return i;
}
public int UpdateStatusById(UserRefRelation userRefRelation)
{
int i = 0;
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
i = session.CreateQuery("Update UserRefRelation set Status =:status where Id = :id")
.SetParameter("status", userRefRelation.Status)
.SetParameter("id", userRefRelation.Id)
.ExecuteUpdate();
transaction.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error : " + ex.StackTrace);
}
return i;
}
public List<UserRefRelation> GetUserRefRelationInfoByRefreeId(UserRefRelation userRefRelation)
{
List<UserRefRelation> lstUserRefRelation = new List<UserRefRelation>();
try
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
lstUserRefRelation = session.CreateQuery("from UserRefRelation u where u.RefereeUserId =:referenceUserId")
.SetParameter("referenceUserId", userRefRelation.ReferenceUserId)
.List<UserRefRelation>().ToList<UserRefRelation>();
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
}
return lstUserRefRelation;
}