Пример #1
0
        //Enregistrement de la taxe due
        //=============================
        public void Enregistrer_Taxe_due(BaseImposable tx)
        {
            DBConnection con = new DBConnection(System.Web.HttpContext.Current.Server.MapPath("~\\bin\\connexion.xml"));

            con.Execute_Query("INSERT INTO taxe_due " +
                              "(" +
                              "nature, " +
                              "id, " +
                              "prov," +
                              "town_dist," +
                              "commune," +
                              "quarter_sect," +
                              "avenue_loc," +
                              "number," +
                              "tax_id," +
                              "rate," +
                              "id_user," +
                              "saving_date" +
                              ")" +
                              "VALUES(" +
                              "'" + tx.nature + "', " +
                              "'" + tx.id + "', " +
                              "'" + tx.prov.Replace("'", "''") + "', " +
                              "'" + tx.town_dist.Replace("'", "''") + "', " +
                              "'" + tx.commune.Replace("'", "''") + "', " +
                              "'" + tx.quarter_sect.Replace("'", "''") + "', " +
                              "'" + tx.avenue_loc.Replace("'", "''") + "', " +
                              "'" + tx.number + "', " +
                              "'" + tx.tax_id + "', " +
                              "" + tx.rate + "," +
                              "'" + tx.id_user + "', " +
                              "getDate() " +
                              ")"
                              );
        }
Пример #2
0
        /************************************
         * Enregistrement Feuille de Calcul
         * =================================*/
        public void EnregistrerFeuille_Calcul(BaseImposable feuille)
        {
            DBConnection con = new DBConnection(System.Web.HttpContext.Current.Server.MapPath("~\\bin\\connexion.xml"));

            con.Execute_Query("SET DATEFORMAT DMY INSERT INTO Feuille_Calcul " +
                              "(" +
                              "id_feuille, " +
                              "datef, " +
                              "userID " +
                              ")" +
                              "VALUES(" +
                              "'" + feuille.id_feuille + "', " +
                              "'" + feuille.datef + "', " +
                              "'" + feuille.id_user + "' " +
                              ")"
                              );
        }
Пример #3
0
        //Enregistrement de la taxe
        //=========================
        public void EnregistrerTaxe(BaseImposable tx)
        {
            DBConnection con = new DBConnection(System.Web.HttpContext.Current.Server.MapPath("~\\bin\\connexion.xml"));

            con.Execute_Query("INSERT INTO tax ( " +
                              "(" +
                              "tax_id, " +
                              "tax_name, " +
                              "generating_fact," +
                              "periodicity" +
                              ")" +
                              "VALUES(" +
                              "'" + tx.tax_id + "'," +
                              "'" + tx.tax_name.Replace("'", "''") + "'," +
                              "'" + tx.generating_fact.Replace("'", "''") + "'," +
                              "'" + tx.periodicity + "'" +
                              ")"
                              );
        }
Пример #4
0
        //ENREGISTREMENT IMPOSITION FEUILLE
        public void EnregistrementImpositionFeuille(BaseImposable bas)
        {
            DBConnection cnx = new DBConnection(System.Web.HttpContext.Current.Server.MapPath("~\\bin\\connexion.xml"));

            cnx.Execute_Query("Insert into Imposition_Feuille " +
                              "(nature, " +
                              "id, " +
                              "prov, " +
                              "town_dist, " +
                              "commune, " +
                              "quarter_sect, " +
                              "avenue_loc, " +
                              "number, " +
                              "tax_id, " +
                              "id_feuille, " +
                              "Montant, " +
                              "Monnaie, " +
                              "Observation " +
                              ") " +
                              "values " +
                              "('" + bas.nature + "', " +
                              "'" + bas.id + "', " +
                              "'" + bas.prov + "', " +
                              "'" + bas.town_dist + "', " +
                              "'" + bas.commune + "', " +
                              "'" + bas.quarter_sect + "', " +
                              "'" + bas.avenue_loc + "', " +
                              "'" + bas.number + "', " +
                              "'" + bas.tax_id + "', " +
                              "'" + bas.id_feuille + "', " +
                              "'" + bas.Montant + "', " +
                              "'" + bas.Monnaie + "', " +
                              "'" + bas.Observation + "' " +
                              ")  " +
                              "");
        }
Пример #5
0
        //Enregistrement de la base imposable
        //===================================
        public void EnregistrerActivite(BaseImposable act)
        {
            DBConnection con = new DBConnection(System.Web.HttpContext.Current.Server.MapPath("~\\bin\\connexion.xml"));

            con.Execute_Query(" SET DATEFORMAT DMY Exec EnregistrerBaseImposable  @nat='" + act.nature.Replace("'", "''") + "',@ass='" + act.id + "',@prov='" + act.prov.Replace("'", "''") + "',@vill='" + act.town_dist.Replace("'", "''") + "',@com='" + act.commune.Replace("'", "''") + "',@quart='" + act.quarter_sect.Replace("'", "''") + "',@aven='" + act.avenue_loc.Replace("'", "''") + "',@idinsp='" + act.inspector_id + "',@num='" + act.number + "',@mes=" + act.sizeAct + ",@unit='" + act.unity + "',@enseig='" + act.signboard + "',@datesav='" + DateTime.Now + "',@iduser='******',@datrec='" + act.datecensus + "'");
        }
Пример #6
0
        //Enregistrement de la nature base_imposable
        //==========================================
        public void EnregistrerNatureActivite(BaseImposable act)
        {
            DBConnection con = new DBConnection(System.Web.HttpContext.Current.Server.MapPath("~\\bin\\connexion.xml"));

            con.Execute_Query("INSERT INTO nature_base_imposable (nature,id_user,saving_date) values ('" + act.nature.Replace("'", "''") + "','" + act.id_user + "',getdate())");
        }