public static SongsDTO getSongByID(int id) { using (SqlConnection conn = new SqlConnection(connString)) { try { conn.Open(); String sqlQuery = String.Format("Select * from Songs where SongID = {0}", id); SqlCommand comm = new SqlCommand(sqlQuery, conn); SqlDataReader reader = comm.ExecuteReader(); SongsDTO dto = new SongsDTO(); if (reader.Read() == true) { dto.SongID = reader.GetInt32(0); dto.Name = reader.GetString(1); dto.Singer = reader.GetString(2); dto.Link = reader.GetString(3); } return(dto); } catch (Exception ex) { return(null); } } }
public static List <SongsDTO> getAllSongs() { using (SqlConnection conn = new SqlConnection(connString)) { try { conn.Open(); String sqlQuery = String.Format("Select * from Songs"); SqlCommand comm = new SqlCommand(sqlQuery, conn); SqlDataReader reader = comm.ExecuteReader(); List <SongsDTO> list = new List <SongsDTO>(); while (reader.Read() == true) { SongsDTO dto = new SongsDTO(); dto.SongID = reader.GetInt32(0); dto.Name = reader.GetString(1); dto.Singer = reader.GetString(2); dto.Link = reader.GetString(3); list.Add(dto); } return(list); } catch (Exception ex) { return(null); } } }