public List <UsersLocale> get_User_Locale(string email) { List <UsersLocale> list_of_user_locale = new List <UsersLocale>(); SqlConnection con = null; try { con = connect("DBConnectionString"); // create a connection to the database using the connection String defined in the web config file String selectSTR = "SELECT * FROM UsersLocale where UsersLocale.Email='" + email + "'"; SqlCommand cmd = new SqlCommand(selectSTR, con); // get a reader SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); // CommandBehavior.CloseConnection: the connection will be closed after reading has reached the end while (dr.Read()) { UsersLocale ul = new UsersLocale(); ul.Locale = (string)dr["Locale"]; ul.Email = (string)dr["Email"]; ul.Id = (string)dr["Id"]; list_of_user_locale.Add(ul); } return(list_of_user_locale); } catch (Exception ex) { // write to log throw (ex); } finally { if (con != null) { con.Close(); } } }
public List <UsersLocale> Get(string email) { UsersLocale u = new UsersLocale(); return(u.get_User_Locale(email)); }