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 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 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); ;
}
}
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();
}