Creating Web Based Music Player System Using MVC and AngularJs

Image Link to YouTube video.

Introduction

In this article, we will learn how to create a simple web based music player system using MVC, AngularJS and Web API.

What is SHANU Music Player?

SHANU Music Player is a web-based music player system. User can upload their songs and play the selected albums. SHANU Music Player has two modules

After the user selects the album, we will check for the songs to be added in the album. If there are no songs for the selected album, then we display the message as "No Songs has been added in this Album”. If album has songs, then we display our Shanu Music Player. From this page, the user can change and play any songs from the list as per his/her choice. In the player, we will display the album image and the title along with the current playing song file name. In the list, we will also display singer name, music file name, and description of the file. User can play, pause, and play next and previous songs of the list



Album/Music CRUD (Upload and Manage Songs)



In this module, we will manage album and music information. User can add albums with images and song details and upload songs in the album.

Manage Album Details



Here, user can add album details with image. Albums are nothing but it’s a favorite or play list. First, user can create albums and add all his/her favorite songs in that album. In the database, we have created two tables. One is Album table (as master) and another is music table (as details).

Music CRUD



This is our main part as we will be adding all our music files to be played in this detail table. Here, we select our album from combobox and add music details and upload to our root directory to play our songs. Users can add new songs, edit, and delete the songs. We will see more detail in code part.

Prerequisites

• Visual Studio 2015: You can download it from here.

Code part

