private void btnSubmit_Click(object sender, RoutedEventArgs e)
{
try
{
using (AudioPlayerDbEntities db = new AudioPlayerDbEntities())
{
foreach (tblUser user in db.tblUsers)
{
if (user.Username == txtUsername.Text && user.Password == txtPassword.Password)
{
_logged = true;
UserView view = new UserView();
view.ShowDialog();
break;
}
else
{
continue;;
}
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
if (_logged == false)
{
MessageBox.Show("Username or Password Incorrect.");
}
}
private void SaveExecute()
{
try
{
using (AudioPlayerDbEntities db = new AudioPlayerDbEntities())
{
db.tblSongs.Add(Song);
db.SaveChanges();
}
MessageBox.Show("Song Added Successfully!");
main.Close();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
private List <tblSong> GetAllSongs()
{
List <tblSong> songs = new List <tblSong>();
try
{
using (AudioPlayerDbEntities db = new AudioPlayerDbEntities())
{
songs = db.tblSongs.Where(s => s.Id > 0).ToList();
return(songs);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
return(null);
}
}
private bool CheckUsername(string username)
{
try
{
using (AudioPlayerDbEntities db = new AudioPlayerDbEntities())
{
if (db.tblUsers.Any(u => u.Username == username))
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
return(false);
}
}
private void SaveExecute()
{
try
{
if (CheckUsername(User.Username))
{
if (CheckPassword(User.Password))
{
try
{
using (AudioPlayerDbEntities db = new AudioPlayerDbEntities())
{
db.tblUsers.Add(User);
db.SaveChanges();
}
MessageBox.Show("Registrated Successfully!");
main.Close();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
else
{
MessageBox.Show("Password Min Lenght 6 and password must contain at least 2 Upper Letters");
}
}
else
{
MessageBox.Show("Username is already in use, please try another one.");
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.Message);
}
}
