public User(String username, String password)
{
Username = username;
Password = password;
UserBinder = new Binder(username);
}
public Binder viewUser(string userName)
{
db = new LinqToSQLDatacontext(connectionString);
// Binder for transerfering data to gui
Binder userBinder = new Binder(userName);
// users information consists of his cardbinder, Linq statement
var query = (from t in db.cardbinders
where t.userid == userName
select t.cardid);
// Adds required cards from db to cardbinders cardlist
foreach (var id in query)
{
var cardQuery = (from c in db.cards
where c.serialnumber == id
select c);
foreach (var e in cardQuery)
{
userBinder.cardList.Add(e);
Console.WriteLine(e.name);
}
}
// returns a binder with username and cardIDs
return userBinder;
}
