public static Magasinier Create(Magasinier m)
{
using (SqlConnection conn = Database.GetConnection())
{
conn.Open();
SqlCommand command = new SqlCommand(CREATE, conn);
command.Parameters.AddWithValue("@username", m.Username);
command.Parameters.AddWithValue("@password", m.Password);
command.Parameters.AddWithValue("@tel", m.Tel);
command.Parameters.AddWithValue("@email", m.Email);
m.Id = (int)command.ExecuteScalar(); //Revnoyer la valeur de l'intersection de la première ligne première colonne
}
return(m);
}
public static Magasinier Get(int id)
{
Magasinier m = 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())
{
m = new Magasinier(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4));
}
}
return(m);
}
public static Magasinier getMag(string username, string password)
{
Magasinier mag = 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())
{
mag = new Magasinier(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4));
}
}
return(mag);
}
public static Boolean Update(Magasinier m)
{
bool aEteModifie = false;
using (SqlConnection conn = Database.GetConnection())
{
conn.Open();
SqlCommand command = new SqlCommand(UPDATE, conn);
command.Parameters.AddWithValue("@username", m.Username);
command.Parameters.AddWithValue("@password", m.Password);
command.Parameters.AddWithValue("@tel", m.Tel);
command.Parameters.AddWithValue("@email", m.Email);
command.Parameters.AddWithValue("@id", m.Id);
aEteModifie = command.ExecuteNonQuery() != 0;
}
return(aEteModifie);
}