public bool INSERT(DatabaseClient dbClient)
{
CheckinUserParams(ref dbClient);
dbClient.ExecuteQuery("INSERT INTO users" +
"(username,password,role,signedup,email,dob,motto,figure,gender,coins,films,gametickets,activitypoints) " +
"VALUES(@username,@password,@role,@signedup,@email,@dob,@motto,@figure,@gender,@coins,@films,@gametickets,@activitypoints);");
return true;
}
public bool UPDATE(DatabaseClient dbClient)
{
CheckinUserParams(ref dbClient);
dbClient.ExecuteQuery("UPDATE users " +
"SET username=@username,password=@password,role=@role,signedup=@signedup,email=@email,dob=@dob,motto=@motto,figure=@figure,gender=@gender,coins=@coins,films=@films,gametickets=@gametickets,activitypoints=@activitypoints " +
"WHERE id = @id;");
return true;
}
public bool DELETE(DatabaseClient dbClient)
{
dbClient.AddParamWithValue("@id", mID);
dbClient.ExecuteQuery("DELETE FROM users WHERE id = @id;");
return true;
}
