public static List <ModelDescription> GetRepairsByYear(DateTime date)
{
List <ModelDescription> retlist = new List <ModelDescription>();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = _ReadConnectionString;
try
{
conn.Open();
SqlCommand comm = new SqlCommand("sprocRepairsInAYear", conn);
comm.CommandType = System.Data.CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@Date", date);
SqlDataReader dr = comm.ExecuteReader();
while (dr.Read())
{
ModelDescription md = new ModelDescription();
md.Fill(dr);
retlist.Add(md);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
finally
{
conn.Close();
}
return(retlist);
}
