private void button1_Click(object sender, EventArgs e) { demande uneDemande = new demande(int.Parse(textBoxTicket.Text), textBoxMateriel.Text, textBoxObjet.Text, int.Parse(textBoxUrgence.Text), dateTimePicker1.Value); // Instanciation pour intéragir avec la base de données BD.ajouterDemande(uneDemande); }
public static void ajouterDemande(demande uneDemande) { //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 demande(ticket, materield, objetd, urgenced, etatd, dated) VALUES(@ticket, @materield, @objetd, @urgenced, 'déclaré', @dated)"; cmd.Parameters.AddWithValue("@ticket", uneDemande.Ticket); cmd.Parameters.AddWithValue("@materield", uneDemande.Materield); cmd.Parameters.AddWithValue("@objetd", uneDemande.Objetd); cmd.Parameters.AddWithValue("@urgenced", Convert.ToDouble(uneDemande.Urgenced)); cmd.Parameters.AddWithValue("@dated", Convert.ToDateTime(uneDemande.Dated)); cmd.ExecuteNonQuery(); MessageBox.Show("Enregistré dans la base !", "Réussite", MessageBoxButtons.OK); } catch (SqlException exp) { MessageBox.Show(exp.Message); } finally { conn.Close(); } }
public static List <demande> selectDemande() { List <demande> lesDemandes = new List <demande>(); 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 ticket, materield, objetd, urgenced, etatd, technicien, dated, travail FROM demande"; MySqlDataReader datareader = cmd.ExecuteReader(); while (datareader.Read()) { demande uneDemande = new demande(Convert.ToInt32(datareader["ticket"]), Convert.ToString(datareader["materield"]), Convert.ToString(datareader["objetd"]), Convert.ToInt32(datareader["urgenced"]), Convert.ToDateTime(datareader["dated"])); lesDemandes.Add(uneDemande); } conn.Close(); return(lesDemandes); }