public PointDeVenteStockVue findById(int id)
{
conn = new DB().getConn();
PointDeVenteStockVue pv = null;
try
{
string query = "select * from point_de_vente_stock_vue where id=" + id;
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
if (reader.Read() == true)
{
pv = new PointDeVenteStockVue(reader.GetInt16(0), reader.GetString(1), reader.GetString(2),
reader.GetString(3), reader.GetString(4), reader.GetInt32(5));
}
}
catch (Exception e)
{
throw new Exception("Erreur dans PointDeVenteStockDAO=>findBydId " + e.Message);
}
finally
{
conn.Close();
reader.Close();
}
return(pv);
}
public List <PointDeVenteStockVue> getAll()
{
List <PointDeVenteStockVue> listAll = new List <PointDeVenteStockVue>();
conn = new DB().getConn();
try
{
string query = "select * from point_de_vente_stock_vue";
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
while (reader.Read() == true)
{
PointDeVenteStockVue pv = new PointDeVenteStockVue(reader.GetInt16(0), reader.GetString(1), reader.GetString(2),
reader.GetString(3), reader.GetString(4), reader.GetInt32(5));
listAll.Add(pv);
}
}
catch (Exception e)
{
throw new Exception("Erreur dans PointDeVenteStockDAO->getAll" + e.Message + e.StackTrace);
}
finally
{
conn.Close();
reader.Close();
}
return(listAll);
}
public List <PointDeVenteStockVue> search(PointDeVenteStockVue pv)
{
List <PointDeVenteStockVue> listAll;
try
{
listAll = pointDeVenteStockDAO.search(pv);
}
catch (Exception e)
{
throw new Exception("Erreur dans PointDeVenteStockService => search:" + e.Message);
}
return(listAll);
}
public List <PointDeVenteStockVue> search(PointDeVenteStockVue pv)
{
conn = new DB().getConn();
List <PointDeVenteStockVue> listAll = new List <PointDeVenteStockVue>();
try
{
string query = "select * from point_de_stock_vue where ";
if (pv.PointDeVente != null)
{
query += " point_de_vente = " + pv.PointDeVente;
}
if (pv.ZoneTravail != null)
{
query += " and zone_travail = " + pv.ZoneTravail;
}
if (pv.Latitude != null)
{
query += " and latitude = " + pv.Latitude;
}
if (pv.Longitude != null)
{
query += " and longitude = " + pv.Longitude;
}
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
while (reader.Read() == true)
{
PointDeVenteStockVue pvs = new PointDeVenteStockVue(reader.GetInt16(0), reader.GetString(1), reader.GetString(2),
reader.GetString(3), reader.GetString(4), reader.GetInt32(5));
listAll.Add(pvs);
}
}
catch (Exception e)
{
throw new Exception("Erreur dans PointDeVenteStockDAO=>search " + e.Message);
}
finally
{
conn.Close();
reader.Close();
}
return(listAll);
}
