public static List <User> List()
{
//conection
ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["megacasting"];
SqlConnection connection = new SqlConnection(connectionStringSettings.ToString());
//Commande
SqlCommand commande = new SqlCommand();
commande.Connection = connection;
commande.CommandText = @"SELECT
Id,
LastName,
FirstName,
PhoneNumber,
Email,
Job,
Addres,
CP,
City,
DateofBirth,
IdCivility,
FROM User";
//Execution
connection.Open();
SqlDataReader dataReader = commande.ExecuteReader();
List <User> listUsers = new List <User>();
while (dataReader.Read())
{
String lastName = dataReader.GetString(1);
Int64 idCivility = dataReader.GetInt64(10);
User user = new User(lastName, CivilityDB.Get(idCivility));
user.Id = dataReader.GetInt64(0);
user.FirstName = dataReader.GetString(2);
user.PhoneNumber = dataReader.GetString(3);
user.Email = dataReader.GetString(4);
user.Job = dataReader.GetString(5);
user.Address = dataReader.GetString(6);
user.CP = dataReader.GetString(7);
user.City = dataReader.GetString(8);
user.DateOfBirth = dataReader.GetDateTime(9);
listUsers.Add(user);
}
dataReader.Close();
connection.Close();
return(listUsers);
}
public static User Get(Int64 id)
{
//Récupération de la chaine de connexion
//Connection
ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["megacasting"];
SqlConnection connection = new SqlConnection(connectionStringSettings.ToString());
//Commande
SqlCommand commande = new SqlCommand();
commande.Connection = connection;
commande.CommandText = @"SELECT Id, LastName, FirstName, PhoneNumber, Email, Job, Address, CP, City, DateOfBirth, IdCivility
FROM User
WHERE Id = @Id";
//Parametre
commande.Parameters.AddWithValue("Id", id);
//Execution
connection.Open();
SqlDataReader dataReader = commande.ExecuteReader();
dataReader.Read();
User user = new User(dataReader.GetString(1), CivilityDB.Get(dataReader.GetInt64(10)));
user.Id = dataReader.GetInt64(0);
user.FirstName = dataReader.GetString(2);
user.PhoneNumber = dataReader.GetString(3);
user.Email = dataReader.GetString(4);
user.Job = dataReader.GetString(5);
user.Address = dataReader.GetString(6);
user.CP = dataReader.GetString(7);
user.City = dataReader.GetString(8);
user.DateOfBirth = dataReader.GetDateTime(9);
dataReader.Close();
connection.Close();
return(user);
}
