private async void ExecuteCommand(IDogShowEntity obj) { List <IHandlerEntryEntityWithAdditionalData> handleritems = await _handlerEntryService.GetHandlerEntryListAsync <HandlerEntryEntityWithAdditionalData>(); var handlerdata = handleritems.Where(i => i.ShowId == obj.Id).ToList(); Dictionary <string, object> datasources = new Dictionary <string, object>(); datasources.Add("DSHandlerEntriesForShow", handlerdata); var ds = new List <IDogShowEntity>(); ds.Add(obj); datasources.Add("DSShowInfo", ds); var ds2 = new List <ReportExecutionProperties>(); ds2.Add(new ReportExecutionProperties() { Mode = _mode }); datasources.Add("DSExecutionProperties", ds2); _reportViewerService.ShowReport(@"Reports\HandlerResultsSheet.rdlc", datasources, null); }
public async override void Prepare() { Items.Clear(); List <IHandlerEntryEntityWithAdditionalData> items = await _service.GetHandlerEntryListAsync <HandlerEntryEntityWithAdditionalData>(); items.ForEach(i => Items.Add(i)); }
public override async Task LoadData() { Items.Clear(); List <IHandlerEntryEntityWithAdditionalData> items = await _service.GetHandlerEntryListAsync <HandlerEntryEntityWithAdditionalData>(SelectedDogShow.Id); items.ForEach(i => Items.Add(i)); }
private async Task AddDataForCertificate(List <ICertficateDetail> certs, IChallengeResult result) { if (!result.Print) { return; } if (string.IsNullOrEmpty(result.EntryNumber)) { return; } if (result.ShowId <= 0) { return; } var allentries = await _handlerEntryService.GetHandlerEntryListAsync <HandlerEntryEntityWithAdditionalData>(); var entries = allentries.Where(e => e.ShowId == result.ShowId && e.EntryNumber == result.EntryNumber).ToList(); if (entries.Count == 1) { IHandlerEntryEntityWithAdditionalData entryData = entries.First(); certs.Add(new CertificateDetail() { RegionName = ReportConstants.REGION_NAME, DateAsString = ReportConstants.SHOWDATE_AS_STRING, SecretaryName = ReportConstants.SECRETARY, VenueName = ReportConstants.VENUE_NAME, ClubName = ReportConstants.CLUB_NAME, ShowName = entryData.ShowName, DateOfBirth = entryData.DOB.ToString("yyyy-MM-dd"), ChallengeName = entryData.EnteredClassName, BreedName = entryData.DogBreed, DogName = entryData.HandlerDisplayName, EntryNumber = entryData.EntryNumber, JudgeName = entryData.JudgeName, OwnerName = "", RegistrationNumber = entryData.DogRegistrationNumber, SexName = entryData.SexName }); } ; }
private async void ExecuteCommand(IDogShowEntity obj) { List <IHandlerEntryEntityWithAdditionalData> items = await _handlerEntryService.GetHandlerEntryListAsync <HandlerEntryEntityWithAdditionalData>(obj.Id); var data = items.Where(i => i.ShowId == obj.Id).ToList(); Dictionary <string, object> datasources = new Dictionary <string, object>(); datasources.Add("DSHandlerEntriesForShow", data); Dictionary <string, string> parms = new Dictionary <string, string>(); parms.Add("parmClubName", ReportConstants.CLUB_NAME); parms.Add("parmDogShowName", obj.DogShowName); parms.Add("parmDogShowDate", obj.ShowDate.ToString("yyyy-MM-dd")); _reportViewerService.ShowReport(@"Reports\HandlerEntryNumberLabelsForShow.rdlc", datasources, parms); }
private async void ExecuteCommand(IDogShowEntity obj) { List <IBreedEntryEntityWithAdditionalData> items = await _breedEntryService.GetBreedEntryListAsync <BreedEntryEntityWithAdditionalData>(); var data = items.Where(i => i.ShowId == obj.Id).ToList(); List <IShowChallengeEntity> showChallenges = await _showChallengeService.GetListAsync <ShowChallengeEntity>(obj.Id); var listOfGroups = items.Select(i => i.BreedGroupName).Distinct(); List <string> positions = new List <string>(); positions.Add("1st"); positions.Add("2nd"); positions.Add("3rd"); positions.Add("4th"); //var magicdata2 = from breedEntry in data // from challenge in showChallenges // select new DataForThisInShowReport() // { // BreedName = breedEntry.BreedName, // BreedGroupName = breedEntry.BreedGroupName, // ShowJudgeName = breedEntry.BreedGroupJudgeName, // BreedGroupChallengeName = challenge.Name, // BreedChallengeAbbreviation = challenge.RelatedBreedGroupChallengeName, // EntryCount = 1 // }; var magicdata = from breedEntry in data from challenge in showChallenges from position in positions select new DataForThisInShowReport() { BreedName = breedEntry.BreedName, BreedGroupName = breedEntry.BreedGroupName, ShowJudgeName = challenge.ChallengeJudgeName, ShowChallengeName = challenge.Name, BreedGroupChallengeAbbreviation = challenge.RelatedBreedGroupChallengeName, EntryCount = position == "1st" ? 1 : 0, PositionText = position, JudgingOrder = challenge.JudginOrder }; //var moremagic = magicdata.Where(i => i.BreedName == "Great Dane" && i.BreedChallengeAbbreviation == "BOB"); //var moremagic2 = magicdata2.Where(i => i.BreedName == "Great Dane" && i.BreedChallengeAbbreviation == "BOB"); List <IHandlerEntryEntityWithAdditionalData> handleritems = await _handlerEntryService.GetHandlerEntryListAsync <HandlerEntryEntityWithAdditionalData>(); var handlerdata = handleritems.Where(i => i.ShowId == obj.Id).ToList(); Dictionary <string, object> datasources = new Dictionary <string, object>(); datasources.Add("dsMagic", magicdata); var ds = new List <IDogShowEntity>(); ds.Add(obj); datasources.Add("DSShowInfo", ds); var ds2 = new List <ReportExecutionProperties>(); ds2.Add(new ReportExecutionProperties() { Mode = _mode }); datasources.Add("DSExecutionProperties", ds2); _reportViewerService.ShowReport(@"Reports\InShowResultsSheet.rdlc", datasources, null); }
private async void ExecuteCommand(IDogShowEntity obj) { List <IBreedEntryEntityWithAdditionalData> items = await _breedEntryService.GetBreedEntryListAsync <BreedEntryEntityWithAdditionalData>(); var data = items.Where(i => i.ShowId == obj.Id).ToList(); List <IBreedEntryClassEntry> classEntryItems = await _breedEntryService.GetBreedEntryClassEntryListAsync <BreedEntryClassEntry>(); var classEntryData = classEntryItems.Where(i => i.ShowId == obj.Id).ToList(); var rankeddata = classEntryData.GroupBy(d => d.ReportGroupingKey) .SelectMany(g => g.OrderBy(y => y.ReportSortingKey) .Select((x, i) => new { g.Key, Item = x, Rank = i + 1 })); foreach (var i in rankeddata) { i.Item.ReportingRank = i.Rank; } var tempData = from c in classEntryData select new { TempShowName = c.ShowName, TempBreedGroupName = c.BreedGroupName, TempBreedName = c.BreedName }; var moreTempData = tempData.Distinct().ToList(); List <IBreedChallengeEntity> breedChallenges = await _breedChallengeService.GetListAsync <BreedChallengeEntity>(); foreach (IBreedChallengeEntity breedChallenge in breedChallenges) { foreach (var tempydatay in moreTempData) { classEntryData.Add(new BreedEntryClassEntry() { ShowName = tempydatay.TempShowName, BreedGroupName = tempydatay.TempBreedGroupName, BreedName = tempydatay.TempBreedName, GenderName = "ALL", EntryNumber = "", EnteredClassName = breedChallenge.Name, JudgingOrder = breedChallenge.JudginOrder }); } } List <IHandlerEntryEntityWithAdditionalData> handleritems = await _handlerEntryService.GetHandlerEntryListAsync <HandlerEntryEntityWithAdditionalData>(); var handlerdata = handleritems.Where(i => i.ShowId == obj.Id).ToList(); Dictionary <string, object> datasources = new Dictionary <string, object>(); //datasources.Add("DSBreedEntriesForShow", data); //datasources.Add("DSHandlerEntriesForShow", handlerdata); datasources.Add("DSBreedEntryClassEntriesForShow", classEntryData); var ds = new List <IDogShowEntity>(); ds.Add(obj); datasources.Add("DSShowInfo", ds); var ds2 = new List <ReportExecutionProperties>(); ds2.Add(new ReportExecutionProperties() { Mode = _mode }); datasources.Add("DSExecutionProperties", ds2); //Dictionary<string, string> parms = new Dictionary<string, string>(); //parms.Add("parmClubName", "Overberg Kennel Club"); //parms.Add("parmDogShowName", obj.DogShowName); //parms.Add("parmDogShowDate", obj.ShowDate.ToString("yyyy-MM-dd")); _reportViewerService.ShowReport(@"Reports\ResultsSheet.rdlc", datasources, null); }