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