/// <summary>
/// This methods finds user based on forwarded username and password.
/// </summary>
/// <param name="username">User username.</param>
/// <param name="password">User password.</param>
/// <returns>User.</returns>
public vwUser FindUser(string username, string password)
{
try
{
using (AudioPlayerEntities context = new AudioPlayerEntities())
{
return(context.vwUsers.Where(x => x.Username == username && x.Password == password).FirstOrDefault());
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public List <vwSong> GetUserSongs(vwUser user)
{
try
{
using (AudioPlayerEntities context = new AudioPlayerEntities())
{
return(context.vwSongs.Where(x => x.UserId == user.UserId).ToList());
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public bool DeleteSong(vwSong song)
{
try
{
using (AudioPlayerEntities context = new AudioPlayerEntities())
{
var songToDelete = context.tblSongs.Where(x => x.SongId == song.SongId).FirstOrDefault();
context.tblSongs.Remove(songToDelete);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
/// <summary>
/// This methods add user to DbSet and save changes to database.
/// </summary>
/// <param name="username">Username.</param>
/// <param name="password">Password.</param>
/// <returns>True if user is created, false if not.</returns>
public bool CreateUser(string username, string password)
{
try
{
using (AudioPlayerEntities context = new AudioPlayerEntities())
{
tblUser user = new tblUser
{
Password = password,
Username = username
};
context.tblUsers.Add(user);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
/// <summary>
/// This method checks if forwarded username unique.
/// </summary>
/// <param name="username">Username.</param>
/// <returns>True if unique, false if not.</returns>
public bool IsUsernameUnique(string username)
{
try
{
using (AudioPlayerEntities context = new AudioPlayerEntities())
{
var list = context.vwUsers.Where(x => x.Username == username).ToList();
//if exists user with forwarded username, return false
if (list.Count() > 0)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}
public bool CreateSong(vwUser user, vwSong song)
{
try
{
using (AudioPlayerEntities context = new AudioPlayerEntities())
{
tblSong newSong = new tblSong
{
Author = song.Author,
Duration = song.Duration,
Name = song.Name,
UserId = user.UserId
};
context.tblSongs.Add(newSong);
context.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Debug.WriteLine("Exception" + ex.Message.ToString());
return(false);
}
}