//[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);
}
