public VenteCarteVue findById(int id)
{
conn = new DB().getConn();
VenteCarteVue carte = null;
try
{
string query = "select * from vente_carte_vue where id=" + id;
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
if (reader.Read() == true)
{
carte = new VenteCarteVue(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2),
reader.GetString(3), reader.GetDateTime(4));
}
}
catch (Exception e)
{
throw new Exception("Erreur dans VenteCarteDAO=>findBydId " + e.Message);
}
finally
{
conn.Close();
reader.Close();
}
return(carte);
}
public List <VenteCarteVue> getAll()
{
List <VenteCarteVue> listAll = new List <VenteCarteVue>();
conn = new DB().getConn();
try
{
string query = "select * from vente_carte_vue";
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
while (reader.Read() == true)
{
VenteCarteVue carte = new VenteCarteVue(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2),
reader.GetString(3), reader.GetDateTime(4));
}
}
catch (Exception e)
{
throw new Exception("Erreur dans VenteCarteDAO->getAll" + e.Message);
}
finally
{
conn.Close();
reader.Close();
}
return(listAll);
}
public ActionResult DetailVente(int idLivraison)
{
venteCarteService = new VenteCarteService();
VenteCarteVue venteCarte = new VenteCarteVue();
venteCarte.Livraison = idLivraison;
List <VenteCarteVue> listVente = venteCarteService.search(venteCarte);
ViewBag.listVenteCarte = listVente;
return(View());
}
public List <VenteCarteVue> search(VenteCarteVue livCarte)
{
List <VenteCarteVue> listCarte;
try
{
listCarte = this.venteCarteDAO.search(livCarte);
}
catch (Exception e)
{
throw new Exception("Erreur dans VenteCarteService => search:" + e.Message + e.StackTrace);
}
return(listCarte);
}
public List <VenteCarteVue> search(VenteCarteVue carte)
{
conn = new DB().getConn();
List <VenteCarteVue> listAll = new List <VenteCarteVue>();
try
{
string query = "select * from vente_carte_vue where 1<2 ";
if (carte.Livraison != 0)
{
query += " and livraison =" + carte.Livraison;
}
if (carte.Quantite != 0)
{
query += " and quantite =" + carte.Quantite;
}
if (carte.Point_de_vente != null)
{
query += " and point_de_vente ='" + carte.Point_de_vente + "'";
}
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
while (reader.Read() == true)
{
VenteCarteVue c = new VenteCarteVue(reader.GetInt32(0), reader.GetInt32(1), reader.GetInt32(2),
reader.GetString(3), reader.GetDateTime(4));
listAll.Add(c);
}
}
catch (Exception e)
{
throw new Exception("Erreur dans VenteCarteDAO=>search " + e.Message);
}
finally
{
conn.Close();
reader.Close();
}
return(listAll);
}
