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