public async Task <IActionResult> PutCommodites_Extra([FromRoute] int id, [FromBody] Commodites_Extra commodites_Extra) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != commodites_Extra.Id_Commodites) { return(BadRequest()); } _context.Entry(commodites_Extra).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!Commodites_ExtraExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <IActionResult> PostCommodites_Extra([FromBody] Commodites_Extra commodites_Extra) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.commodites_Extras.Add(commodites_Extra); await _context.SaveChangesAsync(); return(CreatedAtAction("GetCommodites_Extra", new { id = commodites_Extra.Id_Commodites }, commodites_Extra)); }
public static void Initializer(NLHContext nLHContext) { // IApplicationBuilder applicationBuilder) // NLHContext nLHContext = applicationBuilder.ApplicationServices.GetRequiredService<NLHContext>(); //nLHContext.Database.EnsureCreated(); if (nLHContext.medecins.Any()) { return; } var Medecins = new Medecin[] { new Medecin { Id_Medecin = "MaMa", Nom_Medecin = "Manon", Prenom_Medecin = "Marie", Specialite_Medecin = "Chirugien" }, new Medecin { Id_Medecin = "PaLa", Nom_Medecin = "Patrick", Prenom_Medecin = "Lambert", Specialite_Medecin = "Dentiste" }, new Medecin { Id_Medecin = "LoHe", Nom_Medecin = "Lonbon", Prenom_Medecin = "Henrie", Specialite_Medecin = "Pédiatre" }, new Medecin { Id_Medecin = "MaAn", Nom_Medecin = "Marilou", Prenom_Medecin = "Annette", Specialite_Medecin = "Géneraliste" }, new Medecin { Id_Medecin = "HoIn", Nom_Medecin = "Hoiutiu", Prenom_Medecin = "Ines", Specialite_Medecin = "Ophtamologue" }, new Medecin { Id_Medecin = "LoMa", Nom_Medecin = "Londurt", Prenom_Medecin = "Max", Specialite_Medecin = "Chirugien" }, }; foreach (Medecin m in Medecins) { nLHContext.medecins.Add(m); } nLHContext.SaveChanges(); var Parents = new Parent[] { new Parent { Nom_Parent = "Marilyn", Prenom_Parent = "Monar", Adresse_Parent = "Jarry", Ville_Parent = "Montréal", Province_Parent = "Québec", Code_Postale_Parent = "H2G3R8", Telephone_Parent = "4385825748" }, new Parent { Nom_Parent = "Pat", Prenom_Parent = "Le chat", Adresse_Parent = "Papineau", Ville_Parent = "Montréal", Province_Parent = "Québec", Code_Postale_Parent = "H1G3R7", Telephone_Parent = "4385805748" }, new Parent { Nom_Parent = "Marcelle", Prenom_Parent = "Desailly", Adresse_Parent = "Bourassa", Ville_Parent = "Montréal", Province_Parent = "Québec", Code_Postale_Parent = "H2G3G9", Telephone_Parent = "5145825748" }, new Parent { Nom_Parent = "Lambertin", Prenom_Parent = "Moiu", Adresse_Parent = "Beaubien", Ville_Parent = "Montréal", Province_Parent = "Québec", Code_Postale_Parent = "J5G3R8", Telephone_Parent = "4385825760" }, }; foreach (Parent p in Parents) { nLHContext.parents.Add(p); } nLHContext.SaveChanges(); var CompagnieAssurances = new Compagnie_Assurance[] { new Compagnie_Assurance { Nom_Compagnie = "Industriel Alliance" }, new Compagnie_Assurance { Nom_Compagnie = "La crois bleue" }, new Compagnie_Assurance { Nom_Compagnie = "RAMQ" }, new Compagnie_Assurance { Nom_Compagnie = "AXA" }, }; foreach (Compagnie_Assurance c in CompagnieAssurances) { nLHContext.assurances.Add(c); } nLHContext.SaveChanges(); var Patients = new Patient[] { new Patient { NSS = "RIAN0212", Date_Naissance_Patient = DateTime.Parse("1998-02-12"), Nom_Patient = "Rita", Prenom_Patient = "Anuska", Adresse_Patient = "Jarry", Ville_Patient = "Montréal", Province_Patient = "Québec", Code_Postale_Patient = "K5O6T8", Telephone_Patient = "5142876589", Id_Medecin = Medecins.Single(m => m.Nom_Medecin == "Manon").Id_Medecin, Id_Compagnie = CompagnieAssurances.Single(c => c.Nom_Compagnie == "Industriel Alliance").Id_Compagnie, Ref_Parent = Parents.Single(p => p.Nom_Parent == "Marilyn").Ref_Parent }, new Patient { NSS = "MALI0212", Date_Naissance_Patient = DateTime.Parse("2009-02-12"), Nom_Patient = "Marina", Prenom_Patient = "lise", Adresse_Patient = "Papineau", Ville_Patient = "Montréal", Province_Patient = "Québec", Code_Postale_Patient = "K5A6S8", Telephone_Patient = "5146986589", Id_Medecin = Medecins.Single(m => m.Nom_Medecin == "Patrick").Id_Medecin, Id_Compagnie = CompagnieAssurances.Single(c => c.Nom_Compagnie == "RAMQ").Id_Compagnie, Ref_Parent = Parents.Single(p => p.Nom_Parent == "Pat").Ref_Parent }, new Patient { NSS = "LOMA1012", Date_Naissance_Patient = DateTime.Parse("2016-10-12"), Nom_Patient = "Louise", Prenom_Patient = "Mali", Adresse_Patient = "Pie IX", Ville_Patient = "Montréal", Province_Patient = "Québec", Code_Postale_Patient = "B4P6T8", Telephone_Patient = "4382876589", Id_Medecin = Medecins.Single(m => m.Nom_Medecin == "Lonbon").Id_Medecin, Id_Compagnie = CompagnieAssurances.Single(c => c.Nom_Compagnie == "La crois bleue").Id_Compagnie, Ref_Parent = Parents.Single(p => p.Nom_Parent == "Marcelle").Ref_Parent }, new Patient { NSS = "MALO1130", Date_Naissance_Patient = DateTime.Parse("2016-11-30"), Nom_Patient = "Marina", Prenom_Patient = "Loula", Adresse_Patient = "Pie IX", Ville_Patient = "Montréal", Province_Patient = "Québec", Code_Postale_Patient = "B4P6T8", Telephone_Patient = "4382876589", Id_Medecin = Medecins.Single(m => m.Nom_Medecin == "Lonbon").Id_Medecin, Id_Compagnie = CompagnieAssurances.Single(c => c.Nom_Compagnie == "La crois bleue").Id_Compagnie, Ref_Parent = Parents.Single(p => p.Nom_Parent == "Marcelle").Ref_Parent }, }; foreach (Patient p in Patients) { var patientInDB = nLHContext.patients.Where( m => m.Medecin.Id_Medecin == p.Id_Medecin && m.Compagnie_Assurance.Id_Compagnie == p.Id_Compagnie && m.Parent.Ref_Parent == p.Ref_Parent ).SingleOrDefault(); if (patientInDB == null) { nLHContext.patients.Add(p); } } nLHContext.SaveChanges(); var Departements = new Departement[] { new Departement { Nom_Departement = "Pédiatrie" }, new Departement { Nom_Departement = "Chirugie" }, new Departement { Nom_Departement = "Ophtamologie" }, new Departement { Nom_Departement = "Génicologie" }, new Departement { Nom_Departement = "Pédiatrie" }, }; foreach (Departement d in Departements) { nLHContext.departements.Add(d); } nLHContext.SaveChanges(); var TypeLits = new Type_Lit[] { new Type_Lit { Description = "Individuel", Cout = 250 }, new Type_Lit { Description = "Double", Cout = 150 }, new Type_Lit { Description = "standart", Cout = 50 }, }; foreach (Type_Lit t in TypeLits) { nLHContext.Type_Lits.Add(t); } nLHContext.SaveChanges(); var Lits = new Lit[] { new Lit { Occupe = "non", Id_Departement = Departements.Single(l => l.Nom_Departement == "Pédiatrie").Id_Departement, Numero_Type = TypeLits.Single(t => t.Description == "Individuel").Numero_Type }, new Lit { Occupe = "non", Id_Departement = Departements.Single(l => l.Nom_Departement == "Pédiatrie").Id_Departement, Numero_Type = TypeLits.Single(t => t.Description == "standart").Numero_Type }, new Lit { Occupe = "oui", Id_Departement = Departements.Single(l => l.Nom_Departement == "Pédiatrie").Id_Departement, Numero_Type = TypeLits.Single(t => t.Description == "Double").Numero_Type } }; foreach (Lit l in Lits) { var litInDB = nLHContext.lits.Where( s => s.Departement.Id_Departement == l.Id_Departement && s.Type_Lit.Numero_Type == l.Numero_Type ).SingleOrDefault(); if (litInDB == null) { nLHContext.lits.Add(l); } } nLHContext.SaveChanges(); var DossierAdmissions = new Dossier_Admission[] { new Dossier_Admission { Chirugie_Programme = "Jambe", Date_Admission = DateTime.Parse("2018/06/03"), Date_Chirugie = DateTime.Parse("2018/06/04"), Date_Conge = DateTime.Parse("2018/08/10"), NSS = Patients.Single(p => p.NSS == "MALI0212").NSS, Numero_Lit = Lits.Single(l => l.Occupe == "non").Numero_Lit }, new Dossier_Admission { Chirugie_Programme = "Colon", Date_Admission = DateTime.Parse("2018/10/03"), Date_Chirugie = DateTime.Parse("2018/10/04"), Date_Conge = DateTime.Parse("2018/11/10"), NSS = Patients.Single(p => p.NSS == "RIAN0212").NSS, Numero_Lit = Lits.Single(l => l.Occupe == "non").Numero_Lit }, new Dossier_Admission { Chirugie_Programme = "Jambe", Date_Admission = DateTime.Parse("2019/06/03"), Date_Chirugie = DateTime.Parse("2019/06/04"), Date_Conge = DateTime.Parse("2019/08/10"), NSS = Patients.Single(p => p.NSS == "LOMA1012").NSS, Numero_Lit = Lits.Single(l => l.Occupe == "oui").Numero_Lit }, new Dossier_Admission { Chirugie_Programme = "Genou", Date_Admission = DateTime.Parse("2018/06/03"), Date_Chirugie = DateTime.Parse("2018/06/04"), Date_Conge = DateTime.Parse("2018/08/10"), NSS = Patients.Single(p => p.NSS == "MALO1130").NSS, Numero_Lit = Lits.Single(l => l.Occupe == "oui").Numero_Lit } }; foreach (Dossier_Admission d in DossierAdmissions) { var dossAdmInDB = nLHContext.dossier_Admissions.Where( s => s.Patient.NSS == d.NSS && s.Lit.Numero_Lit == d.Numero_Lit).SingleOrDefault(); if (dossAdmInDB == null) { nLHContext.dossier_Admissions.Add(d); } } nLHContext.SaveChanges(); var Factures = new Facture[] { new Facture { Date_Facture = DateTime.Parse("2019/08/20"), Montant_Facture = 568, Id_Admission = DossierAdmissions.Single(d => d.Chirugie_Programme == "Prostate").Id_Admission }, new Facture { Date_Facture = DateTime.Parse("2018/08/20"), Montant_Facture = 668, Id_Admission = DossierAdmissions.Single(d => d.Chirugie_Programme == "Colon").Id_Admission }, new Facture { Date_Facture = DateTime.Parse("2017/08/20"), Montant_Facture = 1000, Id_Admission = DossierAdmissions.Single(d => d.Chirugie_Programme == "Jambe").Id_Admission }, new Facture { Date_Facture = DateTime.Parse("2019/01/20"), Montant_Facture = 1000, Id_Admission = DossierAdmissions.Single(d => d.Chirugie_Programme == "Genou").Id_Admission } }; foreach (Facture f in Factures) { nLHContext.factures.Add(f); } nLHContext.SaveChanges(); var CommoditeExtras = new Commodites_Extra[] { new Commodites_Extra { Description_Commodite = "Televiseur", Taux_Quotidient = 205, }, new Commodites_Extra { Description_Commodite = "Televiseur+téléphone", Taux_Quotidient = 355, }, new Commodites_Extra { Description_Commodite = "Téléphone", Taux_Quotidient = 205, } }; foreach (Commodites_Extra c in CommoditeExtras) { nLHContext.commodites_Extras.Add(c); } nLHContext.SaveChanges(); var CommoditeAdmissions = new Commodite_Admission[] { new Commodite_Admission { Id_Admission = DossierAdmissions.Single(d => d.Chirugie_Programme == "Prostate").Id_Admission, Id_Commodite = CommoditeExtras.Single(c => c.Description_Commodite == "Televiseur").Id_Commodites }, new Commodite_Admission { Id_Admission = DossierAdmissions.Single(d => d.Chirugie_Programme == "Colon").Id_Admission, Id_Commodite = CommoditeExtras.Single(c => c.Description_Commodite == "Téléphone").Id_Commodites }, new Commodite_Admission { Id_Admission = DossierAdmissions.Single(d => d.Chirugie_Programme == "Jambe").Id_Admission, Id_Commodite = CommoditeExtras.Single(c => c.Description_Commodite == "Televiseur+téléphone").Id_Commodites }, new Commodite_Admission { Id_Admission = DossierAdmissions.Single(d => d.Chirugie_Programme == "Genou").Id_Admission, Id_Commodite = CommoditeExtras.Single(c => c.Description_Commodite == "Televiseur+téléphone").Id_Commodites }, }; foreach (Commodite_Admission c in CommoditeAdmissions) { nLHContext.commodite_Admissions.Add(c); } nLHContext.SaveChanges(); }