public bool InsertMemberWallet(Member_WalletBO objMember_WalletBO) { string fileLog = Path.GetDirectoryName(Path.Combine(pathLog, "Logs")); Sqlhelper helper = new Sqlhelper("", "ConnectionString"); try { bool rs = false; string sql = "SP_InsertMemberWallet"; SqlParameter[] pa = new SqlParameter[5]; pa[0] = new SqlParameter("@IndexWallet", objMember_WalletBO.IndexWallet); pa[1] = new SqlParameter("@IsActive", objMember_WalletBO.IsActive); pa[2] = new SqlParameter("@IsDelete", objMember_WalletBO.IsDelete); pa[3] = new SqlParameter("@MemberID", objMember_WalletBO.MemberID); pa[4] = new SqlParameter("@NumberCoin", objMember_WalletBO.NumberCoin); SqlCommand command = helper.GetCommand(sql, pa, true); int row = command.ExecuteNonQuery(); if (row > 0) { rs = true; } return(rs); } catch (Exception ex) { Utilitys.WriteLog(fileLog, ex.Message); return(false); } finally { helper.destroy(); } }
public bool InsertMemberWallet(Member_WalletBO member) { bool row = false; string fileLog = Path.GetDirectoryName(Path.Combine(pathLog)); try { row = Proxy.InsertMemberWallet(member); } catch (Exception ex) { Utility.WriteLog(fileLog, ex.Message); } return(row); }
public JsonResult RegisterMember(string strEmail, string strPassword, string strFullName, string strCaptcha) { try { // Email null if (strEmail == null || strEmail.Trim().Length == 0) { return(Json(new { intTypeError = 1, result = "", email = strEmail, password = strPassword, fullname = strFullName }, JsonRequestBehavior.AllowGet)); } //Email maxlength > 50 else if (strEmail.Trim().Length > 50) { return(Json(new { intTypeError = 2, result = "", email = strEmail, password = strPassword, fullname = strFullName }, JsonRequestBehavior.AllowGet)); } //password null || error if (strPassword == null || strPassword.Trim().Length == 0) { return(Json(new { InputType = 3, result = "", email = strEmail, password = strPassword, fullname = strFullName }, JsonRequestBehavior.AllowGet)); } //password maxlenght >=8 else if (strPassword.Trim().Length < 8) { return(Json(new { InputType = 4, result = "", email = strEmail, password = strPassword, fullname = strFullName }, JsonRequestBehavior.AllowGet)); } //fullname error || null if (strFullName == null || strFullName.Trim().Length == 0) { return(Json(new { intTypeError = 5, result = "", email = strEmail, password = strPassword, fullname = strFullName }, JsonRequestBehavior.AllowGet)); } //Captcha error || null if (strCaptcha == null || strCaptcha.Trim().Length == 0) { return(Json(new { intTypeError = 6, result = "", email = strEmail, password = strPassword, fullname = strFullName }, JsonRequestBehavior.AllowGet)); } string strResult = ""; MemberBO member = new MemberBO(); TempData["EmailRegister"] = strEmail; TempData["PasswordRegister"] = strPassword; TempData["FullNameRegister"] = strFullName; //TempData["MobileRegister"] = mobile; //string strCaptcha = Request["g-recaptcha-response"].ToString(); // string secretKey = secKey;/*"6LfhJyUUAAAAAPKM6Hl87lD0mVKa-0zPKNR53W_j";*/ var client = new WebClient(); var response = strCaptcha; var result1 = client.DownloadString(string.Format("https://www.google.com/recaptcha/api/siteverify?secret={0}&response={1}", secretKey, response)); var obj = JObject.Parse(result1); var status = (bool)obj.SelectToken("success"); if (status == false) { strResult = "errorCaptcha"; } else { member.FullName = strFullName; member.Email = strEmail; member.Mobile = ""; member.Password = Utility.MaHoaMD5(strPassword); member.IsActive = 0; member.IsDelete = 0; member.CreateDate = DateTime.Now; member.Gender = 1; member.Avatar = ""; bool checkEmail = repository.CheckEmailExists(strEmail); if (checkEmail) { strResult = "EmailExist"; } else { int returnAdminID = repository.InsertMember(member); if (returnAdminID > 0) { try { bool rsSendMail = BBH.BOS.Web.Models.SentMailServicesModels.WSSentMail.SendMailByVerifyMember(strEmail); member = repository.GetMemberDetailByEmail(strEmail); Member_WalletBO memberWallet = new Member_WalletBO(); if (member != null) { memberWallet.IndexWallet = member.MemberID; memberWallet.IsActive = 1; memberWallet.IsDelete = 0; memberWallet.MemberID = member.MemberID; memberWallet.NumberCoin = 0; } bool rs_ = repository.InsertMemberWallet(memberWallet); if (rs_) { strResult = "registerSuccess"; } } catch { } } else { strResult = "RegisterFaile"; } } } return(Json(new { intTypeError = 0, result = strResult, email = strEmail, password = strPassword, fullname = strFullName }, JsonRequestBehavior.AllowGet)); } catch (Exception objEx) { return(Json(new { intTypeError = 0, result = "RegisterFaile", email = strEmail, password = strPassword, fullname = strFullName, messageError = objEx.Message }, JsonRequestBehavior.AllowGet)); } }