public ActionResult MesReservations()
{
//Add logic to verify the view of enseignant..
System.Diagnostics.Debug.WriteLine(User.Identity.Name);
ReservationModels reservationModel = new ReservationModels();
int MY_ID_ENS = reservationModel.getIdEnseignant();
var query = from res in db.RESERVATIONs
where res.ENSEIGNEMENT.ENSEIGNANT.ID_ENSEIGNANT == MY_ID_ENS
select res;
var liste_va = from r in query
where r.STATUS == 1
select r;
reservationModel.reservations_valides = liste_va.ToList<RESERVATION>();
var liste_ea = from r in query
where r.STATUS == 0
select r;
reservationModel.reservations_enattentes = liste_ea.ToList<RESERVATION>();
var liste_rf = from r in query
where r.STATUS == 2
select r;
reservationModel.reservations_refuses = liste_rf.ToList<RESERVATION>();
return View(reservationModel);
}
/***AJOUTER/SOUMETTRE UNE RESERVATION***/
public ActionResult Ajouter()
{
ViewBag.liste_salles = new SelectList(db.SALLEs, "ID_SALLE", "NUMERO_SALLE");//"ID_XX" in selectlist is a must coloum in db.XX
ViewBag.liste_creneaux = new SelectList(db.CRENAUXes, "ID_CRENEAU", "HEURE_DEBUT_AND_HEURE_FIN");
ReservationModels reservationModel=new ReservationModels();
int ID_ENSEIGANT_ACTUEL = reservationModel.getIdEnseignant();
var query = from ensm in db.ENSEIGNEMENTs
where ensm.ENSEIGNANT.ID_ENSEIGNANT== ID_ENSEIGANT_ACTUEL
select ensm;
List<ENSEIGNEMENT> liste_ensm = query.ToList<ENSEIGNEMENT>();
ViewBag.liste_enseignements = new SelectList(liste_ensm, "ID_ENSEIGNEMENT", "DESCRIPTION_ENSEIGNEMENT");
return View();
}
public ActionResult Index(int id =0)
{
//
bool ensSelectionEstNul = true;
ENSEIGNANT enseignant = new ENSEIGNANT();
ReservationModels reservationModel = new ReservationModels(); // permet d'effectuer une requete pour avoir l'emploi du temps
// On charge l'utilisateur choisi par le select enseignant
ViewBag.listeEnseignant = db.ENSEIGNANTs.ToList();
if (id != 0)
{
enseignant = db.ENSEIGNANTs.Find(id);
if (enseignant != null)
{
ensSelectionEstNul = false;
}
}
// Si l'enseignant n'est pas nul alors on fait la requête pour avoir son emploi du temps
// Sinon on charge l'emploi du temps de l'utilisateur courant
if (!ensSelectionEstNul)
{
// requete permettant de récupérer l'emploi du temps de l'utilisateur sélectionné
var query = from res in db.RESERVATIONs
where res.ENSEIGNEMENT.ENSEIGNANT.LOGIN == enseignant.LOGIN
select res;
var liste_va = from r in query
where r.STATUS == 1
select r;
reservationModel.reservations_valides = liste_va.ToList<RESERVATION>();
}
else
{
// requete permettant de récupérer l'emploi du temps de l'utilisateur connecté
string username = WebSecurity.CurrentUserName;
var query = from res in db.RESERVATIONs
where res.ENSEIGNEMENT.ENSEIGNANT.LOGIN == username
select res;
var liste_va = from r in query
where r.STATUS == 1
select r;
reservationModel.reservations_valides = liste_va.ToList<RESERVATION>();
}
// Permet de structurer le code que l'on transmettra au Jquery pour l'affichage
string boucle_nom_du_cours;
string[] boucle_heure_minute_debut;
string[] boucle_heure_minute_fin;
string boucle_date_debut_annee;
string boucle_date_debut_mois;
string boucle_date_debut_jour;
string ensemble_reservation = "{ header: {left: 'prev,next today', center: 'title',right: 'month,agendaWeek,agendaDay' },editable: false, events: [";
int nombre_iteration = reservationModel.reservations_valides.Count;
int iteration_courant = 0;
foreach (RESERVATION i in reservationModel.reservations_valides)
{
iteration_courant++;
boucle_nom_du_cours = i.ENSEIGNEMENT.COUR.LIBELLE_COURS;
boucle_date_debut_annee = i.DATE_RESERVATION.Year.ToString();
boucle_date_debut_mois = (i.DATE_RESERVATION.Month-1).ToString();
boucle_date_debut_jour = i.DATE_RESERVATION.Day.ToString();
boucle_heure_minute_debut = i.CRENAUX.HEURE_DEBUT.Split(new string[] { "h" }, StringSplitOptions.None);
boucle_heure_minute_fin = i.CRENAUX.HEURE_FIN.Split(new string[] { "h" }, StringSplitOptions.None);
if (iteration_courant < nombre_iteration)
{
ensemble_reservation += "{ title: '" + boucle_nom_du_cours + "', " +
"start : new Date(" +
boucle_date_debut_annee + "," + boucle_date_debut_mois + "," + boucle_date_debut_jour + "," + boucle_heure_minute_debut[0] + "," + boucle_heure_minute_debut[1] + ")," +
"end : new Date(" +
boucle_date_debut_annee + "," + boucle_date_debut_mois + "," + boucle_date_debut_jour + "," + boucle_heure_minute_fin[0] + "," + boucle_heure_minute_fin[1] + ")," +
"allDay:false },";
}
else
{
ensemble_reservation += "{ title: '" + boucle_nom_du_cours + "', " +
"start : new Date(" +
boucle_date_debut_annee + "," + boucle_date_debut_mois + "," + boucle_date_debut_jour + "," + boucle_heure_minute_debut[0] + "," + boucle_heure_minute_debut[1] + ")," +
"end : new Date(" +
boucle_date_debut_annee + "," + boucle_date_debut_mois + "," + boucle_date_debut_jour + "," + boucle_heure_minute_fin[0] + "," + boucle_heure_minute_fin[1] + ")," +
"allDay:false }";
}
}
ensemble_reservation = ensemble_reservation + "]}";
ViewData["EDT"] = ensemble_reservation;
//ViewBag.EDT = ensemble_reservation;
ViewData["Enseignantss"] = new SelectList(db.ENSEIGNANTs.ToList(),"ID_ENSEIGNANT", "NOM" );
ViewBag.listeenseignant1 = new SelectList(db.ENSEIGNANTs.ToList(), "NOM", "LOGIN");
// fin de la fonction, on retourne la vue
return View();
}
public ActionResult Soumettre(ReservationModels reservationModel)
{
//if (ModelState.IsValid)
if(reservationModel.RESERVATION.ID_CRENEAU!=0&&reservationModel.RESERVATION.ID_ENSEIGNEMENT!=0&&reservationModel.RESERVATION.DATE_STRING!=null&&reservationModel.RESERVATION.ID_SALLE!=0)
{
try
{
reservationModel.RESERVATION.STATUS = 0;
DateTime temp = reservationModel.RESERVATION.DATE_RESERVATION;
reservationModel.RESERVATION.DATE_RESERVATION = DateTime.ParseExact(reservationModel.RESERVATION.DATE_STRING, "dd/MM/yyyy", null);
System.Diagnostics.Debug.WriteLine(reservationModel.RESERVATION.DATE_RESERVATION.ToString());
db.RESERVATIONs.Add(reservationModel.RESERVATION);
try
{
db.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
return RedirectToAction("Index");
}catch(FormatException ex)
{
System.Diagnostics.Debug.WriteLine(ex.ToString());
return RedirectToAction("Erreur", new { error_message = "Internal Server Error", REQUEST_PATH="/Reservation/Ajouter"});
}
}
return RedirectToAction("Erreur", new { error_message = "vous devez fournir des informations correctes", REQUEST_PATH = "/Reservation/Ajouter" });
}
public ActionResult test()
{
ReservationModels rs = new ReservationModels();
ViewBag.model = rs;
return View();
}
public ActionResult Accepter_OR_Refuser(string submitButton1, string submitButton2, ReservationModels reservationModel)
{
List<RESERVATION> liste_res_a_modifier = new List<RESERVATION>();
foreach (var c in reservationModel.CheckBoxItems)
{
System.Diagnostics.Debug.WriteLine("HA" + c.IsChecked+"HA"+c.Code);
if (c.IsChecked == true)
{
liste_res_a_modifier.Add(db.RESERVATIONs.Find(c.Code));
}
}
var button_name = submitButton1 ?? submitButton2;//NOTE THIS LINE!!
if (button_name.Equals("flag_accepter"))//Decide wether can accept or not?
{
int count_fail = 0;
for (int i = 0; i < liste_res_a_modifier.Count(); i++)
{
RESERVATION res_a_decider = liste_res_a_modifier.ElementAt(i);
var vailde_res = from rs in db.RESERVATIONs
where rs.STATUS == 1
select rs;
List<RESERVATION> vailde_res_liste = vailde_res.ToList<RESERVATION>();
if (vailde_res_liste.Count() == 0)
{
res_a_decider.STATUS = 1;
}
for (int j = 0; j < vailde_res_liste.Count(); j++)
{
if (res_a_decider.DATE_RESERVATION == vailde_res_liste.ElementAt(j).DATE_RESERVATION)
{
if (res_a_decider.ID_CRENEAU == vailde_res_liste.ElementAt(j).ID_CRENEAU)
{
if (res_a_decider.ID_SALLE == vailde_res_liste.ElementAt(j).ID_SALLE)
{
res_a_decider.STATUS = 0;
count_fail++;
break;
}
}
}
res_a_decider.STATUS = 1;
}
try{
db.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
System.Diagnostics.Debug.WriteLine("fails in total is " + count_fail);
}
else if (button_name.Equals("flag_refuser"))
{
foreach (var r in liste_res_a_modifier)
{
r.STATUS = 2;
try
{
db.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage);
}
}
}
}
}
return RedirectToAction("Index");
}
public ActionResult Index()
{
ReservationModels reservationModel = new ReservationModels();
var query = from res in db.RESERVATIONs
select res;
var liste_va = from r in query
where r.STATUS == 1
select r;
reservationModel.reservations_valides = liste_va.ToList<RESERVATION>();
var liste_ea = from r in query
where r.STATUS == 0
select r;
reservationModel.reservations_enattentes = liste_ea.ToList<RESERVATION>();
var liste_rf = from r in query
where r.STATUS == 2
select r;
reservationModel.reservations_refuses = liste_rf.ToList<RESERVATION>();
reservationModel.CheckBoxItems=new List<CheckBoxItem>();
foreach (var ea in reservationModel.reservations_enattentes)
{
reservationModel.CheckBoxItems.Add(new CheckBoxItem { IsChecked=false});
}
return View(reservationModel);
}
