public void addTicket([FromForm] Utilisateur utilisateur, [FromForm] string titre, [FromForm] string urlphoto, [FromForm] string description, [FromForm] List <Tag> tags) { DbContextOptionsBuilder <ContexteBDD> optionsBuilder = new DbContextOptionsBuilder <ContexteBDD>(); var one = ConfigurationManager.ConnectionStrings; var random = ConfigurationManager.ConnectionStrings["DefaultConnection"]; string docstring = random.ConnectionString; optionsBuilder.UseMySql(docstring); using (Models.ContexteBDD dbContext = new Models.ContexteBDD(optionsBuilder.Options)) { Ticket dbTicket = new Ticket(); dbTicket.auteur = utilisateur; dbTicket.titre = titre; dbTicket.description = description; dbTicket.date = DateTime.Now; dbTicket.urlPhoto = urlphoto; dbContext.Tickets.Add(dbTicket); foreach (Tag tag in tags) { TicketTag ticketTag = new TicketTag(); ticketTag.tag = tag; ticketTag.libelle = tag.libelle; ticketTag.ticket = dbTicket; //cassable ? A revoir //ticketTag.TicketId = dbTicket.Id; tag.TicketTags.Add(ticketTag); dbTicket.TicketTags.Add(ticketTag); } dbContext.SaveChanges(); } }
public void Post([FromBody] Classe Classe) { DbContextOptionsBuilder <ContexteBDD> optionsBuilder = new DbContextOptionsBuilder <ContexteBDD>(); var one = ConfigurationManager.ConnectionStrings; var random = ConfigurationManager.ConnectionStrings["DefaultConnection"]; string docstring = random.ConnectionString; optionsBuilder.UseMySql(docstring); using (Models.ContexteBDD dbContext = new Models.ContexteBDD(optionsBuilder.Options)) { Classe dbClasse = new Classe(); dbClasse.libelle = Classe.libelle; dbContext.Classes.Add(dbClasse); dbContext.SaveChanges(); } }
public void Post([FromBody] Tag tag) { DbContextOptionsBuilder <ContexteBDD> optionsBuilder = new DbContextOptionsBuilder <ContexteBDD>(); var one = ConfigurationManager.ConnectionStrings; var random = ConfigurationManager.ConnectionStrings["DefaultConnection"]; string docstring = random.ConnectionString; optionsBuilder.UseMySql(docstring); using (Models.ContexteBDD dbContext = new Models.ContexteBDD(optionsBuilder.Options)) { Tag dbTag = new Tag(); dbTag.libelle = tag.libelle; dbContext.Tags.Add(dbTag); dbContext.SaveChanges(); } }
public void Post([FromBody] Vote Vote) { DbContextOptionsBuilder <ContexteBDD> optionsBuilder = new DbContextOptionsBuilder <ContexteBDD>(); var one = ConfigurationManager.ConnectionStrings; var random = ConfigurationManager.ConnectionStrings["DefaultConnection"]; string docstring = random.ConnectionString; optionsBuilder.UseMySql(docstring); using (Models.ContexteBDD dbContext = new Models.ContexteBDD(optionsBuilder.Options)) { Vote dbVote = new Vote(); dbVote.utilisateurId = Vote.utilisateurId; dbVote.ticketId = Vote.ticketId; dbContext.Votes.Add(dbVote); dbContext.SaveChanges(); } }
public void Post([FromForm] string pseudo, [FromForm] string mdp, [FromForm] string classe) { DbContextOptionsBuilder <ContexteBDD> optionsBuilder = new DbContextOptionsBuilder <ContexteBDD>(); var one = ConfigurationManager.ConnectionStrings; var random = ConfigurationManager.ConnectionStrings["DefaultConnection"]; string docstring = random.ConnectionString; optionsBuilder.UseMySql(docstring); using (Models.ContexteBDD dbContext = new Models.ContexteBDD(optionsBuilder.Options)) { Utilisateur dbUtilisateur = new Utilisateur(); dbUtilisateur.pseudo = pseudo; dbUtilisateur.mdp = mdp; dbUtilisateur.classe = dbContext.Classes.Where(c => c.libelle == classe).First(); dbContext.Utilisateurs.Add(dbUtilisateur); dbContext.SaveChanges(); } }