public User Login(User userInfo)
{
MySqlParameter[] _sqlParams = new MySqlParameter[] {
new MySqlParameter("@username", userInfo.Username),
new MySqlParameter("@password", userInfo.Password)
};
DataSet dUser = dbQuery.get("SELECT * FROM usuario as user " +
"WHERE user.login = @username AND user.senha = @password", _sqlParams);
if (dUser.Tables[0].Rows.Count > 0)
{
_user.ID = int.Parse(dUser.Tables[0].Rows[0]["id"].ToString());
_user.Name = dUser.Tables[0].Rows[0]["nome"].ToString();
_user.Role = (RoleEnum)Enum.Parse(typeof(RoleEnum), dUser.Tables[0].Rows[0]["role"].ToString());
_user.Password = dUser.Tables[0].Rows[0]["senha"].ToString();
_user.Username = dUser.Tables[0].Rows[0]["login"].ToString();
Console.WriteLine(_user.Name.ToString() + " acabou de se conectar!");
return(_user);
}
return(_user);
}
