/////////////CHANGE!! - FOR ALL IN ARCHIVE AND IN CURRENT SONGS!!------
public async Task ChangeYouTubeId(string name, string Id, string toId)
{
var actuallSongs = await GetByNameFromActuall(name);
var archiveSongs = await GetByYouTubeFromArchive(Id);
if (actuallSongs.Count > 0)
{
foreach (var actuallSong in actuallSongs)
{
actuallSong.ChangeYouTubeId(toId);
_liveContext.Update(actuallSong);
}
}
if (archiveSongs.Count > 0)
{
foreach (var achiveSong in archiveSongs)
{
achiveSong.ChangeYouTubeId(toId);
_liveContext.Update(achiveSong);
}
}
/* if(archiveSong != null)
* {
* archiveSong.ChangeYouTubeId(toId);
*
* _liveContext.Update(archiveSong);
* } */
await _liveContext.SaveChangesAsync();
}
public async Task <UserDto> SocialLoginAsync(string userId, string name, string email, string authType)
{
User user = _liveContext.Users.FirstOrDefault(x => x.UserEmail == email && x.AuthType == authType && x.UserSocialId == userId);
//bool sended = _emailService.ResetPassword(user, new Guid());
if (user == null)
{
//Console.WriteLine("Save user to database");
if (string.IsNullOrEmpty(email))
{
var wrong = new UserDto();
wrong.Email = "noEmail";
return(wrong);
}
else
{
User newUser = new User(userId, name, email, authType, "USER");
// var usersCount = _liveContext.Users.
await _liveContext.AddAsync(newUser);
await _liveContext.SaveChangesAsync();
var userDto = _autoMapper.Map <UserDto>(newUser);
userDto.JwtToken = _jwtService.CreateToken(newUser.ID, newUser.UserRole).Token;
return(userDto);
}
}
else
{
if (!user.IsActive)
{
Log.Warning($"Try get deactivate user: {user.UserName}");
return(null);
}
//Console.WriteLine($"login existing user: {user.UserYoutubes.Count}");
//user.UserYoutubes.Add(new UserYoutube("dVVsa","dVVVas","dVVfs","gdVVV"));
user.NextLogin();
_liveContext.Update(user);
await _liveContext.SaveChangesAsync();
}
var userDtoExist = _autoMapper.Map <UserDto>(user);
userDtoExist.JwtToken = _jwtService.CreateToken(user.ID, user.UserRole).Token;
return(userDtoExist);
}
public async Task <object> AddEntityToFolder(Guid userId, string folderId, string entityId, string entityType)
{
//Console.WriteLine("FOLDER ID!: "+ folderId);
Folder folder = null;
if (entityType == "YT" || entityType == "MOVIE")
{
var entity = _liveContext.UserYoutubes.FirstOrDefault(x => x.UserId == userId && x.VideoId == entityId);
if (entity != null)
{
entity.SetFolder(new Guid(folderId));
_liveContext.Update(entity);
}
}
if (entityType == "IMG" || entityType == "BOOK")
{
var entityImg = _liveContext.UserImages.FirstOrDefault(x => x.UserId == userId && x.UrlAddress == entityId);
entityImg.SetFolder(new Guid(folderId));
_liveContext.Update(entityImg);
}
if (entityType == "SPOTIFY")
{
var entityImg = _liveContext.UserSpotify.FirstOrDefault(x => x.UserId == userId && x.SpotifyId == entityId);
entityImg.SetFolder(new Guid(folderId));
_liveContext.Update(entityImg);
}
folder = _liveContext.Folders
.Include(x => x.UserYouTubes)
.Include(x => x.UserImages)
.Include(x => x.UserSpotify)
.FirstOrDefault(x => x.ID.ToString() == folderId);
folder.UpdateFolder();
await _liveContext.SaveChangesAsync();
folder.SetFourIcons();
//Console.WriteLine($"Folder has youtbes: {folder.UserYouTubes.Count}");
return(new { folder = _autoMapper.Map <FolderDto>(folder), entityId = entityId });
}
public async Task ChangeBookTitle(string id, string newTitle, string newAuthor)
{
var book = _liveContext.Bestsellers.FirstOrDefault(x => x.ImageSrc == id);
if (book != null)
{
book.ChangeTitleAndAuthor(newTitle, newAuthor);
_liveContext.Update(book);
await _liveContext.SaveChangesAsync();
}
}
public async Task <UserAdminDto> ChangeUserStatus(SocialLogin user)
{
var exUser = _liveContext.Users.FirstOrDefault(x => x.UserEmail == user.Email && x.AuthType == user.AuthType);
//Console.WriteLine("-----" + user.Email);
// Console.WriteLine("-----" + user.AuthType);
if (exUser != null)
{
exUser.ChangeStatus();
_liveContext.Update(exUser);
await _liveContext.SaveChangesAsync();
return(_autoMapper.Map <UserAdminDto>(exUser));
}
return(null);
}
public async Task <string> ChangeRating(string newRating, string videoId)
{
var movies = await _liveContext.TVMovies.Include(x => x.YouTube)
.Where(x => x.YouTube.VideoID == videoId).ToListAsync();
var archMovies = await _liveContext.ArchiveMovies.Include(x => x.YouTube)
.Where(x => x.YouTube.VideoID == videoId).ToListAsync();
string rating = "0,0";
var actuallMovie = movies.FirstOrDefault();
if (actuallMovie != null)
{
if (string.IsNullOrEmpty(newRating))
{
rating = actuallMovie.getFilmwebRating();
}
else
{
rating = newRating;
}
_liveContext.Update(actuallMovie);
foreach (var movie in movies)
{
movie.changeRating(rating);
//movie.getFilmwebRating();
_liveContext.Update(movie);
}
foreach (var movie in archMovies)
{
movie.changeRating(rating);
//movie.getFilmwebRating();
_liveContext.Update(movie);
}
}
await _liveContext.SaveChangesAsync();
return(rating);
}