/// <summary> /// 校验邮箱验证码是否正确 /// </summary> /// <param name="email">邮箱</param> /// <param name="code">手机验证码</param> /// <param name="message">返回信息(失效,超时...)</param> /// <param name="message">返回错误信息</param> /// <returns>是否正确</returns> public static bool CheckEmailVerfyCode(string code, out string message) { user = null; message = string.Empty; code = SecurityHelper.DESDecrypt(code, key); using (var db = new SQLiteDababase()) { var info = db.FirstOrDefault <TB_ValidCode>("where Code=@0", code); user = db.FirstOrDefault <TB_User>("where Email=@0", info.Target); if (!user.EmailValid) { user.EmailValid = true; user.EmailValidAt = DateTime.Now; user.Update(); } return(true); } return(false); }
public ActionResult Rechange(string telegramHandle, string ethAddress) { if (CurrentUserInfo == null) { return(RedirectToAction("Login")); } using (var db = new SQLiteDababase()) { TB_Recharge tB_Recharge = new TB_Recharge(); tB_Recharge.UserId = CurrentUserInfo.Id; tB_Recharge.TelegramHandle = telegramHandle; tB_Recharge.DesiredContribution = desiredContribution; tB_Recharge.ETHaddress = ethAddress; tB_Recharge.CreateAt = DateTime.Now; tB_Recharge.Insert(); return(Redirect("/Account/RechargeResult")); } }
public static bool SendEmailValidCode(string email, string url) { using (var db = new SQLiteDababase()) { var validCode = db.FirstOrDefault <TB_ValidCode>("where Target=@0 order by CreateAt desc", email); if (validCode == null || validCode.CreateAt < DateTime.Now.AddMinutes(-15)) { validCode = new TB_ValidCode(); validCode.Target = email; validCode.Code = GetVerifyCode(6); validCode.CreateAt = DateTime.Now; validCode.Insert(); } var enCode = SecurityHelper.DESEncrypt(validCode.Code, key); return(true); } }