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); }