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 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;
}
/// <summary>
/// to check user reference and update user expiry , userrefrencerelation status
/// created by Abhay Kr 5-3-2014
/// </summary>
/// <param name="RefereeId"></param>
/// <returns></returns>
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;
}
/// <summary>
/// to check user reference and update user expiry , userrefrencerelation status
/// created by Abhay Kr 5-3-2014
/// </summary>
/// <param name="RefereeId"></param>
/// <returns></returns>
public bool IsUserReferenceActivated(string RefereeId)
{
bool ret = false;
try
{
User objUser = new User();
UserRepository objUserRepository = new UserRepository();
UserRefRelation objUserRefRelation = new UserRefRelation();
UserRefRelationRepository objUserRefRelationRepository = new UserRefRelationRepository();
objUserRefRelation.ReferenceUserId = (Guid.Parse(RefereeId));
List<UserRefRelation> lstUserRefRelation = objUserRefRelationRepository.GetUserRefRelationInfoById(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);
int objUserRepositoryresponse = objUserRepository.UpdateUserExpiryDateById(objUser);
int objUserRefRelationRepositoryresponse = objUserRefRelationRepository.UpdateStatusById(objUserRefRelation);
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
return ret;
}
public List<UserRefRelation> GetUserRefRelationInfoById(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.ReferenceUserId =: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;
}
