public string GetStrMemberID(string strEMail)
{
string strMembverID = "not found user";
SE_Member se = db.SE_Member.FirstOrDefault(u => u.strEMail == strEMail);
//防呆
if (se != null)
{
strMembverID = se.strMemberID;
}
return(strMembverID);
}
public bool AccountCheckstrMemberID(string strMemberID)
{
bool isExist = false;
SE_Member se = db.SE_Member.FirstOrDefault(u => u.strMemberID == strMemberID);
//防呆
if (se != null)
{
isExist = true;
}
return(isExist);
}
public String GetUserData(string strEMail, string strCookieID)
{
SE_Member loginMember = db.SE_Member.FirstOrDefault(u => u.strEMail == strEMail);
LoginModel loginInfo = new LoginModel();
loginInfo.strMemberID = loginMember.strMemberID;
loginInfo.strName = loginMember.strName;
loginInfo.strCookieID = strCookieID;
String UserData = new JavaScriptSerializer().Serialize(loginInfo);
return(UserData);
}
public bool CheckStrActivateCode(string strMemberID, string strActivateCode)
{
bool IsValdate = false;
SE_Member tamp = db.SE_Member.FirstOrDefault(u => u.strMemberID.Equals(strMemberID));
tamp = db.SE_Member.FirstOrDefault(u => u.strActivateCode.Equals(strActivateCode));
SE_Member se = db.SE_Member.FirstOrDefault(u => u.strMemberID.Equals(strMemberID) && u.strActivateCode.Equals(strActivateCode));
//防呆
if (se != null)
{
IsValdate = true;
}
return(IsValdate);
}
public bool UpdateActive(string strMemberID)
{
SE_Member se = db.SE_Member.FirstOrDefault(u => u.strMemberID == strMemberID);
bool IsUpdate = false;
se.ysnActivate = true;
se.ysnActive = true;
try
{
db.SaveChanges();
IsUpdate = true;
}
catch (DbEntityValidationException ex)
{
throw ex;
}
return(IsUpdate);
}
public bool RegisterNewMember(RegisterViewModel register)
{
SE_Member newMember = new SE_Member();
bool isInsert = false;
using (RNGCryptoServiceProvider provider = new RNGCryptoServiceProvider())
{
byte[] data = new byte[8];
provider.GetBytes(data);
newMember.strMemberID = Convert.ToBase64String(data);
}
newMember.strEMail = register.strEMail;
newMember.strName = register.strName;
newMember.strPhone = "";
newMember.strPassword = register.strPassword;
newMember.dtmBirth = register.dtmBirth;
newMember.intZipCode = register.intZipCode;
newMember.strAddress = register.strAddress;
newMember.strMobile = register.strMobile;
newMember.dtmCreate = DateTime.Now;
newMember.ysnPolicy = false;
newMember.ysnDM = false;
newMember.ysnSMS = false;
newMember.ysnTel = false;
newMember.dtmUpdate = DateTime.Now;
newMember.strWHO = "FAQ";
newMember.strDisplayName = "";
try
{
db.SE_Member.Add(newMember);
db.SaveChanges();
isInsert = true;
}
catch (DbEntityValidationException ex)
{
throw ex;
}
return(isInsert);
}
public string RegisterNewMember(RegisterViewModel register, string strActivateCode)
{
SE_Member newMember = new SE_Member();
string isInsert = "";
newMember.strMemberID = Guid.NewGuid().ToString("D");//***亂數產生器
newMember.strEMail = register.strEMail;
newMember.strName = register.strName;
newMember.strPhone = "";
newMember.strPassword = register.strPassword;
newMember.dtmBirth = register.dtmBirth;
newMember.intZipCode = register.intZipCode;
newMember.strAddress = register.strAddress;
newMember.strMobile = register.strMobile;
newMember.dtmCreate = DateTime.Now;
newMember.ysnPolicy = false;
newMember.ysnDM = false;
newMember.ysnSMS = false;
newMember.ysnTel = false;
newMember.dtmUpdate = DateTime.Now;
newMember.strActivateCode = strActivateCode;
newMember.strWHO = "FAQ";
newMember.strDisplayName = "";
try
{
db.SE_Member.Add(newMember);
db.SaveChanges();
isInsert = newMember.strMemberID;
}
catch (DbEntityValidationException ex)
{
throw ex;
}
return(isInsert);
}
public string LoginCheck(string Account, string password)
{
SE_Member loginMember = db.SE_Member.FirstOrDefault(u => u.strEMail == Account);
string status = "";
if (loginMember != null)
{
if (!PasswordCheck(loginMember, password))
{
status = "WrongPassword";
}
else
{
if (!loginMember.ysnActive)
{
status = "notActive";
}
else
{
if (!loginMember.ysnActivate)
{
status = "notActivate";
}
else
{
status = "Success";
}
}
}
}
else
{
status = "NoAccount";
}
return(status);
}
protected bool PasswordCheck(SE_Member checkMember, string Password)
{
bool result = checkMember.strPassword.Equals(Password);
return(result);
}
public void Register(SE_Member member)
{
db.SE_Member.Add(member);
db.SaveChanges();
}
