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