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); }
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 void AddUserRefreeRelation(User objReferee, User objReference) { try { logger.Error("Entered AddUserRefreeRelation"); UserRefRelation objUserRefRelation = new UserRefRelation(); UserRefRelationRepository objUserRefRelationRepository = new UserRefRelationRepository(); objUserRefRelation.Id = Guid.NewGuid(); objUserRefRelation.RefereeUserId = objReferee.Id; objUserRefRelation.ReferenceUserId = objReference.Id; objUserRefRelation.ReferenceUserEmail = objReference.EmailId; objUserRefRelation.RefereeUserEmail = objReferee.EmailId; objUserRefRelation.EntryDate = DateTime.Now; objUserRefRelation.Status = "0"; objUserRefRelationRepository.AddUserRefRelation(objUserRefRelation); logger.Error("Coming out of AddUserRefreeRelation"); } catch (Exception ex) { Console.WriteLine(ex.Message); logger.Error(ex.Message); } }
public bool IsUserReferenceActivated(string RefereeId) { //testing Console.WriteLine("Inside " + RefereeId); bool ret = false; try { User objUser = new User(); Package objPackage = new Package(); UserPackageRelation objUserPackageRelation = new UserPackageRelation(); UserRepository objUserRepository = new UserRepository(); UserPackageRelationRepository objUserPackageRelationRepository = new UserPackageRelationRepository(); UserRefRelation objUserRefRelation = new UserRefRelation(); UserRefRelationRepository objUserRefRelationRepository = new UserRefRelationRepository(); PackageRepository objPackageRepository = new PackageRepository(); objUserRefRelation.ReferenceUserId = (Guid.Parse(RefereeId)); //testing List <UserRefRelation> check = objUserRefRelationRepository.GetUserRefRelationInfo(); //testing List <UserRefRelation> lstUserRefRelation = objUserRefRelationRepository.GetUserRefRelationInfoByRefreeId(objUserRefRelation); if (lstUserRefRelation.Count > 0) { if (lstUserRefRelation[0].Status == "0") { objUserRefRelation = lstUserRefRelation[0]; objUserRefRelation.Status = "1"; objUser = objUserRepository.getUsersById(lstUserRefRelation[0].ReferenceUserId); objUser.ExpiryDate = objUser.ExpiryDate.AddDays(30); objUser.AccountType = "Premium"; objPackage = objPackageRepository.getPackageDetails("Premium"); objUserPackageRelation.Id = Guid.NewGuid(); objUserPackageRelation.UserId = objUser.Id; objUserPackageRelation.PackageId = objPackage.Id; objUserPackageRelation.ModifiedDate = DateTime.Now; objUserPackageRelation.PackageStatus = true; objUserPackageRelationRepository.AddUserPackageRelation(objUserPackageRelation); int objUserRepositoryresponse = objUserRepository.UpdateUserExpiryDateById(objUser); int objUserRefRelationRepositoryresponse = objUserRefRelationRepository.UpdateStatusById(objUserRefRelation); } } } catch (Exception ex) { logger.Error(ex.Message); } return(ret); }
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); }