Structs.FollowUpReturn[] checkClub(DatabaseDataset.ClubsRow club) { string filter = "ClubId='" + club.ClubId + "'"; //filter = ""; ArrayList toReturn = new ArrayList(); DatabaseDataset.ShootersRow[] shooters = (DatabaseDataset.ShootersRow[]) // club.GetShootersRows(); database.Shooters.Select(filter, "GivenName, Surname"); foreach (DatabaseDataset.ShootersRow shooter in shooters) { // This is for safety reasons if (shooter.IsArrivedNull()) { shooter.Arrived = false; } Structs.FollowUpReturn followUp = new Structs.FollowUpReturn(); followUp.Arrived = shooter.Arrived; followUp.CardNr = shooter.Cardnr; followUp.ClubName = club.Name; followUp.Payed = shooter.Payed; followUp.Rounds = getRoundsForShooter(shooter); followUp.ResultsExistForRounds = getResultExistForShooter(shooter); followUp.ShooterName = shooter.Givenname + ", " + shooter.Surname; followUp.ShouldHavePayed = GetShouldHavePayed(shooter); toReturn.Add(followUp); } return((Structs.FollowUpReturn[])toReturn.ToArray(typeof(Structs.FollowUpReturn))); }
private string createClubsLine(DatabaseDataset.ClubsRow club) { StringBuilder toReturn = new StringBuilder(); toReturn.Append(club.ClubId + ";"); toReturn.Append(club.Name + ";"); toReturn.Append(club.Country + ";"); if (!club.IsEmailNull()) { toReturn.Append(club.Email + ";"); } else { toReturn.Append(";"); } if (!club.IsBankgiroNull()) { toReturn.Append(club.Bankgiro + ";"); } else { toReturn.Append(";"); } if (!club.IsPlusgiroNull()) { toReturn.Append(club.Plusgiro + ";"); } else { toReturn.Append(";"); } toReturn.Append("\r\n"); return(toReturn.ToString()); }