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