public static List <Client> GetList()
{
List <Client> listeClient = new List <Client>();
//SqlConnection oConn = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Users\marilou\Documents\mdsb3.mdf;Integrated Security=True;Connect Timeout=30");
//oConn.Open();
SqlConnection oConn = SingleConnection.CreateInstance().GetConnection();
oConn.Open();
SqlCommand oCmd = oConn.CreateCommand();
oCmd.CommandText = "SELECT * FROM CLIENT";
// notre objet contient le resultat de la req
SqlDataReader oReader = oCmd.ExecuteReader();
while (oReader.Read())
{
var client = Client.CreateObject(TypeClient.NORMAL);
client.Id = Convert.ToInt32(oReader["Id"]);
client.Name = Convert.ToString(oReader["NOM"]);
//client.Type = oReader["TYPE"];
client.MtEncours = Convert.ToInt32(oReader["MtEnCours"]);
listeClient.Add(client);
}
oReader.Close();
oConn.Close();
return(listeClient);
}
public static SingleConnection CreateInstance()
{
if (Instance == null)
{
Instance = new SingleConnection();
}
return(Instance);
}
