public ActionResult Create([Bind(Include = "ArtistName,DOB,BirthCity")] Artist artist) { string[] DOB = artist.DOB.Split('/');//probably more effective way to check birth days but.... int ay = Int32.Parse(DOB[2]); int am = Int32.Parse(DOB[0]); int ad = Int32.Parse(DOB[1]); int yyyy = DateTime.Now.Year; int mm = DateTime.Now.Month;// jan is month 0 int dd = DateTime.Now.Day; if (ay > yyyy) { TempData["testmsg"] = "<script>alert('Birth day out of bounds ');</script>"; return(View()); } else if (ay == yyyy && am > mm) { TempData["testmsg"] = "<script>alert('Birth day out of bounds ');</script>"; return(View()); } else if (ay == yyyy && am == mm && ad > dd) { TempData["testmsg"] = "<script>alert('Birth day out of bounds ');</script>"; return(View()); } else if (ModelState.IsValid) { db.Artists.Add(artist); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(artist)); }
public ActionResult Create([Bind(Include = "ArtistKey,ArtistName,BirthDate,BirthCity")] Artist artist) { //Vareables to check the date and compare for non-sencical dates. int toDateY = DateTime.Now.Year; int toDateM = DateTime.Now.Month; int toDateD = DateTime.Now.Day; // artBY => Artist birth year ect. ect. int artBY, artBM, artBD; string[] artDates = artist.BirthDate.Split('-'); // they will only parse if valide enteries if (int.TryParse(artDates[0], out artBY)) { } else { artBY = 9999; } if (int.TryParse(artDates[1], out artBM)) { } else { artBM = 99; } if (int.TryParse(artDates[2], out artBD)) { } else { artBD = 99; } if (artBY > toDateY) { TempData["testmsg"] = "<script>alert('This is an invalide date.');</script>"; return(View()); } else if ((artBY == toDateY) && (artBM > toDateM)) { TempData["testmsg"] = "<script>alert('This is an invalide date.');</script>"; return(View()); } else if ((artBY == toDateY) && (artBM == toDateM) && (artBD > toDateD)) { TempData["testtmsg"] = "<script>alert('This is an invalide date.');</script>"; return(View()); } else if (ModelState.IsValid) { db.Artists.Add(artist); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(artist)); }
public IActionResult Create(Review view) { if (ModelState.IsValid) { _context.Review.Add(view); _context.SaveChanges(); return(RedirectToAction("Index", new { id = view.ArtistId })); } return(View(view)); }
public ActionResult Create([Bind(Include = "ArtistID,ArtistName,DOB,BirthCity")] Artist artist) { if (ModelState.IsValid) { db.Artists.Add(artist); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(artist)); }
public ActionResult Create([Bind(Include = "ID,Name,Age,Band")] Artist artist) { if (ModelState.IsValid) { db.Artists.Add(artist); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(artist)); }
public ActionResult Create(Artist artist) { if (ModelState.IsValid) { db.Artists.Add(artist); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(artist)); }
public ActionResult Create([Bind(Include = "SongID,Titel,Duration,Genre")] Song song) { if (ModelState.IsValid) { db.Songs.Add(song); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(song)); }
public IActionResult Create([FromBody] Artist item) { if (item == null) { return(BadRequest()); } _artistContext.Artists.Add(item); _artistContext.SaveChanges(); return(CreatedAtRoute("GetArtist", new { id = item.Id }, item)); }
public ActionResult Create([Bind(Include = "ArtWorkID,Title,ArtistID")] ArtWork artWork) { if (ModelState.IsValid) { db.ArtWorks.Add(artWork); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ArtistID = new SelectList(db.Artists, "ArtistID", "ArtistName", artWork.ArtistID); return(View(artWork)); }
public ActionResult Create([Bind(Include = "ClassificationID,ArtWorkID,GenreID")] Classification classification) { if (ModelState.IsValid) { db.Classifications.Add(classification); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ArtWorkID = new SelectList(db.ArtWorks, "ArtWorkID", "Title", classification.ArtWorkID); ViewBag.GenreID = new SelectList(db.Genres, "GenreID", "GenreName", classification.GenreID); return(View(classification)); }
private async void appBarButtonRefresh_Click(object sender, RoutedEventArgs e) { var artistLibraryList = await ConnectionHelper.ExecuteRequest(_remote.Host, _remote.Port, _remote.User, _remote.Pass, JsonHelper.JsonCommandAudioLibraryGetArtist()); if (artistLibraryList != "statusError" && artistLibraryList != "connectionError") { var artistList = GetInformationHelper.getAudioLibraryArtist(artistLibraryList); if (artistList != null) { // clear the database deleteArtist(); using (var db = new ArtistContext()) { try { db.Artists.AddRange(artistList); db.SaveChanges(); loadMusic(); } catch (Exception ex) { Debug.WriteLine(ex.Message); } } } } }
public ActionResult Create(FormCollection collection) { try { var newArtist = db.Artists.Create(); newArtist.Name = collection["Name"]; newArtist.BirthCity = collection["BirthCity"]; newArtist.BirthDate = collection["BirthDate"]; db.Artists.Add(newArtist); db.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
// delete all artist in database private void deleteArtist() { using (var db = new ArtistContext()) { try { db.Artists.RemoveRange(db.Artists.ToList()); db.SaveChanges(); } catch (Exception ex) { Debug.WriteLine(ex.Message); } } }
public IEnumerable <Artist> GetArtistsSecret() { var Bus = RabbitHutch.CreateBus("host=localhost"); ConcurrentStack <Artist> artistsCollection = new ConcurrentStack <Artist>(); Bus.Receive <RabbitArtist>("artist", msg => { Artist artist = new Artist() { ArtistName = msg.ArtistName, LastFmRating = msg.LastFmRating }; artistsCollection.Push(artist); }); Thread.Sleep(5000); foreach (Artist a in artistsCollection) { _context.Add(a); } _context.SaveChanges(); return(_context.Artists); }
void GenerateData() { for (int i = 0; i < 30; ++i) { var tracks = new List<Track>(); var albums = new List<Album>(); var genre = new Genre() { Name = "Rock" }; var artist = new Artist() { Name = "Name", Genre = genre, Albums = albums }; albums.Add(new Album() { Name = "Album", Artist = artist, Tracks = tracks }); tracks.Add(new Track() { Name = "Track", Artist = artist, Album = albums[0], Duration = 10, }); _artistContext.Add(artist); } _artistContext.SaveChanges(); }
public static void Initialize(IServiceProvider serviceProvider) { using (var context = new ArtistContext( serviceProvider.GetRequiredService < DbContextOptions <ArtistContext> >())) { Artist artist1 = new Artist() { Name = "Robert John Downey Jr", DayOfBirth = DateTime.Parse("1965-4-4"), Education = "Santa Monica High School", Hometown = "New York" }; Artist artist2 = new Artist() { Name = "Christopher Robert Evans", DayOfBirth = DateTime.Parse("1981-6-13"), Education = "Unknown", Hometown = "Boston,Massachusetts,US" }; Artist artist3 = new Artist() { Name = "Elizabeth Chase Olsen", DayOfBirth = DateTime.Parse("1989-2-16"), Education = "New York University", Hometown = "Los Angeles,California,US" }; //---------------------------------------------------- MavelCharacter character1 = new MavelCharacter() { Name = "Tony stark", HeroName = "Iron man", Power = "Smart,Rich,Iron man suit", Artist = artist1 }; MavelCharacter character2 = new MavelCharacter() { Name = "Steven Rogers", HeroName = "Captain America", Power = "Sodier and Shield", Artist = artist2 }; MavelCharacter character3 = new MavelCharacter() { Name = "Wanda Maximoff", HeroName = "Scarlet Witch", Power = "Mind Stone", Artist = artist3 }; //----------------------------------------------------------- List <Movies> movies = new List <Movies>() { new Movies() { Name = "Sherlock Holmes", ReleaseYear = 2011, Role = "Sherlock Holmes", Artist = artist1 }, new Movies() { Name = "Game 6", ReleaseYear = 2005, Role = "Steven Schwimmer", Artist = artist1 }, new Movies() { Name = "The Judge", ReleaseYear = 2014, Role = "Hank Palmer", Artist = artist1 } //-------------------------------- , new Movies() { Name = "Fantastic Four", ReleaseYear = 2005, Role = "Johnny Storm", Artist = artist2 }, new Movies() { Name = "Scott Pilgrim vs the World", ReleaseYear = 2010, Role = "Lucas Lee", Artist = artist2 }, new Movies() { Name = "Cellular", ReleaseYear = 2004, Role = "Ryan", Artist = artist2 } //----------------------------------- , new Movies() { Name = "Silent House", ReleaseYear = 2011, Role = "Sarah", Artist = artist3 }, new Movies() { Name = "Very Good Girls", ReleaseYear = 2013, Role = "Gerry Fields", Artist = artist3 }, new Movies() { Name = "Oldboy", ReleaseYear = 2014, Role = "Marie Sebastian", Artist = artist3 } }; context.Artists.Add(artist1); context.Artists.Add(artist2); context.Artists.Add(artist3); context.MavelCharacters.Add(character1); context.MavelCharacters.Add(character2); context.MavelCharacters.Add(character3); foreach (var item in movies) { context.Movies.Add(item); } context.SaveChanges(); } }
static void Main(string[] args) { var optionsBuilder = new DbContextOptionsBuilder <ArtistContext>() .UseSqlServer(@"Server=DESKTOP-5A54U6A;Database=ArtistContext;Trusted_Connection=True;MultipleActiveResultSets=true"); using (var context = new ArtistContext(optionsBuilder.Options)) { Console.WriteLine("Starting parsing of artists..."); using (var reader = new StreamReader(@"C:\Users\dahi1\musicbrainzdata\mbdump\artist")) { int counter = 1; while (!reader.EndOfStream) { var line = reader.ReadLine(); Console.WriteLine(line); var values = line.Split('\t'); Console.WriteLine($"Extracted {values.Length} values"); Artist art; try { art = new Artist() // See order here -> https://github.com/metabrainz/musicbrainz-server/blob/master/admin/sql/CreateTables.sql#L208 { Gid = new Guid(values[1]), Name = values[2], Sort_name = values[3], Begin_date_year = values[4] == "\\N" ? null : (int?)int.Parse(values[4]), Begin_date_month = values[5] == "\\N" ? null : (int?)int.Parse(values[5]), Begin_date_day = values[6] == "\\N" ? null : (int?)int.Parse(values[6]), End_date_year = values[7] == "\\N" ? null : (int?)int.Parse(values[7]), End_date_month = values[8] == "\\N" ? null : (int?)int.Parse(values[8]), End_date_day = values[9] == "\\N" ? null : (int?)int.Parse(values[9]), Type = values[10] == "\\N" ? null : (int?)int.Parse(values[10]), Area = values[11] == "\\N" ? null : (int?)int.Parse(values[11]), Gender = values[12] == "\\N" ? null : (int?)int.Parse(values[12]), Comment = values[13], Edits_pending = values[14] == "\\0" ? null : (int?)int.Parse(values[14]), Last_updated = values[15] == "\\N" ? null : (DateTime?)DateTime.Parse(values[15]), Ended = values[16] == "t", Begin_area = values[17] == "\\N" ? null : (int?)int.Parse(values[17]), End_area = values[18] == "\\N" ? null : (int?)int.Parse(values[18]) }; } catch (Exception e) { Console.WriteLine("Couldn't parse artist"); Console.WriteLine(e); continue; } Console.WriteLine($"Successfully parsed artist {art.Name}"); context.Artists.Add(art); if (counter >= 100) { try { Console.WriteLine("Saving batch of artists to DB..."); var result = context.SaveChanges(); Console.WriteLine($"Saved {result} artists !"); counter = 0; } catch (Exception e) { Console.WriteLine("Couldn't save artists to database"); Console.WriteLine(e); return; } } counter++; } } try { Console.WriteLine("Finished parsing artists, saving to database..."); var result = context.SaveChanges(); Console.WriteLine($"Saved {result} artists !"); } catch (Exception e) { Console.WriteLine("Couldn't save artists to database"); Console.WriteLine(e); return; } Console.WriteLine("Starting parsing of releases..."); using (var reader = new StreamReader(@"C:\Users\dahi1\musicbrainzdata\mbdump\release")) { int counter = 1; while (!reader.EndOfStream) { var line = reader.ReadLine(); Console.WriteLine(line); var values = line.Split('\t'); Console.WriteLine($"Extracted {values.Length} values"); Release rel; try { rel = new Release() // See order here -> https://github.com/metabrainz/musicbrainz-server/blob/master/admin/sql/CreateTables.sql#L208 { Gid = new Guid(values[1]), Name = values[2], Artist_credit = int.Parse(values[3]), Release_group = int.Parse(values[4]), Status = values[5] == "\\N" ? null : (int?)int.Parse(values[5]), Packaging = values[6] == "\\N" ? null : (int?)int.Parse(values[6]), Language = values[7] == "\\N" ? null : (int?)int.Parse(values[7]), Script = values[8] == "\\N" ? null : (int?)int.Parse(values[8]), Barcode = values[9], Comment = values[10], Edits_pending = values[11] == "\\0" ? null : (int?)int.Parse(values[11]), Quality = values[12] == "\\-1" ? null : (int?)int.Parse(values[12]), Last_updated = values[13] == "\\N" ? null : (DateTime?)DateTime.Parse(values[13]) }; } catch (Exception e) { Console.WriteLine("Couldn't parse release"); Console.WriteLine(e); continue; } Console.WriteLine($"Successfully parsed release {rel.Name}"); context.Releases.Add(rel); if (counter >= 100) { try { Console.WriteLine("Saving batch of releases to DB..."); var result = context.SaveChanges(); Console.WriteLine($"Saved {result} releases !"); counter = 0; } catch (Exception e) { Console.WriteLine("Couldn't save releases to database"); Console.WriteLine(e); return; } } counter++; } } try { Console.WriteLine("Finished parsing releases, saving to database..."); var result = context.SaveChanges(); Console.WriteLine($"Saved {result} releases !"); } catch (Exception e) { Console.WriteLine("Couldn't save releases to database"); Console.WriteLine(e); return; } } }
public void SaveChanges() { Context.SaveChanges(); }