//Retourne un Delivery_Time en fonction de son ID
public Delivery_Time GetDelivery_Time(int id)
{
Delivery_Time delivery_time = null;
try
{
using (SqlConnection cn = new SqlConnection(connectionString))
{
string query = "Select * from Delivery_Time WHERE Id = @id";
SqlCommand cmd = new SqlCommand(query, cn);
cmd.Parameters.AddWithValue("@id", id);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
delivery_time = new Delivery_Time();
delivery_time.IdDelivery_Time = (int)dr["Id"];
delivery_time.Delivery_time = (string)dr["Delivery_Time"];
}
}
}
}
catch (Exception e)
{
throw e;
}
return(delivery_time);
}
//Retourne une liste de tous les Delivery_Time
public List <Delivery_Time> GetAllDelivery_Time()
{
List <Delivery_Time> results = null;
try
{
using (SqlConnection cn = new SqlConnection(connectionString))
{
string query = "SELECT * FROM Delivery_Time WHERE Delivery_Time.Delivery_Time > CONVERT(VARCHAR(5), GETDATE(), 108);";
SqlCommand cmd = new SqlCommand(query, cn);
cn.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (results == null)
{
results = new List <Delivery_Time>();
}
Delivery_Time delivery_time = new Delivery_Time();
delivery_time.IdDelivery_Time = (int)dr["Id"];
delivery_time.Delivery_time = (string)dr["Delivery_Time"];
results.Add(delivery_time);
}
}
}
}
catch (Exception e)
{
throw e;
}
return(results);
}
