public static bool AddNewMusic(Music music) { const string QUARY = @"Exec dbo.AddNewMusic @ID_Record, @PlayTyme, @BitRate, @Album, @Style"; var connectionString = GetConnectionString(); using (var connection = new SqlConnection(connectionString)) { using (var command = new SqlCommand(QUARY, connection)) { command.Parameters.Add("@ID_Record", SqlDbType.Int); command.Parameters["@ID_Record"].Value = music.IDRecord; command.Parameters.Add("@PlayTyme", SqlDbType.NVarChar); command.Parameters["@PlayTyme"].Value = music.PlayTime; command.Parameters.Add("@BitRate", SqlDbType.Int); command.Parameters["@BitRate"].Value = music.Bitrate; command.Parameters.Add("@Album", SqlDbType.NVarChar); command.Parameters["@Album"].Value = music.Album; command.Parameters.Add("@Style", SqlDbType.NVarChar); command.Parameters["@Style"].Value = music.Style; command.Connection.Open(); int count; try { count = command.ExecuteNonQuery(); } catch (InvalidCastException) { return false; } if (count == 1) { return true; } return false; } } }
public static void AddNewMusic(Music music) { RecordAccess.AddNewMusic(music); }
public static Music GetMusicById(int id) { const string QUARY = @"Exec dbo.GetMusicById @ID_Record"; var connectionString = GetConnectionString(); using (var connection = new SqlConnection(connectionString)) { using (var command = new SqlCommand(QUARY, connection)) { command.Parameters.Add("@ID_Record", SqlDbType.Int); command.Parameters["@ID_Record"].Value = id; command.Connection.Open(); Music result = null; using (var reader = command.ExecuteReader()) { while (reader.Read()) { result = new Music { Album = reader["Album"].ToString(), Bitrate = (int) reader["Bitrate"], IDRecord = (int) reader["ID_Record"], PlayTime = reader["PlayTime"].ToString(), Style = reader["Style"].ToString() }; } reader.Close(); } return result; } } }