public async void LoadDB()
{
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
await context.Users.ForEachAsync(user => { });
}
}
public string GetRecovery(string login)
{
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
var userInfo = context.Users.SingleOrDefault(user => user.Login == login);
return(userInfo.RecoveryCode);
}
}
public void UpdateTimeInApp(int time, string login)
{
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
var userInfo = context.Users.SingleOrDefault(user => user.Login == login);
userInfo.TimeInApp += time;
context.SaveChanges();
}
}
public void AddInFavorite(string login, string nameSong)
{
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
var userInfo = context.Users.SingleOrDefault(user => user.Login == login);
var newSong = context.Songs.SingleOrDefault(song => song.Name == nameSong);
userInfo.FavoritesSongs += $"{newSong.SongID} ";
context.SaveChanges();
}
}
public void DeleteSong(string name)
{
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
Songs song = context.Songs.Where(s => s.Name == name).FirstOrDefault();
context.Songs.Remove(song);
context.SaveChanges();
}
SelectSongs();
}
public void SelectSongs()
{
songsList = new Dictionary <string, string>();
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
foreach (var song in context.Songs)
{
songsList.Add(song.Name, song.Text);
}
};
}
public void AddSong(string name, string text)
{
Songs newSong = new Songs();
newSong.Name = name;
newSong.Text = text;
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
context.Songs.Add(newSong);
context.SaveChanges();
}
}
public string GetPass(string login)
{
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
foreach (var user in context.Users)
{
if (login == user.Login)
{
return(user.Password);
}
}
}
return("");
}
public void UpdateUserAvatar(string oldName, string newAvatar)
{
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
foreach (var user in context.Users)
{
if (oldName == user.Login)
{
user.Avatar = newAvatar;
}
}
context.SaveChanges();
}
}
public void UpdateUserPass(string oldName, string newPass)
{
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
foreach (var user in context.Users)
{
if (oldName == user.Login)
{
user.Password = GetHash(newPass);
}
}
context.SaveChanges();
}
}
public List <int> GetFavoriteSongList(string login)
{
try
{
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
var userInfo = context.Users.SingleOrDefault(user => user.Login == login);
return(userInfo.FavoritesSongs.Trim().Split(' ').Select(x => int.Parse(x)).ToList());
}
}
catch
{
}
return(null);
}
public async Task <int> GetTimeInApp(string login)
{
int result = 0;
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
await context.Users.ForEachAsync(user =>
{
if (user.Login == login)
{
result = (int)user.TimeInApp;
}
});
}
return(result);
}
public void DeleteFromFavorite(string login, string nameSong)
{
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
var userInfo = context.Users.SingleOrDefault(user => user.Login == login);
var curentSong = context.Songs.SingleOrDefault(song => song.Name == nameSong);
List <int> favoritesSongs = GetFavoriteSongList(login);
favoritesSongs.Remove(curentSong.SongID);
string favInDB = "";
foreach (var songId in favoritesSongs)
{
favInDB += songId + " ";
}
userInfo.FavoritesSongs = favInDB;
context.SaveChanges();
}
}
public Dictionary <string, string> SelectFavoriteSong(string login)
{
List <int> favoritesSongsId = GetFavoriteSongList(login);
Dictionary <string, string> result = new Dictionary <string, string>();
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
foreach (var songId in favoritesSongsId)
{
foreach (var song in context.Songs)
{
if (song.SongID == songId)
{
result.Add(song.Name, song.Text);
}
}
}
}
return(result);
}
public bool RecoveryPass(string login, string recoveryCode, string newPass)
{
bool result = false;
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
var userInfo = context.Users.SingleOrDefault(user => user.Login == login);
if (recoveryCode == userInfo.RecoveryCode)
{
MessageBox.Show("Пароль успешно изменен");
userInfo.Password = GetHash(newPass);
}
else
{
result = false;
MessageBox.Show("Не верный кол воостановления, поворите попытку!");
}
context.SaveChanges();
}
return(result);
}
public bool CheckOnFavorite(string login, string checkSong)
{
bool result = false;
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
var userInfo = context.Users.SingleOrDefault(user => user.Login == login);
var curentSong = context.Songs.SingleOrDefault(song => song.Name == checkSong);
List <int> favoriteSongList = GetFavoriteSongList(login);
if (favoriteSongList != null)
{
foreach (var songId in favoriteSongList)
{
if (curentSong.SongID == songId)
{
result = true;
break;
}
}
}
}
return(result);
}
public async Task <bool> SignIn(string login, string password)
{
bool result = false;
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
await context.Users.ForEachAsync(user =>
{
if ((user.Login == login) & (user.Password == GetHash(password)))
{
result = true;
}
});
}
if (result)
{
MessageBox.Show("Вход выполнен успешно!");
}
else
{
MessageBox.Show("Неправильный логин или пароль!");
}
return(result);
}
public async Task <bool> SingUp(string login, string password)
{
bool result = true;
Random rand = new Random();
Users newUser = new Users();
newUser.Login = login;
newUser.Password = GetHash(password);
newUser.Avatar = @"NoAvatar.png";
newUser.TimeInApp = 0;
newUser.FavoritesSongs = "";
newUser.RecoveryCode = rand.Next(10000, 99999).ToString();
using (GuitarHelperDBContext context = new GuitarHelperDBContext())
{
foreach (var user in context.Users)
{
if (login == user.Login)
{
MessageBox.Show("Пользователь с таким именем уже сущесвует!");
result = false;
}
}
if (result)
{
context.Users.Add(newUser);
context.SaveChanges();
MessageBox.Show("Пользователь успешно зарегистрирован!");
return(result);
}
else
{
return(result);
}
}
}