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