public StatistiqueTotal findById(int id)
{
conn = new DB().getConn();
StatistiqueTotal stat = null;
try
{
string query = "select * from statistique_total where id=" + id;
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
if (reader.Read() == true)
{
stat = new StatistiqueTotal(reader.GetInt16(0), reader.GetString(1), reader.GetInt32(2));
}
}
catch (Exception e)
{
throw new Exception("Erreur dans StatistiqueTotalDAO=>findBydId " + e.Message);
}
finally
{
conn.Close();
reader.Close();
}
return(stat);
}
public List <StatistiqueTotal> getAll()
{
List <StatistiqueTotal> listAll = new List <StatistiqueTotal>();
conn = new DB().getConn();
try
{
string query = "select * from statistique_total";
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
while (reader.Read() == true)
{
StatistiqueTotal stat = new StatistiqueTotal(reader.GetInt16(0), reader.GetString(1), reader.GetInt64(2));
listAll.Add(stat);
}
}
catch (Exception e)
{
throw new Exception("Erreur dans StatistiqueTotalDAO->getAll" + e.Message + e.StackTrace);
}
finally
{
conn.Close();
reader.Close();
}
return(listAll);
}
public List <StatistiqueTotal> search(StatistiqueTotal stat)
{
List <StatistiqueTotal> listStat;
try
{
listStat = statistiqueDAO.search(stat);
}
catch (Exception e)
{
throw new Exception("Erreur dans StatistiqueTotalService => search:" + e.Message);
}
return(listStat);
}
public List <StatistiqueTotal> search(StatistiqueTotal stat)
{
conn = new DB().getConn();
List <StatistiqueTotal> listAll = new List <StatistiqueTotal>();
try
{
string query = "select * from statistique_total where 1<2 ";
if (stat.Carte != null)
{
query += " and carte =" + stat.Carte;
}
if (stat.Quantite != 0)
{
query += " and quantite =" + stat.Quantite;
}
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
while (reader.Read() == true)
{
StatistiqueTotal statTotal = new StatistiqueTotal(reader.GetInt16(0), reader.GetString(1), reader.GetInt32(2));
listAll.Add(statTotal);
}
}
catch (Exception e)
{
throw new Exception("Erreur dans StatistiqueTotalDAO=>search " + e.Message);
}
finally
{
conn.Close();
reader.Close();
}
return(listAll);
}
