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();
}
}
}