1. Create Database and Table.
   
   The following is the script to create a database, table, and sample insert query. Run this script in your SQL Server. I have used SQL Server 2014.
   
   1. -- =============================================
   2. -- Author : Shanu
   3. -- Create date : 2016-02-28
   4. -- Description : To Create Database
   6. -- =============================================
   7. --Script to create DB,Table and sample Insert data
   9. USE MASTER;
   11. -- 1) Check for the Database Exists .If the database is exist then drop and create new DB
   12. IF EXISTS (SELECT [name] FROM sys.databases WHERE [name] = 'musicPlayerDB' )
   13. BEGIN
   14. ALTER DATABASE musicPlayerDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
   15. DROP DATABASE musicPlayerDB ;
   16. END
   19. CREATE DATABASE musicPlayerDB
   20. GO
   22. USE musicPlayerDB
   23. GO
   25. IF EXISTS ( SELECT [name] FROM sys.tables WHERE [name] = 'AlbumMaster' )
   26. DROP TABLE AlbumMaster
   27. GO
   29. CREATE TABLE AlbumMaster
   30. (
   31. AlbumID int identity(1,1),
   32. AlbumName VARCHAR(200) NOT NULL ,
   33. ImageName VARCHAR(500) NOT NULL
   34. CONSTRAINT [PK_AlbumMaster] PRIMARY KEY CLUSTERED
   35. (
   36. [AlbumID] ASC
   38. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
   39. ) ON [PRIMARY]
   41. Insert into AlbumMaster(AlbumName,ImageName) Values('RedAlbum','RedAlbum.jpg')
   43. select * from AlbumMaster
   46. IF EXISTS ( SELECT [name] FROM sys.tables WHERE [name] = 'MusicPlayerMaster' )
   47. DROP TABLE MusicPlayerMaster
   48. GO
   50. CREATE TABLE MusicPlayerMaster
   51. (
   52. MusicID int identity(1,1),
   53. SingerName VARCHAR(100) NOT NULL ,
   54. AlbumName VARCHAR(200) NOT NULL ,
   55. MusicFileName VARCHAR(500) NOT NULL,
   56. Description VARCHAR(100) NOT NULL,
   58. CONSTRAINT [PK_MusicPlayerMaster] PRIMARY KEY CLUSTERED
   59. (
   60. [MusicID] ASC
   62. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
   63. ) ON [PRIMARY]
   65. select * from MusicPlayerMaster
   Stored Procedure : Run all this procedure one by one in your SQL Server,
   
   
   • SP to select all records of Album Details
     
     1. USE musicPlayerDB
     2. GO
     4. -- =============================================
     5. -- To Select Albumdetails
     6. -- EXEC USP_AlbumMaster_Select ''
     7. -- =============================================
     8. CREATE PROCEDURE [dbo].[USP_AlbumMaster_Select]
     9. (
     10. @AlbumName VARCHAR(100) = ''
     11. )
     12. AS
     13. BEGIN
     14. SELECT AlbumID,AlbumName , ImageName
     15. FROM AlbumMaster
     16. WHERE
     17. AlbumName like @AlbumName +'%'
     18. Order By AlbumName
     19. END
   • SP to Insert Album Details.
     
     1. USE musicPlayerDB
     2. GO
     4. -- To insert
     5. -- EXEC [USP_Album_Insert] ''
     6. -- =============================================
     7. CREATE PROCEDURE [dbo].[USP_Album_Insert]
     8. (
     9. @AlbumName VARCHAR(200) = '',
     10. @ImageName VARCHAR(500) = ''
     11. )
     12. AS
     13. BEGIN
     14. IF NOT EXISTS (SELECT * FROM AlbumMaster WHERE AlbumName=@AlbumName)
     15. BEGIN
     17. INSERT INTO [dbo].AlbumMaster (AlbumName ,ImageName )
     18. VALUES (@AlbumName ,@ImageName )
     20. Select 'Inserted' as results
     22. END
     23. ELSE
     24. BEGIN
     25. Select 'Exists' as results
     26. END
     28. END
   • SP to select all records of Music details
     
     1. USE musicPlayerDB
     2. GO
     3. -- 1) select all MusicPlayerMaster records
     5. -- Author : Shanu
     6. -- Create date : 2016-08-23
     7. -- Description :select top 10 random kidsLearnerMaster records
     8. -- Tables used : MusicPlayerMaster
     9. -- Modifier : Shanu
     10. -- Modify date : 2016-08-23
     11. -- =============================================
     12. -- To Select all user roles
     13. -- EXEC USP_MusicAlbum_SelectALL ''
     14. -- =============================================
     15. CREATE PROCEDURE [dbo].[USP_MusicAlbum_SelectALL]
     16. (
     17. @AlbumName VARCHAR(100) = ''
     18. )
     19. AS
     20. BEGIN
     21. SELECT MusicID,
     22. SingerName ,
     23. AlbumName ,
     24. MusicFileName,
     25. Description
     26. FROM MusicPlayerMaster
     27. WHERE
     28. AlbumName like @AlbumName +'%'
     30. END
   • SP to Insert Music Details
     
     1. USE musicPlayerDB
     2. GO
     4. Insert MusicPlayerMaster records
     6. -- Author : Shanu
     7. -- Create date : 2016-08-23
     8. -- Description :Insert
     9. -- Tables used : MusicPlayerMaster
     10. -- Modifier : Shanu
     11. -- Modify date : 2016-08-23
     12. -- =============================================
     13. -- To insert
     14. -- EXEC USP_MusicAlbum_Insert ''
     15. -- =============================================
     16. CREATE PROCEDURE [dbo].[USP_MusicAlbum_Insert]
     17. (
     18. @SingerName VARCHAR(100) = '',
     19. @AlbumName VARCHAR(200) = '',
     20. @MusicFileName VARCHAR(500) = '',
     21. @Description VARCHAR(100) = ''
     22. )
     23. AS
     24. BEGIN
     25. IF NOT EXISTS (SELECT * FROM MusicPlayerMaster WHERE MusicFileName=@MusicFileName)
     26. BEGIN
     28. INSERT INTO [dbo].[MusicPlayerMaster]
     29. (SingerName ,AlbumName ,MusicFileName ,Description)
     30. VALUES
     31. (@SingerName ,@AlbumName ,@MusicFileName ,@Description)
     33. Select 'Inserted' as results
     35. END
     36. ELSE
     37. BEGIN
     38. Select 'Exists' as results
     39. END
     41. END
   • SP to Update Music Details
     
     1. USE musicPlayerDB
     2. GO
     3. Update all MusicPlayerMaster records
     5. -- Author : Shanu
     6. -- Create date : 2016-08-23
     7. -- Description :Update
     8. -- Tables used : MusicPlayerMaster
     9. -- Modifier : Shanu
     10. -- Modify date : 2016-08-23
     11. -- =============================================
     12. -- To Select all user roles
     13. -- EXEC USP_MusicAlbum_Update ''
     14. -- =============================================
     15. Create PROCEDURE [dbo].[USP_MusicAlbum_Update]
     16. (
     17. @musicID VARCHAR(20) = '',
     18. @SingerName VARCHAR(100) = '',
     19. @AlbumName VARCHAR(200) = '',
     20. @MusicFileName VARCHAR(500) = '',
     21. @Description VARCHAR(100) = ''
     22. )
     23. AS
     24. BEGIN
     25. UPDATE [dbo].[MusicPlayerMaster]
     26. SET [SingerName] = @SingerName,
     27. [AlbumName] = @AlbumName,
     28. [MusicFileName] = @MusicFileName,
     29. [Description] = @Description
     30. WHERE
     31. musicID = @musicID
     32. Select 'Updated' as results
     33. END
   • SP to Delete record by Admin
     
     1. USE musicPlayerDB
     2. GO
     3. -- 5) Stored procedure To Delete KIDSLEARN
     5. -- Author : Shanu
     6. -- Create date : 2016-02-28
     7. -- Description :To Delete KIDSLEARN detail
     8. -- Tables used : kidsLearnerMaster
     9. -- Modifier : Shanu
     10. -- Modify date : 2016-02-28
     11. -- =============================================
     12. -- To delete KIDSLEARN record
     13. -- =============================================
     14. Create PROCEDURE [dbo].[USP_KIDSLEARN_Delete]
     15. ( @KIDIDENTITY VARCHAR(20) = '' )
     16. AS
     17. BEGIN
     18. DELETE FROM kidsLearnerMaster WHERE KIDIDENTITY=@KIDIDENTITY
     20. END
