public ActionResult Echantillon(int id_rdv) { ViewBag.Employe = (Employe)Session["Employe"]; if (ViewBag.Employe != null) { ProduitDAO produitManager = new ProduitDAO(); EchantillonDonneDAO echantillonDonneManager = new EchantillonDonneDAO(); RendezVousDAO rendezVousManager = new RendezVousDAO(); RendezVous rendezVous = rendezVousManager.Read(id_rdv, false); List <EchantillonDonne> mesEchantillonsDonnes = echantillonDonneManager.ReadAllFromRendezVous(id_rdv); List <Produit> mesFamilles = produitManager.ReadFamille(); ViewBag.Famille = mesFamilles; ViewBag.EchantillonDonne = mesEchantillonsDonnes; ViewBag.RendezVous = rendezVous; return(View()); } else { return(RedirectToAction("Index", "Home")); } }
public void AddModifyRDV(int?id, string date, string time, string motif, int indice, int id_employe, int id_praticien) { RendezVousDAO rendezVousManager = new RendezVousDAO(); PraticienDAO praticienManager = new PraticienDAO(); EmployeDAO employeManager = new EmployeDAO(); RendezVous newRDV = id == null ? new RendezVous() : rendezVousManager.Read((int)id, false); //Debug.WriteLine("Debug.Time = > " + time); newRDV.Date_rdv = new DateTime(Convert.ToInt32(date.Substring(0, 4)), Convert.ToInt32(date.Substring(5, 2)), Convert.ToInt32(date.Substring(8)), Convert.ToInt32(time.Substring(0, 2)), Convert.ToInt32(time.Substring(3)), 00); newRDV.Date_bilan = newRDV.Date_rdv.AddDays(7); newRDV.Indice_confiance = indice; newRDV.Motif_rdv = (RendezVous.Rdv)Enum.Parse(typeof(RendezVous.Rdv), motif); newRDV.Praticien = praticienManager.Read(id_praticien); newRDV.Employe = employeManager.Read(id_employe); if (id == null) // ADD { rendezVousManager.Create(newRDV); } else // MODIFY { rendezVousManager.Update(newRDV); } }
public void Delete(string table, int id) { if (table.Equals("rendez_vous")) { RendezVousDAO rendezVousManager = new RendezVousDAO(); rendezVousManager.Delete(rendezVousManager.Read(id, false)); } else if (table.Equals("ligne_frais")) { LigneFraisDAO ligneFraisDAO = new LigneFraisDAO(); ligneFraisDAO.Delete(id); } else if (table.Equals("praticien")) { PraticienDAO praticienManager = new PraticienDAO(); praticienManager.Delete(id); } }
public string Read(string table, int id) { string response = ""; if (table.Equals("rendez_vous")) { RendezVousDAO rendezVousManager = new RendezVousDAO(); RendezVous rendezVous = rendezVousManager.Read(id, false); JavaScriptSerializer serializer = new JavaScriptSerializer(); response = serializer.Serialize(rendezVous); } else if (table.Equals("etablissement")) { PraticienDAO praticienManager = new PraticienDAO(); EtablissementDAO etablissementManager = new EtablissementDAO(); Etablissement etablissement = etablissementManager.Read(id); Praticien praticien = new Praticien(); praticien.Etablissement = etablissement; List <Praticien> PraticiensInEtablissement = new List <Praticien>(); PraticiensInEtablissement.Add(praticien); PraticiensInEtablissement.AddRange(praticienManager.ReadAllPraticiensInEtablissement(id)); JavaScriptSerializer serializer = new JavaScriptSerializer(); response = serializer.Serialize(PraticiensInEtablissement); } else if (table.Equals("ligne_frais")) { LigneFraisDAO ligneFraisDAO = new LigneFraisDAO(); LigneFrais mesLigneFrais = ligneFraisDAO.Read(id, true); //Debug.WriteLine("====================================" + mesLigneFrais.Frais); JavaScriptSerializer serializer = new JavaScriptSerializer(); response = serializer.Serialize(mesLigneFrais); //Debug.WriteLine("================================================" + response); } return(response); }
public string AddModifyED(string nom, int concentration, int id_rdv, int quantite, string addOrModify) { string response = ""; EchantillonDonneDAO echantillonDonneManager = new EchantillonDonneDAO(); RendezVousDAO rendezVousManager = new RendezVousDAO(); EchantillonDAO echantillonManager = new EchantillonDAO(); ProduitDAO produitDAO = new ProduitDAO(); int echantillonLu = echantillonManager.Read_IdEchantillon_FromNomConcentration(nom, concentration); EchantillonDonne echantillonDonne = new EchantillonDonne(); echantillonDonne.RendezVous = rendezVousManager.Read(id_rdv, true); echantillonDonne.Echantillon = echantillonManager.Read(echantillonLu, true); echantillonDonne.Quantite = quantite; echantillonDonne.Produit = produitDAO.ReadFromNom(nom, true); if (addOrModify.Equals("add")) // ADD { if (echantillonDonneManager.Read(echantillonDonne.Echantillon.Id_echantillon, echantillonDonne.RendezVous.Id_rdv) == null) { echantillonDonneManager.Create(echantillonDonne); response = "Add done !"; } else { response = "Allready exist !"; } } else // MODIFY { echantillonDonneManager.Update(echantillonDonne); response = "Modify done !"; } return(response); }