private void SetSportaSheet(ExcelWorksheet worksheet)
{
ExcelHelper.SetHeader(
worksheet,
ExcelExportResources.CompetitionVolgnummer,
ExcelExportResources.CompetitionIndex,
ExcelExportResources.CompetitionLidnummer,
ExcelExportResources.PlayerName,
ExcelExportResources.PlayerRanking,
ExcelExportResources.PlayerRankingValue
);
int i = 2;
var rankingValueConverter = new KlassementValueConverter();
foreach (var player in _players.Where(x => x.ClubIdSporta == Constants.OwnClubId).OrderBy(x => x.VolgnummerSporta))
{
worksheet.Cells[i, 1].Value = player.VolgnummerSporta;
worksheet.Cells[i, 2].Value = player.IndexSporta;
worksheet.Cells[i, 3].Value = player.LidNummerSporta;
worksheet.Cells[i, 4].Value = player.Naam;
worksheet.Cells[i, 5].Value = player.KlassementSporta;
worksheet.Cells[i, 6].Value = rankingValueConverter.Sporta(player.KlassementSporta);
i++;
}
worksheet.Cells.AutoFitColumns();
}
private void SetSportaSheet(ExcelWorksheet worksheet)
{
ExcelHelper.SetHeader(
worksheet,
ExcelExportResources.CompetitionVolgnummer,
ExcelExportResources.CompetitionIndex,
ExcelExportResources.CompetitionLidnummer,
ExcelExportResources.PlayerName,
ExcelExportResources.PlayerRanking,
ExcelExportResources.PlayerRankingValue
);
int i = 2;
var rankingValueConverter = new KlassementValueConverter();
foreach (var player in _players.Where(x => x.ClubIdSporta == Constants.OwnClubId).OrderBy(x => x.VolgnummerSporta))
{
worksheet.Cells[i, 1].Value = player.VolgnummerSporta;
worksheet.Cells[i, 2].Value = player.IndexSporta;
worksheet.Cells[i, 3].Value = player.LidNummerSporta;
worksheet.Cells[i, 4].Value = player.Name;
worksheet.Cells[i, 5].Value = player.KlassementSporta;
worksheet.Cells[i, 6].Value = rankingValueConverter.Sporta(player.KlassementSporta);
i++;
}
worksheet.Cells.AutoFitColumns();
}
public static void Configure(KlassementValueConverter klassementToValueConverter)
{
Factory = new MapperConfiguration(cfg =>
{
PlayerMapping(cfg, klassementToValueConverter);
ClubMapping(cfg);
MatchMapping(cfg);
TeamMapping(cfg);
ReportMapping(cfg);
});
}
private static PlayerCompetition CreateVttlPlayer(KlassementValueConverter converter, int clubId, int uniqueIndex, string frenoyLink, string ranking, int position, int rankingIndex)
{
return new PlayerCompetition(
Competition.Vttl,
clubId, uniqueIndex, frenoyLink, ranking, position, rankingIndex, converter.Vttl(ranking));
}
private static void PlayerMapping(IMapperConfiguration cfg, KlassementValueConverter klassementToValueConverter)
{
cfg.CreateMap<PlayerEntity, Player>()
.ForMember(
dest => dest.Name,
opts => opts.MapFrom(src => src.Naam))
.ForMember(
dest => dest.Alias,
opts => opts.MapFrom(src => src.NaamKort))
.ForMember(
dest => dest.Active,
opts => opts.MapFrom(src => !src.IsGestopt))
.ForMember(
dest => dest.QuitYear,
opts => opts.MapFrom(src => src.Gestopt))
.ForMember(
dest => dest.Security,
opts => opts.MapFrom(src => src.Toegang.ToString()))
.ForMember(
dest => dest.Style,
opts => opts.MapFrom(src => new PlayerStyle(src.Id, src.Stijl, src.BesteSlag)))
.ForMember(
dest => dest.Contact,
opts => opts.MapFrom(src => new PlayerContact(src.Id, src.Email, src.Gsm, src.Adres, src.Gemeente)))
.ForMember(
dest => dest.Vttl,
opts => opts.MapFrom(src => src.ClubIdVttl.HasValue ?
CreateVttlPlayer(klassementToValueConverter, src.ClubIdVttl.Value, src.ComputerNummerVttl.Value, src.LinkKaartVttl, src.KlassementVttl, src.VolgnummerVttl.Value, src.IndexVttl.Value)
: null))
.ForMember(
dest => dest.Sporta,
opts => opts.MapFrom(src => src.ClubIdSporta.HasValue ?
CreateSportaPlayer(klassementToValueConverter, src.ClubIdSporta.Value, src.LidNummerSporta.Value, src.LinkKaartSporta, src.KlassementSporta, src.VolgnummerSporta.Value, src.IndexSporta.Value)
: null))
;
}