public IHttpActionResult deleteone([FromUri] System.Int32 editionId ) { LitEditionView result = db.LitEditionDbSet .Where(p => p.EditionId == editionId) .Select(itm => new LitEditionView() { editionId = itm.EditionId, editionName = itm.EditionName }).FirstOrDefault(); if (result == null) { return(NotFound()); } LitEdition entityToDelete = db.LitEditionDbSet .Where(p => p.EditionId == result.editionId) .FirstOrDefault(); if (entityToDelete == null) { return(Ok(result)); } db.LitEditionDbSet.Remove(entityToDelete); db.SaveChanges(); return(Ok(result)); }
public IHttpActionResult addone([FromBody] LitEditionView viewToAdd) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } LitEdition entityToAdd = new LitEdition(); entityToAdd.EditionId = viewToAdd.editionId; entityToAdd.EditionName = viewToAdd.editionName; db.LitEditionDbSet.Add(entityToAdd); db.SaveChanges(); LitEditionView result = db.LitEditionDbSet .Where(p => p.EditionId == entityToAdd.EditionId) .Select(itm => new LitEditionView() { editionId = itm.EditionId, editionName = itm.EditionName }).FirstOrDefault(); if (result == null) { return(NotFound()); } return(Ok(result)); }
public IHttpActionResult updateone([FromBody] LitEditionView viewToUpdate) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } LitEdition resultEntity = db.LitEditionDbSet .Where(p => p.EditionId == viewToUpdate.editionId) .FirstOrDefault(); if (resultEntity == null) { return(NotFound()); } resultEntity.EditionName = viewToUpdate.editionName; db.Entry(resultEntity).State = EntityState.Modified; db.SaveChanges(); LitEditionView result = db.LitEditionDbSet .Where(p => p.EditionId == viewToUpdate.editionId) .Select(itm => new LitEditionView() { editionId = itm.EditionId, editionName = itm.EditionName }).FirstOrDefault(); if (result == null) { return(NotFound()); } return(Ok(result)); }
public static void InsertEdition(this LitDbContext db, int EditionId, string EditionName) { if (!db.LitEditionDbSet.Any(l => (l.EditionName == EditionName))) { LitEdition edition = new LitEdition() { EditionId = EditionId, EditionName = EditionName }; db.LitEditionDbSet.Add(edition); db.SaveChanges(); db.Entry(edition).State = System.Data.Entity.EntityState.Detached; } }
public static void PopulateAuthors(this LitDbContext db) { LitGenre novel = db.LitGenreDbSet.Where(l => (l.GenreName == "Literary novel")).FirstOrDefault(); LitGenre shortStory = db.LitGenreDbSet.Where(l => (l.GenreName == "Literary short story")).FirstOrDefault(); LitGenre play = db.LitGenreDbSet.Where(l => (l.GenreName == "Literary play")).FirstOrDefault(); LitEdition firstEdition = db.LitEditionDbSet.Where(l => (l.EditionName == "First Edition")).FirstOrDefault(); int MacmillanId = InsertPublisher(db, "Macmillan Inc.", "USA", "US"); int authorId = InsertAuthor(db, "Jack", "London", new DateTime(1876, 1, 12), new DateTime(1916, 11, 22), "USA", "US"); if (authorId > -1) { int ManuscriptId = InsertManusript(db, "The Cruise of the Dazzler", new DateTime(1902, 2, 12), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "The Cruise of the Dazzler", new DateTime(1903, 2, 12), 1.2, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "A Daughter of the Snows", new DateTime(1902, 3, 14), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "A Daughter of the Snows", new DateTime(1903, 2, 12), 1.3, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "The Call of the Wild", new DateTime(1903, 4, 14), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "A Daughter of the Snows", new DateTime(1904, 4, 12), 1.3, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "The Kempton-Wace Letters", new DateTime(1903, 4, 17), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "The Kempton-Wace Letters", new DateTime(1904, 4, 12), 1.4, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "The Sea-Wolf", new DateTime(1904, 1, 17), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "The Sea-Wolf", new DateTime(1904, 4, 17), 1.5, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "The Game", new DateTime(1905, 3, 12), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "The Game", new DateTime(1906, 3, 17), 1.5, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "White Fang", new DateTime(1906, 4, 20), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "White Fang", new DateTime(1907, 4, 17), 1.5, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "Before Adam", new DateTime(1907, 7, 28), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "Before Adam", new DateTime(1908, 4, 27), 1.6, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "The Iron Heel", new DateTime(1908, 3, 27), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "The Iron Heel", new DateTime(1909, 5, 27), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "Martin Eden", new DateTime(1909, 4, 7), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "Martin Eden", new DateTime(1910, 5, 27), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "An Old Soldier's Story", new DateTime(1893, 1, 15), null, authorId, shortStory.GenreId, "en-US"); InsertBook(db, "An Old Soldier's Story", new DateTime(1894, 2, 17), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "Who Believes in Ghosts!", new DateTime(1894, 2, 12), null, authorId, shortStory.GenreId, "en-US"); InsertBook(db, "Who Believes in Ghosts!", new DateTime(1895, 5, 28), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "And 'FRISCO Kid Came Back", new DateTime(1894, 3, 11), null, authorId, shortStory.GenreId, "en-US"); InsertBook(db, "And 'FRISCO Kid Came Back", new DateTime(1895, 4, 12), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "One More Unfortunate", new DateTime(1894, 4, 27), null, authorId, shortStory.GenreId, "en-US"); InsertBook(db, "One More Unfortunate", new DateTime(1895, 4, 12), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "Night's Swim In Yeddo Bay", new DateTime(1894, 5, 17), null, authorId, shortStory.GenreId, "en-US"); InsertBook(db, "Night's Swim In Yeddo Bay", new DateTime(1895, 4, 12), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "Sakaicho, Hona Asi And Hakadaki", new DateTime(1894, 6, 7), null, authorId, shortStory.GenreId, "en-US"); InsertBook(db, "Sakaicho, Hona Asi And Hakadaki", new DateTime(1895, 4, 12), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "A Klondike Christmas", new DateTime(1896, 6, 16), null, authorId, shortStory.GenreId, "en-US"); InsertBook(db, "A Klondike Christmas", new DateTime(1897, 4, 12), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "Mahatma's Little Joke", new DateTime(1896, 6, 26), null, authorId, shortStory.GenreId, "en-US"); InsertBook(db, "Mahatma's Little Joke", new DateTime(1897, 4, 12), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "Theft", new DateTime(1909, 6, 26), null, authorId, play.GenreId, "en-US"); InsertBook(db, "Theft", new DateTime(1910, 4, 12), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "Daughters of the Rich: A One Act Play", new DateTime(1914, 5, 26), null, authorId, play.GenreId, "en-US"); InsertBook(db, "Daughters of the Rich: A One Act Play", new DateTime(1910, 4, 12), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "The Acorn Planter: A California Forest Play", new DateTime(1915, 5, 26), null, authorId, play.GenreId, "en-US"); InsertBook(db, "The Acorn Planter: A California Forest Play", new DateTime(1910, 4, 12), 1.7, MacmillanId, ManuscriptId, firstEdition.EditionId); } int scribnerMagazineId = InsertPublisher(db, "Scribner's Magazine", "USA", "US"); int scribnerSunId = InsertPublisher(db, "Charles Scribner's Sons", "USA", "US"); authorId = InsertAuthor(db, "Ernest", "Hemingway", new DateTime(1899, 7, 21), new DateTime(1961, 7, 2), "USA", "US"); if (authorId > -1) { int ManuscriptId = InsertManusript(db, "The Sun Also Rises", new DateTime(1925, 2, 12), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "The Sun Also Rises", new DateTime(1926, 2, 12), 1.2, scribnerMagazineId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "A Farewell to Arms", new DateTime(1928, 2, 12), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "A Farewell to Arms", new DateTime(1929, 2, 12), 1.2, scribnerSunId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "For Whom the Bell Tolls", new DateTime(1939, 2, 12), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "For Whom the Bell Tolls", new DateTime(1940, 2, 12), 1.2, scribnerSunId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "The Old Man and the Sea", new DateTime(1951, 2, 12), null, authorId, novel.GenreId, "en-US"); InsertBook(db, "The Old Man and the Sea", new DateTime(1952, 2, 12), 1.2, scribnerSunId, ManuscriptId, firstEdition.EditionId); } int wardLockId = InsertPublisher(db, "Ward Lock & Co", "GBR", "GB"); int stoughtonId = InsertPublisher(db, "Hodder & Stoughton", "GBR", "GB"); authorId = InsertAuthor(db, "Arthur", "Conan Doyle", new DateTime(1859, 5, 22), new DateTime(1930, 7, 7), "GBR", "GB"); { int ManuscriptId = // 20 November 1886 InsertManusript(db, "The Mystery of Cloomber", new DateTime(1887, 2, 10), null, authorId, novel.GenreId, "en-GB"); InsertBook(db, "The Mystery of Cloomber", new DateTime(1888, 11, 20), 1.2, wardLockId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "Sherlock Holmes", new DateTime(1885, 2, 10), null, authorId, novel.GenreId, "en-GB"); InsertBook(db, "Sherlock Holmes", new DateTime(1886, 11, 20), 1.2, wardLockId, ManuscriptId, firstEdition.EditionId); ManuscriptId = InsertManusript(db, "The Lost World", new DateTime(1910, 2, 12), null, authorId, novel.GenreId, "en-GB"); InsertBook(db, "The Lost World", new DateTime(1911, 2, 12), 1.2, stoughtonId, ManuscriptId, firstEdition.EditionId); } }