public ApiResult <User> ConfirmEmail(UserPostOTP item)
{
var result = new ApiResult <User>();
try
{
DbProvider.SetCommandText2("sp_User_ConfirmEmail", CommandType.StoredProcedure);
// Input parameter
DbProvider.AddParameter("UserId", item.Id, SqlDbType.Int);
DbProvider.AddParameter("OTP", item.OTP, SqlDbType.NVarChar);
// Output parameter
DbProvider.AddParameter("ErrCode", DBNull.Value, SqlDbType.NVarChar, 1000, ParameterDirection.Output);
DbProvider.AddParameter("ReturnMsg", DBNull.Value, SqlDbType.NVarChar, 4000, ParameterDirection.Output);
// Xử lý thủ tục và kết quả trả về từ DB
DbProvider.ExecuteNonQuery();
string errorCode = DbProvider.Command.Parameters["ErrCode"].Value.ToString();
if (!errorCode.Equals(Constants.SUCCESS))
{
result.Failed(new ErrorObject()
{
Code = DbProvider.Command.Parameters["ErrCode"].Value.ToString(),
Description = DbProvider.Command.Parameters["ReturnMsg"].Value.ToString()
});
}
}
catch (Exception ex)
{
result.Failed(new ErrorObject()
{
Code = Constants.ERR_EXCEPTION,
Description = ex.Message
});
}
return(result);
}
public IHttpActionResult ConfirmOTP(int Id = 0, string OTP = "", string SucRedirectUrl = "", string FailRedirectUrl = "")
{
var Rs = new ApiResult <User>();
if (Id == 0)
{
Rs.Failed(new ErrorObject {
Code = "UserId", Description = "UserId is required"
});
}
if (OTP.Trim() == "")
{
Rs.Failed(new ErrorObject {
Code = "OTPCOde", Description = "OTPCOde is Reuqired"
});
}
if (Rs.Errors.Count > 0)
{
return(Content(HttpStatusCode.BadRequest, Rs));
}
var item = new UserPostOTP()
{
Id = Id, OTP = OTP
};
var e = userDAL.ConfirmEmail(item);
if (!e.Succeeded)
{
return(Redirect(FailRedirectUrl));
}
else
{
return(Redirect(SucRedirectUrl));
}
}
