/////////////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); }