public async Task <IActionResult> OTPGeneration(ObjOTPGenerationRequest ObjOTPGeneration)
{
Random rnd = new Random();
int otp = rnd.Next(1000, 9999);
string msg = "your otp from Event Booking Registration is " + otp;
bool otpCheck = _eventBookingService.SendOTP("*****@*****.**", ObjOTPGeneration.Email, "Event Booking Authentication OTP", msg);
string ResponseMessage = await _eventBookingService.OTPGeneration(ObjOTPGeneration, Convert.ToString(otp));
return(Ok(ResponseMessage));
}
public async Task <string> OTPGenerationDB(ObjOTPGenerationRequest ObjOTPGeneration, string otp)
{
string ResponseMessage = "";
try
{
var param = new SqlParameter[] {
new SqlParameter()
{
ParameterName = "@userName",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 100,
Direction = System.Data.ParameterDirection.Input,
Value = string.IsNullOrEmpty(ObjOTPGeneration.Username)?String.Empty:ObjOTPGeneration.Username
},
new SqlParameter()
{
ParameterName = "@OTP",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = 10,
Direction = System.Data.ParameterDirection.Input,
Value = otp
},
new SqlParameter()
{
ParameterName = "@ResponseMessage",
SqlDbType = System.Data.SqlDbType.VarChar,
Size = -1,
Direction = System.Data.ParameterDirection.Output
}
};
string queryString = "";
queryString = "Sp_OTPGeneration @userName,@OTP,@ResponseMessage OUT";
ResponseMessage = await _IDBLayercs.ExecuteAsyncSql(param, queryString, 2);
//var _Context = new AuthenticationContext();
//int affectedRows = await _Context.Database.ExecuteSqlRawAsync("sp_PartnershipApprovalupdate @UserID,@userName,@BookingID,@ResponseMessage OUT", param);
//ResponseMessage = Convert.ToString(param[3].Value);
}
catch (Exception ex)
{
ResponseMessage = ex.Message.ToString();
}
return(ResponseMessage);
}
public async Task <string> OTPGeneration(ObjOTPGenerationRequest ObjOTPGeneration, string otp)
{
string ResponseMessage = await _eventBookingRepository.OTPGenerationDB(ObjOTPGeneration, otp);
return(ResponseMessage);
}