public MobileOTP GetOTP(string username) { MobileOTP mobileOTP = new MobileOTP(); using (SqlConnection _con = new SqlConnection(_connectionString)) { using (SqlCommand cmd = new SqlCommand("Get_OTP", _con)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@USERNAME", System.Data.SqlDbType.NVarChar).Value = username; cmd.Parameters.Add("@OTP", System.Data.SqlDbType.NVarChar, 50).Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add("@MOBILENO", System.Data.SqlDbType.NVarChar, 50).Direction = System.Data.ParameterDirection.Output; _con.Open(); try { cmd.ExecuteNonQuery(); mobileOTP.MobileNo = cmd.Parameters["@MOBILENO"].Value?.ToString(); mobileOTP.OTP = cmd.Parameters["@OTP"].Value?.ToString(); } catch (Exception) { throw; } finally { _con.Close(); } } } return(mobileOTP); }
public MobileOTP GenerateOTP(OTPRequest request) { Random random = new Random(); MobileOTP mobileOTP = new MobileOTP(); mobileOTP.OTP = random.Next(100, 9999).ToString("0000"); using (SqlConnection _con = new SqlConnection(_connectionString)) { using (SqlCommand cmd = new SqlCommand("CREATE_OTP", _con)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@USERNAME", System.Data.SqlDbType.NVarChar).Value = request.UserName; cmd.Parameters.Add("@OTP", System.Data.SqlDbType.NVarChar).Value = mobileOTP.OTP; cmd.Parameters.Add("@IPADDRESS", System.Data.SqlDbType.NVarChar).Value = request.IPAddress; cmd.Parameters.Add("@LATITUDE", System.Data.SqlDbType.Decimal).Value = request.Latitude; cmd.Parameters.Add("@LONGITUDE", System.Data.SqlDbType.Decimal).Value = request.Longitude; cmd.Parameters.Add("@ACTIONPAGEID", System.Data.SqlDbType.Int).Value = request.ActionPageID; cmd.Parameters.Add("@MOBILENO", System.Data.SqlDbType.NVarChar, 50).Direction = System.Data.ParameterDirection.Output; _con.Open(); try { cmd.ExecuteNonQuery(); mobileOTP.MobileNo = cmd.Parameters["@MOBILENO"].Value?.ToString(); } catch (Exception) { throw; } finally { _con.Close(); } } } return(mobileOTP); }