private void UpdateGenres() { int genrerId = Convert.ToInt32(txbGenresId.Text); if (txbGenresTitle.Text == "") { MessageBox.Show("Thông tin chưa đủ"); } else { genre genre = db.genres.FirstOrDefault(x => x.gen_id == genrerId); if (genre == null) { MessageBox.Show("Genres không tồn tại, sửa không thành công"); } else { try { genre.gen_title = txbGenresTitle.Text; db.SaveChanges(); MessageBox.Show("Sửa thành công"); ReloadDataGird(); } catch (Exception) { MessageBox.Show("Sửa không thành công"); } } } }
public async Task <IHttpActionResult> Putgenre(string id, genre genre) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != genre.type) { return(BadRequest()); } db.Entry(genre).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!genreExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> Postgenre(genre genre) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.genre.Add(genre); try { await db.SaveChangesAsync(); } catch (DbUpdateException) { if (genreExists(genre.type)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = genre.type }, genre)); }
private void DeleteGenres() { int genresId = Convert.ToInt32(txbGenresId.Text); genre genre = db.genres.FirstOrDefault(x => x.gen_id == genresId); if (genre == null) { MessageBox.Show("Genres không tồn tại, xoá không thành công"); } else { try { db.genres.Remove(genre); db.SaveChanges(); MessageBox.Show("Xoá thành công"); ReloadDataGird(); } catch (Exception) { MessageBox.Show("Xoá không thành công"); } } }
//Constructors public Song(string title, string artist, double dur, genre gen) { Title = title; Artist = artist; Duration = dur; Genre = gen; }
public void add_sample_data(ChinookDbContext db) { var digital_download = new media_type() { Name = "Digital Download" }; var rock_genre = new genre() { Name = "Rock" }; var new_artist = new artist() { Name = "Bob Sacamano" }; var new_album = new album() { Title = "My stuff 2018", Artist = new_artist }; var new_track = new track() { Name = "Bad Medicine", Album = new_album, Genre = rock_genre, MediaType = digital_download }; var new_playlist = new playlist() { PlaylistId = 0, Name = "Test playlist" }; var ref_playlist_track = new playlist_track() { playlist = new_playlist, track = new_track }; new_playlist.tracks.Add(ref_playlist_track); db.playlist_tracks.Add(ref_playlist_track); db.SaveChanges(); }
public ActionResult InsertRelatedTables(int count) { List <MeasurementViewModel> results = new List <MeasurementViewModel>(); for (int i = 0; i < count; i++) { List <album> albums = new List <album>(); List <genre> genres = new List <genre>(); List <mediatype> mediaTypes = new List <mediatype>(); using (ChinookContext context = new ChinookContext()) { for (int j = 0; j < 100; j++) { album newAlbum = context.albums.Create(); newAlbum.ArtistId = 1; newAlbum.Title = "Inserted Album " + j.ToString(); albums.Add(newAlbum); genre newGenre = context.genres.Create(); newGenre.Name = "Inserted Genre " + j.ToString(); genres.Add(newGenre); mediatype newType = context.mediatypes.Create(); newType.Name = "Inserted Media Type"; mediaTypes.Add(newType); } ; List <track> tracks = new List <track>(); for (int j = 0; j < 100; j++) { track newTrack = context.tracks.Create(); newTrack.album = albums[j]; newTrack.Bytes = 123; newTrack.Composer = "Inseted Composer"; newTrack.genre = genres[j]; newTrack.mediatype = mediaTypes[j]; newTrack.Milliseconds = 123; newTrack.Name = "Inseted Track " + j.ToString(); newTrack.UnitPrice = 99; tracks.Add(newTrack); } measurement.Start(); context.tracks.AddRange(tracks); context.SaveChanges(); measurement.Stop(); results.Add(new MeasurementViewModel() { memory = measurement.memory, milliseconds = measurement.milliseconds }); } } return(View("MeasurementResults", results)); }
public VerhaalViewModel(int id, string titel, string beschrijving, genre genre, int gebrID) { this.titel = titel; this.beschrijving = beschrijving; this.genre = genre; this.gebrID = gebrID; this.ID = id; }
public ActionResult DeleteConfirmed(int id) { genre genre = db.genres.Find(id); db.genres.Remove(genre); db.SaveChanges(); return(RedirectToAction("Index")); }
public void DeleteGenre(int id) { genre genre = db.genres.Find(id); db.genres.Attach(genre); db.genres.Remove(genre); db.SaveChanges(); }
public Track(int id, string title, TimeSpan length, string artist, genre genre, int rate) { Id = id; Title = title; Length = length; Artist = artist; Genre = genre; Rate = rate; }
public async Task <ActionResult> DeleteConfirmed(int id) { genre genre = await db.genres.FindAsync(id); db.genres.Remove(genre); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public void AddGenre(genre genre) { if (genre == null) { return; } db.genres.Add(genre); db.SaveChanges(); }
public ActionResult Edit([Bind(Include = "genre_id,genre1")] genre genre) { if (ModelState.IsValid) { db.Entry(genre).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(genre)); }
public Int64 SearchGenre(string genrename) { using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext()) { genre genre = (from g in osdb.genres where g.genrename.Equals(genrename.Trim(), StringComparison.InvariantCultureIgnoreCase) select g).SingleOrDefault(); return((genre == null) ? -1 : genre.genreID); } }
public GenreForm(genre genre) { this.genre = genre; InitializeComponent(); if (genre.id == 0) { return; } textBox_GenreName.Text = genre.name; }
/// <summary> /// Retrieve the book details from the user /// </summary> /// <param name="library">The library to add the book to</param> public static void GetBookDetails(Library <Book> library) { Console.Clear(); Console.Write("Enter the title: "); string title = Console.ReadLine(); Console.Write("Enter the author's first name: "); string first = Console.ReadLine(); Console.Write("Enter the author's first name: "); string last = Console.ReadLine(); Console.Write("Enter the number of pages: "); string pageInput = Console.ReadLine(); int pages; bool validInput = Int32.TryParse(pageInput, out pages); // validate page input while (!validInput || pages <= 0) { Console.WriteLine("Invalid input"); Console.Write("Enter the number of pages: "); pageInput = Console.ReadLine(); validInput = Int32.TryParse(pageInput, out pages); } Console.WriteLine("Select Genre: "); DisplayGenres(); // get genre selection from user string selection = Console.ReadLine(); int result; bool validGenre = Int32.TryParse(selection, out result); // validation genre selection while (!validGenre || (result < 1 || result > 11)) { Console.Clear(); Console.WriteLine("Invalid selection."); Console.WriteLine(); Console.WriteLine("Select Genre: "); DisplayGenres(); selection = Console.ReadLine(); validGenre = Int32.TryParse(selection, out result); } // genre choice result genre genreChoice = GenreSelection(result); // library AddABook(title, first, last, pages, library, genreChoice); Console.Clear(); }
public async Task <ActionResult> Edit([Bind(Include = "genre_id,genre_name")] genre genre) { if (ModelState.IsValid) { db.Entry(genre).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(genre)); }
public int GetIdByIgdb(int id_igdb, string name) { genre genre = db.genre.Where(l => l.id_igdb == id_igdb).FirstOrDefault(); if (genre == null) { genre = Adicionar(id_igdb, name); } return(genre.id); }
public ActionResult Create([Bind(Include = "genre_id,genre1")] genre genre) { if (ModelState.IsValid) { db.genres.Add(genre); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(genre)); }
public async Task <IHttpActionResult> Getgenre(string id) { genre genre = await db.genre.FindAsync(id); if (genre == null) { return(NotFound()); } return(Ok(genre)); }
public ActionResult Edit(GenreViewModel genre) { genre g = genre.FromModel(); if (ModelState.IsValid) { db.Entry(g).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(genre)); }
public async Task <ActionResult> Create([Bind(Include = "genre_id,genre_name")] genre genre) { if (ModelState.IsValid) { db.genres.Add(genre); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(genre)); }
public VerhaalViewModel ToViewModel(Verhaal H) { VerhaalViewModel V; int usID = H.AuteurID; string Titel = H.Titel; string Desc = H.Beschrijving; genre Genre = (genre)((int)H.VerhaalGenre); int ID = H.ID; V = new VerhaalViewModel(ID, Titel, Desc, Genre, usID); return(V); }
private genre Adicionar(int id_igdb, string nome) { genre genre = new genre { name = nome, id_igdb = id_igdb }; db.genre.Add(genre); db.SaveChanges(); return(genre); }
static public bool IsGenreExist(genre candidate, List <genre> genres) { List <genre> existingOne = genres.Where(o => o.genre1 == candidate.genre1).ToList(); if (existingOne.Count != 0) { return(true); } else { return(false); } }
public Int64 AddGenre(string genrename) { using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext()) { genre g = new genre { genrename = genrename }; osdb.genres.InsertOnSubmit(g); osdb.SubmitChanges(); return(g.genreID); } }
// GET: Admin/Genres/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } genre genre = await db.genres.FindAsync(id); if (genre == null) { return(HttpNotFound()); } return(View(genre)); }
public async Task <IHttpActionResult> Deletegenre(string id) { genre genre = await db.genre.FindAsync(id); if (genre == null) { return(NotFound()); } db.genre.Remove(genre); await db.SaveChangesAsync(); return(Ok(genre)); }
private void btn_AddGenre_Click(object sender, EventArgs e) { genre genre = new genre(); GenreForm form = new GenreForm(genre); var result = form.ShowDialog(); if (result == DialogResult.Cancel) { return; } _model.AddGenre(form.getGenre()); Refresh(); }
// GET: genres/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } genre genre = db.genres.Find(id); if (genre == null) { return(HttpNotFound()); } return(View(genre)); }
private void Addgenre( List<string> liste) { //se if Genre exists if not add genre using (var musik = new pcindexEntities()) { List<string> list2 = (from p in musik.genres select p.Genre1 ).ToList(); liste = listcompair(liste, list2); if (liste.Count >= 1) { foreach (var onpath in liste) { var _genre = new genre(); _genre.Genre1 = onpath; musik.genres.Add(_genre); musik.SaveChanges(); } } } }
public Int64 AddGenre(string genrename) { using (OnlineShoppingDataClassesDataContext osdb = new OnlineShoppingDataClassesDataContext()) { genre g = new genre { genrename = genrename }; osdb.genres.InsertOnSubmit(g); osdb.SubmitChanges(); return g.genreID; } }