public ActionResult Create([Bind(Include = "id,titre,description,Retards_Tags,pj")] Retard retard) { if (ModelState.IsValid) { retard.file = Request["fileEnvoie"]; retard.eleve = EleveRequest.GetEleveById(Int32.Parse(User.Identity.Name)); RetardRequest.Create(retard); retard = RetardRequest.getLastRetard(retard); Retards_Tags rt = new Retards_Tags { Id_Retard = retard.id, Id_Tags = Int32.Parse(Request["Retards_Tags"]) }; Tags_RetardRequest.Create(rt); return(RedirectToAction("Index", "Home")); } ViewBag.Retards_Tags = new SelectList(TagsRequest.GetTags(), "id", "libelle"); //ViewBag.Eleve = new SelectList(EleveRequest.GetEleves(), "id", "pseudo"); return(View()); }
/// <summary> /// Méthode permettant la création d'une classe. /// </summary> /// <param name="classe">Classe que l'on souhaite créer dans la base.</param> public static void Create(Retards_Tags tagRetard) { string query = "INSERT INTO tags_retard (id, idRetard, idTags) VALUES (null, @idRetard, @idTags)"; // Open connection databaseConnexion connection = new databaseConnexion(); if (connection.OpenConnection() == true) { // Create Command using (MySqlCommand cmd = new MySqlCommand(query, connection.GetConnection())) { // shield sql injection cmd.Parameters.AddWithValue("@idRetard", tagRetard.Id_Retard); cmd.Parameters.AddWithValue("@idTags", tagRetard.Id_Tags); // close Connection int result = cmd.ExecuteNonQuery(); connection.CloseConnection(); } } }