public UploadFileController(IHostingEnvironment env, IOptions <ConnectionString> connString,
MusicAlbumRepository musicRepository, IOptions <RemoteCredentials> remoteCredentials)
{
this.enviroment = env;
this.connectionString = connString.Value;
this.remoteCredentials = remoteCredentials.Value;
Debug.WriteLine(connectionString.ServerInfo.IP);
}
public ActionResult Delete(int id)
{
MusicAlbumRepository musicAlbumRepository = new MusicAlbumRepository();
MusicAlbum musicAlbum = new MusicAlbum();
using (musicAlbumRepository)
{
musicAlbum = musicAlbumRepository.SelectOne(id);
}
return(View(musicAlbum));
}
public ActionResult Delete(int id, MusicAlbum musicAlbum)
{
try
{
MusicAlbumRepository musicAlbumRepository = new MusicAlbumRepository();
using (musicAlbumRepository)
{
musicAlbumRepository.Delete(id);
}
return(RedirectToAction("Index"));
}
catch
{
// TODO Add view for error message
return(View());
}
public ActionResult Create(MusicAlbum musicAlbum)
{
try
{
MusicAlbumRepository musicAlbumRepository = new MusicAlbumRepository();
using (musicAlbumRepository)
{
musicAlbumRepository.Insert(musicAlbum);
}
return(RedirectToAction("Index"));
}
catch
{
// TODO Add view for error message
return(View());
}
}
public ActionResult Index(string sortOrder)
{
//
// instantiate a repo
//
MusicAlbumRepository musicAlbumRepository = new MusicAlbumRepository();
//
// create a distinct list of cities for the artist filter
//
ViewBag.Artist = ListOfArtists();
//
// return the data context as an enumerable
//
IEnumerable <MusicAlbum> musicAlbums;
using (musicAlbumRepository)
{
musicAlbums = musicAlbumRepository.SelectAll() as IList <MusicAlbum>;
}
//
// sort by name unless posted as a new sort
//
switch (sortOrder)
{
case "Song":
musicAlbums = musicAlbums.OrderBy(musicAlbum => musicAlbum.Song);
break;
case "Artist":
musicAlbums = musicAlbums.OrderBy(musicAlbum => musicAlbum.Artist);
break;
default:
musicAlbums = musicAlbums.OrderBy(musicAlbum => musicAlbum.Song);
break;
}
return(View(musicAlbums));
}
public ActionResult Details(int id)
{
//
// instantiate a repository
//
MusicAlbumRepository musicAlbumRepository = new MusicAlbumRepository();
MusicAlbum musicAlbum = new MusicAlbum();
//
// get a brewery that has the matching id
//
using (musicAlbumRepository)
{
musicAlbum = musicAlbumRepository.SelectOne(id);
}
return(View(musicAlbum));
}
public ActionResult Index(string searchCriteria, string artistFilter)
{
//
// instantiate a repository
//
MusicAlbumRepository musicAlbumRepository = new MusicAlbumRepository();
//
// create a distinct list of artists for the artist filter
//
//IEnumerable<string> artists = ListOfArtists();
ViewBag.Artists = ListOfArtists();
//
// return the data context as an enumerable
//
IEnumerable <MusicAlbum> musicAlbums;
using (musicAlbumRepository)
{
musicAlbums = musicAlbumRepository.SelectAll() as IList <MusicAlbum>;
}
//
// if posted with a search on music album name
//
if (searchCriteria != null)
{
musicAlbums = musicAlbums.Where(musicAlbum => musicAlbum.Song.ToUpper().Contains(searchCriteria.ToUpper()));
}
//
// if posted with a filter by city
//
if (artistFilter != "" || artistFilter == null)
{
musicAlbums = musicAlbums.Where(musicAlbum => musicAlbum.Artist == artistFilter);
}
return(View(musicAlbums));
}
private IEnumerable <string> ListOfArtists()
{
//
// instantiate a repository
//
MusicAlbumRepository musicAlbumRepository = new MusicAlbumRepository();
//
// return the data context as an enumerable
//
IEnumerable <MusicAlbum> musicAlbums;
using (musicAlbumRepository)
{
musicAlbums = musicAlbumRepository.SelectAll() as IList <MusicAlbum>;
}
//
// get a distinct list of cities
//
var artist = musicAlbums.Select(musicAlbum => musicAlbum.Artist).Distinct().OrderBy(x => x);
return(artist);
}
public MusicAlbumController(MusicAlbumRepository musicRepository)
{
this.musicRepository = musicRepository;
}
public AlbumModelBinder(MusicAlbumRepository _service)
{
this.service = _service;
}
