public List <EmployeStockHistoVue> getAll()
{
List <EmployeStockHistoVue> listAll = new List <EmployeStockHistoVue>();
conn = new DB().getConn();
try
{
string query = "select * from employe_stock_histo_vue";
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
while (reader.Read() == true)
{
EmployeStockHistoVue empStock = new EmployeStockHistoVue(reader.GetInt16(0), reader.GetString(1),
reader.GetString(2), reader.GetInt16(3), reader.GetString(4), reader.GetString(5),
reader.GetString(6), reader.GetString(7), reader.GetInt32(8), reader.GetString(9));
listAll.Add(empStock);
}
}
catch (Exception e)
{
throw new Exception("Erreur dans EmployeStockHistoDAO->getAll" + e.Message);
}
finally
{
conn.Close();
reader.Close();
}
return(listAll);
}
public EmployeStockHistoVue findById(int id)
{
conn = new DB().getConn();
EmployeStockHistoVue empStock = null;
try
{
string query = "select * from employe_stock_histo_vue where id=" + id;
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
if (reader.Read() == true)
{
empStock = new EmployeStockHistoVue(reader.GetInt16(0), reader.GetString(1),
reader.GetString(2), reader.GetInt16(3), reader.GetString(4), reader.GetString(5),
reader.GetString(6), reader.GetString(7), reader.GetInt32(8), reader.GetString(9));
}
}
catch (Exception e)
{
throw new Exception("Erreur dans EmployeStockHistoDAO=>findBydId " + e.Message + e.StackTrace);
}
finally
{
conn.Close();
reader.Close();
}
return(empStock);
}
public List <EmployeStockHistoVue> search(EmployeStockHistoVue empStock)
{
List <EmployeStockHistoVue> listAll;
try
{
listAll = empStockHistoDAO.search(empStock);
}
catch (Exception e)
{
throw new Exception("Erreur dans EmployeStockHistoService => search:" + e.Message);
}
return(listAll);
}
public List <EmployeStockHistoVue> search(EmployeStockHistoVue empStock)
{
conn = new DB().getConn();
List <EmployeStockHistoVue> listAll = new List <EmployeStockHistoVue>();
try
{
string query = "select * from employe_stock_histo_vue where 1<2";
if (empStock.Nom != null)
{
query += " and nom = '" + empStock.Nom + "'";
}
if (empStock.Prenom != null)
{
query += " and prenom = '" + empStock.Prenom + "'";
}
if (empStock.Age != 0)
{
query += " and age = " + empStock.Age;
}
if (empStock.Sexe != null)
{
query += " and sexe = '" + empStock.Sexe + "'";
}
if (empStock.Email != null)
{
query += " and email = '" + empStock.Email + "'";
}
if (empStock.Contact != null)
{
query += " and contact = '" + empStock.Contact + "'";
}
if (empStock.TypeEmploye != null)
{
query += " and type_employe = '" + empStock.TypeEmploye + "'";
}
if (empStock.Stock != 0)
{
query += " and stock = " + empStock.Stock;
}
if (empStock.Carte != null)
{
query += " and carte = '" + empStock.Carte + "'";
}
cmd = new NpgsqlCommand(query, conn);
reader = cmd.ExecuteReader();
while (reader.Read() == true)
{
EmployeStockHistoVue empS = new EmployeStockHistoVue(reader.GetInt16(0), reader.GetString(1),
reader.GetString(2), reader.GetInt16(3), reader.GetString(4), reader.GetString(5),
reader.GetString(6), reader.GetString(7), reader.GetInt32(8), reader.GetString(9));
listAll.Add(empS);
}
}
catch (Exception e)
{
throw new Exception("Erreur dans EmployeStockHistoDAO=>search " + e.Message);
}
finally
{
conn.Close();
reader.Close();
}
return(listAll);
}