public double?ObtenirPrixSeance(int?id) { if (id != null) { double result = 0; H15_PROJET_E03Entities dataContext = new H15_PROJET_E03Entities(); var query = from Seances in dataContext.Seances where Seances.SeanceId == id select Seances.Forfait.Prix; string prixSeance = ""; foreach (var asfa in query) { prixSeance = asfa.ToString(); } if (!double.TryParse(prixSeance, out result)) { return(null); } return(result); } return(null); }
// GET: Agents/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Agent agent = unitOfWork.AgentRepository.ObtenirAgentParID(id); if (agent == null) { return(HttpNotFound()); } ViewModels.AgentRapport rapport = new ViewModels.AgentRapport(); List <usp_ProduireRapportAgent_Result> lstRapport = new List <usp_ProduireRapportAgent_Result>(); H15_PROJET_E03Entities context = new H15_PROJET_E03Entities(); using (context) { var result = context.usp_ProduireRapportAgent(id, DateTime.Now.Year); foreach (var item in result) { lstRapport.Add(item); } rapport.RapportAgent = lstRapport; rapport.Agent = agent; } double?prixTotal = 0; foreach (var item in rapport.RapportAgent) { Seance sea = unitOfWork.SeanceRepository.ObtenirSeanceparDate(item.DateSeance.Value); prixTotal += unitOfWork.SeanceRepository.ObtenirCoutTotal(sea.SeanceId); } ViewBag.prixTotal = prixTotal; return(View(rapport)); }
public ActionResult Rapport(int?id) { H15_PROJET_E03Entities context = new H15_PROJET_E03Entities(); if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Agence age = unitOfWork.AgenceRepository.ObtenirAgenceParID(id); if (age == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } List <usp_ProduireRapportAgence_Result> lstResults = new List <usp_ProduireRapportAgence_Result>(); ViewBag.nomAgence = unitOfWork.AgenceRepository.GetByID(id).Nom; ViewBag.agenceId = id; return(View(lstResults)); }
public string[] ObtenirExtra(int?id) { H15_PROJET_E03Entities dataContext = new H15_PROJET_E03Entities(); var query = from Seances in dataContext.Seances where Seances.SeanceId == id select Seances.Extras; string[] tabExtra; if (query != null) { foreach (var extra in query) { if (extra != null) { tabExtra = extra.Split('|'); return(tabExtra); } } } return(null); }
public ActionResult Rapport(int id, FormCollection formCollection) { H15_PROJET_E03Entities context = new H15_PROJET_E03Entities(); List <usp_ProduireRapportAgence_Result> lstResults = new List <usp_ProduireRapportAgence_Result>(); string anneeString = formCollection["Année"]; string moisString = formCollection["Mois"]; int?annee; int?mois; if (anneeString == null || anneeString == "") { annee = null; } else { try { annee = int.Parse(anneeString); } catch { annee = null; } } if (moisString == null || moisString == "") { mois = null; } else { try { mois = int.Parse(moisString); } catch { mois = null; } } if (annee != null && mois != null) { using (context) { var result = context.usp_ProduireRapportAgence(id, annee, mois); foreach (var item in result) { lstResults.Add(item); } DateTime dateDemandee = new DateTime(annee.Value, mois.Value, 1); ViewBag.date = dateDemandee; ViewBag.agenceId = id; ViewBag.annee = annee; ViewBag.mois = mois; ViewBag.nomAgence = unitOfWork.AgenceRepository.GetByID(id).Nom; return(View(lstResults)); } } return(RedirectToAction("Rapport")); }
public AgenceRepository(H15_PROJET_E03Entities context) : base(context) { }
public ProprieteRepository(H15_PROJET_E03Entities context) : base(context) { }
public PhotoRepository(H15_PROJET_E03Entities context) : base(context) { }
public ForfaitRepository(H15_PROJET_E03Entities context) : base(context) { }
public GenericRepository(H15_PROJET_E03Entities context) //public GenericRepository(GestionPhotoImmobilierEntities1 context) { this.context = context; this.dbSet = context.Set <TEntity>(); }