2. Create your MVC Web Application in Visual Studio 2015
   
   After installing the Visual Studio 2015, click Start >> Programs >> select Visual Studio 2015 >> Click Visual Studio 2015. Click New >> Project >> select Web >> ASP.NET Web Application. Enter your project name and click OK.
   
   
   
   Select MVC,WEB API and click OK.
   
   
   
   Web.Config : To upload large file size
   
   Note: Here, we need to upload music files as mp3 or wav. So, we need to upload large files to our root directory. For uploading large files in webconfig, we add the below code part,
   
   1. <system.web>
   2. <httpRuntime executionTimeout="3600" maxRequestLength="102400" />
   3. </system.web>
   5. <system.webServer>
   6. <security>
   7. <requestFiltering>
   8. <requestLimits maxAllowedContentLength="104857600" />
   9. </requestFiltering>
   10. </security>
   11. </system.webServer>

Add Database using ADO.NET Entity Data Model

Right click the project and click Add, then New Item. Select Data, then ADO.NET Entity Data Model and give the name for your EF and click Add.



Select "EF Designer from database" and click Next.



Connect to your database. Click Next to select Tables and Stored Procedure for Menu management.



Now, select all your tables and Stored procedure details and click Finish.



Procedure to add Web API Controller

Right-click the Controllers folder. Click Add and then click Controller.

Select Web API 2 Controller – Empty, click add and give name for your Web API controller.

Working with WEBAPI Controller for CRUD

Select Controller and add an Empty Web API 2 Controller. Provide your name to the Web API controller and click OK. Here, for our Web API Controller, we have given the name “MusicAPIController".

As we have created Web API controller, we can see that our controller has been inherited with ApiController. As we all know, Web API is a simple and easy way to build HTTP Services for Browsers and Mobiles.

Web API has the following four methods as Get/Post/Put and Delete where:

• Get is to request for the data. (Select)
• Post is to create a data. (Insert)
• Put is to update the data.
• Delete is to delete data.

Get Method

In our example, I have used only one Get method since I am using only one Stored Procedure. We need to create an object for our Entity and write our Get method to do Select/Insert/Update and Delete operations.

Select Operation

We use a Get method to get all the details of the both AlbumMaster and MusicDetail tables using an entity object and we return the result as IEnumerable. We use this method in our AngularJS and display the result in an MVC page from the AngularJS controller. Using Ng-Repeat, we can bind the details.

Here, we can see in the getAlbums method I have passed the search parameter to the USP_AlbumMaster_Select ALL Stored Procedure. In the Stored Procedure, I used like "%" to return all the records if the search parameter is empty.

Insert Operation

The same as select, we passed all the parameters to the insert procedure. This insert method will return the result from the database as a record is inserted or not. We will get the result and display it from the AngularJS Controller to MVC application.
Same like Album, we will be using the methods for Music Details to perform our CRUD operations here is the code for Select, Insert, Update and Delete.
Next, we will create our AngularJs Controller and View page to perform our CRUD operations to manage both Albums and MusicDetails.

Album/Music CRUD (Upload and Manage Songs)



Creating AngularJS Controller

Firstly, create a folder inside the Scripts folder and name it as “MyAngular”.



Now, add your Angular Controller inside the folder.

Right click the MyAngular folder and click Add and New Item. Select Web and then AngularJS Controller and provide a name for the Controller. I have named my AngularJS Controller “Controller.js”.



Once the AngularJS Controller is created, we can see by default the controller will have the code with the default module definition and all.

If the AngularJS package is missing, then add the package to your project. Right click your MVC project and click Manage NuGet Packages. Search for AngularJS and click Install.


Procedure to Create AngularJS Script Files

Modules.js: Here, we will add the reference to the AngularJS JavaScript and create an Angular Module named “AngularJs_Module”.
Controllers: In AngularJS Controller, I have done all the business logic and returned the data from Web API to our MVC HTML page.

