public Demandes_envoyees selectDonneesFromIdDemandeEnvoyee(string p_id_demande_envoyee)
{
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM demandes_envoyees WHERE id_message='" + p_id_demande_envoyee + "'";
MySqlDataReader reader = cmd.ExecuteReader();
Demandes_envoyees demande_envoyee = null;
if (reader.Read())
{
demande_envoyee = new Demandes_envoyees();
demande_envoyee.id_message = Convert.ToString(reader["id_message"]);
demande_envoyee.texte_message = Convert.ToString(reader["texte_message"]);
demande_envoyee.date_message = Convert.ToDateTime(reader["date_message"]);
demande_envoyee.xml = Convert.ToString(reader["xml"]);
demande_envoyee.id_ps_exp = Convert.ToString(reader["id_ps_exp"]);
demande_envoyee.id_ps_dest = Convert.ToString(reader["id_ps_dest"]);
demande_envoyee.id_demande = Convert.ToString(reader["id_demande"]);
}
connection.Close();
return(demande_envoyee);
}
public List <Demandes_envoyees> selectAll()
{
List <Demandes_envoyees> lst_demandesenvoyees = new List <Demandes_envoyees>();
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "SELECT * FROM demandes_envoyees ORDER BY id_message";
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Demandes_envoyees demande_envoyee = new Demandes_envoyees();
demande_envoyee.id_message = Convert.ToString(reader["id_message"]);
demande_envoyee.texte_message = Convert.ToString(reader["texte_message"]);
demande_envoyee.date_message = Convert.ToDateTime(reader["date_message"]);
demande_envoyee.xml = Convert.ToString(reader["xml"]);
demande_envoyee.id_ps_exp = Convert.ToString(reader["id_ps_exp"]);
demande_envoyee.id_ps_dest = Convert.ToString(reader["id_ps_dest"]);
demande_envoyee.id_demande = Convert.ToString(reader["id_demande"]);
lst_demandesenvoyees.Add(demande_envoyee);
}
connection.Close();
return(lst_demandesenvoyees);
}
public string deleteDemandeEnvoyee(Demandes_envoyees p_demande_envoyee)
{
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText = "DELETE FROM demandes_envoyees WHERE id_message='" + p_demande_envoyee.id_message + "'";
MySqlDataReader reader = cmd.ExecuteReader();
int rows = cmd.ExecuteNonQuery();
connection.Close();
return(rows + " ligne(s) supprimée(s)");
}
public string insertDemandeEnvoyee(Demandes_envoyees p_demande_envoyee)
{
MySqlCommand cmd = connection.CreateCommand();
cmd.CommandText =
"INSERT INTO demandes_envoyees(id_message,texte_message,date_message,xml,id_ps_exp,id_ps_dest,id_demande) VALUES('" +
p_demande_envoyee.id_message + "','" + p_demande_envoyee.texte_message + "','" + p_demande_envoyee.date_message + "','" + p_demande_envoyee.xml + "','" +
p_demande_envoyee.id_ps_exp + "','" + p_demande_envoyee.id_ps_dest + "','" + p_demande_envoyee.id_demande + "')";
MySqlDataReader reader = cmd.ExecuteReader();
int rows = cmd.ExecuteNonQuery();
connection.Close();
return(rows + " ligne(s) insérée(s)");
}
public string updateDemandeEnvoyee(Demandes_envoyees p_demande_envoyee)
{
return(null);
}
public string deleteDemandeEnvoyee(Demandes_envoyees p_demande_envoyee)
{
return(demande_envoyeeado.deleteDemandeEnvoyee(p_demande_envoyee));
}
public string insertDemandeEnvoyee(Demandes_envoyees p_demande_envoyee)
{
return(demande_envoyeeado.insertDemandeEnvoyee(p_demande_envoyee));
}
