private void Form1_Load(object sender, System.EventArgs e)
{
dataA.Open();
string sql = "select * from distinctYearDate";
SqlCommand cmd = new SqlCommand(sql, dataA);
SqlDataReader dr = cmd.ExecuteReader();
List <string> priv = new List <string>();
// var columns = new List<String>();
// var reader = cmd.ExecuteReader();
//hidEmployee = "1";
while (dr.Read())
{
priv.Add(dr[0].ToString().TrimEnd());
//String str = dr.GetValue(6);
}
foreach (string str in priv)
{
dateYearText.Items.Add(str);
}
dr.Close();
dataA.Close();
dataA.Open();
sql = "select * from distinctCountryHotel";
cmd = new SqlCommand(sql, dataA);
dr = cmd.ExecuteReader();
priv = new List <string>();
// var columns = new List<String>();
// var reader = cmd.ExecuteReader();
//hidEmployee = "1";
while (dr.Read())
{
priv.Add(dr[0].ToString().TrimEnd());
//String str = dr.GetValue(6);
}
foreach (string str in priv)
{
hotelCountryText.Items.Add(str);
}
dr.Close();
dataA.Close();
dataA.Open();
sql = "exec getClientDWCountry";
cmd = new SqlCommand(sql, dataA);
dr = cmd.ExecuteReader();
priv = new List <string>();
// var columns = new List<String>();
// var reader = cmd.ExecuteReader();
//hidEmployee = "1";
while (dr.Read())
{
priv.Add(dr[0].ToString().TrimEnd());
//String str = dr.GetValue(6);
}
foreach (string str in priv)
{
clientCountryText.Items.Add(str);
}
dr.Close();
dataA.Close();
dataA.Close();
dataA.Open();
sql = "select * from distinctProvinceHotel";
cmd = new SqlCommand(sql, dataA);
dr = cmd.ExecuteReader();
priv = new List <string>();
// var columns = new List<String>();
// var reader = cmd.ExecuteReader();
//hidEmployee = "1";
while (dr.Read())
{
priv.Add(dr[0].ToString().TrimEnd());
//String str = dr.GetValue(6);
}
foreach (string str in priv)
{
hotelProvinceText.Items.Add(str);
}
dr.Close();
dataA.Close();
dataA.Open();
sql = "select * from distinctProvinceClient";
cmd = new SqlCommand(sql, dataA);
dr = cmd.ExecuteReader();
priv = new List <string>();
// var columns = new List<String>();
// var reader = cmd.ExecuteReader();
//hidEmployee = "1";
while (dr.Read())
{
priv.Add(dr[0].ToString().TrimEnd());
//String str = dr.GetValue(6);
}
foreach (string str in priv)
{
clientProvinceText.Items.Add(str);
}
dr.Close();
dataA.Close();
dataA.Open();
sql = "select * from distinctCityHotel";
cmd = new SqlCommand(sql, dataA);
dr = cmd.ExecuteReader();
priv = new List <string>();
// var columns = new List<String>();
// var reader = cmd.ExecuteReader();
//hidEmployee = "1";
while (dr.Read())
{
priv.Add(dr[0].ToString().TrimEnd());
//String str = dr.GetValue(6);
}
foreach (string str in priv)
{
hotelCityText.Items.Add(str);
}
dr.Close();
dataA.Close();
dataA.Open();
sql = "select * from distinctCityClient";
cmd = new SqlCommand(sql, dataA);
dr = cmd.ExecuteReader();
priv = new List <string>();
// var columns = new List<String>();
// var reader = cmd.ExecuteReader();
//hidEmployee = "1";
while (dr.Read())
{
priv.Add(dr[0].ToString().TrimEnd());
//String str = dr.GetValue(6);
}
foreach (string str in priv)
{
clientCityText.Items.Add(str);
}
dr.Close();
dataA.Close();
}
public static void Main(string[] args)
{
Personne p1 = new Personne();
Personne p2 = new Personne("Jean", "Louis");
Personne p3 = new Personne()
{
Nom = "El", Prenom = "Jean"
};
Personne p4 = p2.Clone() as Personne;
//Personne p4 = (Personne) p2.Clone();
//Console.WriteLine(p1);
Console.WriteLine(p2);
Console.WriteLine(p4);
p2.Nom = "Cronier";
p4.Prenom = "Antoine";
Console.WriteLine(p2);
Console.WriteLine(p4);
//Console.WriteLine(p3);
Jeu <CardGame> jeu = new Bataille();
// A proscrire je ne connais pas le type réel => Jeu<CardGame>
//var jeu = new Bataille();
jeu.play();
// new sur abstract impossible.
//Jeu jeu1 = new Jeu();
// var ici est possible car membre de droite connu
var jeux = new List <Jeu <CardGame> >();
jeux.Add(jeu);
jeux.Add(new Bataille());
foreach (var item in jeux)
{
item.play();
// Attention ne pas modifier les valeurs d'item dans le foreach
}
for (int i = 0; i < jeux.Count; i++)
{
jeux.ElementAt(i).play();
}
Console.WriteLine(Extension.Add(10, 12));
int a = 10;
Console.WriteLine(a.Add(12));
String b = "aizpepoazipe";
Console.WriteLine(b.Add("11111"));
Func <String> func1 = new Func <string>(() =>
{
return("func1");
});
Console.WriteLine(func1.Invoke());
Func <int, int, String> func2 = new Func <int, int, String>((i, j) =>
{
return("produit i et j => " + (i * j));
});
Console.WriteLine(func2.Invoke(10, 12));
func2 = func2Test;
Console.WriteLine(func2.Invoke(10, 12));
Action a1 = new Action(() =>
{
Console.WriteLine("in a1");
Console.WriteLine(func2.Invoke(10, 12));
});
a1.Invoke();
Task.Factory.StartNew(() =>
{
for (int i = 0; i < 10000; i++)
{
Console.WriteLine(i);
}
});
jeux.Where(x => x.Name.Equals("bataille"));
Console.ReadKey();
}
