public static void SeedType(AssetTrackerContext context)
{
var cotd = context.Organizations
.Include(o => o.OrganizationUsers)
.Include(t => t.Types)
.Single(s => s.Name == "Colorado Teardrops");
if (!cotd.Types.Any())
{
cotd.Types.Add(new Entities.Type {
Name = "Basedrop", OrganizationId = cotd.Id
});
cotd.Types.Add(new Entities.Type {
Name = "Canyonland", OrganizationId = cotd.Id
});
cotd.Types.Add(new Entities.Type {
Name = "Mount Massive", OrganizationId = cotd.Id
});
cotd.Types.Add(new Entities.Type {
Name = "The Summit", OrganizationId = cotd.Id
});
cotd.Types.Add(new Entities.Type {
Name = "Custom", OrganizationId = cotd.Id
});
context.SaveChanges();
}
}
public static void SeedOrganizations(AssetTrackerContext context)
{
if (!context.Organizations.Any())
{
var users = new List <Organization>
{
new Organization {
Name = "Colorado Teardrops"
},
new Organization {
Name = "New England Teardrops"
}
};
context.AddRange(users);
context.SaveChanges();
}
}
public static void SeedLocations(AssetTrackerContext context)
{
var cotd = context.Organizations
.Include(o => o.OrganizationUsers)
.Include(l => l.Locations)
.Single(s => s.Name == "Colorado Teardrops");
if (!cotd.Locations.Any())
{
cotd.Locations.Add(new Location {
Name = "Main Warehouse", OrganizationId = cotd.Id
});
cotd.Locations.Add(new Location {
Name = "South Storage Unit", OrganizationId = cotd.Id
});
cotd.Locations.Add(new Location {
Name = "Showroom", OrganizationId = cotd.Id
});
context.SaveChanges();
}
}
public static void SeedStatus(AssetTrackerContext context)
{
var cotd = context.Organizations
.Include(o => o.OrganizationUsers)
.Include(s => s.Statuses)
.Single(s => s.Name == "Colorado Teardrops");
if (!cotd.Statuses.Any())
{
cotd.Statuses.Add(new Status {
Name = "Received", OrganizationId = cotd.Id
});
cotd.Statuses.Add(new Status {
Name = "Available", OrganizationId = cotd.Id
});
cotd.Statuses.Add(new Status {
Name = "Hold", OrganizationId = cotd.Id
});
cotd.Statuses.Add(new Status {
Name = "Sold", OrganizationId = cotd.Id
});
context.SaveChanges();
}
}
public static void SeedUsers(AssetTrackerContext context)
{
if (!context.Users.Any())
{
//Now add the Organization to User Relationships
var cotd = context.Organizations
.Include(o => o.OrganizationUsers)
.Single(s => s.Name == "Colorado Teardrops");
var netd = context.Organizations
.Include(o => o.OrganizationUsers)
.Single(s => s.Name == "New England Teardrops");
var users = new List <User>
{
new User {
NmFirst = "Roger", NmLast = "Williams", Email = "*****@*****.**", SelectedOrganizationId = cotd.Id
},
new User {
NmFirst = "John", NmLast = "Routt", Email = "*****@*****.**", SelectedOrganizationId = cotd.Id
},
new User {
NmFirst = "Davey", NmLast = "Crockett", Email = "*****@*****.**", SelectedOrganizationId = cotd.Id
},
};
context.AddRange(users);
context.SaveChanges();
var roger = context.Users
.Single(s => s.NmFirst == "Roger");
var john = context.Users
.Single(s => s.NmFirst == "John");
var davey = context.Users
.Single(s => s.NmFirst == "Davey");
cotd.OrganizationUsers.Add(new OrganizationUser
{
User = john,
Organization = cotd
});
cotd.OrganizationUsers.Add(new OrganizationUser
{
User = davey,
Organization = cotd
});
netd.OrganizationUsers.Add(new OrganizationUser
{
User = roger,
Organization = netd
});
netd.OrganizationUsers.Add(new OrganizationUser
{
User = davey,
Organization = netd
});
context.SaveChanges();
}
}
public static void SeedAssets(AssetTrackerContext context)
{
if (!context.Assets.Any())
{
var cotd = context.Organizations.Single(s => s.Name == "Colorado Teardrops");
var netd = context.Organizations.Single(s => s.Name == "New England Teardrops");
var baseType = cotd.Types.Single(s => s.Name == "Basedrop");
var canyonType = cotd.Types.Single(s => s.Name == "Canyonland");
var massiveType = cotd.Types.Single(s => s.Name == "Mount Massive");
var summitType = cotd.Types.Single(s => s.Name == "The Summit");
var customType = cotd.Types.Single(s => s.Name == "Custom");
var recStatus = cotd.Statuses.Single(s => s.Name == "Received");
var availStatus = cotd.Statuses.Single(s => s.Name == "Available");
var holdStatus = cotd.Statuses.Single(s => s.Name == "Hold");
var soldStatus = cotd.Statuses.Single(s => s.Name == "Sold");
var mainLocation = cotd.Locations.Single(s => s.Name == "Main Warehouse");
var southLocation = cotd.Locations.Single(s => s.Name == "South Storage Unit");
var showLocation = cotd.Locations.Single(s => s.Name == "Showroom");
//First Asset
var newasset = new Asset
{
Tag = "23ERF34J",
Type = baseType,
Status = recStatus,
CreateDt = new DateTime(2018, 12, 3),
Description = "Red with rugged tire package"
};
context.Add(newasset);
context.SaveChanges();
var updateasset = context.Assets
.Include(l => l.AssetLocations)
.Include(o => o.AssetOrganizations)
.Single(s => s.Tag == "23ERF34J");
updateasset.AssetLocations.Add(new AssetLocation()
{
Location = mainLocation,
Asset = updateasset,
Note = "North wall",
CreateDt = new DateTime(2018, 12, 4)
});
updateasset.AssetOrganizations.Add(new AssetOrganization()
{
Organization = cotd,
Asset = updateasset
});
context.SaveChanges();
//Second Asset
newasset = new Asset
{
Tag = "98ERG36T",
Type = massiveType,
Status = availStatus,
CreateDt = new DateTime(2018, 10, 13),
Description = "Black with all these options..."
};
context.Add(newasset);
context.SaveChanges();
updateasset = context.Assets
.Include(l => l.AssetLocations)
.Include(o => o.AssetOrganizations)
.Single(s => s.Tag == "98ERG36T");
updateasset.AssetLocations.Add(new AssetLocation()
{
Location = showLocation,
Asset = updateasset,
Note = "Floor",
CreateDt = new DateTime(2018, 11, 24)
});
updateasset.AssetOrganizations.Add(new AssetOrganization()
{
Organization = cotd,
Asset = updateasset
});
context.SaveChanges();
}
}