public static List<Ristourne> getListRistourne(String query)
{
NpgsqlConnection con = Connexion.Connection();
try
{
List<Ristourne> l = new List<Ristourne>();
NpgsqlCommand Lcmd = new NpgsqlCommand(query, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
if (lect.HasRows)
{
while (lect.Read())
{
Ristourne a = new Ristourne();
a.Id = Convert.ToInt64(lect["id"].ToString());
a.Reference = lect["reference"].ToString();
a.BaseRistourne = lect["base_ristourne"].ToString();
a.Permanent = Convert.ToBoolean((lect["permanent"] != null) ? (!lect["permanent"].ToString().Trim().Equals("") ? lect["permanent"].ToString().Trim() : "false") : "false");
a.Grilles = BLL.GrilleRistourneBll.Liste("SELECT * FROM yvs_com_grille_ristourne WHERE remise =" + a.Id);
a.Update = true;
l.Add(a);
}
lect.Close();
}
return l;
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return null;
}
finally
{
Connexion.Deconnection(con);
}
}
public static Ristourne getAjoutRistourne(Ristourne 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 RistourneBll(Ristourne unRistourne)
{
ristourne = unRistourne;
}
public static Ristourne getOneRistourne(long id)
{
NpgsqlConnection con = Connexion.Connection();
try
{
String search = "select * from yvs_com_ristourne where id = " + id + "";
NpgsqlCommand Lcmd = new NpgsqlCommand(search, con);
NpgsqlDataReader lect = Lcmd.ExecuteReader();
Ristourne a = new Ristourne();
if (lect.HasRows)
{
while (lect.Read())
{
a.Id = Convert.ToInt64(lect["id"].ToString());
a.Reference = lect["reference"].ToString();
a.BaseRistourne = lect["base_ristourne"].ToString();
a.Permanent = Convert.ToBoolean((lect["permanent"] != null) ? (!lect["permanent"].ToString().Trim().Equals("") ? lect["permanent"].ToString().Trim() : "false") : "false");
a.Grilles = BLL.GrilleRistourneBll.Liste("SELECT * FROM yvs_com_grille_ristourne WHERE remise =" + a.Id);
}
a.Update = true;
lect.Close();
}
return a;
}
catch (NpgsqlException e)
{
Messages.Exception(e);
return null;
}
finally
{
Connexion.Deconnection(con);
}
}
public static bool getUpdateRistourne(Ristourne 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);
}
}
