public static void AddElementIntervenant(int activiteElementDetailsId, Intervenant intervenant)
{
var details = DAO.Find <ActiviteElementDetails>(activiteElementDetailsId);
details.Intervenant = intervenant;
DAO.Update(details);
}
public Mission(string nom, string description, int nbHeursPrevues, Dictionary <DateTime, int> releveHoraire, Intervenant executant1)
{
Nom = nom;
Description = description;
NbHeursPrevues = nbHeursPrevues;
ReleveHoraire = releveHoraire;
Executant1 = executant1;
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
Intervenant intervenant = await db.Intervenants.FindAsync(id);
db.Intervenants.Remove(intervenant);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
/// <summary>
/// construit, à partir d'un noeud XML un objet de la classe Prestation.
/// Avec son Intervenant
/// </summary>
/// <param name="unePrestationXML">Elément XML de la prestation à créer</param>
/// <returns>Un objet de la classe Prestation</returns>
private static Prestation XmlToPrestation(XmlElement unePrestationXML)
{
string libellePrestation = unePrestationXML.ChildNodes[0].InnerText;
DateTime datePrestation = TraitementXML.XmlToDateTime((XmlElement)unePrestationXML.ChildNodes[1]);
int idIntervenant = Convert.ToInt32(unePrestationXML.GetAttribute("idintervenant"));
XmlElement unIntervenantXML = ChercheIntervenant(idIntervenant);
Intervenant unIntervenant = TraitementXML.XmlToIntervenant(unIntervenantXML);
return(new Prestation(libellePrestation, datePrestation, unIntervenant));
}
/// <summary>
/// construit, à partir d'un noeud XML un objet de la classe Intervenant
/// Avec ses prestations
/// </summary>
/// <param name="unIntervenantXml">Elément XML de l'intervenant à créer</param>
/// <returns>Un objet de la classe Intervenant</returns>
public static Intervenant XmlToIntervenantComplet(XmlElement unIntervenantXml)
{
Intervenant unIntervenant = XmlToIntervenant(unIntervenantXml);
int idIntervenant = Convert.ToInt16(unIntervenantXml.GetAttribute("idintervenant"));
foreach (XmlElement unePrestationXml in LesPrestations)
{
}
return(unIntervenant);
}
public async Task <ActionResult> Edit([Bind(Include = "IntervenantId,IntervenantNom,IntervenantPrenom,NumeroSecuriteSociale,DateCreation,DateModification")] Intervenant intervenant)
{
if (ModelState.IsValid)
{
db.Entry(intervenant).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(intervenant));
}
// GET: Intervenants/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Intervenant intervenant = await db.Intervenants.FindAsync(id);
if (intervenant == null)
{
return(HttpNotFound());
}
return(View(intervenant));
}
static void Main(string[] args)
{
using (var db = new ContexteBDD())
{
var Date = DateTime.Now;
var admin = new Administration()
{
Admin = "Big Brother"
};
var person = new Intervenant()
{
Matricule = "A92B",
Nom = "Pampa",
Prenom = "Juju"
};
var inter = new Intervention()
{
Adresse = "32 Rue du Poney des Sables",
DateOuvert = Date,
DateCloture = Date.AddDays(2),
Cloturer = false
};
var vehicule = new Vehicule()
{
Marque = "Citroen",
Modele = "Tesla",
Immatriculation = "COM2T17",
VolumeUtile = 25,
Disponible = true
};
var materiel = new Materiel()
{
Designation = "Vis de qualité",
DateAchat = Date,
Disponible = true
};
db.Administrations.Add(admin);
db.Intervenants.Add(person);
db.Interventions.Add(inter);
db.Vehicules.Add(vehicule);
db.Materiels.Add(materiel);
db.SaveChanges();
}
}
static void Main(string[] args)
{
using (var db = new ContextBDD())
{
var dateNow = DateTime.Now;
var intervenant = new Intervenant()
{
Matricule = 123456,
Nom = "Guégan",
Prenom = "Eva",
};
var vehicule = new Vehicule()
{
Immatriculation = "AB-123-CD",
Marque = "Toyota",
Modele = "azerty",
VolumeUtile = 25,
};
var materiel = new Materiel()
{
RefUnique = 987,
Designation = "Tournevis plat",
Description = "Tournevis plat bosh ...",
DateAchat = dateNow,
};
var intervention = new Intervention()
{
AdresseClient = "12 rue Saint Exupéry",
DebutIntervention = dateNow,
FinIntervention = dateNow,
};
intervenant.Interventions.Add(intervention);
intervenant.Vehicules.Add(vehicule);
intervenant.Materiels.Add(materiel);
db.Intervenants.Add(intervenant);
db.Vehicules.Add(vehicule);
db.Materiels.Add(materiel);
db.Interventions.Add(intervention);
db.SaveChanges();
Console.WriteLine("Les informations ont bien été inséré dans la base de données");
}
}
static void Main(string[] args)
{
using (var db = new ContexteBDD())
{
// var Véhicule = db.Véhicules.First(c => c.Immatriculation == "AC-456-BD");
var Véhicule = new Véhicule()
{
Immatriculation = "AC-456-BD",
Marque = "Renault",
Modèle = "Clio 2",
Volume = 45,
Disponible = true
};
var Intervenant = new Intervenant()
{
Matricule = 1,
Nom = "Dupont",
Prenom = "Jean"
};
var Intervention = new Intervention()
{
Id = 1
};
var Materiel = new Matériel()
{
Référence = 1,
Désignation = "pioche",
Description = "Description",
dateAchat = 11 - 11 - 2019,
Disponible = true
};
db.Véhicules.Add(Véhicule);
db.Intervenants.Add(Intervenant);
db.Interventions.Add(Intervention);
db.SaveChanges();
}
}
static void Main(string[] args)
{
using (var db = new ConnexionBDD())
{
var v = new Vehicule()
{
Disponible = true,
Marque = "Renault",
Immatriculation = "13-Vz-5",
VolumeUtile = 50,
Model = "nisan",
};
var personne = new Intervenant()
{
Nom = "Ricard",
Prenom = "Didier"
};
db.intervenants.Add(personne);
db.Vehicules.Add(v);
db.SaveChanges();
}
}
public bool Equals(Intervenant intervenant)
{
return(Nom.Equals(intervenant.Nom) && Prenom.Equals(intervenant.Prenom) && Mail.Equals(intervenant.Mail));
}
public Role(Intervenant intervenant, string libelle)
{
this.Libelle = libelle;
this.Intervenant = intervenant;
}
public async Task ModifyAsync(Intervenant intervenant) => await Collection .ReplaceOneAsync(x => x.Id == intervenant.Id, intervenant);
public async Task AddAsync(Intervenant intervenant) => await Collection .InsertOneAsync(intervenant);
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;
}
}
