// METHODS : private int ExecuteUpdate(SqlCommand cmd, Jonction model) { cmd.CommandText = "UPDATE Jonction SET regle=@val1 WHERE id=@val2"; cmd.Parameters.AddWithValue("@val1", model.Regle); cmd.Parameters.AddWithValue("@val2", model.Id); return(cmd.ExecuteNonQuery()); }
public int Update(Jonction model) { int result = -1; connexion.Open(); using (SqlCommand cmd = connexion.CreateCommand()) { result = this.ExecuteUpdate(cmd, model); } connexion.Close(); return(result); }
private void ReglerQte(Jonction jonct, Pari pari, Json.Stat stat, PariDetail pd1, PariDetail pd2) { if (stat.equipe1 > (stat.equipe2 + pd1.Compensation)) { int ecart = stat.equipe1 - (stat.equipe2 + pd1.Compensation); if (ecart > pd1.Ecart) { int ecart2 = ecart / (int)pd1.Ecart; float montant = ecart2 * pd1.MontantEcart; if (montant > jonct.Montant) { montant = jonct.Montant; } Client cl1 = pd1.Pari.Client, cl2 = pd2.Pari.Client; cl1.Solde += (jonct.Montant + montant); cl2.Solde += (jonct.Montant - montant); new ClientDAO(connection).Update(cl1); new ClientDAO(connection).Update(cl2); } else { Client client = pd1.Pari.Client; client.Solde += jonct.Montant; new ClientDAO(connection).Update(client); } } else if (stat.equipe1 < (stat.equipe2 + pd1.Compensation)) { int ecart = (stat.equipe2 + pd1.Compensation) - stat.equipe1; if (ecart > pd2.Ecart) { int ecart2 = ecart / (int)pd2.Ecart; float montant = ecart2 * pd2.MontantEcart; if (montant > jonct.Montant) { montant = jonct.Montant; } Client cl1 = pd1.Pari.Client, cl2 = pd2.Pari.Client; cl1.Solde += (jonct.Montant - montant); cl2.Solde += (jonct.Montant + montant); new ClientDAO(connection).Update(cl1); new ClientDAO(connection).Update(cl2); } else { Client client = pd2.Pari.Client; client.Solde += jonct.Montant; new ClientDAO(connection).Update(client); } } else { this.Egalite(jonct, pari, pd1, pd2); } }
private void Regler(Jonction jonction) { PariDetail pd1 = jonction.Pari, pd2 = jonction.ContrePari; Pari pari = pd1.Pari; Partie partie = pari.Partie.Partie; Action action = pari.Action; Json.Stat stat = new OtherDAO(connection).SelectOneStat(partie.Id, action.Id, pd1.Equipe.Id, pd2.Equipe.Id); if (pari.TypePari == 0) { this.ReglerTotal(jonction, pari, stat, pd1, pd2); } else { this.ReglerQte(jonction, pari, stat, pd1, pd2); } }
private void ReglerTotal(Jonction jonct, Pari pari, Json.Stat stat, PariDetail pd1, PariDetail pd2) { if (stat.equipe1 > (stat.equipe2 + pd1.Compensation)) { Client client = pd1.Pari.Client; client.Solde += (jonct.Montant * 2); new ClientDAO(connection).Update(client); } else if (stat.equipe1 < (stat.equipe2 + pd1.Compensation)) { Client client = pd2.Pari.Client; client.Solde += (jonct.Montant * 2); new ClientDAO(connection).Update(client); } else { this.Egalite(jonct, pari, pd1, pd2); } }
private void Egalite(Jonction jonct, Pari pari, PariDetail pd1, PariDetail pd2) { Client cl1 = pd1.Pari.Client, cl2 = pd2.Pari.Client; ClientDAO cldao = new ClientDAO(connection); if (pari.RegleEgalite == 0) { cl1.Solde += jonct.Montant; cl2.Solde += jonct.Montant; cldao.Update(cl1); cldao.Update(cl2); } else if (pari.RegleEgalite == 1) { cl1.Solde += (jonct.Montant * 2); cldao.Update(cl1); } else { cl2.Solde += (jonct.Montant * 2); cldao.Update(cl2); } }
// METHODS : public bool Equals(Jonction jonction) { return(this.id == jonction.Id); }