public static void Seed(ApplicationDbContext context)
{
try
{
ApplicationUser adminUser;
#region Admin user
var userManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new ApplicationDbContext()));
userManager.UserValidator = new UserValidator <ApplicationUser>(userManager)
{
AllowOnlyAlphanumericUserNames = true,
RequireUniqueEmail = true
};
var roleManager = new RoleManager <ApplicationRole>(new RoleStore <ApplicationRole>(new ApplicationDbContext()));
string name = "*****@*****.**";
string password = "******";
string firstname = "Admin";
string lastName = "Association";
string roleName = "Admin";
var role = roleManager.FindByName(roleName);
if (role == null)
{
role = new ApplicationRole(roleName);
var roleResult = roleManager.Create(role);
}
adminUser = userManager.FindByName(name);
if (adminUser == null)
{
adminUser = new ApplicationUser {
UserName = name, Email = name, FirstName = firstname, LastName = lastName
};
var userResult = userManager.Create(adminUser, password);
var result = userManager.SetLockoutEnabled(adminUser.Id, false);
}
var rolesForUser = userManager.GetRoles(adminUser.Id);
if (!rolesForUser.Contains(role.Name))
{
var result = userManager.AddToRole(adminUser.Id, role.Name);
}
#endregion
// --------------------------------------------------------------------
// Data
// ---
#region CategorieActivite
// --------------------------------------------------------------------
// CategorieActivite
// ---
string nomcatDanse = "Cours de danse";
context.CategoriesActivite.AddOrUpdate(c => c.CategorieActiviteNom,
new CategorieActivite
{
CategorieActiviteNom = nomcatDanse,
ParentId = null
});
context.CategoriesActivite.AddOrUpdate(c => c.CategorieActiviteNom,
new CategorieActivite
{
CategorieActiviteNom = "Ateliers",
ParentId = null
});
context.SaveChanges();
CategorieActivite catDanseParent = context.CategoriesActivite.First(c => c.CategorieActiviteNom == nomcatDanse);
string nomCatDanseContemporaine = "Danse contemporaine";
context.CategoriesActivite.AddOrUpdate(c => c.CategorieActiviteNom,
new CategorieActivite
{
CategorieActiviteNom = nomCatDanseContemporaine,
ParentId = catDanseParent.Id
});
string nomCatZumba = "Zumba";
context.CategoriesActivite.AddOrUpdate(c => c.CategorieActiviteNom,
new CategorieActivite
{
CategorieActiviteNom = nomCatZumba,
ParentId = catDanseParent.Id
});
context.SaveChanges();
#endregion
CategorieActivite catZumba = context.CategoriesActivite.First(c => c.CategorieActiviteNom == nomCatZumba);
CategorieActivite catDanse = context.CategoriesActivite.First(c => c.CategorieActiviteNom == nomCatDanseContemporaine);
#region Lieux
// --------------------------------------------------------------------
// Lieux
// ---
string lieuCDH = "CDH";
context.Lieux.AddOrUpdate(l => l.LieuCode,
new Lieu
{
LieuNom = "Château de l'Horloge",
LieuCode = lieuCDH,
Adresse = "50 Place Du Château de l'Horloge",
Adresse2 = "Jas de Bouffan",
CodePostal = "13090",
Ville = "Aix-en-Provence"
});
string lieuBEL = "BEL";
context.Lieux.AddOrUpdate(l => l.LieuCode,
new Lieu
{
LieuNom = "Espace Jeunesse Bellegarde",
LieuCode = lieuBEL,
Adresse = "37 Boulevard Aristide Briand",
CodePostal = "13100",
Ville = "Aix-en-Provence"
});
context.SaveChanges();
#endregion
Lieu cdh = context.Lieux.First(l => l.LieuCode == lieuCDH);
Lieu bel = context.Lieux.First(l => l.LieuCode == lieuBEL);
#region Activités
// --------------------------------------------------------------------
// Activités
// ---
context.Activites.AddOrUpdate(a => a.ActiviteCode,
new Activite
{
ActiviteCode = "DANSE-BEL-1",
ActiviteNom = "Danse contemporaine 4-6 ans Bellegarde",
CategorieActiviteId = catDanse.Id,
DateDebut = new DateTime(2014, 09, 04),
DateFin = new DateTime(2015, 07, 01),
Planification = new Planification
{
Jour = JourSemaine.Jeudi,
HeureDebut = TimeSpan.FromHours(17),
HeureFin = TimeSpan.FromHours(18)
},
LieuId = bel.LieuId,
});
context.Activites.AddOrUpdate(a => a.ActiviteCode,
new Activite
{
ActiviteCode = "DANSE-BEL-2",
ActiviteNom = "Danse contemporaine 7-9 ans Bellegarde",
CategorieActiviteId = catDanse.Id,
DateDebut = new DateTime(2014, 09, 04),
DateFin = new DateTime(2015, 07, 01),
Planification = new Planification
{
Jour = JourSemaine.Jeudi,
HeureDebut = TimeSpan.FromHours(18),
HeureFin = TimeSpan.FromHours(19)
},
LieuId = bel.LieuId,
});
context.Activites.AddOrUpdate(a => a.ActiviteCode,
new Activite
{
ActiviteCode = "ZUMBA-BEL",
ActiviteNom = "Zumba Bellegarde",
CategorieActiviteId = catZumba.Id,
DateDebut = new DateTime(2014, 09, 04),
DateFin = new DateTime(2015, 07, 01),
Planification = new Planification
{
Jour = JourSemaine.Jeudi,
HeureDebut = TimeSpan.FromHours(20),
HeureFin = TimeSpan.FromHours(21)
},
LieuId = bel.LieuId,
});
context.Activites.AddOrUpdate(a => a.ActiviteCode,
new Activite
{
ActiviteCode = "ZUMBA-CDH",
ActiviteNom = "Zumba",
CategorieActiviteId = catZumba.Id,
DateDebut = new DateTime(2014, 09, 01),
DateFin = new DateTime(2015, 07, 01),
Planification = new Planification
{
Jour = JourSemaine.Lundi,
HeureDebut = TimeSpan.FromHours(19),
HeureFin = TimeSpan.FromHours(20)
},
LieuId = cdh.LieuId,
});
context.SaveChanges();
#endregion
Activite zumbaCDH = context.Activites.First(a => a.ActiviteCode == "ZUMBA-CDH");
Activite zumbaBEL = context.Activites.First(a => a.ActiviteCode == "ZUMBA-BEL");
Activite danseBEL1 = context.Activites.First(a => a.ActiviteCode == "DANSE-BEL-1");
Activite danseBEL2 = context.Activites.First(a => a.ActiviteCode == "DANSE-BEL-2");
#region Formules
// --------------------------------------------------------------------
// Formules
// ---
context.Formules.AddOrUpdate(f => new { f.FormuleNom, f.ActiviteId },
new Formule
{
ActiviteId = zumbaCDH.ActiviteId,
FormuleNom = "Abonnement annuel",
IsActive = true,
Tarif = 135
});
context.Formules.AddOrUpdate(f => new { f.FormuleNom, f.ActiviteId },
new Formule
{
ActiviteId = zumbaBEL.ActiviteId,
FormuleNom = "Abonnement annuel",
IsActive = true,
Tarif = 135
});
context.Formules.AddOrUpdate(f => new { f.FormuleNom, f.ActiviteId },
new Formule
{
ActiviteId = zumbaBEL.ActiviteId,
FormuleNom = "Abonnement semestre",
IsActive = true,
Tarif = 80
});
context.Formules.AddOrUpdate(f => new { f.FormuleNom, f.ActiviteId },
new Formule
{
ActiviteId = danseBEL1.ActiviteId,
FormuleNom = "Abonnement annuel",
IsActive = true,
Tarif = 230
});
context.Formules.AddOrUpdate(f => new { f.FormuleNom, f.ActiviteId },
new Formule
{
ActiviteId = danseBEL2.ActiviteId,
FormuleNom = "Abonnement annuel",
IsActive = true,
Tarif = 230
});
context.SaveChanges();
#endregion
Formule aboZumbaCDH = context.Formules.First(f => f.ActiviteId == zumbaCDH.ActiviteId);
Formule abozumbaBEL = context.Formules.First(f => f.ActiviteId == zumbaBEL.ActiviteId && f.FormuleNom == "Abonnement annuel");
Formule abozumbaBELSemestre = context.Formules.First(f => f.ActiviteId == zumbaBEL.ActiviteId && f.FormuleNom == "Abonnement semestre");
Formule abodanseBEL1 = context.Formules.First(f => f.ActiviteId == danseBEL1.ActiviteId);
Formule abodanseBEL2 = context.Formules.First(f => f.ActiviteId == danseBEL2.ActiviteId);
Formule[] formules = context.Formules.ToArray();
const int numAdherents = 0; //1000;
#region Adherents
if (context.Adherents.Any() == false)
{
for (int i = 1; i <= numAdherents; i++)
{
context.Adherents.Add(new Adherent
{
AdherentNom = Lorem.Words(1).Limit(30),
AdherentPrenom = Lorem.Words(1, Lorem.Chance(1, 20) ? 2 : 1).Limit(30),
Adresse = (Lorem.Number(1, 1000) + " " + Lorem.Sentence(2, 5)).Limit(150),
Adresse2 = (Lorem.Chance(20, 100) ? Lorem.Words(2, 5) : "").Limit(150),
CertificatMedical = Lorem.Chance(80, 100),
CodePostal = Lorem.Number(10000, 95999).ToString(),
//EditeurCourantId = adminUser.Id,
EMail = Lorem.Email().Limit(80),
Notes = Lorem.Chance(10, 100) ? Lorem.Paragraph(20, 2).Limit(150) : "",
Statut = Lorem.Enum <StatutAdherent>(),
Telephone = "0" + Lorem.Number(100000000, 999999999).ToString(),
Ville = Lorem.Words(1, 4).Limit(150),
DateCreation = DateTime.Now,
DateModification = DateTime.Now,
DateResiliation = null
});
context.SaveChanges();
#region Abonnements
Adherent adh = context.Adherents.Find(i);
adh.Abonnements = new List <Abonnement>();
Formule firstFormule = Lorem.Random(formules);
AddAbonnement(context, adh, firstFormule);
if (Lorem.Chance(1, 50)) // multiple formules
{
Formule secondFormule = Lorem.Random(formules);
if (secondFormule.FormuleId != firstFormule.FormuleId) // ensure it is distinct
{
AddAbonnement(context, adh, secondFormule);
}
}
context.SaveChanges();
#endregion
#region Reglement
foreach (Abonnement abo in adh.Abonnements)
{
if (Lorem.Chance(95, 100))
{
switch (abo.TypeReglement)
{
case TypeReglement.Especes:
context.Reglements.Add(new Reglement {
AdherentId = adh.AdherentId, Montant = abo.Formule.Tarif, IsAdhesionIncluse = true
});
break;
case TypeReglement.Cheque_Comptant:
AddReglementCheque(context, adh, abo, 1);
break;
case TypeReglement.Cheque_3Fois:
AddReglementCheque(context, adh, abo, 3);
break;
break;
}
context.SaveChanges();
}
}
#endregion
}
}
#endregion
#region Intervenants
string numSecu1 = Lorem.Number(100000000000000, 299999999999999).ToString();
string numSecu2 = Lorem.Number(100000000000000, 299999999999999).ToString();
context.Intervenants.AddOrUpdate(i => i.NumeroSecuriteSociale, new Intervenant
{
IntervenantNom = Lorem.Words(1).Limit(50),
IntervenantPrenom = Lorem.Words(1).Limit(50),
NumeroSecuriteSociale = numSecu1
});
context.Intervenants.AddOrUpdate(i => i.NumeroSecuriteSociale, new Intervenant
{
IntervenantNom = Lorem.Words(1).Limit(50),
IntervenantPrenom = Lorem.Words(1).Limit(50),
NumeroSecuriteSociale = numSecu2
});
context.SaveChanges();
#endregion
Intervenant int1 = context.Intervenants.First(i => i.NumeroSecuriteSociale == numSecu1);
#region Missions
context.Missions.AddOrUpdate(m => new { m.ActiviteId, m.IntervenantId }, new Mission
{
ActiviteId = zumbaCDH.ActiviteId,
IntervenantId = int1.IntervenantId,
DateDebut = zumbaCDH.DateDebut,
DateFin = zumbaCDH.DateFin,
Description = "Instructeur Zumba",
SalaireHoraire = 20
});
context.Missions.AddOrUpdate(m => new { m.ActiviteId, m.IntervenantId }, new Mission
{
ActiviteId = zumbaBEL.ActiviteId,
IntervenantId = int1.IntervenantId,
DateDebut = zumbaBEL.DateDebut,
DateFin = zumbaBEL.DateFin,
Description = "Instructeur Zumba",
SalaireHoraire = 20
});
context.SaveChanges();
#endregion
}
catch (Exception e)
{
if (e is System.Data.Entity.Validation.DbEntityValidationException)
{
}
// Uncomment to debug seed
if (System.Diagnostics.Debugger.IsAttached == false)
{
System.Diagnostics.Debugger.Launch();
}
throw;
}
}