public static List<User> getAll()
{
Database db = new Database();
List<User> users = new List<User>();
string queryString = "select * from Users";
SqlDataReader reader = db.query(queryString);
if (reader.HasRows)
{
while (reader.Read())
{
User user = new User();
user.Username = reader["username"].ToString();
user.Password = reader["password"].ToString();
user.CreateAt = reader["create_at"].ToString();
users.Add(user);
}
}
db.Disconnect();
return users;
}
public static User find(string username)
{
Database db = new Database();
string queryString = "select * from Users where username = @username";
List<SqlParameter> atrs = new List<SqlParameter>()
{
new SqlParameter() {ParameterName = "@username",SqlDbType= SqlDbType.NVarChar,Value = username }
};
SqlDataReader reader = db.query(queryString, atrs);
if (reader.HasRows)
{
while (reader.Read())
{
User user = new User();
user.Username = reader["username"].ToString();
user.Password = reader["password"].ToString();
user.CreateAt = reader["create_at"].ToString();
return user;
}
}
db.Disconnect();
return null;
}
