public ActionResult Reserver(int idClient, int idMed, int hDebut, int mDebut, int hFin, int mFin, DateTime jour)
{
CRENEAUX cr = new CRENEAUX()
{
ID = (int)cx.CRENEAUX.Max(x => x.ID) + 1, HDEBUT = hDebut, MDEBUT = mDebut, HFIN = hFin, MFIN = mFin, ID_MEDECIN = idMed
};
cr.MEDECINS = cx.MEDECINS.Single(x => x.ID == idMed);
RV rv = new RV()
{
ID = (int)cx.RV.Max(x => x.ID) + 1, ID_CLIENT = idClient, ID_CRENEAU = cr.ID, JOUR = jour
};
rv.CRENEAUX = cr;
rv.CLIENTS = cx.CLIENTS.Single(x => x.ID == idClient);
cx.CRENEAUX.Add(cr);
cx.RV.Add(rv);
cx.SaveChanges();
List <RV> lRv = new List <RV>();
foreach (var item in cx.RV.Where(x => x.CRENEAUX.ID_MEDECIN == cr.ID_MEDECIN && x.JOUR == rv.JOUR))
{
lRv.Add(item);
}
MEDECINS med = cx.MEDECINS.Single(x => x.ID == idMed);
ViewData["idMed"] = idMed;
ViewData["titreMed"] = med.TITRE;
ViewData["nomMed"] = med.NOM;
ViewData["prenomMed"] = med.PRENOM;
ViewData["jour"] = jour;
return(View("Calendrier", lRv));
}
public ActionResult Supprimer(int idRv, int idCr)
{
RV rv = cx.RV.Single(x => x.ID == idRv);
CRENEAUX cr = cx.CRENEAUX.Single(x => x.ID == idCr);
MEDECINS med = cx.MEDECINS.Single(x => x.ID == cr.MEDECINS.ID);
int idMed = (int)cr.ID_MEDECIN;
DateTime jour = (DateTime)rv.JOUR;
ViewData["idMed"] = idMed;
ViewData["titreMed"] = med.TITRE;
ViewData["nomMed"] = med.NOM;
ViewData["prenomMed"] = med.PRENOM;
ViewData["jour"] = jour;
cx.RV.Remove(rv);
cx.SaveChanges();
cx.CRENEAUX.Remove(cr);
cx.SaveChanges();
List <RV> lRv = new List <RV>();
foreach (var item in cx.RV.Where(x => x.CRENEAUX.ID_MEDECIN == idMed && x.JOUR == jour))
{
lRv.Add(item);
}
return(View("Calendrier", lRv));
}
public ActionResult Calendrier(int idMed, DateTime jour)
{
MEDECINS med = cx.MEDECINS.Single(x => x.ID == idMed);
ViewData["idMed"] = idMed;
ViewData["titreMed"] = med.TITRE;
ViewData["nomMed"] = med.NOM;
ViewData["prenomMed"] = med.PRENOM;
ViewData["jour"] = jour;
List <RV> lRV = new List <RV>();
foreach (var item in cx.RV.Where(x => x.CRENEAUX.ID_MEDECIN == idMed && x.JOUR == jour))
{
lRV.Add(item);
}
return(View(lRV));
}
public ActionResult Reserver(int idMed, int hDebut, int mDebut, int hFin, int mFin, DateTime jour)
{
MEDECINS med = new MEDECINS();
med = cx.MEDECINS.Single(x => x.ID == idMed);
ViewData["idMed"] = idMed;
ViewData["titreMed"] = med.TITRE;
ViewData["nomMed"] = med.NOM;
ViewData["prenomMed"] = med.PRENOM;
ViewData["hDebut"] = hDebut;
ViewData["mDebut"] = mDebut;
ViewData["hFin"] = hFin;
ViewData["mFin"] = mFin;
ViewData["jour"] = jour;
List <CLIENTS> lCl = new List <CLIENTS>();
foreach (var item in cx.CLIENTS)
{
lCl.Add(item);
}
return(View(lCl));
}
