public static Agence getAjoutAgence(Agence a)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string insert = "";
NpgsqlCommand cmd = new NpgsqlCommand(insert, con);
cmd.ExecuteNonQuery();
a.Id = getCurrent();
return a;
}
catch
{
return null;
}
finally
{
Connexion.Deconnection(con);
}
}
public static List<Agence> getListAgence(String query)
{
NpgsqlConnection con = Connexion.Connection();
try
{
List<Agence> l = new List<Agence>();
NpgsqlCommand Lcmd = new NpgsqlCommand(query, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
if (lect.HasRows)
{
while (lect.Read())
{
Agence a = new Agence();
a.Id = Convert.ToInt64(lect["id"].ToString());
a.Adresse = lect["adresse"].ToString();
a.Abbreviation = lect["abbreviation"].ToString();
a.CodeAgence = lect["codeagence"].ToString();
a.Designation = lect["designation"].ToString();
a.Societe = (lect["societe"] != null
? (!lect["societe"].ToString().Trim().Equals("")
? BLL.SocieteBll.One(Convert.ToInt32(lect["societe"].ToString()))
: new Societe())
: new Societe());
l.Add(a);
}
lect.Close();
}
return l;
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return null;
}
finally
{
Connexion.Deconnection(con);
}
}
public static Agence getOneAgence(long id)
{
NpgsqlConnection con = Connexion.Connection();
try
{
String search = "select * from yvs_agences where id = " + id + "";
NpgsqlCommand Lcmd = new NpgsqlCommand(search, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
Agence a = new Agence();
if (lect.HasRows)
{
while (lect.Read())
{
a.Id = Convert.ToInt64(lect["id"].ToString());
a.Adresse = lect["adresse"].ToString();
a.Abbreviation = lect["abbreviation"].ToString();
a.CodeAgence = lect["codeagence"].ToString();
a.Designation = lect["designation"].ToString();
a.Ville = (lect["ville"] != null
? (!lect["ville"].ToString().Trim().Equals("")
? BLL.DictionnaireBll.One(Convert.ToInt32(lect["ville"].ToString()))
: new Dictionnaire())
: new Dictionnaire());
a.Societe = (lect["societe"] != null
? (!lect["societe"].ToString().Trim().Equals("")
? BLL.SocieteBll.One(Convert.ToInt32(lect["societe"].ToString()))
: new Societe())
: new Societe());
}
lect.Close();
}
return a;
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return null;
}
finally
{
Connexion.Deconnection(con);
}
}
public static bool getUpdateAgence(Agence a)
{
NpgsqlConnection con = Connexion.Connection();
try
{
string update = "";
NpgsqlCommand Ucmd = new NpgsqlCommand(update, con);
Ucmd.ExecuteNonQuery();
return true;
}
catch (Exception e)
{
Messages.Exception(e);
return false;
}
finally
{
Connexion.Deconnection(con);
}
}
public AgenceBll(Agence unAgence)
{
agence = unAgence;
}