public List<ServiceSearchResult> GetSourceByParishString(string parishs, int startYear, int endYear)
{
var ssresults = new List<ServiceSearchResult>();
using (var context = new GeneralModelContainer())
{
var parishGroups = context.uspGetParishSources(parishs, startYear, endYear).ToList();
foreach (var parish in parishGroups)
{
var ssr = new ServiceSearchResult
{
ParishId = parish.SourceMappingParishId.GetValueOrDefault(),
IsMarriage = true,
IsBaptism = true,
IsBurial = true
};
var parishResult = parishGroups.Where(ps => ps.SourceMappingParishId == ssr.ParishId).ToList();
if (parishResult.Count > 0 && !parishResult.Exists(pr => pr.MapTypeId == 43))
{
ssr.IsMarriage = parishResult.Exists(pr => pr.MapTypeId == 40);
//baptisms
ssr.IsBaptism = parishResult.Exists(pr => pr.MapTypeId == 41);
//burials
ssr.IsBurial = parishResult.Exists(pr => pr.MapTypeId == 42);
}
ssresults.Add(ssr);
}
return ssresults;
}
}
