/* 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); }