Ejemplo n.º 1
0
        /// <summary>
        /// Insertion_DEMCOUT
        /// </summary>
        /// <param name="row"></param>
        public void Insertion_DEMCOUT(List <CsTdemCout> rows)
        {
            cn              = new SqlConnection(ConnectionString);
            cmd             = new SqlCommand();
            cmd.Connection  = cn;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = EnumProcedureStockee.InsertDEMCOUT.Trim();
            cmd.Parameters.Clear();


            try
            {
                foreach (CsTdemCout row in rows)
                {
                    cmd.Parameters.Add("@CENTRE", SqlDbType.VarChar).Value   = row.CENTRE;
                    cmd.Parameters.Add("@PRODUIT", SqlDbType.VarChar).Value  = row.PRODUIT;
                    cmd.Parameters.Add("@TDEM", SqlDbType.VarChar).Value     = row.TDEM;
                    cmd.Parameters.Add("@COPER1", SqlDbType.VarChar).Value   = row.COPER1;
                    cmd.Parameters.Add("@OBLI1", SqlDbType.VarChar).Value    = row.OBLI1;
                    cmd.Parameters.Add("@AUTO1", SqlDbType.VarChar).Value    = row.AUTO1;
                    cmd.Parameters.Add("@MONTANT1", SqlDbType.Decimal).Value = row.MONTANT1;
                    cmd.Parameters.Add("@TAXE1", SqlDbType.VarChar).Value    = row.TAXE1;
                    cmd.Parameters.Add("@COPER2", SqlDbType.VarChar).Value   = row.COPER2;
                    cmd.Parameters.Add("@OBLI2", SqlDbType.VarChar).Value    = row.OBLI2;
                    cmd.Parameters.Add("@AUTO2", SqlDbType.VarChar).Value    = row.AUTO2;
                    cmd.Parameters.Add("@MONTANT2", SqlDbType.Decimal).Value = row.MONTANT2;
                    cmd.Parameters.Add("@TAXE2", SqlDbType.VarChar).Value    = row.TAXE2;
                    cmd.Parameters.Add("@COPER3", SqlDbType.VarChar).Value   = row.COPER3;
                    cmd.Parameters.Add("@OBLI3", SqlDbType.VarChar).Value    = row.OBLI3;
                    cmd.Parameters.Add("@AUTO3", SqlDbType.VarChar).Value    = row.AUTO3;
                    cmd.Parameters.Add("@MONTANT3", SqlDbType.Decimal).Value = row.MONTANT3;
                    cmd.Parameters.Add("@TAXE3", SqlDbType.VarChar).Value    = row.TAXE3;
                    cmd.Parameters.Add("@COPER4", SqlDbType.VarChar).Value   = row.COPER4;
                    cmd.Parameters.Add("@OBLI4", SqlDbType.VarChar).Value    = row.OBLI4;
                    cmd.Parameters.Add("@AUTO4", SqlDbType.VarChar).Value    = row.AUTO4;
                    cmd.Parameters.Add("@MONTANT4", SqlDbType.Decimal).Value = row.MONTANT4;
                    cmd.Parameters.Add("@TAXE4", SqlDbType.VarChar).Value    = row.TAXE4;
                    cmd.Parameters.Add("@COPER5", SqlDbType.VarChar).Value   = row.COPER5;
                    cmd.Parameters.Add("@OBLI5", SqlDbType.VarChar).Value    = row.OBLI5;
                    cmd.Parameters.Add("@AUTO5", SqlDbType.VarChar).Value    = row.AUTO5;
                    cmd.Parameters.Add("@MONTANT5", SqlDbType.Decimal).Value = row.MONTANT5;
                    cmd.Parameters.Add("@TAXE5", SqlDbType.VarChar).Value    = row.TAXE5;
                    cmd.Parameters.Add("@DMAJ", SqlDbType.DateTime).Value    = row.DMAJ;
                    cmd.Parameters.Add("@TRANS", SqlDbType.VarChar).Value    = row.TRANS;
                    DBBase.SetDBNullParametre(cmd.Parameters);

                    if (cn.State == ConnectionState.Closed)
                    {
                        cn.Open();
                    }
                    StartTransaction(cn);

                    cmd.ExecuteNonQuery();
                }
                CommitTransaction(cmd.Transaction);
            }
            catch (Exception ex)
            {
                RollBackTransaction(cmd.Transaction);
                throw new Exception(EnumProcedureStockee.InsertDEMCOUT + ":" + ex.Message);
            }
            finally
            {
                if (cn.State == ConnectionState.Open)
                {
                    cn.Close(); // Fermeture de la connection
                }
                cmd.Dispose();
            }
        }