//[Route("GetById/{Id}")] public IActionResult GetById(/*[FromRoute]*/ int Id) { Avis av = new Avis(); av = _avRepo.GetById(Id); return(Ok(av)); }
public ActionResult SaveComment(string commentaire, string nom, string note, string nomSeo) { Avis nouvelAvis = new Avis(); nouvelAvis.DateAvis = DateTime.Now; nouvelAvis.Description = commentaire; nouvelAvis.Nom = nom; double dNote = 0; if (!double.TryParse(note, NumberStyles.Any, CultureInfo.InvariantCulture, out dNote)) { //RedirectToAction(); throw new Exception("Impossible de parser la note" + note); } nouvelAvis.Note = dNote; using (var context = new AvisFormationDbEntities()) { var formationEntity = context.Formation.FirstOrDefault(f => f.NomSeo == nomSeo); if (formationEntity == null) { return(RedirectToAction("Acccueil", "Home")); } nouvelAvis.IdFormation = formationEntity.Id; context.Avis.Add(nouvelAvis); context.SaveChanges(); } return(RedirectToAction("DetailsFormation", "Formation", new { nomSeo })); }
public static Avis getUnAvis(int idAvis) { Avis unAvis = new Avis(); unAvis.setId(idAvis); try { MySqlConnection cnx = MySQL.getCnx(); cnx.Ping(); string requete = "SELECT AVI_NOTE, AVI_COMMENTAIRE FROM avis WHERE AVI_ID = " + idAvis; MySqlCommand cmd = new MySqlCommand(requete, cnx); var reader = cmd.ExecuteReader(); if (reader.Read()) { unAvis.setNote(reader.GetInt32(0)); unAvis.setCommentaire(reader.GetString(1)); } cnx.Close(); return(unAvis); } catch (MySqlException ex) { return(unAvis); } }
public async Task <IActionResult> Edit(int id, [Bind("ID,Texte,UserID,RecetteID")] Avis avis) { if (id != avis.ID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(avis); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!AvisExists(avis.ID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["RecetteID"] = new SelectList(_context.Recette, "ID", "ID", avis.RecetteID); ViewData["UserID"] = new SelectList(_context.User, "Id", "Id", avis.UserID); DisplayMessage("Votre avis a bien été modifié", Class.TypeMessage.SUCCESS); return(View(avis)); }
public ActionResult MesAvisHome(Avis avis) { if (Session.Count > 0) { int idCurrent = Convert.ToInt32(Session["id"]); Page currentPage = db.Page.Where(p => p.id == avis.Pag_id && p.archived == 1).FirstOrDefault(); if (currentPage != null) { avis.iduser = idCurrent; avis.archived = 1; avis.created = DateTime.Now; avis.status = 0; db.Avis.Add(avis); db.SaveChanges(); TempData["myData"] = "1"; TempData["result_code"] = 1; TempData["message"] = "Avis envoyer et en attente de valudation par la compagnie."; TempData.Keep(); return(RedirectToAction("MesAvisHome", new { id = currentPage.Ins_id })); } else { return(HttpNotFound()); } } else { return(RedirectToAction("Login", "Inscrires")); } }
public List <Avis> GetForTheme(Theme theme) { string query = ""; query += "select avis.id,avis.commentaire,avis.date,avis.joueur from avis "; query += "join joueur on joueur.id = avis.joueur "; query += "join joueur_partie ON joueur.id = joueur_partie.joueur "; query += "join partie ON joueur_partie.partie = partie.id "; query += "join salle ON partie.salle = salle.id "; query += "join theme_salle ON salle.id = theme_salle.salle "; query += "where theme_salle.theme = " + theme.Id + " AND "; query += "theme_salle.dateDebut < avis.date AND "; query += "theme_salle.dateFin > avis.date "; query += "group by avis.id, avis.commentaire, avis.date, avis.joueur "; query += "order by avis.date"; DataTable tab = _dbal.RQuery(query).Tables[0]; List <Avis> lstAvis = new List <Avis>(); foreach (DataRow row in tab.Rows) { Avis avis = new Avis(row); avis.Joueur = _daoJoueur.GetById((int)row["joueur"]); lstAvis.Add(avis); } return(lstAvis); }
// public ActionResult SaveComment(string commentaire, string nom, string note, string nomSeo) public ActionResult SaveComment(SaveCommentViewModel comment) { Avis nouvelAvis = new Avis { DateAvis = DateTime.Now, Description = comment.Commentaire, Nom = comment.Nom }; double dNote = 0; if (!double.TryParse(comment.Note, NumberStyles.Any, CultureInfo.InvariantCulture, out dNote)) { throw new Exception("Impossible de parser la note " + comment.Note); } nouvelAvis.Note = dNote; using (var context = new AvisEntities()) { var formationEntity = context.Formations .FirstOrDefault(f => f.NomSeo == comment.NomSeo); if (formationEntity == null) { return(RedirectToAction("Acceuil", "Home")); } nouvelAvis.IdFormation = formationEntity.Id; context.Avis.Add(nouvelAvis); context.SaveChanges(); } return(RedirectToAction("DetailsFormation", "Formation", new { nomSeo = comment.NomSeo })); }
public Avis SelectById(int id) { DataRow rowAvis = this.thedbal.SelectById("Avis", id); Avis myAvis = this.theDaoAvis.SelectById((int)rowAvis["idClient"]); return(new Avis((int)rowAvis["id"], (Client)rowAvis["idClient"], (int)rowAvis["note"], (string)rowAvis["commentaire"], (Theme)rowAvis["idTheme"])); }
public ActionResult DeleteConfirmed(int id) { Avis avis = db.Avis.Find(id); db.Avis.Remove(avis); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult MesAvisHome(decimal id) { Page page = db.Page.Where(p => p.Ins_id == id && p.archived == 1).FirstOrDefault(); if (page != null) { Inscrire inscrire = db.Inscrire.Where(p => p.id == page.Ins_id && p.archived == 1).FirstOrDefault(); ViewBag.inscrire = inscrire; List <Avis> listAvis = db.Avis.Where(p => p.Pag_id == page.id && p.archived == 1 && p.status == 1).OrderByDescending(p => p.created).ToList(); listAvis = listAvis.Take(15).ToList(); List <Avis> newListAvis = new List <Avis>(); foreach (Avis item in listAvis) { Avis newAvis = new Avis(); newAvis = item; Inscrire insc = db.Inscrire.Where(p => p.id == item.iduser).FirstOrDefault(); if (insc != null) { newAvis.Pseudo = insc.login; newAvis.Profil = insc.profil; } newListAvis.Add(newAvis); } ViewBag.newListAvis = newListAvis; ViewBag.page = page; if (TempData["myData"] != null) { String errsms = TempData["myData"].ToString(); if (errsms.Equals("1")) { TempData["result_code"] = 1; TempData["myData"] = null; TempData.Keep(); } else { TempData["result_code"] = -1; TempData["message"] = "Echec de l'opération veuillez réessayer."; TempData["myData"] = null; TempData.Keep(); } } return(View()); } else { return(HttpNotFound()); } ViewBag.page = page; return(View()); }
public Avis SelectById(int id) { DataRow rowAvis = this.mydbal.SelectById("Avis", id); Client myCLient = this.theDaoCLient.SelectById((int)rowAvis["id"]); Theme myTheme = this.theDaoTheme.SelectById((int)rowAvis["id"]); Avis myAvis = this.theDaoAvis.SelectById((int)rowAvis["idClient"]); return(new Avis((int)rowAvis["id"], myCLient, (int)rowAvis["note"], (string)rowAvis["commentaire"], myTheme)); }
public ActionResult Edit([Bind(Include = "Id,Nom,Description,Note,IdFormation,DateAvis,UserId")] Avis avis) { if (ModelState.IsValid) { db.Entry(avis).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.IdFormation = new SelectList(db.Formation, "Id", "Nom", avis.IdFormation); return(View(avis)); }
public void Insert(Avis theAvis, Client theClient, Theme theTheme) { string query = "Avis(id, idClient, note, commentaire, idTheme) VALUES (" + theAvis.Id + "," + theClient.Id + "," + theAvis.Note + "," + theAvis.Commentaire + "," + theTheme.Id + "')"; this.mydbal.Insert(query); }
public void Update(Avis myAvis) { string query = "Avis SET id = " + myAvis.Id + ", idClient = " + myAvis.IdClient.Id + ", note =" + myAvis.Note + ", commentaire = '" + myAvis.Commentaire.Replace("'", "''") + "', idTheme = " + myAvis.IdTheme.id + "where id = " + myAvis.Id; this.thedbal.Update(query); }
public ActionResult Create([Bind(Include = "Id,Nom,Description,Note,IdFormation,DateAvis,UserId")] Avis avis) { if (ModelState.IsValid) { db.Avis.Add(avis); db.SaveChanges(); return(RedirectToAction("details", "formation", new { id = avis.IdFormation })); } ViewBag.IdFormation = new SelectList(db.Formation, "Id", "Nom", avis.IdFormation); return(View(avis)); }
public void TestEquals() { Avis a1 = new Avis("Kevindu38", 5, "salut c'est michou", new DateTime(21 / 12 / 2012)); Avis a2 = new Avis("Kevindu39", 5, "salut c'est Jean", new DateTime(21 / 12 / 2010)); Avis a3 = new Avis("Kevindu38", 5, "salut c'est michou", new DateTime(21 / 12 / 2012)); // a1 et a3 identiques Assert.AreEqual(a1, a3); // a1 et a2 différents (pseudos) Assert.AreNotEqual(a1, a2); }
// Ajouter votre avis et note à votre film préféré (ou détesté). public static void AddAvis() { Avis avis = new Avis(); avis.Film = 3; avis.Utilisateur = 642; avis.Avis1 = "infame"; avis.Note = 0; ctx.Avis.Add(avis); ctx.SaveChanges(); }
public IActionResult Update([FromBody] Avis avis) { int success = _avRepo.Update(avis); if (success == 0) { return(Ok()); } else { return(NotFound()); } }
// GET: Avis/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Avis avis = db.Avis.Find(id); if (avis == null) { return(HttpNotFound()); } return(View(avis)); }
/// <summary> /// Méthode bouton Click. Permet d'ajouter un commentaire à la base donnée. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button_Click(object sender, RoutedEventArgs e) { try { Avis avis = new Avis(Manager.UtilisateursEnCours, Manager.ProduitsSelectionne, Convert.ToInt32(Slider.Value), TextBoxComment.Text); Manager.Ajouter(avis); new FenetrePopUp("Le commentaire à bien été ajouté", "OK!"); Close(); } catch (Exception ex) { new FenetrePopUp(ex.Message, "OK!"); } }
public static List <Avis> ChargerAvis(MediaManager m) { List <Avis> l = new List <Avis>(); Avis a1 = new Avis(2, new Utilisateur("User1"), m.GetRandom()); Avis a2 = new Avis(1, new Utilisateur("User1"), m.GetRandom()); Avis a3 = new Avis(4, new Utilisateur("User1"), m.GetRandom()); Avis a4 = new Avis(1.5, new Utilisateur("User2"), m.GetRandom()); Avis a5 = new Avis(2, new Utilisateur("User3"), m.GetRandom()); Avis a6 = new Avis(3, "Commentaire", new Utilisateur("User3"), m.GetRandom()); Avis a7 = new Avis(4.5, "Commentaire", new Utilisateur("User4"), m.GetRandom()); Avis a8 = new Avis(2.5, "Commentaire", new Utilisateur("User5"), m.GetRandom()); return(l); }
// GET: Avis/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Avis avis = db.Avis.Find(id); if (avis == null) { return(HttpNotFound()); } ViewBag.IdFormation = new SelectList(db.Formation, "Id", "Nom", avis.IdFormation); return(View(avis)); }
public async Task <IActionResult> Create([Bind("ID,Texte,UserID,RecetteID")] Avis avis) { if (ModelState.IsValid) { _context.Add(avis); await _context.SaveChangesAsync(); DisplayMessage("Avis créé", Class.TypeMessage.SUCCESS); return(RedirectToAction(nameof(Index))); } ViewData["RecetteID"] = new SelectList(_context.Recette, "ID", "ID", avis.RecetteID); ViewData["UserID"] = new SelectList(_context.User, "Id", "Id", avis.UserID); DisplayMessage("Avis non valide", Class.TypeMessage.DANGER); return(View(avis)); }
//public ActionResult SaveComment(string commentaire, string nom, string note, string nomSeo) public ActionResult SaveComment(SaveCommentViewModel comment) { using (var context = new AvisEntities()) { var formationEntity = context.Formation.FirstOrDefault(f => f.NomSeo == comment.nomSeo); if (formationEntity == null) { return(RedirectToAction("Acceuil", "Home")); } Avis nouvelAvis = new Avis(); nouvelAvis.DateAvis = DateTime.Now; nouvelAvis.Description = comment.commentaire; nouvelAvis.UserId = User.Identity.GetUserId(); var userId = User.Identity.GetUserId(); var mgerUnicite = new UniqueAvisVerification(); if (!mgerUnicite.EstAuthoriseACommenter(userId, formationEntity.Id)) { TempData["Message"] = "Désolé, vous ne pouvez poster qu'un seul avis par formation"; return(RedirectToAction("DetailsFormation", "Formation", new { nomSeo = comment.nomSeo })); } var mger = new PersonneManager(); nouvelAvis.Nom = mger.GetNomFromUserId(userId); double dNote = 0; if (!double.TryParse(comment.note, NumberStyles.Any, CultureInfo.InvariantCulture, out dNote)) { throw new Exception("impossible de parser la note " + comment.note); } nouvelAvis.Note = dNote; nouvelAvis.IdFormation = formationEntity.Id; context.Avis.Add(nouvelAvis); context.SaveChanges(); } return(RedirectToAction("DetailsFormation", "Formation", new { nomSeo = comment.nomSeo })); }
public ActionResult Validate(int id, bool validate) { Avis avis = _avisRepository.GetById(id); if (validate) { avis.Valide = true; avis.Moderateur = User.Identity.Name; _avisRepository.Update(avis); } else { _avisRepository.Delete(avis); } return(RedirectToAction("AttenteModeration")); }
public ActionResult Create(AvisViewModel avisViewModel) { try { Avis avis = new Avis { IdClient = avisViewModel.IdClient, IdProduit = avisViewModel.IdProduit, Note = avisViewModel.Note, Date = DateTime.Now, Contenu = avisViewModel.Contenu }; _avisRepository.Create(avis); return(RedirectToAction("Index", "Tirelires")); } catch { return(View()); } }
public static void Exo3_CreateAvis() { var ctx = new FilmsDBContext(); Avis avis = new Avis { Note = new Decimal(0.954231), Film = 37, Utilisateur = 1, Avis1 = "Film génial !" }; ctx.Avis.Add(avis); int nbChanges = ctx.SaveChanges(); Console.WriteLine("Avis créé : " + avis.ToString()); Console.ReadKey(); }
public static void Exo3Q4() { var ctx = new FilmsDBContext(); var film = ctx.Film.Include(a => a.Avis).Where(f => f.Nom.ToUpper() == "PULP FICTION").FirstOrDefault(); var user = ctx.Utilisateur.Where(u => u.Login == "Fynn").FirstOrDefault(); var avis = new Avis() { Avis1 = "Meiller film de tout les temps", Note = 100, FilmNavigation = film, UtilisateurNavigation = user }; ctx.Avis.Add(avis); ctx.SaveChanges(); }
//en commentaire le insertFromCSV public void InsertFromCSV(string filename) { using (var reader = new StreamReader(filename)) using (var csv = new CsvReader(reader, CultureInfo.InvariantCulture)) { csv.Configuration.Delimiter = ";"; csv.Configuration.PrepareHeaderForMatch = (string header, int index) => header.ToLower(); var record = new Avis(); var records = csv.EnumerateRecords(record); foreach (Avis r in records) { Console.WriteLine(r.Id + "---" + r.Note); //this.Insert(); } } }
/// <summary> /// Genere une liste d'avis concernant UN Hebergement /// </summary> /// <returns>Retourne une Liste d'Avis Concernant un hebergement</returns> public List <Avis> GetAvisHebergement(int IdHebergement) { List <Avis> ListeAvis = null; try { // requete + parametres à transmettre. string sql = "sp_GetAvisHebergement"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); sqlParameters.Add((new SqlParameter("@IdHebergement", IdHebergement))); //Execution de GetDataReader Erité de DataAccess base.GetDataReader(sql, sqlParameters); //Verification de recuperation de données ListeAvis = new List <Avis>(); if (base.sqlDataReader.HasRows) { while (base.sqlDataReader.Read()) { Avis avis = new Avis(); avis.Date = Convert.ToDateTime(base.sqlDataReader["Date"]); avis.Commentaire = Convert.ToString(base.sqlDataReader["Commentaire"]); avis.Note = Convert.ToInt32(base.sqlDataReader["Note"]); avis.Statut = Convert.ToBoolean(base.sqlDataReader["Statut"]); avis.IdClient = Convert.ToInt32(base.sqlDataReader["IdClient"]); DaoClient daoClient = new DaoClient(); avis.Client = daoClient.GetUtilisateurId(Convert.ToInt32(base.sqlDataReader["IdClient"])); avis.IdHebergement = Convert.ToInt32(base.sqlDataReader["IdHebergement"]); DaoHebergement daoHebergement = new DaoHebergement(); avis.Hebergement = daoHebergement.GetHebergement(Convert.ToInt32(base.sqlDataReader["IdHebergement"])); ListeAvis.Add(avis); } } } catch (Exception ex) { throw ex; } return(ListeAvis); }