public static Administrateur getAd(string username, string password)
{
Administrateur ad = null;
using (SqlConnection connection = Database.GetConnection())
{
connection.Open();
SqlCommand command = new SqlCommand(GETCONENCTION, connection);
command.Parameters.AddWithValue("@username", username);
command.Parameters.AddWithValue("@password", password);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
ad = new Administrateur(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3));
}
}
return(ad);
}
public static Administrateur Get(int id)
{
Administrateur a = null;
using (SqlConnection conn = Database.GetConnection())
{
conn.Open();
SqlCommand command = new SqlCommand(GET, conn);
command.Parameters.AddWithValue("@id", id);
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
a = new Administrateur(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3));
}
}
return(a);
}
public static Boolean Update(Administrateur a)
{
bool aEteModifie = false;
using (SqlConnection conn = Database.GetConnection())
{
conn.Open();
SqlCommand command = new SqlCommand(UPDATE, conn);
command.Parameters.AddWithValue("@username", a.Username);
command.Parameters.AddWithValue("@password", a.Password);
command.Parameters.AddWithValue("@email", a.Email);
command.Parameters.AddWithValue("@id", a.Id);
aEteModifie = command.ExecuteNonQuery() != 0;
}
return(aEteModifie);
}
