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