public Guid[] Search(CprBroker.Schemas.Part.SoegInputType1 searchCriteria)
{
using (var dataContext = new PartSearchDataContext())
{
int firstResults = 0;
int.TryParse(searchCriteria.FoersteResultatReference, out firstResults);
int maxResults = 0;
int.TryParse(searchCriteria.MaksimalAntalKvantitet, out maxResults);
if (maxResults <= 0)
{
maxResults = 1000;
}
var expr = CreateWhereExpression(dataContext, searchCriteria);
return(dataContext
.PersonSearchCaches
.Where(expr)
.OrderBy(psc => psc.UUID)
.Select(psc => psc.UUID)
.Skip(firstResults)
.Take(maxResults)
.ToArray());
}
}
public bool IsAlive()
{
using (var dataContext = new PartSearchDataContext())
{
try
{
var first = dataContext.PersonSearchCaches.FirstOrDefault();
return(true);
}
catch (Exception ex)
{
CprBroker.Engine.Local.Admin.LogException(ex);
return(false);
}
}
}
public static Expression <Func <PersonSearchCache, bool> > CreateWhereExpression(PartSearchDataContext dataContext, CprBroker.Schemas.Part.SoegInputType1 searchCriteria)
{
var pred = PredicateBuilder.True <PersonSearchCache>();
if (searchCriteria.SoegObjekt != null)
{
if (!string.IsNullOrEmpty(searchCriteria.SoegObjekt.UUID))
{
var personUuid = new Guid(searchCriteria.SoegObjekt.UUID);
pred = pred.And(p => p.UUID == personUuid);
}
// Lifecycle status
if (searchCriteria.SoegObjekt.SoegRegistrering != null)
{
if (searchCriteria.SoegObjekt.SoegRegistrering.LivscyklusKodeSpecified)
{
pred = pred.And(p => p.LivscyklusKode == searchCriteria.SoegObjekt.SoegRegistrering.LivscyklusKode.ToString());
}
}
// Search by cpr number
if (!string.IsNullOrEmpty(searchCriteria.SoegObjekt.BrugervendtNoegleTekst))
{
pred = pred.And(pr => pr.UserInterfaceKeyText == searchCriteria.SoegObjekt.BrugervendtNoegleTekst);
}
// Attributes
if (searchCriteria.SoegObjekt.SoegAttributListe != null)
{
if (searchCriteria.SoegObjekt.SoegAttributListe.SoegEgenskab != null)
{
foreach (var prop in searchCriteria.SoegObjekt.SoegAttributListe.SoegEgenskab)
{
if (prop.BirthDateSpecified)
{
// TODO: Check formatting of dates, could be different between webserver and database
pred = pred.And((pt) => pt.Birthdate == prop.BirthDate.ToShortDateString());
}
if (prop.PersonGenderCodeSpecified)
{
pred = pred.And((pt) => pt.PersonGenderCode == prop.PersonGenderCode.ToString());
}
if (prop != null)
{
if (prop.NavnStruktur != null)
{
if (!string.IsNullOrEmpty(prop.NavnStruktur.KaldenavnTekst))
{
pred = pred.And((pt) => pt.NickName == prop.NavnStruktur.KaldenavnTekst);
}
if (!string.IsNullOrEmpty(prop.NavnStruktur.NoteTekst))
{
pred = pred.And((pt) => pt.Note == prop.NavnStruktur.NoteTekst);
}
if (!string.IsNullOrEmpty(prop.NavnStruktur.PersonNameForAddressingName))
{
pred = pred.And((pt) => pt.AddressingName == prop.NavnStruktur.PersonNameForAddressingName);
}
if (prop.NavnStruktur.PersonNameStructure != null)
{
// Search by name
var name = prop.NavnStruktur.PersonNameStructure;
if (!name.IsEmpty)
{
if (!string.IsNullOrEmpty(name.PersonGivenName))
{
pred = pred.And((pt) => pt.PersonGivenName == name.PersonGivenName);
}
if (!string.IsNullOrEmpty(name.PersonMiddleName))
{
pred = pred.And((pt) => pt.PersonMiddleName == name.PersonMiddleName);
}
if (!string.IsNullOrEmpty(name.PersonSurnameName))
{
pred = pred.And((pt) => pt.PersonSurnameName == name.PersonSurnameName);
}
}
}
}
}
}
}
}
}
return(pred);
}