public static Alerte_Ech Get(Int32 Identifiant)
{
Alerte_Ech alerte_Ech = new Alerte_Ech();
//Connection
SqlConnection connection = DataBase.Connection();
//Requete
String requete = select+" WHERE Identifiant = @Identifiant;";
//Commande
SqlCommand commande = new SqlCommand(requete, connection);
//Parametres
commande.Parameters.AddWithValue("Identifiant", Identifiant);
//Execution
try
{
connection.Open();
SqlDataReader dataReader = commande.ExecuteReader();
while (dataReader.Read())
{
alerte_Ech.Identifiant = dataReader.GetInt32(0);
alerte_Ech.Message = dataReader.GetString(1);
alerte_Ech.Date = dataReader.GetDateTime(2);
alerte_Ech.ID_Echantillon = dataReader.GetInt32(3);
}
dataReader.Close();
}
catch (Exception)
{
alerte_Ech = null;
}
finally
{
connection.Close();
}
return alerte_Ech;
}
public static Boolean Insert(Alerte_Ech alerte_Ech)
{
//Connection
SqlConnection connection = DataBase.Connection();
//Requete
String requete = @"INSERT INTO Alerte_Ech (" + champs + ") VALUES (Message,Date,ID_Echantillon);";
//Commande
SqlCommand commande = new SqlCommand(requete, connection);
//Parametres
commande.Parameters.AddWithValue("Message", alerte_Ech.Message);
commande.Parameters.AddWithValue("Date", alerte_Ech.Date);
commande.Parameters.AddWithValue("ID_Echantillon", alerte_Ech.ID_Echantillon);
//Execution
try
{
connection.Open();
commande.ExecuteNonQuery();
return true;
}
catch (Exception)
{
return false;
}
finally
{
connection.Close();
}
}
public static Boolean Update(Alerte_Ech alerte_Ech)
{
//Connection
SqlConnection connection = DataBase.Connection();
//Requete
String requete = @"UPDATE Alerte_Ech
SET Message=@Message,Date=@Date,ID_Echantillon=@ID_Echantillon
WHERE Identifiant=@Identifiant ;";
//Commande
SqlCommand commande = new SqlCommand(requete, connection);
//Parametres
commande.Parameters.AddWithValue("Identifiant",alerte_Ech.Identifiant);
commande.Parameters.AddWithValue("Message", alerte_Ech.Message);
commande.Parameters.AddWithValue("Date", alerte_Ech.Date);
commande.Parameters.AddWithValue("ID_Echantillon", alerte_Ech.ID_Echantillon);
//Execution
try
{
connection.Open();
commande.ExecuteNonQuery();
return true;
}
catch (Exception)
{
return false;
}
finally
{
connection.Close();
}
}
public static List<Alerte_Ech> List()
{
List<Alerte_Ech> listeAlerte_Ech = new List<Alerte_Ech>();
//Connection
SqlConnection connection = DataBase.Connection();
//Requete
String requete = select+";";
//Commande
SqlCommand commande = new SqlCommand(requete, connection);
//Parametres
//Execution
try
{
connection.Open();
SqlDataReader dataReader = commande.ExecuteReader();
while (dataReader.Read())
{
Alerte_Ech alerte_Ech = new Alerte_Ech();
alerte_Ech.Identifiant = dataReader.GetInt32(0);
alerte_Ech.Message = dataReader.GetString(1);
alerte_Ech.Date = dataReader.GetDateTime(2);
alerte_Ech.ID_Echantillon = dataReader.GetInt32(3);
listeAlerte_Ech.Add(alerte_Ech);
}
dataReader.Close();
}
catch (Exception)
{
listeAlerte_Ech = null;
}
finally
{
connection.Close();
}
return listeAlerte_Ech;
}