public List <confirmOTP> GetOTP(string EmailAddress)
{
//Vehicle vehicleInfo = null;
List <confirmOTP> otp_list = new List <confirmOTP>();
using (SqlConnection con = new SqlConnection(GetStringConnect()))
{
string sql = "usp_GetOTP";
using (SqlCommand cmd = new SqlCommand(sql, con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmailAddress", EmailAddress);
con.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr != null)
{
while (dr.Read())
{
var otp_num = new confirmOTP();
otp_num.Id = Convert.ToInt32(dr["Id"]);
otp_num.OTP = dr["OTP"].ToString();
otp_num.EmailAddress = dr["EmailAddress"].ToString();
otp_list.Add(otp_num);
}
con.Close();
}
return(otp_list);
}
}
}
}
public IEnumerable <confirmOTP> GetOTP()
{
List <confirmOTP> _otp = new List <confirmOTP>();
using (SqlConnection con = new SqlConnection(GetStringConnect()))
{
con.Open();
using (SqlCommand cmd = new SqlCommand("SELECT * FROM Login_OTP", con))
{
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr != null)
{
while (dr.Read())
{
var otpInfo = new confirmOTP();
otpInfo.Id = Convert.ToInt32(dr["Id"]);
otpInfo.EmailAddress = dr["EmailAddress"].ToString();
otpInfo.OTP = dr["OTP"].ToString();
_otp.Add(otpInfo);
}
con.Close();
}
return(_otp);
}
}
}
}
public void SaveOTP(confirmOTP otp)
{
SqlConnection con = new SqlConnection(GetStringConnect());
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandText = "usp_IOTP";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@EmailAddress", otp.EmailAddress);
cmd.Parameters.AddWithValue("@OTP", otp.OTP);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
