public List <SharedLib.Models.Contact> SelectContacts(int id) { // TODO: DRY List <SharedLib.Models.Contact> contacts = new List <SharedLib.Models.Contact>(); var sql = $"SELECT u.Id, u.Name,u.Username FROM Contacts LEFT JOIN Users u ON u.Id = ReceiverId WHERE SenderId = {id}"; _command = new SqlCommand(sql, _connection); _reader = _command.ExecuteReader(); while (_reader.Read()) { var c = new SharedLib.Models.Contact(); c.ParseSqlReader(_reader); contacts.Add(c); } _reader.Close(); sql = $"SELECT u.Id, u.Name,u.Username FROM Contacts LEFT JOIN Users u ON u.Id = SenderId WHERE ReceiverId = {id}"; _command = new SqlCommand(sql, _connection); _reader = _command.ExecuteReader(); while (_reader.Read()) { var c = new SharedLib.Models.Contact(); c.ParseSqlReader(_reader); contacts.Add(c); } _reader.Close(); return(contacts); }
public List <SharedLib.Models.Contact> SearchUsers(string name) { List <SharedLib.Models.Contact> contacts = new List <SharedLib.Models.Contact>(); var sql = $"SELECT * FROM Users WHERE Username like '%{name}%' OR Name like '%{name}%'"; _command = new SqlCommand(sql, _connection); _reader = _command.ExecuteReader(); while (_reader.Read()) { var c = new SharedLib.Models.Contact(); c.ParseSqlReader(_reader); contacts.Add(c); } _reader.Close(); return(contacts); }