コード例 #1
0
        public void Enregistrer(Remboursement remb)
        {
            if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
            {
                ImplementeConnexion.Instance.Conn.Open();
            }
            using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
            {
                cmd.CommandText = "INSERT_REMBOURSEMENT";
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 4, DbType.Int32, Id));
                cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@ref_semaine", 4, DbType.Int32, RefSemaine));
                cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@usersession", 50, DbType.String, UserSession.GetInstance().UserName));

                cmd.ExecuteNonQuery();

                MessageBox.Show("Enregistrement reussie", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
コード例 #2
0
        private Remboursement GetDetailsRemboursement(IDataReader rd)
        {
            Remboursement r = new Remboursement();

            i = i + 1;



            r.Num                = i;
            r.Id                 = Convert.ToInt32(rd["Id"].ToString());
            r.RefInscription     = Convert.ToInt32(rd["IdInscription"].ToString());
            r.IdRound            = Convert.ToInt32(rd["IdRound"].ToString());
            r.Matricule          = rd["Matricule"].ToString();
            r.Noms               = rd["Nom_Complet"].ToString();
            r.Montant            = rd["Montant"].ToString();
            r.Sexe               = rd["Sexe"].ToString();
            r.RefSemaine         = Convert.ToInt32(rd["IdSemaine"].ToString());
            r.Date_Debut         = Convert.ToDateTime(rd["Date_Debut"].ToString());
            r.Date_Fin           = Convert.ToDateTime(rd["Date_Fin"].ToString());
            r.Date_Remboursement = Convert.ToDateTime(rd["Date_Remboursement"].ToString());
            return(r);
        }