public DataTable GetAllArticles()
{
DataTable dt = new DataTable();
MySqlCommand = new SqlCommand("SELECT * FROM[Article] ");
dt = Connexion.FunctionToRead(MySqlCommand);
return dt;
}
public List <User> GetAllUsers()
{
List <User> AllUsers = new List <User>();
MySqlCommand = new SqlCommand("select * from [Users]");
dt = Connexion.FunctionToRead(MySqlCommand);
foreach (DataRow row in dt.Rows)
{
AllUsers.Add(ConvertRowToUser(row));
}
return(AllUsers);
}
public DataTable GetAllFactureLine()
{
DataTable dt = new DataTable();
MySqlCommand = new SqlCommand("SELECT * FROM[LigneFacture] ");
dt = Connexion.FunctionToRead(MySqlCommand);
return(dt);
}