public void createUser(string userName, string password)
{
db = new LinqToSQLDatacontext(connectionString);
user newUser = new user();
newUser.name = userName;
newUser.password = password;
// Create User
db.users.InsertOnSubmit(newUser);
db.SubmitChanges();
}
public void addCardToUser(string userName, int cardID)
{
db = new LinqToSQLDatacontext(connectionString);
// Create new card in cardbinder
cardbinder newcard = new cardbinder();
newcard.id = getLast();
newcard.userid = userName;
newcard.cardid = cardID;
//add new card til cardbinder table
db.cardbinders.InsertOnSubmit(newcard);
db.SubmitChanges();
}
public void deleteUser(string userName)
{
db = new LinqToSQLDatacontext(connectionString);
// Get cardbinder to delete
db.cardbinders.DeleteAllOnSubmit(db.cardbinders.Where(e => e.userid == userName));
db.SubmitChanges();
// Get user to delete
user removeUser = db.users.FirstOrDefault(e => e.name.Equals(userName));
// Delete User
db.users.DeleteOnSubmit(removeUser);
db.SubmitChanges();
}
public void createCard(string name, string imagepath, int friendship, int bravery, int humor, int starfactor)
{
db = new LinqToSQLDatacontext(connectionString);
// Create new Card
card newcard = new card();
newcard.name = name;
newcard.serialnumber = getCount()+1;
newcard.imagepath = imagepath;
newcard.friendship = friendship;
newcard.bravery = bravery;
newcard.humor = humor;
newcard.starfactor = starfactor;
// adds new card to database
db.cards.InsertOnSubmit(newcard);
db.SubmitChanges();
}
public void editUsername(string userName, string newName)
{
db = new LinqToSQLDatacontext(connectionString);
try
{
//Get cardbinder to edit
var binderQuery =
from b in db.cardbinders
where b.userid == userName
select b;
foreach (cardbinder b in binderQuery)
{
// create new cardbinder to replace old
cardbinder binder = new cardbinder();
binder.id = b.id;
binder.cardid = b.cardid;
binder.userid = newName;
db.cardbinders.DeleteOnSubmit(b);
db.cardbinders.InsertOnSubmit(binder);
}
//Get user to edit
var query =
from u in db.users
where u.name == userName
select u;
foreach (user u in query)
{
// create new user and cardbinder to replace old
user uNew = new user();
uNew.name = newName;
uNew.password = u.password;
db.users.DeleteOnSubmit(u);
db.users.InsertOnSubmit(uNew);
}
// Save changes
db.SubmitChanges();
}
catch (Exception e)
{
Console.WriteLine(e); ;
}
}
private int getCount()
{
db = new LinqToSQLDatacontext(connectionString);
var count = db.cards.Count();
return count;
}
private int getLast()
{
db = new LinqToSQLDatacontext(connectionString);
cardbinder lastEntry = db.cardbinders.Last();
return lastEntry.id;
}
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;
}
public void removeCardFromUser(string userName, int serialNumber)
{
db = new LinqToSQLDatacontext(connectionString);
// Get cardbinder and remove card
cardbinder removeCard = db.cardbinders.FirstOrDefault(e => e.cardid.Equals(serialNumber) && e.userid.Equals(userName));
// Delete card
db.cardbinders.DeleteOnSubmit(removeCard);
db.SubmitChanges();
}
public void removeCard(int serialNumber)
{
db = new LinqToSQLDatacontext(connectionString);
// Get Card to remove
// Lamda used!!!!!!!!!!!!!!!!!!!!!!!!!
card removeCard = db.cards.FirstOrDefault(e => e.serialnumber.Equals(serialNumber));
// Delete Card
db.cards.DeleteOnSubmit(removeCard);
db.SubmitChanges();
}
public List<card> getCards()
{
db = new LinqToSQLDatacontext(connectionString);
List<card> allCards = new List<card>();
var all = db.cards;
foreach (var card in all)
allCards.Add(card);
return allCards;
}
public User findUser(string userName)
{
db = new LinqToSQLDatacontext(connectionString);
user u = db.users.FirstOrDefault(e => e.name == userName);
User foundUser = new User(u.name, u.password);
return foundUser;
}
