public PotentialClientsController(IPotentialClientService potentialClientService,
IUserService userService,
IStatusService statusService,
IProjectService projectService,
ISourceService sourceService)
{
_potentialClientService = potentialClientService;
_userService = userService;
_statusService = statusService;
_projectService = projectService;
_sourceService = sourceService;
}
public static async Task Initialize(PotentialClientsContext context, IPotentialClientService potentialClientService)
{
//TODO: Use migrations
context.Database.EnsureCreated();
if (context.PotentialClients.Any())
{
return;
}
var assembly = typeof(DatabaseInitializer).GetTypeInfo().Assembly;
Stream stream = assembly.GetManifestResourceStream("PotentialClients.EFCore.people.json");
using (StreamReader sr = new StreamReader(stream))
{
using (JsonReader reader = new JsonTextReader(sr))
{
JsonSerializer serializer = new JsonSerializer();
JArray jarray = serializer.Deserialize(reader) as JArray;
var potentialClients = jarray.Select(x => new PotentialClientDto
{
PersonId = (long)x["PersonId"],
FirstName = (string)x["FirstName"],
LastName = (string)x["LastName"],
CurrentRole = (string)x["CurrentRole"],
Country = (string)x["Country"],
Industry = (string)x["Industry"],
NumberOfRecommendations = (int?)x["NumberOfRecommendations"],
NumberOfConnections = (int?)x["NumberOfConnections"]
});
await potentialClientService.ImportPotentialClients(potentialClients);
}
}
context.Database.ExecuteSqlRaw(
@"
IF OBJECT_ID('dbo.View_PotentialClientPositions', 'V') IS NOT NULL
DROP VIEW dbo.View_PotentialClientPositions
");
context.Database.ExecuteSqlRaw(
@"
CREATE VIEW View_PotentialClientPositions AS
SELECT P.PersonId, ROW_NUMBER() OVER
(ORDER BY P.Score DESC) AS Postion
FROM [dbo].[PotentialClients] AS P");
}
public PotentialClientsController(IPotentialClientRepository potentialClientRepository, IPotentialClientService potentialClientService)
{
this._potentialClientRepository = potentialClientRepository;
this._potentialClientService = potentialClientService;
}
