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;
}
}
