private void SavePari(Res response, int id, StructPari value)
{
SqlConnection connection = Models.Connexion.Get("Server=localhost;Database=foot;User ID=sa;Password=itu;");
Models.PariDAO padao = new Models.PariDAO(connection);
Models.PariDetailDAO paddao = new Models.PariDetailDAO(connection);
Models.ClientDAO cldao = new Models.ClientDAO(connection);
Models.Pari pari = new Models.Pari(value.pari); pari.Id = padao.NextId();
Models.PariDetail detail = new Models.PariDetail(value.detail); detail.Id = paddao.NextId(); detail.Pari = pari;
Models.Client client = cldao.SelectOne("WHERE id='" + pari.Client + "'");
client.Solde -= detail.Montant;
if (client != null && padao.Insert(pari.ToInsert()) > 0)
{
paddao.Insert(detail.ToInsert());
cldao.Update(client);
value.pari.id = pari.Id;
value.detail.id = detail.Id;
response.data = value;
response.error = false;
}
else
{
throw new Exception("Enregistrement du pari impossible !");
}
}
private void Interessants(Res response, Pari value)
{
SqlConnection connection = Models.Connexion.Get("Server=localhost;Database=foot;User ID=sa;Password=itu;");
Models.PariDetailDAO paddao = new Models.PariDetailDAO(connection);
Models.PariDetail detail = paddao.SelectOne("WHERE pari='" + value.id + "'");
response.data = paddao.Select(", Pari p WHERE p.id=pd.pari AND p.partie='" + detail.Pari.Partie + "' AND p.client != '" + detail.Pari.Client + "' AND p.typePari=" + detail.Pari.TypePari + " AND p.action='" + detail.Pari.Action + "' AND p.equilibre=" + detail.Pari.Equilibre + " AND pd.equipe!='" + detail.Equipe + "' AND pd.montant > 0");
response.error = false;
}
private void AnswerPost(Res response, Pari value)
{
paddao = new Models.PariDetailDAO(connection);
jodao = new Models.JonctionDAO(connection);
Models.PariDetail detail = paddao.SelectOne("WHERE pari='" + value.id + "'");
response.data = jodao.Select("WHERE pari='" + detail + "' OR contrePari='" + detail + "'");
response.error = false;
}
private void AnswerPut(Res response, int id, Jonction value)
{
paddao = new Models.PariDetailDAO(connection);
jodao = new Models.JonctionDAO(connection);
Models.PariDetail pari = paddao.SelectOne("WHERE pari='" + value.pari + "'");
Models.PariDetail contre = paddao.SelectOne("WHERE pari='" + value.contrePari + "'");
if (pari != null && contre != null)
{
this.ManagePut(response, pari, contre);
}
else
{
throw new Exception("Pari introuvable !");
}
}
