/// ------------------------------------------------------- /// <summary> /// 사용자 회원가입 /// </summary> /// <returns> 0:성공, <> 0 실패, 중복 ID 존재: -1</returns> /// ------------------------------------------------------- public int RegisterUser(TAcctMst objTAcctMst) { pl_objAesEncrypt = new AESEncrypt(); try { pl_objSqlCommand = new SqlCommand("dbo.UP_ACCT_INFO_NT_INS", pl_objSqlCon); pl_objSqlCommand.CommandType = CommandType.StoredProcedure; pl_objSqlCommand.Parameters.AddWithValue("@pi_strUserID", objTAcctMst.UserID); pl_objSqlCommand.Parameters.AddWithValue("@pi_strUserName", objTAcctMst.UserName); pl_objSqlCommand.Parameters.AddWithValue("@pi_strUserPwd", pl_objAesEncrypt.Encrypt(objTAcctMst.UserPwd)); pl_objSqlCommand.Parameters.AddWithValue("@pi_dtBirthDay", objTAcctMst.BirthDay); pl_objSqlCommand.Parameters.AddWithValue("@pi_intGenderCode", objTAcctMst.GenderCode); pl_objSqlCommand.Parameters.AddWithValue("@pi_strEmailAddr", objTAcctMst.EmailAddr); pl_objSqlParam = new SqlParameter(); pl_objSqlParam.ParameterName = "@po_intRetVal"; pl_objSqlParam.SqlDbType = SqlDbType.Int; pl_objSqlParam.Direction = ParameterDirection.Output; pl_objSqlCommand.Parameters.Add(pl_objSqlParam); pl_objSqlCon.Open(); pl_objSqlCommand.ExecuteNonQuery(); pl_intRetValue = Convert.ToInt32(pl_objSqlParam.Value); return(pl_intRetValue); } catch (Exception pl_objEx) { Console.WriteLine(pl_objEx); return(1); } finally { pl_objSqlCon.Close(); } }
public ActionResult RegisterFrm(TAcctMst objTAcctMst, FormCollection objFormCollect) { if (ModelState.IsValid) { pl_objAcctDao = new AccountDAO(); objTAcctMst.UserID = objFormCollect["UserID"]; objTAcctMst.UserName = objFormCollect["UserName"]; objTAcctMst.UserPwd = objFormCollect["UserPwd"]; objTAcctMst.BirthDay = Convert.ToDateTime(objFormCollect["BirthDay"]); objTAcctMst.GenderCode = Convert.ToByte(objFormCollect["GenderCode"]); objTAcctMst.EmailAddr = objFormCollect["EmailAddr"]; pl_intRegsterChkRetVal = pl_objAcctDao.RegisterUser(objTAcctMst); if (pl_intRegsterChkRetVal.Equals(0)) { ViewBag.Message = "User Details Saved"; return(RedirectToAction("LoginFrm", "Account")); } else if (pl_intRegsterChkRetVal.Equals(-1)) { ViewBag.Message = "Duplicated ID"; return(View(objTAcctMst)); } else { ViewBag.Message = "Login Fail"; return(View(objTAcctMst)); } } else { return(View("RegisterFrm", objTAcctMst)); } }