public HttpResponseMessage Get(string title) { using (ghostDBEntities entities = new ghostDBEntities()) { IEnumerable <TextReplace> textreplace = entities.TextReplaces.ToList(); IEnumerable <Track> tracklist = entities.Tracks.Where(e => e.Title.ToLower().Contains(title.ToLower())); IEnumerable <Album> albumlist = entities.Albums.ToList(); IEnumerable <Artist> artistlist = entities.Artists.ToList(); IEnumerable <Format> formatlist = entities.Formats.ToList(); string f = formatlist.FirstOrDefault(e => e.Name.Equals("GitHubFile")).Text; foreach (Track track in tracklist) { Album Album = albumlist.FirstOrDefault(e => e.idAlbum.Equals(track.idAlbum)); Artist Artist = artistlist.FirstOrDefault(e => e.idArtist.Equals(Album.idArtist)); track.Url = string.Format(f, Tools.ConvertToGitHubFolder(Artist.Name), Tools.ConvertToGitHubFolder(Album.Title), Tools.ConvertToGitHubFile(track.FileName, textreplace)); } List <Track> l = tracklist.ToList <Track>(); //var entity = entities.Tracks.Where(e => e.Title.ToLower().Contains(title.ToLower())); if (tracklist != null || tracklist.Count() == 0) { return(Request.CreateResponse <List <Track> >(HttpStatusCode.OK, l)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Tracks with title like '" + title + "' not found.")); } } }
public HttpResponseMessage Put(int id, [FromBody] TextReplace textreplace) { try { using (ghostDBEntities entities = new ghostDBEntities()) { var entity = entities.TextReplaces.FirstOrDefault(e => e.idTextReplace.Equals(id)); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Artist with id '" + id.ToString() + "' not found.")); } else { entity.OldText = textreplace.OldText; entity.NewText = textreplace.NewText; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Put(int id, [FromBody] Track track) { try { using (ghostDBEntities entities = new ghostDBEntities()) { var entity = entities.Tracks.FirstOrDefault(e => e.idTrack.Equals(id)); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Track with id '" + id.ToString() + "' not found.")); } else { entity.idAlbum = track.idAlbum; entity.Title = track.Title; entity.TrackNumber = track.TrackNumber; entity.FileName = track.FileName; entity.FileUrlName = track.FileUrlName; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Put(int id, [FromBody] User user) { try { using (ghostDBEntities entities = new ghostDBEntities()) { var entity = entities.Users.FirstOrDefault(e => e.idUser.Equals(id)); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "User with id '" + id.ToString() + "' not found.")); } else { entity.password = user.password; entity.username = user.username; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public IEnumerable <TextReplace> Get() { using (ghostDBEntities entities = new ghostDBEntities()) { return(entities.TextReplaces.ToList()); } }
public IEnumerable <User> Get() { using (ghostDBEntities entities = new ghostDBEntities()) { return(entities.Users.ToList()); } }
public IEnumerable <Artist> Get() { using (ghostDBEntities entities = new ghostDBEntities()) { return(entities.Artists.ToList()); } }
public HttpResponseMessage Put(int id, [FromBody] Album album) { try { using (ghostDBEntities entities = new ghostDBEntities()) { var entity = entities.Albums.FirstOrDefault(e => e.idAlbum.Equals(id)); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Album with id '" + id.ToString() + "' not found.")); } else { entity.idArtist = album.idArtist; entity.Title = album.Title; entity.Tracks = album.Tracks; entity.Year = album.Year; entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public HttpResponseMessage Get(int id) { using (ghostDBEntities entities = new ghostDBEntities()) { var entity = entities.Tracks.FirstOrDefault(e => e.idTrack.Equals(id)); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Track with id '" + id.ToString() + "' not found.")); } } }
public HttpResponseMessage Get(string username) { using (ghostDBEntities entities = new ghostDBEntities()) { var entity = entities.Users.FirstOrDefault(e => e.username.ToLower().Contains(username.ToLower())); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "User with name like '" + username + "' not found.")); } } }
public HttpResponseMessage Get(string title) { using (ghostDBEntities entities = new ghostDBEntities()) { var entity = entities.Albums.FirstOrDefault(e => e.Title.ToLower().Contains(title.ToLower())); if (entity != null) { return(Request.CreateResponse(HttpStatusCode.OK, entity)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Albums with title like '" + title + "' not found.")); } } }
public HttpResponseMessage Post([FromBody] Track track) { try { using (ghostDBEntities entities = new ghostDBEntities()) { entities.Tracks.Add(track); entities.SaveChanges(); var message = Request.CreateResponse(HttpStatusCode.Created, track); message.Headers.Location = new Uri(Request.RequestUri + track.idTrack.ToString()); return(message); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public IEnumerable <Track> Get() { using (ghostDBEntities entities = new ghostDBEntities()) { IEnumerable <TextReplace> textreplace = entities.TextReplaces.ToList(); IEnumerable <Track> tracklist = entities.Tracks.ToList(); IEnumerable <Album> albumlist = entities.Albums.ToList(); IEnumerable <Artist> artistlist = entities.Artists.ToList(); IEnumerable <Format> formatlist = entities.Formats.ToList(); string f = formatlist.FirstOrDefault(e => e.Name.Equals("GitHubFile")).Text; foreach (Track track in tracklist) { Album Album = albumlist.FirstOrDefault(e => e.idAlbum.Equals(track.idAlbum)); Artist Artist = artistlist.FirstOrDefault(e => e.idArtist.Equals(Album.idArtist)); track.Url = string.Format(f, Tools.ConvertToGitHubFolder(Artist.Name), Tools.ConvertToGitHubFolder(Album.Title), Tools.ConvertToGitHubFile(track.FileName, textreplace)); } return(tracklist); } }
public HttpResponseMessage Delete(int id) { try { using (ghostDBEntities entities = new ghostDBEntities()) { var entity = entities.Tracks.FirstOrDefault(e => e.idTrack.Equals(id)); if (entity == null) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Track with id '" + id.ToString() + "' not found.")); } else { entities.Tracks.Remove(entity); entities.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }