private static int CreateSystemUser(WorkoutsContext context)
{
var systemUser = context.Users.FirstOrDefault(x => x.Name == "SYSTEM");
if (systemUser == null)
{
context.Users.Add(
new User
{
Id = 0,
CreatedByUserId = 0,
CreatedDateTime = DateTime.Now.ToUniversalTime(),
Name = "SYSTEM"
});
context.SaveChanges();
systemUser = context.Users.FirstOrDefault(x => x.Name == "SYSTEM");
systemUser.CreatedByUserId = systemUser.Id;
context.SaveChanges();
if (systemUser == null)
{
throw new ApplicationException("Couldn't retrieve system user after creating it.");
}
}
return(systemUser.Id);
}
private static void SeedTargetAreas(WorkoutsContext context, int systemUserId)
{
//Check for the INITIAL SET of target areas. Any later additions will be added in a later
//seed set.
if (!context.TargetAreas.Any())
{
context.TargetAreas.Add(new TargetArea {
Name = "Abs", CreatedByUserId = systemUserId, CreatedDateTime = DateTime.Now.ToUniversalTime()
});
context.TargetAreas.Add(new TargetArea {
Name = "Back", CreatedByUserId = systemUserId, CreatedDateTime = DateTime.Now.ToUniversalTime()
});
context.TargetAreas.Add(new TargetArea {
Name = "Biceps", CreatedByUserId = systemUserId, CreatedDateTime = DateTime.Now.ToUniversalTime()
});
context.TargetAreas.Add(new TargetArea {
Name = "Chest", CreatedByUserId = systemUserId, CreatedDateTime = DateTime.Now.ToUniversalTime()
});
context.TargetAreas.Add(new TargetArea {
Name = "Core", CreatedByUserId = systemUserId, CreatedDateTime = DateTime.Now.ToUniversalTime()
});
context.TargetAreas.Add(new TargetArea {
Name = "Legs", CreatedByUserId = systemUserId, CreatedDateTime = DateTime.Now.ToUniversalTime()
});
context.TargetAreas.Add(new TargetArea {
Name = "Shoulders", CreatedByUserId = systemUserId, CreatedDateTime = DateTime.Now.ToUniversalTime()
});
context.TargetAreas.Add(new TargetArea {
Name = "Triceps", CreatedByUserId = systemUserId, CreatedDateTime = DateTime.Now.ToUniversalTime()
});
context.SaveChanges();
}
//4/23/2022 - Add CARDIO target area
if (!context.TargetAreas.Any(x => x.Name == "Cardio"))
{
context.TargetAreas.Add(new TargetArea {
Name = "Cardio", CreatedByUserId = systemUserId, CreatedDateTime = DateTime.Now.ToUniversalTime()
});
context.SaveChanges();
}
}
public static void EnsureSeedData(this WorkoutsContext context)
{
int systemUserId = CreateSystemUser(context);
SeedTargetAreas(context, systemUserId);
}