static void Main()
{
var context = new DossierSystemContext();
var individuals = context.Individuals
.Where(i => i.Activities
.Any(a => a.ActivityType.Name == "DrugTrafficking"))
.OrderBy(i => i.FullName)
.Select(i => new
{
i.FullName,
i.BirthDate,
Activities = i.Activities
.Where(a => a.ActivityType.Name == "DrugTrafficking")
.OrderBy(a => a.ActiveFrom)
.Select(a => new
{
a.Description,
a.ActiveFrom,
a.ActiveTo
})
});
var json = JsonConvert.SerializeObject(
individuals,
Formatting.Indented,
new JsonSerializerSettings
{
ContractResolver = new CamelCasePropertyNamesContractResolver()
});
File.WriteAllText("../../drug-activities.json", json);
}
static void Main()
{
var context = new DossierSystemContext();
var visitors = context.Individuals
.Where(i => i.Locations
.Any(l => l.City.Name == "Jurish" && l.LastSeen.Year < 2005))
.Select(i => new
{
i.FullName,
Locations = i.Locations
.Where(l => l.City.Name == "Jurish" && l.LastSeen.Year < 2005)
.Select(lc => new
{
Seen = lc.LastSeen
})
});
var json = JsonConvert.SerializeObject(
visitors,
Formatting.Indented,
new JsonSerializerSettings
{
ContractResolver = new CamelCasePropertyNamesContractResolver()
});
File.WriteAllText("../../jurish-visitors.json", json);
}
static void Main()
{
var context = new DossierSystemContext();
var individuals = context.Individuals
.Where(i => !i.Locations
.Any(l => l.LastSeen.Year >= 2010) && i.Status == Status.Active);
foreach (var individual in individuals)
{
individual.Status = Status.Missing;
}
context.SaveChanges();
}
static void Main()
{
var context = new DossierSystemContext();
var individuals = context.Individuals
.Where(i => i.Status == Status.Active)
.OrderBy(i => i.FullName)
.Select(i => new
{
i.Id,
i.FullName,
i.Alias
});
var json = JsonConvert.SerializeObject(
individuals,
Formatting.Indented,
new JsonSerializerSettings
{
ContractResolver = new CamelCasePropertyNamesContractResolver()
});
File.WriteAllText("../../active-individuals.json", json);
}
