Exemplo n.º 1
0
        public static void DeleteMonthValues(string _month, string _year, string _day)
        {
            string _constr = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationDb"].ToString();

            DAL.DAL _dal = new DAL.DAL(_constr, DAL.DAL.Moteurs.SQLSERVER.ToString());
            if (_dal.IsConnexionFermee())
            {
                //Ouverture de la connection
                _dal.OuvrirConnexion();
            }

            string[] _param = new string[3];

            _param[0] = "@MOIS" + ";" + SqlDbType.NVarChar + ";" + _month.ToString();
            _param[1] = "@ANNEE" + ";" + SqlDbType.NVarChar + ";" + _year.ToString();
            _param[2] = "@JOUR" + ";" + SqlDbType.NVarChar + ";" + _day.ToString();

            _dal.ExecuteQueryNoResult("DeleteDayMonthValues", CommandType.StoredProcedure, _param);
            _dal.FermeConnexion();
        }