public void Update(Song model) { if (model == null || model.ID < 1) { throw new ArgumentException("Mode is not valid."); } using (ChordsDBEntities1 db = new ChordsDBEntities1()) { Song modelFromDB = db.Songs.FirstOrDefault(e => e.ID == model.ID); if (modelFromDB == null) { throw new NullReferenceException("Model by given ID doesn't exist at database."); } modelFromDB.Permission = model.Permission; modelFromDB.Language = model.Language; modelFromDB.Lyrics = model.Lyrics; modelFromDB.Comments = model.Comments; modelFromDB.Chords = model.Chords; modelFromDB.Name = model.Name; db.Entry(modelFromDB).State = EntityState.Modified; db.SaveChanges(); } }
public void Update(User model) { if (model == null || model.ID < 1) { throw new ArgumentException("Mode is not valid."); } using (ChordsDBEntities1 db = new ChordsDBEntities1()) { User modelFromDB = db.Users.FirstOrDefault(e => e.ID == model.ID); if (modelFromDB == null) { throw new NullReferenceException("Model by given ID doesn't exist at database."); } modelFromDB.Email = model.Email; modelFromDB.First_Name = model.First_Name; modelFromDB.Last_Name = model.Last_Name; modelFromDB.Password = model.Password; db.Entry(modelFromDB).State = EntityState.Modified; db.SaveChanges(); } }
public int Create(CreatedBy model) { using (ChordsDBEntities1 db = new ChordsDBEntities1()) { model = db.CreatedByArtists.Add(model); db.SaveChanges(); } return(1); }
public IEnumerable <CreatedBy> GetAll() { using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (CreatedBy ar in db.CreatedByArtists) { yield return(ar); } } }
public IEnumerable <Artist> GetAll() { using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (Artist ar in db.Artists) { yield return(ar); } } }
public IEnumerable <Song> GetAll() { using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (Song song in db.Songs) { yield return(song); } } }
public IEnumerable <User> GetAll() { using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (User user in db.Users) { yield return(user); } } }
public Song GetByID(int ID) { Song song = null; using (ChordsDBEntities1 db = new ChordsDBEntities1()) { song = db.Songs.FirstOrDefault(s => s.ID == ID); } return(song); }
public User GetByUserName(string userName) { User user = null; using (ChordsDBEntities1 db = new ChordsDBEntities1()) { user = db.Users.FirstOrDefault(s => s.Username == userName); } return(user); }
public User GetByID(int ID) { User user = null; using (ChordsDBEntities1 db = new ChordsDBEntities1()) { user = db.Users.FirstOrDefault(s => s.ID == ID); } return(user); }
public Artist GetByID(int ID) { Artist artist = null; using (ChordsDBEntities1 db = new ChordsDBEntities1()) { artist = db.Artists.FirstOrDefault(s => s.ID == ID); } return(artist); }
public int Create(User model) { int id = MaxIDInTable() + 1; using (ChordsDBEntities1 db = new ChordsDBEntities1()) { model.ID = id; model = db.Users.Add(model); db.SaveChanges(); } return(model.ID); }
public IEnumerable <Song> GetMySongs(int userID) { using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (Song song in db.Songs) { if (song.Published_By_User_ID == userID) { yield return(song); } } } }
public IEnumerable <Song> GetPubicSongs() { using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (Song song in db.Songs) { if (String.Compare(song.Permission, "Public") == 0) { yield return(song); } } } }
public IEnumerable <CreatedBy> GetAllSongsOfArtist(int artistID) { using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (CreatedBy createdby in db.CreatedByArtists) { if (createdby.Artist_ID == artistID) { yield return(createdby); } } } }
public IEnumerable <CreatedBy> GetAllArtistsOfSong(int songID) { using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (CreatedBy createdby in db.CreatedByArtists) { if (createdby.Song_ID == songID) { yield return(createdby); } } } }
public void Delete(int id) { using (ChordsDBEntities1 db = new ChordsDBEntities1()) { User user = db.Users.FirstOrDefault(x => x.ID == id); if (user == null) { throw new NullReferenceException("Attempt to remove item that doesn't exist in database."); } db.Users.Remove(user); db.Entry(user).State = EntityState.Deleted; db.SaveChanges(); } }
private int MaxIDInTable() { int id = 0; using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (User user in db.Users) { if (user.ID > id) { id = user.ID; } } } return(id); }
private int MaxIDInTable() { int id = 0; using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (Artist ar in db.Artists) { if (ar.ID > id) { id = ar.ID; } } } return(id); }
private int MaxIDInTable() { int id = 0; using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (Song song in db.Songs) { if (song.ID > id) { id = song.ID; } } } return(id); }
public IEnumerable <Song> GetSharedSongs(int userID) { using (ChordsDBEntities1 db = new ChordsDBEntities1()) { foreach (SongsAccess songA in db.SongsAccesses) { if (songA.User_ID == userID && songA.Display == true && songA.Shared_Access == true) { SongDal songDal = new SongDal(); Song song = songDal.GetByID(songA.Song_ID); if (song.Published_By_User_ID != userID && (String.Compare(song.Permission, "Shared") == 0)) { yield return(song); } } } } }