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 Delete([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))
{
dbContext.Votes.Remove(vote);
}
}
public IEnumerable <Ticket> GetTopMonth()
{
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))
{
return(dbContext.Tickets.FromSqlRaw("Select * FROM Tickets WHERE DATEDIFF(NOW(), date) <= 30"));
}
}
public IEnumerable <Ticket> GetAll()
{
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))
{
return(dbContext.Tickets);
}
}
public IEnumerable <Ticket> GetTicketsByTag([FromRoute] string libelle)
{
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))
{
return(dbContext.Tickets.FromSqlRaw("SELECT * FROM Tickets t JOIN TicketTags tt ON t.Id = tt.TicketId WHERE tt.libelle = ?", libelle));
}
}
public int Get([FromQuery] int ticketId)
{
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))
{
IEnumerable <Vote> votes = dbContext.Votes.Where(v => v.ticketId == ticketId);
return(votes.Count());
}
}
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();
}
}
