public static ObservableCollection <StockageDAO> selectStockages()
{
ObservableCollection <StockageDAO> l = new ObservableCollection <StockageDAO>();
string query = "SELECT * FROM stockage;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataReader reader = null;
try
{
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
StockageDAO p = new StockageDAO(reader.GetInt32(0), reader.GetInt32(1));
l.Add(p);
}
}
catch (Exception e)
{
MessageBox.Show("Il y a un problème dans la table Stockage : {0}", e.StackTrace);
}
reader.Close();
return(l);
}
public static void updateStockage(StockageDAO p)
{
string query = "UPDATE stockage set idAdresseStockage=\"" + p.idAdresseStockageDAO + "\" where idStockage=" + p.idStockageDAO + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void insertStockage(StockageDAO p)
{
int id = getMaxIdStockage() + 1;
string query = "INSERT INTO stockage VALUES (\"" + id + "\",\"" + p.idAdresseStockageDAO + "\");";
MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static StockageViewModel getStockage(int idStockage)
{
StockageDAO sDAO = StockageDAO.getStockage(idStockage);
int idAdresse = sDAO.idAdresseStockageDAO;
AdresseViewModel a = AdresseORM.getAdresse(idAdresse);
StockageViewModel s = new StockageViewModel(sDAO.idStockageDAO, a);
return(s);
}
public static StockageDAO getStockage(int idStockage)
{
string query = "SELECT * FROM stockage WHERE id=" + idStockage + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
StockageDAO pers = new StockageDAO(reader.GetInt32(0), reader.GetInt32(1));
reader.Close();
return(pers);
}
public static ObservableCollection <StockageViewModel> listeStockages()
{
ObservableCollection <StockageDAO> lDAO = StockageDAO.listeStockages();
ObservableCollection <StockageViewModel> l = new ObservableCollection <StockageViewModel>();
foreach (StockageDAO element in lDAO)
{
int idAdresse = element.idAdresseStockageDAO;
AdresseViewModel a = AdresseORM.getAdresse(idAdresse);
StockageViewModel s = new StockageViewModel(element.idAdresseStockageDAO, a);
l.Add(s);
}
return(l);
}
public static void insertStockage(StockageDAO p)
{
StockageDAL.insertStockage(p);
}
public static void updateStockage(StockageDAO p)
{
StockageDAL.updateStockage(p);
}
public static StockageDAO getStockage(int idStockage)
{
StockageDAO p = StockageDAL.getStockage(idStockage);
return(p);
}
public static void insertStockage(StockageViewModel s)
{
StockageDAO.insertStockage(new StockageDAO(s.idStockageProperty,
s.idAdresseStockageProperty.idAdresseProperty));
}
public static void supprimerStockage(int id)
{
StockageDAO.supprimerStockage(id);
}
