public static InstantRound GetInstance()
{
if (inst == null)
{
inst = new InstantRound();
}
return(inst);
}
public List <ClsSMS> AllNumDette()
{
List <ClsSMS> lst = new List <ClsSMS>();
if (ImplementeConnexion.Instance.Conn.State == ConnectionState.Closed)
{
ImplementeConnexion.Instance.Conn.Open();
}
using (IDbCommand cmd = ImplementeConnexion.Instance.Conn.CreateCommand())
{
cmd.CommandText = "SELECT_SMS_DETTE";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(Parametre.Instance.AjouterParametre(cmd, "@id", 30, DbType.String, InstantRound.GetInstance().Id));
IDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
lst.Add(GetSDette(rd));
}
rd.Dispose();
}
return(lst);
}