/// <summary>
/// Marks customer as active the first time throught active email
/// </summary>
/// <param name="customerId">Customer identifier</param>
public bool UpdateFirstActive(long customerId)
{
using (var dba = new BetEXDataContainer())
{
var member = dba.Members.Where(w => w.MemberID == customerId).SingleOrDefault();
if (member != null)
{
member.Status = Constant.Status.ACTIVE;
member.IsActive = true;
dba.SaveChanges();
return true;
}
return false;
}
}
public bool UpdateHistory(LoginHistory history)
{
using (var dba = new BetEXDataContainer())
{
try
{
var Orghistory = dba.LoginHistories.Where(w => w.ID == history.ID).SingleOrDefault();
if (Orghistory != null)
{
Orghistory.LogoutTime = history.LogoutTime;
dba.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
}
public bool Update(Member entity)
{
using (var dba = new BetEXDataContainer())
{
var member = dba.Members.Where(w => w.MemberID == entity.MemberID).SingleOrDefault();
if (member != null)
{
member.NickName = CommonHelper.EnsureNotNull(entity.NickName);
member.FirstName = CommonHelper.EnsureNotNull(entity.FirstName);
member.LastName = CommonHelper.EnsureNotNull(entity.LastName);
member.MiddleName = CommonHelper.EnsureNotNull(entity.MiddleName);
member.SecurityQuestion1 = CommonHelper.EnsureNotNull(entity.SecurityQuestion1) ?? member.SecurityQuestion1;
member.SecurityQuestion2 = CommonHelper.EnsureNotNull(entity.SecurityQuestion2) ?? member.SecurityQuestion2;
member.SecurityAnswer1 = CommonHelper.EnsureNotNull(entity.SecurityAnswer1) ?? member.SecurityAnswer1;
member.SecurityAnswer2 = CommonHelper.EnsureNotNull(entity.SecurityAnswer2) ?? member.SecurityAnswer2;
member.Address = CommonHelper.EnsureNotNull(entity.Address) ?? member.Address;
member.City = CommonHelper.EnsureNotNull(entity.City) ?? member.City;
member.PostalCode = CommonHelper.EnsureNotNull(entity.PostalCode) ?? member.PostalCode;
member.Telephone = CommonHelper.EnsureNotNull(entity.Telephone) ?? member.Telephone;
member.Cellphone = CommonHelper.EnsureNotNull(entity.Cellphone) ?? member.Cellphone;
member.Email1 = CommonHelper.EnsureNotNull(entity.Email1) ?? member.Email1;
member.Email2 = CommonHelper.EnsureNotNull(entity.Email2) ?? member.Email2;
member.Country = entity.Country;
member.Gender = entity.Gender;
member.Suffix = CommonHelper.EnsureNotNull(entity.Suffix) ?? member.Suffix;
member.TotalPoints = entity.TotalPoints ?? member.TotalPoints;
member.DiscountRate = entity.DiscountRate ?? member.DiscountRate;
member.LastUpdate = entity.LastUpdate ?? member.LastUpdate;
member.Language = CommonHelper.EnsureNotNull(entity.Language) ?? member.Language;
member.BettingRegion = CommonHelper.EnsureNotNull(entity.BettingRegion) ?? member.BettingRegion;
member.Timezone = CommonHelper.EnsureNotNull(entity.Timezone) ?? member.Timezone;
member.Currency = entity.Currency ?? member.Currency;
member.AutoLogout = entity.AutoLogout ?? member.AutoLogout;
member.EmailFormat = CommonHelper.EnsureNotNull(entity.EmailFormat) ?? member.EmailFormat;
dba.SaveChanges();
}
return true;
}
}
/// <summary>
/// Sets a customer email
/// </summary>
/// <param name="customerId">Customer identifier</param>
/// <param name="newEmail">New email</param>
/// <returns>Customer</returns>
public Member SetEmail(long customerId, string newEmail)
{
using (var dba = new BetEXDataContainer())
{
var member = dba.Members.Where(w => w.MemberID == customerId).SingleOrDefault();
if (member != null)
{
member.Email1 = newEmail;
dba.SaveChanges();
return member;
}
return null;
}
}
/// <summary>
/// Marks customer as deleted
/// </summary>
/// <param name="customerId">Customer identifier</param>
public bool MarkCustomerAsDeleted(long customerId)
{
using (var dba = new BetEXDataContainer())
{
var member = dba.Members.Where(w => w.MemberID == customerId).SingleOrDefault();
if (member != null)
{
member.Status = Constant.Status.DELETED;
dba.SaveChanges();
return true;
}
return false;
}
}
public long InsertHistory(LoginHistory history)
{
using (var dba = new BetEXDataContainer())
{
dba.AddToLoginHistories(history);
dba.SaveChanges();
return history.ID;
}
}
public void Insert(Member entity)
{
using (var dba = new BetEXDataContainer())
{
dba.AddToMembers(entity);
dba.SaveChanges();
}
}
