public static List<Remise> getListRemise(String query) { NpgsqlConnection con = Connexion.Connection(); try { List<Remise> l = new List<Remise>(); NpgsqlCommand Lcmd = new NpgsqlCommand(query, con); NpgsqlDataReader lect = Lcmd.ExecuteReader(); if (lect.HasRows) { while (lect.Read()) { Remise a = new Remise(); a.Id = Convert.ToInt64(lect["id"].ToString()); a.Reference = lect["reference"].ToString(); a.BaseRemise = lect["base_remise"].ToString(); a.Permanent = Convert.ToBoolean((lect["permanent"] != null) ? (!lect["permanent"].ToString().Trim().Equals("") ? lect["permanent"].ToString().Trim() : "false") : "false"); a.Grilles = BLL.GrilleRemiseBll.Liste("SELECT * FROM yvs_com_grille_remise 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 Remise getAjoutRemise(Remise 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); } }
private static double MontantRemise(Remise r, double quantite, double montant) { double remise = 0; if (r != null) { switch (r.BaseRemise) { case Constantes.BASE_CA: foreach (GrilleRabais g in r.Grilles) { if (g.Maximal >= montant && montant >= g.Minimal) { switch (g.Nature) { case Constantes.NATURE_MTANT: remise = g.Montant; break; case Constantes.NATURE_TAUX: remise = (montant * g.Montant) / 100; break; default: break; } break; } } break; case Constantes.BASE_QTE: foreach (GrilleRabais g in r.Grilles) { if (g.Maximal >= quantite && quantite >= g.Minimal) { switch (g.Nature) { case Constantes.NATURE_MTANT: remise = g.Montant; break; case Constantes.NATURE_TAUX: remise = (montant * g.Montant) / 100; break; default: break; } break; } } break; default: remise = 0; break; } } return remise; }
public static Remise getOneRemise(long id) { NpgsqlConnection con = Connexion.Connection(); try { String search = "select * from yvs_com_remise where id = " + id + ""; NpgsqlCommand Lcmd = new NpgsqlCommand(search, con); NpgsqlDataReader lect = Lcmd.ExecuteReader(); Remise a = new Remise(); if (lect.HasRows) { while (lect.Read()) { a.Id = Convert.ToInt64(lect["id"].ToString()); a.Reference = lect["reference"].ToString(); a.BaseRemise = lect["base_remise"].ToString(); a.Permanent = Convert.ToBoolean((lect["permanent"] != null) ? (!lect["permanent"].ToString().Trim().Equals("") ? lect["permanent"].ToString().Trim() : "false") : "false"); a.Grilles = BLL.GrilleRemiseBll.Liste("SELECT * FROM yvs_com_grille_remise 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 getUpdateRemise(Remise 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 RemiseBll(Remise unRemise) { remise = unRemise; }