public void OnGet() { Heading1 = "Chinook Music Company"; Chinook db = new Chinook(); //Albums = db.Albums.Select( a => a.AlbumId.ToString() + ". " + a.Title + " " + a.Artist.ArtistId); //Tracks = db.Tracks.Select( b => b.TrackId.ToString() + "." + b.Name + " " + b.Composer); }
// PUT api/tracks/5 public HttpResponseMessage Put(int id, [FromBody] Tracks tracks) { tracks.TrackId = id; var value = Chinook.UpsertTrack(tracks); return(Request.CreateResponse(HttpStatusCode.OK, tracks)); }
public AlbumIndexViewModel(Chinook.Repository.IMusicRepository musicRepository, int page, int pageSize = 5) { PageSize = pageSize; var albums = musicRepository.GetAlbums(); int totalRows = albums.Count(); int totalPages = (int)Math.Ceiling((double)totalRows / pageSize); int currentPage = page; if (currentPage < 1) currentPage = 1; if (currentPage > totalPages) currentPage = totalPages; int startRow = (currentPage - 1) * pageSize; CurrentPage = currentPage; TotalPages = totalPages; NextPage = currentPage < totalPages ? currentPage + 1 : (int?)null; PreviousPage = currentPage > 1 ? currentPage - 1 : (int?)null; StartingRow = startRow + 1; Albums = from a in albums.OrderBy(x => x.AlbumID).Skip(startRow).Take(pageSize) select new AlbumViewModel { AlbumID = a.AlbumID, Title = a.Title, Artist = musicRepository.GetArtists().Where(x => x.ID == a.ArtistID).Select(x => x.Name).FirstOrDefault(), }; }
public HttpResponseMessage Get(string artistId) { int id = Convert.ToInt32(artistId); var value = Chinook.AlbumsByArtist(id); return(Request.CreateResponse(HttpStatusCode.OK, value)); }
// DELETE api/tracks public HttpResponseMessage Delete([FromBody] int[] value) { foreach (int id in value) { Chinook.DeleteTrack(id); } return(Request.CreateResponse(HttpStatusCode.OK)); }
public void Non_existant_placeholder() { var c = new Chinook(); var p = new PlaceholderParser(); var d = p.Parse(c, "Hello, [Does.Not.Exist]!"); Assert.AreEqual(0, d.Count); }
public void OnGet() { Heading1 = "Albums"; // Albums = new[] {} Chinook db = new Chinook(); Albums = db.Albums.Select(a => a.AlbumId.ToString() + ". " + a.ArtistId + ". " + a.Title); }
public void No_placeholders() { var c = new Chinook(); var p = new PlaceholderParser(); var d = p.Parse(c, "Hello, world!"); Assert.AreEqual(0, d.Count); }
public void Invalid_path_placeholder() { var c = new Chinook(); var p = new PlaceholderParser(); var d = p.Parse(c, "Hello, [Track.Album.Name]!"); Assert.AreEqual(0, d.Count); }
public void No_placeholders() { var c = new Chinook(); var p = new PlaceholderParser(); var d = p.Parse(c, "Hello, world!"); Assert.AreEqual(0, d.Count); }
public void Non_existant_placeholder() { var c = new Chinook(); var p = new PlaceholderParser(); var d = p.Parse(c, "Hello, [Does.Not.Exist]!"); Assert.AreEqual(0, d.Count); }
public void Invalid_path_placeholder() { var c = new Chinook(); var p = new PlaceholderParser(); var d = p.Parse(c, "Hello, [Track.Album.Name]!"); Assert.AreEqual(0, d.Count); }
public void One_placeholder() { var c = new Chinook(); var p = new PlaceholderParser(); var d = p.Parse(c, "Hello, [Track.Name]!"); Assert.AreEqual(1, d.Count); Assert.IsTrue(d.ContainsKey("[Track.Name]")); Assert.AreEqual(new FieldPath(c.Track["Name"]), d["[Track.Name]"]); }
public void Depth2_placeholder() { var c = new Chinook(); var p = new PlaceholderParser(); var d = p.Parse(c, "Hello, [Track.AlbumId.Title]!"); Assert.AreEqual(1, d.Count); Assert.IsTrue(d.ContainsKey("[Track.AlbumId.Title]")); Assert.AreEqual(new FieldPath(c.Track["AlbumId"], c.Album["Title"]), d["[Track.AlbumId.Title]"]); }
public void Depth2_placeholder() { var c = new Chinook(); var p = new PlaceholderParser(); var d = p.Parse(c, "Hello, [Track.AlbumId.Title]!"); Assert.AreEqual(1, d.Count); Assert.IsTrue(d.ContainsKey("[Track.AlbumId.Title]")); Assert.AreEqual(new FieldPath(c.Track["AlbumId"], c.Album["Title"]), d["[Track.AlbumId.Title]"]); }
public void One_placeholder() { var c = new Chinook(); var p = new PlaceholderParser(); var d = p.Parse(c, "Hello, [Track.Name]!"); Assert.AreEqual(1, d.Count); Assert.IsTrue(d.ContainsKey("[Track.Name]")); Assert.AreEqual(new FieldPath(c.Track["Name"]), d["[Track.Name]"]); }
public void Single_field_path() { var config = new Chinook(); var factory = new Factory(); var adapter = new FieldPathComboAdapter(factory); var path = new FieldPath(config["Track"]["Name"]); var fields = factory.GetFields(path[0].Subject); adapter.SelectedPath = path; Assert.AreEqual(1, adapter.Items.Count); Assert.AreEqual(fields.Count, adapter.Items[0].Fields.Count); Assert.Contains(path[0], adapter.Items[0].Fields); }
public void Double_field_path() { var config = new Chinook(); var factory = new Factory(); var adapter = new FieldPathComboAdapter(factory); var path = new FieldPath(config["Track"]["AlbumId"], config["Album"]["Title"]); var fields1 = factory.GetFields(path[0].Subject); var fields2 = factory.GetFields(path[1].Subject); adapter.SelectedPath = path; Assert.AreEqual(2, adapter.Items.Count); Assert.AreEqual(fields1.Count, adapter.Items[0].Fields.Count); Assert.AreEqual(fields2.Count, adapter.Items[1].Fields.Count); Assert.Contains(path[0], adapter.Items[0].Fields); Assert.Contains(path[1], adapter.Items[1].Fields); }
public AlbumSearchViewModel(string phrase, Chinook.Repository.IMusicRepository musicRepository) { phrase = phrase.ToLower(); var artists = musicRepository.GetArtists().ToArray(); var artistQuery = from x in artists select x; if (!String.IsNullOrWhiteSpace(phrase)) { artistQuery = from x in artistQuery where x.Name.ToLower().Contains(phrase) select x; } var artistIDs = (from x in artistQuery select x.ID).ToArray(); var query = from x in musicRepository.GetAlbums() where artistIDs.Contains(x.ArtistID) select x; if (!String.IsNullOrWhiteSpace(phrase)) { var query2 = from x in musicRepository.GetAlbums() where x.Title.ToLower().Contains(phrase) select x; query = query.Union(query2); } var albums = query.Distinct(); Albums = from a in albums select new AlbumViewModel { AlbumID = a.AlbumID, Title = a.Title, Artist = artists.Where(x => x.ID == a.ArtistID).Select(x => x.Name).FirstOrDefault(), }; }
public void Incomplete_field_path() { var config = new Chinook(); var factory = new Factory(); var adapter = new FieldPathComboAdapter(factory); var path = new FieldPath(config["Track"]["AlbumId"], config["Album"]["ArtistId"]); var fields1 = factory.GetFields(path[0].Subject); var fields2 = factory.GetFields(path[1].Subject); var fields3 = factory.GetFields(config["Artist"]); // this should be added by SelectedPath adapter.SelectedPath = path; Assert.AreEqual(3, adapter.Items.Count); Assert.AreEqual(fields1.Count, adapter.Items[0].Fields.Count); Assert.AreEqual(fields2.Count, adapter.Items[1].Fields.Count); Assert.AreEqual(fields3.Count, adapter.Items[2].Fields.Count); Assert.Contains(path[0], adapter.Items[0].Fields); Assert.Contains(path[1], adapter.Items[1].Fields); Assert.Contains(path[2], adapter.Items[2].Fields); }
static void Main(string[] args) { Guppy guppy = new Guppy(); Console.WriteLine("============GUPPY============"); Console.WriteLine(guppy.EatsFood()); Console.WriteLine($"Guppies are HUGE fish {guppy.PetFish}"); Console.WriteLine($"Guppies are cold blooded Animals {guppy.ColdBlooded}"); Owl owl = new Owl(); Console.WriteLine("============OWL============"); Console.WriteLine($"Owls have feathers {owl.Feathers}"); Console.WriteLine($"Owls can fly {owl.CanFly()}"); Console.WriteLine($"Owls have wings {owl.Wings}"); Sockeye sockeye = new Sockeye(); Console.WriteLine("============SOCKEYE============"); Console.WriteLine(sockeye.EatsFood()); Console.WriteLine($"Sockeyes lay eggs {sockeye.LaysEggs()}"); Console.WriteLine($"Sockeye are { sockeye.Scaley} "); Chinook chinook = new Chinook(); Console.WriteLine("============CHINOOK============"); Console.WriteLine(chinook.EatsFood()); Console.WriteLine($"Chinook fish can ingest food {chinook.Heterotrophy}"); Console.WriteLine($"Chinook fish have a tail { chinook.HasTail }"); AfricanPenguin africanpenguin = new AfricanPenguin(); Console.WriteLine("============AFRICAN PENGUIN============"); Console.WriteLine($"African Penguin has feathers {africanpenguin.Feathers}"); Console.WriteLine($"African Penguins can't fly {africanpenguin.CanFly()}"); Console.WriteLine($"African Penguin have Wings { africanpenguin.Wings}"); }
public void ChinnokSwim() { Chinook chinook = new Chinook(); Assert.True(chinook.Swims()); }
public void Setup() { _db = new Chinook(); }
// GET api/tracks public HttpResponseMessage Get() { var value = Chinook.Tracks(0); return(Request.CreateResponse(HttpStatusCode.OK, value)); }
public void Setup() { _db = new Chinook(); }
// POST api/tracks public HttpResponseMessage Post([FromBody] Tracks tracks) { var value = Chinook.UpsertTrack(tracks); return(Request.CreateResponse(HttpStatusCode.OK, tracks)); }
public HttpResponseMessage Get(int id) { var value = Chinook.Albums(id); return(Request.CreateResponse(HttpStatusCode.OK, value)); }
public ChinookController(IConfiguration config) { _chinook = new Chinook(config); }
public AlbumEditViewModel(Chinook.DomainModel.Album album, Chinook.Repository.IMusicRepository musicRepository) { Album = new AlbumInputModel(album); Artists = new SelectList(musicRepository.GetArtists(), "ID", "Name", album.ArtistID); }
// DELETE api/tracks/5 public HttpResponseMessage Delete(int id) { Chinook.DeleteTrack(id); return(Request.CreateResponse(HttpStatusCode.OK)); }
public DeleteModel(Chinook context) { _context = context; }
public AlbumsModel(Chinook injectedContext) { db = injectedContext; }
public void ChinnokIsAFish() { Chinook chinook = new Chinook(); Assert.True(chinook is Fish); }