public void Enregistrer(Cotisation cot)
{
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "INSERT_COTISATION";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 4, DbType.Int32, Id));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@ref_inscription", 4, DbType.Int32, RefInscription));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@ref_semaine", 4, DbType.Int32, RefSemaine));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@date_concerne", 20, DbType.Date, DateConcernee));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@ref_frais", 4, DbType.Int32, RefFrais));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@montant", 4, DbType.Decimal, Convert.ToDecimal(Montant)));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@cas", 4, DbType.Int32, Convert.ToDecimal(Cas)));
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@usersession", 30, DbType.String, UserSession));
cmd.ExecuteNonQuery();
//MessageBox.Show("Enregistrement reussie", "Save", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private Cotisation GetDetailCotisation(IDataReader dr)
{
Cotisation cot = new Cotisation();
i = i + 1;
cot.Num = i;
cot.Id = Convert.ToInt32(dr["Id"].ToString());
cot.DateCotisation = Convert.ToDateTime(dr["Date_Cotisation"].ToString());
cot.DateConcernee = Convert.ToDateTime(dr["Date_Concernee"].ToString());
cot.Montant = dr["Montant"].ToString();
cot.Mont = Convert.ToDouble(dr["Mont"].ToString());
cot.RefInscription = Convert.ToInt32(dr["IdInscription"].ToString());
cot.RefRound = Convert.ToInt32(dr["IdRound"].ToString());
cot.Matricule = dr["Matricule"].ToString();
cot.Nom = dr["Nom"].ToString();
cot.Postnom = dr["Postnom"].ToString();
cot.Prenom = dr["Prenom"].ToString();
cot.Sexe = dr["Sexe"].ToString();
cot.RefSemaine = Convert.ToInt32(dr["IdSemaine"].ToString());
cot.RefFrais = Convert.ToInt32(dr["IdFrais"].ToString());
cot.Designation = dr["Designation"].ToString();
return(cot);
}
private Cotisation GetDetailDettes(IDataReader dr)
{
Cotisation cot = new Cotisation();
i = i + 1;
cot.Num = i;
cot.RefInscription = Convert.ToInt32(dr["IdInscription"].ToString());
cot.Matricule = dr["Matricule"].ToString();
cot.Nom = dr["Nom_Complet"].ToString();
cot.Sexe = dr["Sexe"].ToString();
return(cot);
}