public Gender(DbGender dbGender)
{
GenderId = dbGender.DbGenderId;
Name = dbGender.Name;
}
protected override void Seed(DataContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
DbGender maleGender = context.DbGenders.FirstOrDefault(g => g.Name == "Male");
DbGender femaleGender = context.DbGenders.FirstOrDefault(g => g.Name == "Female");
if (maleGender == null)
{
maleGender = new DbGender {
DbGenderId = Guid.NewGuid(), Name = "Male"
};
context.DbGenders.Add(maleGender);
context.SaveChanges();
}
if (femaleGender == null)
{
femaleGender = new DbGender {
DbGenderId = Guid.NewGuid(), Name = "Female"
};
context.DbGenders.Add(femaleGender);
context.SaveChanges();
}
// Access Rights
if (context.DbAccessRights.Count() == 0)
{
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Login"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit His/Her Own Personal User Information"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit His/Her Own Login Information"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit His/Her Own Access Rights"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can View Users"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Print Users"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Email Users"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Export Users"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Import Users"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Add Users"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Remove Users"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit Users"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit Other Users' Personal Information"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit Other Users' Login Information"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit Other Users' Access Rights"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can View Work Requests"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Print Work Requests"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Email Work Requests"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Export Work Requests"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Import Work Requests"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Add Work Requests"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit Work Requests"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit Work Request Status"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit Work Request Assigned To"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Remove Work Requests"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can View Customers"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Print Customers"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Email Customers"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Export Customers"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Import Customers"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Add Customers"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit Customers"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Remove Customers"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can View Access Rights"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Print Rights"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Email Rights"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Export Rights"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Import Rights"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Add Access Rights"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Edit Access Rights"
});
context.DbAccessRights.Add(new DbAccessRight {
DbAccessRightId = Guid.NewGuid(), Name = "Can Remove Access Rights"
});
context.SaveChanges();
}
if (context.DbUsers.Count() == 0)
{
context.DbUsers.Add(new DbUser {
DbUserId = Guid.NewGuid(), FirstName = "Charlie", LastName = "Flores Paz", DbGender = maleGender
});
context.DbUsers.Add(new DbUser {
DbUserId = Guid.NewGuid(), FirstName = "Arin", LastName = "Avastazarian", DbGender = maleGender
});
context.DbUsers.Add(new DbUser {
DbUserId = Guid.NewGuid(), FirstName = "Ana", LastName = "None", DbGender = femaleGender
});
context.DbUsers.Add(new DbUser {
DbUserId = Guid.NewGuid(), FirstName = "Sareen", LastName = "None", DbGender = femaleGender
});
context.SaveChanges();
var dbUsers = context.DbUsers.ToList();
// User Access Rights
foreach (var dbUser in dbUsers)
{
foreach (var dbAccessRight in context.DbAccessRights)
{
context.DbUserAccessRights.Add(new DbUserAccessRight {
DbUserAccessRightId = Guid.NewGuid(), DbUser = dbUser, DbAccessRight = dbAccessRight
});
}
}
// User Logins
foreach (var dbUser in context.DbUsers)
{
context.DbUserLogins.Add(new DbUserLogin {
DbUserLoginId = Guid.NewGuid(), UserId = dbUser.FirstName, PasswordHash = "lmi", DbUser = dbUser
});
}
context.SaveChanges();
}
// Work status
if (context.DbWorkStatuses.Count() == 0)
{
context.DbWorkStatuses.Add(new DbWorkStatus {
DbWorkStatusId = Guid.NewGuid(), Name = "Development"
});
context.DbWorkStatuses.Add(new DbWorkStatus {
DbWorkStatusId = Guid.NewGuid(), Name = "Testing"
});
context.DbWorkStatuses.Add(new DbWorkStatus {
DbWorkStatusId = Guid.NewGuid(), Name = "Complete"
});
context.SaveChanges();
}
// Work Types
if (context.DbWorkTypes.Count() == 0)
{
context.DbWorkTypes.Add(new DbWorkType {
DbWorkTypeId = Guid.NewGuid(), Name = "Bug"
});
context.DbWorkTypes.Add(new DbWorkType {
DbWorkTypeId = Guid.NewGuid(), Name = "Feature"
});
context.DbWorkTypes.Add(new DbWorkType {
DbWorkTypeId = Guid.NewGuid(), Name = "Customization"
});
context.SaveChanges();
}
// Software Types
if (context.DbSoftwareTypes.Count() == 0)
{
context.DbSoftwareTypes.Add(new DbSoftwareType {
DbSoftwareTypeId = Guid.NewGuid(), Name = "JM Retail"
});
context.DbSoftwareTypes.Add(new DbSoftwareType {
DbSoftwareTypeId = Guid.NewGuid(), Name = "JM Wholesale"
});
context.SaveChanges();
}
}
