Beispiel #1
0
        public static Pos_AvAr Get(Int32 Identifiant)
        {
            Pos_AvAr pos_AvAr = new Pos_AvAr();

            //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())
                {
                    pos_AvAr.Identifiant = dataReader.GetInt32(0);
                    pos_AvAr.Position = dataReader.GetString(1);
                }

                dataReader.Close();

            }
            catch (Exception)
            {
                pos_AvAr = null;
            }
            finally
            {
                connection.Close();
            }
            return pos_AvAr;
        }
Beispiel #2
0
        public static Boolean Insert(Pos_AvAr pos_AvAr)
        {
            //Connection
            SqlConnection connection = DataBase.Connection();

            //Requete
            String requete = @"INSERT INTO Pos_AvAr ("+champs+") VALUES (@Position);";

            //Commande
            SqlCommand commande = new SqlCommand(requete, connection);

            //Parametres
            commande.Parameters.AddWithValue("Position", pos_AvAr.Position);
            //Execution
            try
            {
                connection.Open();
                commande.ExecuteNonQuery();
                return true;
            }
            catch (Exception)
            {
                return false;
            }
            finally
            {
                connection.Close();
            }
        }
Beispiel #3
0
        public static Boolean Update(Pos_AvAr pos_AvAr)
        {
            //Connection
            SqlConnection connection = DataBase.Connection();

            //Requete
            String requete = @"UPDATE Pos_AvAr
                               SET Position=@Position
                               WHERE Identifiant=@Identifiant ;";

            //Commande
            SqlCommand commande = new SqlCommand(requete, connection);

            //Parametres
            commande.Parameters.AddWithValue("Identifiant",pos_AvAr.Identifiant);
            commande.Parameters.AddWithValue("Position",pos_AvAr.Position );

            //Execution
            try
            {
                connection.Open();
                commande.ExecuteNonQuery();
                return true;
            }
            catch (Exception)
            {
                return false;
            }
            finally
            {
                connection.Close();
            }
        }
Beispiel #4
0
        public static List<Pos_AvAr> List()
        {
            List<Pos_AvAr> listePos_AvAr = new List<Pos_AvAr>();

            //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())
                {
                    Pos_AvAr pos_AvAr = new Pos_AvAr();
                    pos_AvAr.Identifiant = dataReader.GetInt32(0);
                    pos_AvAr.Position = dataReader.GetString(1);
                    listePos_AvAr.Add(pos_AvAr);
                }

                dataReader.Close();

            }
            catch (Exception)
            {
                listePos_AvAr = null;
            }
            finally
            {
                connection.Close();
            }

            return listePos_AvAr;
        }