1. Variable declarations
   
   Firstly, we declared all the local variables needed to be used.
   
   1. app.controller("AngularJs_Controller", function ($scope, $timeout, $rootScope, $window, $http , FileUploadService) {
   2. $scope.date = new Date();
   3. $scope.MyName = "shanu";
   4. // For Album Details
   5. $scope.AlbumIdentitys = 0;
   6. $scope.UImage = "";
   7. $scope.AlbumName = "";
   9. // For Music Details
   10. $scope.musicID = 0;
   11. $scope.SingerName = "";
   12. $scope.AlbumNameS = "RedAlbum";
   13. $scope.MusicFileName = "";
   14. $scope.Description = "";
   16. //For Visible design
   18. $scope.showMusicsAdd = false;
   19. $scope.showAlbum = true;
   20. $scope.showMusics = false;
   21. $scope.showEditMusics = false;
2. Methods
   
   Select Method
   
   In the select method, we have used $http.get to get the details of both Album and Music Details from Web API. In the get method, we will provide our API Controller name and method to get the details.
   
   The final result will be displayed to the MVC HTML page using data-ng-repeat.
   
   1. // This method is to get all the kids Learn Details to display for CRUD.
   2. selectAlbumDetails($scope.AlbumName);
   4. function selectAlbumDetails(AlbumName) {
   5. $http.get('/api/MusicAPI/getAlbums/', { params: { AlbumName: AlbumName } }).success(function (data) {
   6. $scope.AlbumData = data;
   8. if ($scope.AlbumData.length > 0) {
   9. }
   10. })
   11. .error(function () {
   12. $scope.error = "An Error has occured while loading posts!";
   13. });
   15. $http.get('/api/MusicAPI/getMusicSelectALL/', { params: { AlbumName: AlbumName } }).success(function (data) {
   16. $scope.MusicData = data;
   18. if ($scope.AlbumData.length > 0) {
   19. }
   20. })
   21. .error(function () {
   22. $scope.error = "An Error has occured while loading posts!";
   23. });
   24. }

Insert Album

For adding album, we also upload album image to our rood directory .

Note: First, create a folder named “uploads” from your solution to upload all your album images and music files like mp3.


Image Upload:.

$scope.ChechFileValid

This method checks if the attached image file is valid or not. If the image file is not valid, then display the error message.

In this method, pass the image file to the UploadFile method and once the image is uploaded successfully to our root folder, the Album details will be inserted into database.

fac.UploadFile = function (file) In this method, using $http.post, we pass our image file to the MVC Controller and our HTTPost method as in the following,
This save part explains about our Album details save to our database using AngularJS Controller. Same like this, we will be saving and uploading our music files to our root directory to play our music.

Here is the AngularJS Controller code part to perform our Music Details CRUD operation and upload Music files to our root folder.
Music Player Module

This is our main module where user can play his/her favorite songs from this page. First, we will display all Album details with images in home page.



Here, we have created one more AngularJS Controller and named it as HomeController. In this controller, we will get details of albums and music to play our songs.

Album display: First, we create a new AngularJS controller and declare all variables. In home page, we display all the album details with image and album title. By default, we call the selectAlbumDetails() method to display the album details in home page.
In home page, we display only 3 Album details in one row. To fix the 3 columns, first in home page Index View page, we add this CSS style.
In html part, we use this style in div tag to display 3 columns per row.
Music Player



In Music player part, first we declare the audio tag in html part .In audio tag, we give the source audio file from our AngularJS controller part.
To Play Songs

To play the songs, first we will be loading all the songs of the selected album. In this method, we pass our selected Album to our Web API to load all songs. If there is no records for the album, then we display the message as ("No Songs has been added in this Album" .If songs are available for the album, then we pick the first record of song and pass the song name to playMusic method.
In playMusic, we get the music file name and play the current selected songs.



Play Next Song

In Next image click, we call the nextSong method .In this method, we check and increment the selected song index to play the next song .We will pass the song name to playMusic method to play the song.
Play Previous Song

In Previous image click, we call the previousSong method .In this method, we check and decrement the selected song index to play the previous song .We will pass the song name to playMusic method to play the song.
Pause Current Song

In stop image click, we call the pauseMusic method .In this method, we pause the currently playing song.
Play Current Song

In play image click, we call the playCurrent method .In this method we continue playing of paused song.
Conclusion

Hope you all like this Shanu Music Player web based system.

This is simple web based music system developed using MVC and AngularJS. This application can be extended to add more features, like recently played songs and most played songs etc. as per your requirement.