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 ActionResult ConsultationRDV()
{
ViewBag.Employe = (Employe)Session["Employe"];
if (ViewBag.Employe != null)
{
RendezVousDAO rendezVousDAO = new RendezVousDAO();
PraticienDAO praticienDAO = new PraticienDAO();
List <RendezVous> futursRDV = rendezVousDAO.ReadRDVFuturFromCommercialID(ViewBag.Employe.Id);
Debug.WriteLine("Debug Bug");
List <RendezVous> passesRDV = rendezVousDAO.ReadRDVHistoFromCommercialID(ViewBag.Employe.Id);
Debug.WriteLine("Fin Bug");
List <Praticien> mesPraticiens = praticienDAO.ReadAll();
ViewBag.FutursRDV = futursRDV;
ViewBag.PassesRDV = passesRDV;
ViewBag.MesPraticiens = mesPraticiens;
ViewData["Message"] = "Page de Consultation de vos Rendez-vous.";
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);
}
