public static LotViewModel getLot(int idLot)
{
LotDAO pDAO = LotDAO.getLot(idLot);
LotViewModel p = new LotViewModel(pDAO.idLotDAO, pDAO.nomDAO, pDAO.descriptionDAO, pDAO.prix_departDAO);
return(p);
}
public static ObservableCollection <LotDAO> selectLots()
{
ObservableCollection <LotDAO> l = new ObservableCollection <LotDAO>();
string query = "SELECT * FROM Lot;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataReader reader = null;
try
{
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
LotDAO p = new LotDAO(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3));
l.Add(p);
}
}
catch (Exception e)
{
MessageBox.Show("Il y a un problème dans la table Lot : {0}", e.StackTrace);
}
reader.Close();
return(l);
}
public static void updateLot(LotDAO p)
{
string query = "UPDATE Lot set nom=\"" + p.nomDAO + "\", description=\"" + p.descriptionDAO + "\", prix_depart=\"" + p.prix_departDAO + "\"WHERE id = \"" + p.idLotDAO + "\" ;";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd);
cmd.ExecuteNonQuery();
}
public static void insertLot(LotDAO p)
{
int id = getMaxIdLot() + 1;
string query = "INSERT INTO Lot (id, nom, description, prix_depart) VALUES (\"" + id + "\",\"" + p.nomDAO + "\",\"" + p.descriptionDAO + "\",\"" + p.prix_departDAO + "\");";
MySqlCommand cmd2 = new MySqlCommand(query, DALConnection.OpenConnection());
MySqlDataAdapter sqlDataAdap = new MySqlDataAdapter(cmd2);
cmd2.ExecuteNonQuery();
}
public static ObservableCollection <LotViewModel> listeLots()
{
ObservableCollection <LotDAO> lDAO = LotDAO.listeLots();
ObservableCollection <LotViewModel> l = new ObservableCollection <LotViewModel>();
foreach (LotDAO element in lDAO)
{
LotViewModel p = new LotViewModel(element.idLotDAO, element.nomDAO, element.descriptionDAO, element.prix_departDAO);
l.Add(p);
}
return(l);
}
public static LotDAO getLot(int idLot)
{
string query = "SELECT * FROM Lot WHERE id=" + idLot + ";";
MySqlCommand cmd = new MySqlCommand(query, DALConnection.OpenConnection());
cmd.ExecuteNonQuery();
MySqlDataReader reader = cmd.ExecuteReader();
reader.Read();
LotDAO pers = new LotDAO(reader.GetInt32(0), reader.GetString(1), reader.GetString(2), reader.GetInt32(3));
reader.Close();
return(pers);
}
public static void insertLot(LotDAO p)
{
LotDAL.insertLot(p);
}
public static void updateLot(LotDAO p)
{
LotDAL.updateLot(p);
}
public static LotDAO getLot(int idLot)
{
LotDAO p = LotDAL.getLot(idLot);
return(p);
}
public static void insertLot(LotViewModel p)
{
LotDAO.insertLot(new LotDAO(p.idLotProperty, p.nomProperty, p.descriptionProperty, p.prix_departProperty));
}
public static void supprimerLot(int id)
{
LotDAO.supprimerLot(id);
}
