//GET codes from an account public static List<TemporaryCode> getTemporaryCodes(String username) { List<TemporaryCode> list = new List<TemporaryCode>(); using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); SqlCommand getCommand = new SqlCommand("Select * from Temporary_Codes where EmailId = @Email", conn); getCommand.Parameters.AddWithValue("@Email", username); using (SqlDataReader rdr = getCommand.ExecuteReader()) { while (rdr.Read()) { TemporaryCode tc = new TemporaryCode(); tc.code = Convert.ToInt32(rdr["code"]); tc.contact = rdr["contact"].ToString(); tc.status = rdr["status"].ToString(); list.Add(tc); } } } return list; }
//Db for Codes public static TemporaryCode getTemporaryCode(String mail, String contact) { TemporaryCode tc = null; using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = connectionString; conn.Open(); SqlCommand getCommand = new SqlCommand("Select * from Temporary_Codes where EmailId = @Email AND contact=@contact", conn); getCommand.Parameters.AddWithValue("@Email", mail); getCommand.Parameters.AddWithValue("@contact", contact); using (SqlDataReader rdr = getCommand.ExecuteReader()) { if (rdr.Read()) { tc = new TemporaryCode(); tc.code = Convert.ToInt32(rdr["code"]); tc.contact = rdr["contact"].ToString(); tc.status = rdr["status"].ToString(); } } } return tc; }