public static Playlist GetById(int id)
{
using (var dbContext = new AudioPlayerDbContext())
{
return(dbContext.Playlists.Include("MusicTracks").FirstOrDefault(x => x.PlaylistId == id));
}
}
public static IEnumerable <Playlist> GetAll(int userId)
{
using (var dbContext = new AudioPlayerDbContext())
{
return(dbContext.Playlists.Include("MusicTracks").Include("Users").Where(x => x.PlaylistOwnerId == userId).ToList());
}
}
public static IEnumerable <Genre> GetAll()
{
using (var dbContext = new AudioPlayerDbContext())
{
return(dbContext.Genres.ToList());
}
}
public static Genre GetByName(string genreName)
{
using (var dbContext = new AudioPlayerDbContext())
{
return(dbContext.Genres.FirstOrDefault(x => x.GenreName == genreName));
}
}
public static User GetUser(int id)
{
using (var dbContext = new AudioPlayerDbContext())
{
return(dbContext.Users.FirstOrDefault(x => x.UserId == id));
}
}
public static void AddOrUpdate(Playlist playlist)
{
using (var dbContext = new AudioPlayerDbContext())
{
dbContext.Playlists.AddOrUpdate(playlist);
dbContext.SaveChanges();
}
}
public static void AddOrUpdate(MusicTrack musicTrack)
{
using (var dbContext = new AudioPlayerDbContext())
{
dbContext.MusicTracks.AddOrUpdate(musicTrack);
dbContext.SaveChanges();
}
}
public static void Delete(Playlist playlist)
{
using (var dbContext = new AudioPlayerDbContext())
{
//dbContext.Entry(playlist).State = EntityState.Deleted;
dbContext.Playlists.Remove(playlist);
dbContext.SaveChanges();
}
}
public static User Authentication(string login, string password)
{
User user;
using (var dbContext = new AudioPlayerDbContext())
{
var passwordHash = AuthUtils.GetHash(password);
user = dbContext.Users.FirstOrDefault(usr => usr.UserLogin == login && usr.PasswordHash == passwordHash);
}
return(user);
}
public static IEnumerable <MusicTrackDto> GetAllInPlaylist(Playlist playlist)
{
var musicTrackDtos = new List <MusicTrackDto>();
using (var dbContext = new AudioPlayerDbContext())
{
var musicTracks = dbContext.MusicTracks.Include("Genres").Include("Users").Include("Playlists").
Where(x => x.Playlists.Any(p => p.PlaylistId == playlist.PlaylistId)).ToList();
foreach (var musicTrack in musicTracks)
{
musicTrackDtos.Add(new MusicTrackDto
{
Id = musicTrack.TrackId,
Name = musicTrack.TrackName,
AuthorName = musicTrack.TrackAuthor,
GenreName = musicTrack.Genres.GenreName
});
}
}
return(musicTrackDtos);
}
private void signInBtn_Click(object sender, EventArgs e)
{
if (FullNameTxtBox.Text == string.Empty)
{
FullNameTxtBox.BackColor = Color.IndianRed;
return;
}
if (LoginTxtBox.Text == string.Empty)
{
LoginTxtBox.BackColor = Color.IndianRed;
return;
}
if (PasswordTxtBox.Text == string.Empty || ConfirmPasswordTxtBox.Text == string.Empty || PasswordTxtBox.Text != ConfirmPasswordTxtBox.Text)
{
PasswordTxtBox.BackColor = Color.IndianRed;
ConfirmPasswordTxtBox.BackColor = Color.IndianRed;
return;
}
using (var dbContext = new AudioPlayerDbContext())
{
_user.UserFullName = FullNameTxtBox.Text;
_user.UserLogin = LoginTxtBox.Text;
if (_user.PasswordHash != PasswordTxtBox.Text)
{
_user.PasswordHash = AuthUtils.GetHash(PasswordTxtBox.Text);
}
dbContext.Users.AddOrUpdate(_user);
dbContext.SaveChanges();
}
DialogResult = DialogResult.OK;
Close();
}
