public Demandes_recues selectDonneesFromIdDemandeRecue(string p_id_demande_recue) { MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM demandes_recues WHERE id_message='" + p_id_demande_recue + "'"; MySqlDataReader reader = cmd.ExecuteReader(); Demandes_recues demande_recue = null; if (reader.Read()) { demande_recue = new Demandes_recues(); demande_recue.id_message = Convert.ToString(reader["id_message"]); demande_recue.texte_message = Convert.ToString(reader["texte_message"]); demande_recue.date_message = Convert.ToDateTime(reader["date_message"]); demande_recue.xml = Convert.ToString(reader["xml"]); demande_recue.id_ps_exp = Convert.ToString(reader["id_ps_exp"]); demande_recue.id_ps_dest = Convert.ToString(reader["id_ps_dest"]); demande_recue.id_demande_recue = Convert.ToString(reader["id_demande_recue"]); } connection.Close(); return(demande_recue); }
public List <Demandes_recues> selectAll() { List <Demandes_recues> lst_demandesrecues = new List <Demandes_recues>(); MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT * FROM demandes_recues ORDER BY id_message"; MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Demandes_recues demande_recue = new Demandes_recues(); demande_recue.id_message = Convert.ToString(reader["id_message"]); demande_recue.texte_message = Convert.ToString(reader["texte_message"]); demande_recue.date_message = Convert.ToDateTime(reader["date_message"]); demande_recue.xml = Convert.ToString(reader["xml"]); demande_recue.id_ps_exp = Convert.ToString(reader["id_ps_exp"]); demande_recue.id_ps_dest = Convert.ToString(reader["id_ps_dest"]); demande_recue.id_demande_recue = Convert.ToString(reader["id_demande_recue"]); lst_demandesrecues.Add(demande_recue); } connection.Close(); return(lst_demandesrecues); }
public string deleteDemandeRecue(Demandes_recues p_demande_recue) { MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "DELETE FROM demandes_recues WHERE id_message='" + p_demande_recue.id_message + "'"; MySqlDataReader reader = cmd.ExecuteReader(); int rows = cmd.ExecuteNonQuery(); connection.Close(); return(rows + " ligne(s) supprimée(s)"); }
public string insertDemandeRecue(Demandes_recues p_demande_recue) { MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "INSERT INTO demandes_recues(id_message,texte_message,date_message,xml,id_ps_exp,id_ps_dest,id_demande_recue) VALUES('" + p_demande_recue.id_message + "','" + p_demande_recue.texte_message + "','" + p_demande_recue.date_message + "','" + p_demande_recue.xml + "','" + p_demande_recue.id_ps_exp + "','" + p_demande_recue.id_ps_dest + "','" + p_demande_recue.id_demande_recue + "')"; MySqlDataReader reader = cmd.ExecuteReader(); int rows = cmd.ExecuteNonQuery(); connection.Close(); return(rows + " ligne(s) insérée(s)"); }
public string updateDemandeRecue(Demandes_recues p_demande_recue) { return(null); }
public string deleteDemandeRecue(Demandes_recues p_demande_recue) { return(demande_recueado.deleteDemandeRecue(p_demande_recue)); }
public string insertDemandeRecue(Demandes_recues p_demande_recue) { return(demande_recueado.insertDemandeRecue(p_demande_recue)); }