private Remboursement GetDetailsRecouvrement(IDataReader dr)
{
Remboursement rem = new Remboursement();
i = i + 1;
rem.Num = i;
rem.Code = dr["Code"].ToString();
rem.Montant = Convert.ToDouble(dr["Montant"].ToString());
rem.Client = dr["Noms"].ToString();
rem.Sexe = dr["Sexe"].ToString();
rem.Phone = dr["Telephone"].ToString();
return(rem);
}
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.AddParametres(cmd, "@id", 5, DbType.Int32, remb.Id));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@code", 20, DbType.String, remb.Code));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@montant", 50, DbType.Double, remb.Montant));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@observation", 50, DbType.String, remb.Observation));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@refcredit", 5, DbType.Int32, remb.RefCredit));
cmd.Parameters.Add(Parametre.Instance.AddParametres(cmd, "@date", 20, DbType.Date, remb.DateRemboursement));
cmd.ExecuteNonQuery();
}
}
private Remboursement GetDetails(IDataReader dr)
{
Remboursement rem = new Remboursement();
i = i + 1;
rem.Num = i;
rem.Id = Convert.ToInt32(dr["Id"].ToString());
rem.Code = dr["Code"].ToString();
rem.Montant = Convert.ToDouble(dr["Montant"].ToString());
rem.DateRemboursement = Convert.ToDateTime(dr["Date_Remboursement"].ToString());
rem.Observation = dr["Observation"].ToString();
rem.CodeCredit = dr["Code_Credit"].ToString();
rem.MontantR = dr["Montant_Restant"].ToString();
rem.CodeClient = dr["Code_Client"].ToString();
rem.Client = dr["Client"].ToString();
rem.Sexe = dr["Sexe"].ToString();
rem.Phone = dr["Telephone"].ToString();
return(rem);
}