public static List <incident> afficheIncidCollection()
{
incident unIncident;
List <incident> lesIncidents = new List <incident>();
MySqlConnection conn = new MySqlConnection(connexion);
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT objet_incid, niv_urgence_incid, date_incid, etat_incid, type_charge_incid, id_mat, id_tech, id_user FROM incident";
MySqlDataReader uneLigne = cmd.ExecuteReader();
while (uneLigne.Read())
{
unIncident = new incident(Convert.ToString(uneLigne["objet_incid"]), Convert.ToInt32(uneLigne["niv_urgence_incid"]), Convert.ToString(uneLigne["date_incid"]), Convert.ToInt32(uneLigne["etat_incid"]), Convert.ToString(uneLigne["type_charge_incid"]), Convert.ToInt32(uneLigne["id_mat"]), Convert.ToInt32(uneLigne["id_tech"]), Convert.ToInt32(uneLigne["id_user"]));
lesIncidents.Add(unIncident);
}
conn.Close();
return(lesIncidents);
}
//Ajoute incident
public static void ajouteIncid(incident unIncid)
{
MySqlConnection conn = new MySqlConnection(connexion);
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO incident(objet_incid,niv_urgence_incid,date_incid,etat_incid,type_charge_incid,id_mat,id_tech,id_user)" +
"VALUES(@objet, @nivUrgence, @date, @etat, @priseCharge, @idMat, @idTech,@idUser)";
cmd.Parameters.AddWithValue("@objet", unIncid.Objet);
cmd.Parameters.AddWithValue("@nivUrgence", unIncid.NivUrgence);
cmd.Parameters.AddWithValue("@date", unIncid.DateIncid);
cmd.Parameters.AddWithValue("@etat", unIncid.EtatIncid);
cmd.Parameters.AddWithValue("@priseCharge", unIncid.TypePriseCharge);
cmd.Parameters.AddWithValue("@idMat", unIncid.IdMat);
cmd.Parameters.AddWithValue("@idTech", unIncid.IdTech);
cmd.Parameters.AddWithValue("@idUser", unIncid.IdUser);
cmd.ExecuteNonQuery();
conn.Close();
}
private void btnDeclarer_Click(object sender, EventArgs e)
{
incident unIncid = new incident(TBprobleme.Text, Convert.ToInt32(numUrgence.Value), Convert.ToString(DateTime.Now), Convert.ToInt32(numEtat.Value), "Reçu", Convert.ToInt32(TBposte.Text), 0, id);
BD.ajouteIncid(unIncid);
}
