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