public int ResultadoPronostico(Usuario u) { SQLServerConnection connection = SQLServerConnection.GetInstance(connectionString); string consulta = String.Format("SELECT * FROM PronosticoPartido WHERE idUsuario = {0}", u.Id); DbDataReader reader = connection.Execute(consulta); List <int> pronosticados = new List <int>(); List <int> reales = new List <int>(); int puntaje = 0; while (reader.Read()) { pronosticados.Add(reader.GetInt32(2)); pronosticados.Add(reader.GetInt32(3)); } consulta = String.Format("SELECT * FROM Partido"); reader = connection.Execute(consulta); while (reader.Read()) { reales.Add(reader.GetInt32(2)); reales.Add(reader.GetInt32(3)); } for (int i = 0; i < 32; i = i + 2) { puntaje += PuntosPartido(pronosticados[i], pronosticados[i + 1], reales[i], reales[i + 1]); } return(puntaje); }
public void AsociarMailToken(string email, string token) { SQLServerConnection connection = SQLServerConnection.GetInstance(connectionString); string consulta = String.Format("SELECT * FROM Token WHERE Token = '{0}'", token); DbDataReader reader = connection.Execute(consulta); if (!reader.Read()) { throw new NoExisteElTokenException(); } reader.Close(); consulta = String.Format("SELECT * FROM Token t, Usuario u WHERE t.token = '{0}' AND t.idUsuario = u.id AND u.email = '{1}'", token, email); reader = connection.Execute(consulta); if (reader.Read()) { throw new YaEstaAsociadoElUsuarioConElTokenException(); } reader.Close(); consulta = String.Format("SELECT * FROM Token WHERE token = '{0}' AND idUsuario = -1", token); reader = connection.Execute(consulta); if (!reader.Read()) { throw new YaEstaAsociadoElTokenConOtroUsuarioException(); } AgregarUsuario(email, token); Usuario usuario = GetUsuarioPorToken(token); connection.ExecuteNonQuery(String.Format("UPDATE Token SET idUsuario = {0} WHERE Token = '{1}'", usuario.Id, token)); }
public string GetTokenPorEmail(string email) { SQLServerConnection connection = SQLServerConnection.GetInstance(connectionString); DbDataReader reader = connection.Execute(String.Format("SELECT * FROM Usuario u, Token t WHERE u.email = '{0}' AND u.Id = t.idUsuario", email) /*"SELECT * FROM Usuario u, Token t WHERE email = '{0}' and u.Id = t.idUsuario", email)*/); reader.Read(); return(reader.GetString(3)); }
public string RecuperarPronostico(Usuario u) { SQLServerConnection connection = SQLServerConnection.GetInstance(connectionString); string consulta = String.Format("SELECT * FROM PronosticoPartido WHERE idUsuario = {0}", u.Id); string pronosticos = ""; DbDataReader reader = connection.Execute(consulta); while (reader.Read()) { pronosticos += reader.GetInt32(2) + ";"; pronosticos += reader.GetInt32(3) + ";"; } pronosticos = pronosticos.Substring(0, pronosticos.Length - 1); return(pronosticos); }
private string connectionString = ConfigurationManager.ConnectionStrings["mydb"].ToString();//"Data Source=GABRIEL-PC;Initial Catalog=Pencas;Integrated Security=True; MultipleActiveResultSets=True;"; public List <Usuario> GetUsuarios() { List <Usuario> retorno = new List <Usuario>(); SQLServerConnection connection = SQLServerConnection.GetInstance(connectionString); DbDataReader reader = connection.Execute("SELECT * FROM Usuario"); while (reader.Read()) { Usuario u = new Usuario(); u.Id = reader.GetInt32(0); u.Nombre = reader.GetString(1); retorno.Add(u); } reader.Close(); return(retorno); }
public Usuario GetUsuarioPorEmail(string email) { SQLServerConnection connection = SQLServerConnection.GetInstance(connectionString); DbDataReader reader = connection.Execute(String.Format("SELECT * FROM Usuario WHERE email = '{0}'", email) /*"SELECT * FROM Usuario u, Token t WHERE email = '{0}' and u.Id = t.idUsuario", email)*/); if (reader.Read()) { Usuario u = new Usuario(); u.Id = reader.GetInt32(0); u.Nombre = reader.GetString(1); u.EnvioPronostico = reader.GetBoolean(2); return(u); } else { throw new NoExisteUsuarioException(); } }
//public Usuario GetUsuarioPorEmail(string email) //{ // SQLServerConnection connection = SQLServerConnection.GetInstance(connectionString); // DbDataReader reader = connection.Execute(String.Format("SELECT * FROM Usuario WHERE email = '{0}'", email)/*"SELECT * FROM Usuario u, Token t WHERE email = '{0}' and u.Id = t.idUsuario", email)*/); // if (reader.Read()) // { // Usuario u = new Usuario(); // u.Id = reader.GetInt32(0); // u.Email = reader.GetString(1); // u.Token = reader.GetString(2); // u.Puntaje = reader.GetInt32(3); // return u; // } // else // { // throw new NoExisteUsuarioException(); // } //} //public string GetTokenPorEmail(string email) //{ // SQLServerConnection connection = SQLServerConnection.GetInstance(connectionString); // DbDataReader reader = connection.Execute(String.Format("SELECT * FROM Usuario u, Token t WHERE u.email = '{0}' AND u.Id = t.idUsuario", email)/*"SELECT * FROM Usuario u, Token t WHERE email = '{0}' and u.Id = t.idUsuario", email)*/); // reader.Read(); // return reader.GetString(3); //} public Usuario GetUsuarioPorToken(string token) { SQLServerConnection connection = SQLServerConnection.GetInstance(connectionString); DbDataReader reader = connection.Execute(String.Format("SELECT * FROM Usuario WHERE token = '{0}'", token)); if (reader.Read()) { Usuario u = new Usuario(); u.Id = reader.GetInt32(0); u.Email = reader.GetString(1); u.Token = reader.GetString(2); u.Puntaje = reader.GetInt32(3); return(u); } else { throw new NoExisteUsuarioException(); } }