public static int InsertBook(this LitDbContext db, string BookTitle, DateTime PublicationDate, Double Price, int PublisherIdRef, int ManuscriptIdRef, int?EditionIdRef) { int result = -1; LitBook book = db.LitBookDbSet.Where(a => (a.BookTitle == BookTitle) && (a.PublisherIdRef == PublisherIdRef) && (a.ManuscriptIdRef == ManuscriptIdRef)).FirstOrDefault(); if (book != null) { result = book.BookId; db.Entry(book).State = System.Data.Entity.EntityState.Detached; return(result); } book = new LitBook() { BookTitle = BookTitle, PublicationDate = PublicationDate, Price = Price, PublisherIdRef = PublisherIdRef, ManuscriptIdRef = ManuscriptIdRef, EditionIdRef = EditionIdRef }; db.LitBookDbSet.Add(book); db.SaveChanges(); result = book.BookId; db.Entry(book).State = System.Data.Entity.EntityState.Detached; return(result); }
public static int InsertAuthor(this LitDbContext db, string FirstName, string LastName, DateTime BirthDate, DateTime DeathDate, string Iso3CntrRef, string Iso2CntrRef) { int result = -1; LitAuthor author = db.LitAuthorDbSet.Where(a => (a.FirstName == FirstName) && (a.LastName == LastName)).FirstOrDefault(); if (author != null) { result = author.AuthorId; db.Entry(author).State = System.Data.Entity.EntityState.Detached; return(result); } author = new LitAuthor() { FirstName = FirstName, LastName = LastName, BirthDate = BirthDate, DeathDate = DeathDate, Iso3CntrRef = Iso3CntrRef, Iso2CntrRef = Iso2CntrRef }; db.LitAuthorDbSet.Add(author); db.SaveChanges(); result = author.AuthorId; db.Entry(author).State = System.Data.Entity.EntityState.Detached; return(result); }
public static int InsertManusript(this LitDbContext db, string ManuscriptTitle, DateTime CompletionDate, DateTime?BeginningDate, int AuthorIdRef, int GenreIdRef, string DialectIdRef) { int result = -1; LitManuscript manuscript = db.LitManuscriptDbSet.Where(a => (a.ManuscriptTitle == ManuscriptTitle) && (a.AuthorIdRef == AuthorIdRef)).FirstOrDefault(); if (manuscript != null) { result = manuscript.ManuscriptId; db.Entry(manuscript).State = System.Data.Entity.EntityState.Detached; return(result); } manuscript = new LitManuscript() { ManuscriptTitle = ManuscriptTitle, CompletionDate = CompletionDate, BeginningDate = BeginningDate, AuthorIdRef = AuthorIdRef, GenreIdRef = GenreIdRef, DialectIdRef = DialectIdRef }; db.LitManuscriptDbSet.Add(manuscript); db.SaveChanges(); result = manuscript.ManuscriptId; db.Entry(manuscript).State = System.Data.Entity.EntityState.Detached; return(result); }
public static void PopulateEditions(this LitDbContext db) { InsertEdition(db, 1, "First Edition"); InsertEdition(db, 2, "Second Edition"); InsertEdition(db, 3, "Third Edition"); InsertEdition(db, 4, "Fourth Edition"); }
public static void PopulateGengers(this LitDbContext db) { db.InsertGenger(1, "Literary novel"); db.InsertGenger(2, "Literary story"); db.InsertGenger(3, "Literary essay"); db.InsertGenger(4, "Literary poem"); db.InsertGenger(5, "Literary short story"); db.InsertGenger(6, "Literary play"); }
private void MenuItem_Click_1(object sender, RoutedEventArgs e) { // Create db Database.SetInitializer( new DropCreateDatabaseAlways <LitDbContext>()); LitDbContext db = new LitDbContext(); db.LitGenreDbSet.FirstOrDefault(); MessageBox.Show("The database was successfully created.", "Done", MessageBoxButton.OK, MessageBoxImage.Information); Database.SetInitializer(new CreateDatabaseIfNotExists <LitDbContext>()); }
private void MenuItem_Click_6(object sender, RoutedEventArgs e) { LitDbContext db = new LitDbContext(); try { db.PopulateCounties(); MessageBox.Show("The Counties was successfully saved.", "Done", MessageBoxButton.OK, MessageBoxImage.Information); } catch (Exception expt) { ErrorTextBox.Text = expt.Message; } }
public static void InsertGenger(this LitDbContext db, int GenreId, string GenreName) { if (!db.LitGenreDbSet.Any(l => (l.GenreName == GenreName))) { LitGenre genre = new LitGenre() { GenreId = GenreId, GenreName = GenreName }; db.LitGenreDbSet.Add(genre); db.SaveChanges(); db.Entry(genre).State = System.Data.Entity.EntityState.Detached; } }
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 PopulateDialects(this LitDbContext db) { CultureInfo[] cultureInfos = CultureInfo.GetCultures(CultureTypes.AllCultures & CultureTypes.SpecificCultures); foreach (CultureInfo cultureInfo in cultureInfos) { if (string.IsNullOrEmpty(cultureInfo.Name)) { continue; } RegionInfo regionInfo = new RegionInfo(cultureInfo.Name); if (!db.LitLanguageDbSet.Any(l => (l.Iso3 == cultureInfo.ThreeLetterISOLanguageName) && (l.Iso2 == cultureInfo.TwoLetterISOLanguageName))) { continue; } if (!db.LitCountryDbSet.Any(c => (c.Iso3 == regionInfo.ThreeLetterISORegionName) && (c.Iso2 == regionInfo.TwoLetterISORegionName))) { continue; } if (db.LitDialectDbSet.Any(d => d.DialectId == cultureInfo.Name)) { continue; } if (!db.LitDialectDbSet.Any(d => (d.Iso3CntrRef == regionInfo.ThreeLetterISORegionName) && (d.Iso2CntrRef == regionInfo.TwoLetterISORegionName) && (d.Iso3LngRef == cultureInfo.ThreeLetterISOLanguageName) && (d.Iso2LngRef == cultureInfo.TwoLetterISOLanguageName))) { LitDialect dialect = new LitDialect() { DialectId = cultureInfo.Name, Iso3CntrRef = regionInfo.ThreeLetterISORegionName, Iso2CntrRef = regionInfo.TwoLetterISORegionName, Iso3LngRef = cultureInfo.ThreeLetterISOLanguageName, Iso2LngRef = cultureInfo.TwoLetterISOLanguageName, DialectName = cultureInfo.EnglishName }; db.LitDialectDbSet.Add(dialect); db.SaveChanges(); db.Entry(dialect).State = System.Data.Entity.EntityState.Detached; } } }
public static int InsertPublisher(this LitDbContext db, string PublisherName, string Iso3CntrRef, string Iso2CntrRef) { int result = -1; LitPublisher publisher = db.LitPublisherDbSet.Where(a => (a.PublisherName == PublisherName) && (a.Iso3CntrRef == Iso3CntrRef)).FirstOrDefault(); if (publisher != null) { result = publisher.PublisherId; db.Entry(publisher).State = System.Data.Entity.EntityState.Detached; return(result); } publisher = new LitPublisher() { PublisherName = PublisherName, Iso3CntrRef = Iso3CntrRef, Iso2CntrRef = Iso2CntrRef }; db.LitPublisherDbSet.Add(publisher); db.SaveChanges(); result = publisher.PublisherId; db.Entry(publisher).State = System.Data.Entity.EntityState.Detached; return(result); }
public static void PopulateLanguages(this LitDbContext db) { CultureInfo[] cultureInfos = CultureInfo.GetCultures(CultureTypes.NeutralCultures); foreach (CultureInfo cultureInfo in cultureInfos) { if (string.IsNullOrEmpty(cultureInfo.Name)) { continue; } if (!db.LitLanguageDbSet.Any(l => (l.Iso3 == cultureInfo.ThreeLetterISOLanguageName) && (l.Iso2 == cultureInfo.TwoLetterISOLanguageName))) { LitLanguage lang = new LitLanguage() { Iso3 = cultureInfo.ThreeLetterISOLanguageName, Iso2 = cultureInfo.TwoLetterISOLanguageName, LanguageName = cultureInfo.EnglishName }; db.LitLanguageDbSet.Add(lang); db.SaveChanges(); db.Entry(lang).State = System.Data.Entity.EntityState.Detached; } } }
public static void PopulateCounties(this LitDbContext db) { CultureInfo[] cultureInfos = CultureInfo.GetCultures(CultureTypes.AllCultures & CultureTypes.SpecificCultures); foreach (CultureInfo cultureInfo in cultureInfos) { if (string.IsNullOrEmpty(cultureInfo.Name)) { continue; } RegionInfo regionInfo = new RegionInfo(cultureInfo.Name); if (!db.LitCountryDbSet.Any(c => (c.Iso3 == regionInfo.ThreeLetterISORegionName) && (c.Iso2 == regionInfo.TwoLetterISORegionName))) { LitCountry сountry = new LitCountry() { Iso3 = regionInfo.ThreeLetterISORegionName, Iso2 = regionInfo.TwoLetterISORegionName, CountryName = regionInfo.EnglishName }; db.LitCountryDbSet.Add(сountry); db.SaveChanges(); db.Entry(сountry).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); } }
public static void PopulatePublishers(this LitDbContext db) { InsertPublisher(db, "Macmillan Inc.", "USA", "US"); }