public List <User> ListFriends(int id) { List <User> users = new List <User>(); string sql = @"SELECT U.* FROM FRIENDS F INNER JOIN USERS U ON (F.FRIEND = U.ID) WHERE F.USER = ?"; using (MySqlCommand command = new MySqlCommand(sql, connection)) { command.Parameters.Add(@"USER", MySqlDbType.String).Value = id; using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { User user = new User(); user.Id = reader.GetInt32("ID"); user.Name = reader.GetString("NAME"); user.Password = reader.GetString("PASSWORD"); user.RegistrationDate = utilities.JulianToDate(reader.GetInt32("REGISTRATION_DATE")); user.Email = reader.GetString("EMAIL"); user.City = reader.GetString("CITY"); user.Cpf = reader.GetString("CPF"); user.BirthDate = utilities.JulianToDate(reader.GetInt32("BIRTH_DATE")); user.Genre = reader.GetString("GENRE"); user.Description = reader.GetString("DESCRIPTION"); user.ProfilePic = reader.GetString("PROFILE_PIC"); user.CoverPic = reader.GetString("COVER_PIC"); users.Add(user); } } } return(users); }
public User Login(string email, string password) { User user = new User(); string sql = @"SELECT * FROM USERS WHERE EMAIL = ? AND PASSWORD = ?"; using (MySqlCommand command = new MySqlCommand(sql, connection)) { command.Parameters.Add(@"EMAIL", MySqlDbType.String).Value = email; command.Parameters.Add(@"PASSWORD", MySqlDbType.String).Value = password; using (MySqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { user.Id = reader.GetInt32("ID"); user.Name = reader.GetString("NAME"); user.Password = reader.GetString("PASSWORD"); user.RegistrationDate = utilities.JulianToDate(reader.GetInt32("REGISTRATION_DATE")); user.Email = reader.GetString("EMAIL"); user.City = reader.GetString("CITY"); user.Cpf = reader.GetString("CPF"); user.BirthDate = utilities.JulianToDate(reader.GetInt32("BIRTH_DATE")); user.Genre = reader.GetString("GENRE"); user.Description = reader.GetString("DESCRIPTION"); user.ProfilePic = reader.GetString("PROFILE_PIC"); user.CoverPic = reader.GetString("COVER_PIC"); } } } return(user); }