예제 #1
0
        public static List <Panneaux> GetPanneaux()
        {
            const string getPannauxQuery  = "select cc_cont, cc_elem, cc_dessin, cc_d_deb from dbo.CONTDET";
            var          listeDesPanneaux = new List <Panneaux>();

            try
            {
                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    conn.Open();
                    if (conn.State != ConnectionState.Closed)
                    {
                        using (SqlCommand cmd = conn.CreateCommand())
                        {
                            cmd.CommandText = getPannauxQuery;
                            using (SqlDataReader reader = cmd.ExecuteReader())
                            {
                                while (reader.Read())
                                {
                                    var pannel = new Panneaux();
                                    pannel.Contrat     = reader.GetString(0);
                                    pannel.Element     = reader.GetString(1);
                                    pannel.Dessin      = reader.GetString(2);
                                    pannel.Fabrication = reader.GetString(3);
                                    listeDesPanneaux.Add(pannel);
                                }
                            }
                        }
                    }
                }
                return(listeDesPanneaux);
            }
            catch (Exception eSql)
            {
                Debug.WriteLine("Exception: " + eSql.Message);
            }
            return(null);
        }
예제 #2
0
 public static void Delete(Panneaux panneaux)
 {
     Debug.WriteLine("J'imagine que le delete a la bd est ici.");
 }
예제 #3
0
 public static void Write(Panneaux panneaux)
 {
     Debug.WriteLine("J'imagine que l'ecriture *et l<update* a la bd est ici.");
 }