public static void ajouterMateriel(materiel unMateriel)
{
//Connexion
String connString = "Server = 127.0.0.1; Database = gsb_medic; Uid = dev; Password = Az123@; SslMode = none;";
MySqlConnection conn = new MySqlConnection(connString);
conn.Open();
try
{
// Requete SQL
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO materiel(idM, processeur, disque, memoire, garantie, ticket) VALUES(@idM, @processeur, @disque, @memoire, @garantie, @ticket)";
cmd.Parameters.AddWithValue("@idM", unMateriel.IdM);
cmd.Parameters.AddWithValue("@processeur", unMateriel.Processeur);
cmd.Parameters.AddWithValue("@disque", unMateriel.Disque);
cmd.Parameters.AddWithValue("@memoire", unMateriel.Memoire);
cmd.Parameters.AddWithValue("@garantie", unMateriel.Garantie);
cmd.Parameters.AddWithValue("@ticket", unMateriel.Ticket);
cmd.ExecuteNonQuery();
MessageBox.Show("Enregistré dans la base !", "Réussite", MessageBoxButtons.OK);
}
catch (SqlException exp)
{
MessageBox.Show(exp.Message);
}
finally
{
conn.Close();
}
}
private void button1_Click(object sender, EventArgs e)
{
// Instanciation pour intéragir avec la base de données
materiel unMateriel = new materiel(idTextBox1.Text, processeurTextBox2.Text, disqueTextBox3.Text, memoireTextBox4.Text, garantieTextBox5.Text, int.Parse(ticketTextBox6.Text));
BD.ajouterMateriel(unMateriel);
}
public static List <materiel> selectMateriel()
{
List <materiel> LesMateriels = new List <materiel>();
string connString = "Server = 127.0.0.1; Database = gsb_medic; Uid = dev; password = Az123@; SslMode=none;";
MySqlConnection conn = new MySqlConnection(connString);
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT idM, processeur, disque, memoire, garantie, ticket FROM materiel";
MySqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
materiel unMateriel = new materiel(Convert.ToString(dataReader["idM"]), Convert.ToString(dataReader["processeur"]), Convert.ToString(dataReader["disque"]), Convert.ToString(dataReader["memoire"]), Convert.ToString(dataReader["garantie"]), Convert.ToInt16(dataReader["ticket"]));
LesMateriels.Add(unMateriel);
}
conn.Close();
return(LesMateriels);
}