//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;
}
