/* private MySqlConnection Connect()
* {
* string connString = "Server =127.0.0.1;Port=3306;Database=placemybet1;Uid=root;password=;SslMode=none";
* MySqlConnection con = new MySqlConnection(connString);
* return con;
* }*/
internal void calc(MercadoCuota cUpdate)
{
// MySqlConnection con = Connect();
// MySqlCommand command = con.CreateCommand();
double pOver = cUpdate.Apostado_over / (cUpdate.Apostado_over + cUpdate.Apostado_under);
double pUnder = cUpdate.Apostado_under / (cUpdate.Apostado_over + cUpdate.Apostado_under);
Debug.WriteLine("Update over: " + cUpdate.Apostado_over);
Debug.WriteLine("Update under: " + cUpdate.Apostado_under);
Debug.WriteLine("pro: " + pOver);
Debug.WriteLine("under: " + pUnder);
double cOver = 0.95;
double cUnder = 0.95;
if (pOver != 0)
{
cOver = 1 / pOver * 0.95;
}
if (pUnder != 0)
{
cUnder = (1 / pUnder) * 0.95;
}
double overDoble = Math.Round((double)Convert.ToDouble(cOver), 2);
double underDoble = Math.Round((double)Convert.ToDouble(cUnder), 2);
// con.Open();
// command.CommandText = "UPDATE mercado SET cuota_over = " + overDoble.ToString(CultureInfo.CreateSpecificCulture("us-US")) + " , cuota_under = " + underDoble.ToString(CultureInfo.CreateSpecificCulture("us-US")) + "WHERE id = " + cUpdate.MercadoId + ";";
Debug.WriteLine("cOver: " + cOver);
Debug.WriteLine("cUnder: " + cUnder);
// command.ExecuteNonQuery();
}
internal MercadoCuota cuotaUpdate()
{
// MySqlConnection con = Connect();
// MySqlCommand command = con.CreateCommand();
// command.CommandText = "SELECT * FROM mercado";
// con.Open();
// MySqlDataReader res = command.ExecuteReader();
MercadoCuota cUpdate = null;
// if (res.Read())
// {
// Debug.WriteLine("Recuperado: " + res.GetDouble(0) + " " + res.GetDouble(1));
// cUpdate = new MercadoCuota(res.GetInt32(0),res.GetDouble(4), res.GetDouble(5));
// }
// return cUpdate;
return(null);
}
