/// <summary>
/// Retorna uma lista contendo todos os usuários cadastrados
/// </summary>
public static List <User> GetAllUsers(string connectionString)
{
List <User> users = new List <User>();
User temp;
using (var conn = new MySqlConnection(connectionString))
{
using (var cmd = conn.CreateCommand())
{
try
{
conn.Open();
cmd.CommandText = "SELECT * FROM users";
using (MySqlDataReader dataReader = cmd.ExecuteReader())
{
while (dataReader.Read())
{
temp = Maper.MapUser(dataReader);
temp.Password = null;
users.Add(temp);
}
}
return(users);
}
catch (Exception e)
{
throw e;
}
}
}
}
/// <summary>
/// Busca na base as informações do usuario para login
/// </summary>
public static User LoginRequest(string connectionString, string username)
{
User user = null;
using (var conn = new MySqlConnection(connectionString))
{
using (var cmd = conn.CreateCommand())
{
try
{
conn.Open();
cmd.CommandText = "SELECT * FROM users WHERE username = '******' AND active = True";
using (MySqlDataReader dataReader = cmd.ExecuteReader())
{
dataReader.Read();
user = Maper.MapUser(dataReader);
}
return(user);
}
catch (MySqlException e)
{
throw e;
}
}
}
}
/// <summary>
/// Retorna um usuário que corresponde ao id informado
/// </summary>
public static User GetUserById(string connectionString, int userId)
{
User user = null;
using (var conn = new MySqlConnection(connectionString))
{
using (var cmd = conn.CreateCommand())
{
try
{
conn.Open();
cmd.CommandText = "SELECT * FROM users WHERE user_id = " + userId;
using (MySqlDataReader dataReader = cmd.ExecuteReader())
{
dataReader.Read();
user = Maper.MapUser(dataReader);
}
return(user);
}
catch (MySqlException e)
{
throw e;
}
}
}
}
