public static void AddActivityType(IPCS.Repositories.Context.IPCSContext context,
string name, string newName, string descripction, int order, int column, string clazz, int subType)
{
var activityType = context.ActivityTypes.Where(w => w.Name == name).SingleOrDefault();
if (activityType == null)
{
activityType = new ActivityType
{
};
}
activityType.Description = descripction;
activityType.Class = clazz;
activityType.Column = column;
activityType.Order = order;
activityType.Name = newName;
activityType.SubType = subType;
if (activityType.Id == 0)
{
context.Add(activityType);
}
else
{
context.Update(activityType);
}
}
protected static void AddProjectInformations(IPCS.Repositories.Context.IPCSContext context)
{
if (!context.ProjectInformations.Any())
{
context.ProjectInformations.Add(new ProjectInformation
{
ProjectNumber = "001239123",
Apsd = DateTime.Now,
Opsd = DateTime.Now,
OriginalCost = 20000,
Npd = DateTime.Now,
ProjectName = "Sears Tower",
ProjectLocation = context.ProjectLocations.First(),
ProjectStatus = context.ProjectStatuses.First(),
Budget = context.Budgets.First(),
CoordinatesX = "58",
CoordinatesY = "58"
});
context.ProjectInformations.Add(new ProjectInformation
{
ProjectNumber = "001239123",
Apsd = DateTime.Now,
Opsd = DateTime.Now,
OriginalCost = 20000,
Npd = DateTime.Now,
ProjectName = "Sears Tower",
ProjectLocation = context.ProjectLocations.First(),
ProjectStatus = context.ProjectStatuses.First(),
Budget = context.Budgets.First(),
CoordinatesX = "",
CoordinatesY = ""
});
}
}
protected static void AddEntities(IPCS.Repositories.Context.IPCSContext context)
{
if (!context.Entities.Any())
{
context.Entities.Add(new Entity
{
Name = "Contractor"
});
context.Entities.Add(new Entity
{
Name = "Inspector"
});
context.Entities.Add(new Entity
{
Name = "Project Manager"
});
context.Entities.Add(new Entity
{
Name = "Owner"
});
context.Entities.Add(new Entity
{
Name = "Owner's Representative"
});
context.Entities.Add(new Entity
{
Name = "Other"
});
}
}
public static void Seed(IPCS.Repositories.Context.IPCSContext context, UserManager <User> userManager, bool seed)
{
context.Database.Migrate();
AddCurrency(context);
context.SaveChanges();
AddProjectStatus(context);
context.SaveChanges();
AddCountry(context, seed);
context.SaveChanges();
AddState(context, seed);
context.SaveChanges();
AddActivityType(context, "Administrative Activities", "Administrative Activities", "No administrative activities", 0, 1, "panel-primary", 1);
AddActivityType(context, "Construction Activities", "Construction Activities", "No construction activities", 1, 1, "panel-primary", 1);
AddActivityType(context, "Project Visitors", "Project Visitors", "No project visitors", 2, 1, "panel-primary", 1);
AddActivityType(context, "Safety", "Safety", "No safety issues", 6, 1, "panel-primary", 4);
AddActivityType(context, "Critical Path Activities", "Critical Path Activities", "No critical path activities", 7, 1, "panel-primary", 5);
AddActivityType(context, "Weather", "Weather", "No weather issues", 0, 2, "panel-warning", 3);
AddActivityType(context, "Pending Issues", "Pending Issues", "No pending issues", 1, 2, "panel-primary", 1);
AddActivityType(context, "Two Week Look Ahead", "Two Week Look Ahead", "No two week look ahead", 1, 2, "panel-primary", 1);
AddActivityType(context, "Issues That May Affect Cost", "Issues That May Affect Cost", "No issues that may affect cost", 0, 3, "panel-danger", 2);
AddActivityType(context, "Issues That Affect Cost", "Issues That Affect Cost", "No issues affecting cost", 1, 3, "panel-danger", 2);
AddActivityType(context, "Issues That May Affect Schedule", "Issues That May Affect Schedule", "No issues that may affect schedule", 2, 3, "panel-danger", 2);
AddActivityType(context, "Issues That Affect Schedule", "Issues That Affect Schedule", "No issues affecting schedule", 3, 3, "panel-danger", 2);
context.SaveChanges();
AddSafetyIssues(context, "Incident", "Incident", 0);
AddSafetyIssues(context, "Accident ", "Accident", 1);
AddSafetyIssues(context, "Near Miss ", "Near Miss", 2);
context.SaveChanges();
AddWeatherConditions(context, "Rainy", "Rainy", 0);
AddWeatherConditions(context, "Sunny", "Sunny", 1);
AddWeatherConditions(context, "Cloudy", "Cloudy", 2);
AddWeatherConditions(context, "Stormy", "Stormy", 3);
AddWeatherConditions(context, "Snowing", "Snowing", 4);
context.SaveChanges();
AddEntities(context);
context.SaveChanges();
AddCity(context, seed);
context.SaveChanges();
#if DEBUG
//AddProjectCertifications(context);
//context.SaveChanges();
//AddProjectOrders(context);
//context.SaveChanges();
// AddLocations(context, "New Petersburg IL", "103 Wacker Dr");
// context.SaveChanges();
// AddBudget(context);
// context.SaveChanges();
// AddProjectInformations(context);
//context.SaveChanges();
#endif
}
protected static void AddCurrency(IPCS.Repositories.Context.IPCSContext context)
{
if (!context.Currencies.Any())
{
context.Currencies.Add(new Currency
{
Name = "Dollars",
Symbol = "USD"
});
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env,
ILoggerFactory loggerFactory, IPCS.Repositories.Context.IPCSContext context,
UserManager <User> userManager)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddFile(Configuration.GetSection("LoggingFile"));
loggerFactory.AddDebug();
if (string.IsNullOrWhiteSpace(env.WebRootPath))
{
env.WebRootPath = System.IO.Path.Combine(Directory.GetCurrentDirectory(), "wwwroot");
}
UseIdentityServerAuthenticationOptions opt = new UseIdentityServerAuthenticationOptions();
Configuration.GetSection("UseIdentityServerAuthenticationOptions").Bind(opt);
app.UseIdentityServerAuthentication(new IdentityServerAuthenticationOptions
{
Authority = opt.Authority,
ApiName = opt.ApiName,
RequireHttpsMetadata = opt.RequireHttpsMetadata,
AutomaticAuthenticate = opt.AutomaticAuthenticate,
AutomaticChallenge = opt.AutomaticChallenge,
RoleClaimType = ClaimTypes.Role,
EnableCaching = opt.EnableCaching,
AuthenticationScheme = opt.AuthenticationScheme,
SupportedTokens = IdentityServer4.AccessTokenValidation.SupportedTokens.Jwt,
JwtBearerEvents = new CustomJwtBearerEvents()
});
app.UseCors("CorsPolicy");
app.UseMvc();
var pathUploadProjectFolder = Path.Combine(env.WebRootPath, "upload", "project");
if (!Directory.Exists(pathUploadProjectFolder))
{
Directory.CreateDirectory(pathUploadProjectFolder);
}
app.UseStaticFiles(new StaticFileOptions()
{
FileProvider = new PhysicalFileProvider(
Path.Combine(env.WebRootPath, "upload", "project")),
RequestPath = new PathString("/project")
});
DBInitialize.Seed(context, userManager, Configuration.GetValue <bool>("SEED"));
}
protected static void AddLocations(IPCS.Repositories.Context.IPCSContext context, string address1, string address2)
{
if (!context.ProjectLocations.Any())
{
context.ProjectLocations.Add(new ProjectLocation
{
Address1 = address1,
Address2 = address2,
ZipCode = "12213",
State = "State",
Country = "Country",
City = "City"
});
}
}
protected static void AddCountry(IPCS.Repositories.Context.IPCSContext context, bool seed)
{
if (seed)
{
var json = File.ReadAllText("./JsonData/countries.json");
var countries = JsonConvert.DeserializeObject <List <Country> >(json);
foreach (var country in countries)
{
if (context.Countries.Where(w => w.Code == country.Code).SingleOrDefault() == null)
{
context.Countries.Add(country);
}
}
}
}
protected static void AddCity(IPCS.Repositories.Context.IPCSContext context, bool seed)
{
if (seed)
{
var json = File.ReadAllText("./JsonData/cities.json");
var cities = JsonConvert.DeserializeObject <List <City> >(json);
foreach (var city in cities)
{
if (context.Cities.Where(w => w.Code == city.Code && w.StateCode == city.StateCode).SingleOrDefault() == null)
{
city.ListAvailable = true;
context.Cities.Add(city);
}
}
}
}
protected static void AddState(IPCS.Repositories.Context.IPCSContext context, bool seed)
{
if (seed)
{
var json = File.ReadAllText("./JsonData/states.json");
var states = JsonConvert.DeserializeObject <List <State> >(json);
foreach (var state in states)
{
if (context.States.Where(w => w.Code == state.Code && w.CountryCode == "US").SingleOrDefault() == null)
{
state.CountryCode = "US";
state.ListAvailable = true;
context.States.Add(state);
}
}
}
}
protected static void AddProjectStatus(IPCS.Repositories.Context.IPCSContext context)
{
if (!context.ProjectStatuses.Any())
{
context.ProjectStatuses.Add(new ProjectStatus
{
Name = "In Progress",
Description = "In Progress"
});
context.ProjectStatuses.Add(new ProjectStatus
{
Name = "Complete",
Description = "Complete"
});
}
var status = context.ProjectStatuses.Where(w => w.Name == "In Progress").SingleOrDefault();
if (status != null)
{
status.Name = "On-Going";
status.Description = "On-Going";
context.ProjectStatuses.Update(status);
}
status = context.ProjectStatuses.Where(w => w.Name == "Complete").SingleOrDefault();
if (status != null)
{
status.Name = "Closed";
status.Description = "Closed";
context.ProjectStatuses.Update(status);
}
status = context.ProjectStatuses.Where(w => w.Name == "Deleted").SingleOrDefault();
if (status == null)
{
context.ProjectStatuses.Add(new ProjectStatus
{
Name = "Deleted",
Description = "Deleted"
});
}
}
public static void AddWeatherConditions(IPCS.Repositories.Context.IPCSContext context, string name, string newName, int order)
{
var condition = context.WeatherConditions.Where(w => w.Name == name).SingleOrDefault();
if (condition == null)
{
condition = new WeatherCondition();
}
condition.Name = newName;
condition.Order = order;
if (condition.Id == 0)
{
context.WeatherConditions.Add(condition);
}
else
{
context.WeatherConditions.Update(condition);
}
}
public static void AddSafetyIssues(IPCS.Repositories.Context.IPCSContext context, string name, string newName, int order)
{
var safety = context.SafetyIssues.Where(w => w.Name == name).SingleOrDefault();
if (safety == null)
{
safety = new SafetyIssue();
}
safety.Name = newName;
safety.Order = order;
if (safety.Id == 0)
{
context.SafetyIssues.Add(safety);
}
else
{
context.SafetyIssues.Update(safety);
}
}