public ArtistEntity FromBusinessEntity(Artist businessEntity, ArtistConvertOptions options) { if (businessEntity == null) { return(null); } ArtistEntity dataEntity = new ArtistEntity() { ID = businessEntity.ID, Name = businessEntity.Name, PrivateMarks = businessEntity.PrivateMarks, Biography = businessEntity.Biography, IsWaste = businessEntity.IsWaste }; if (options == ArtistConvertOptions.Full) { foreach (Tag tagBusinessEntity in businessEntity.Tags) { TagEntity tagDataEntity = FromBusinessEntity(tagBusinessEntity); dataEntity.Tags.Add(tagDataEntity); } foreach (Album albumBusinessEntity in businessEntity.Albums) { AlbumEntity albumDataEntity = FromBusinessEntity(albumBusinessEntity); dataEntity.Albums.Add(albumDataEntity); } } return(dataEntity); }
public Artist FromDataEntity(ArtistEntity dataEntity, ArtistConvertOptions options) { if (dataEntity == null) { return(null); } Artist businessEntity = new Artist() { ID = dataEntity.ID, Name = dataEntity.Name, PrivateMarks = dataEntity.PrivateMarks, Biography = dataEntity.Biography, IsWaste = dataEntity.IsWaste }; if (options == ArtistConvertOptions.Full) { foreach (TagEntity tagDataEntity in dataEntity.Tags) { businessEntity.Tags.Add(FromDataEntity(tagDataEntity)); } foreach (AlbumEntity albumEntity in dataEntity.Albums) { businessEntity.Albums.Add(FromDataEntity(albumEntity, AlbumConvertOptions.Small)); } } return(businessEntity); }
public Task <Status> AddArtistInfoAsync(FullArtistInfo artistInfo, CancellationToken token) { return(Task.Run(async() => { using var contextContainer = _dbContextFactory.Create(); var context = contextContainer.Context; try { var artist = new ArtistEntity { ProviderId = artistInfo.Artist.ProviderId, Name = artistInfo.Artist.Name }; context.Artists.Add(artist); await context.SaveChangesAsync(token); context.Albums.AddRange(artistInfo.Albums.Select(i => new AlbumEntity { ProviderId = i.ProviderId, Name = i.Name, ArtistId = artist.Id })); await context.SaveChangesAsync(token); return Status.Ok; } catch (Exception) { return Status.Fail; } }, token)); }
public void WhereLiteEqualsIB() { ArtistEntity michael = Database.Query <ArtistEntity>().SingleEx(a => a.Dead); var albums = (from a in Database.Query <AlbumEntity>() where a.Author.ToLite().Is(michael.ToLite()) select a.ToLite()).ToList(); }
public void WhereLiteEqualsIBA() { ArtistEntity michael = Database.Query <ArtistEntity>().SingleEx(a => a.Dead); var albums = (from n in Database.Query <NoteWithDateEntity>() where n.Target.ToLite().Is(michael.ToLite()) select n.ToLite()).ToList(); }
public static ArtistModel ToModel(this ArtistEntity artist) { return(new() { Id = artist.Id.ToItemId(), Name = artist.Name, }); }
public void CrawlArtists(List <Cast> castItems) { if (castItems == null) { return; } try { string artistPageContent = string.Empty; TableManager tblMgr = new TableManager(); List <ArtistEntity> aeList = new List <ArtistEntity>(); foreach (Cast cast in castItems) { if (string.IsNullOrEmpty(cast.link)) { continue; } HttpWebRequest request = (HttpWebRequest)WebRequest.Create(cast.link); using (HttpWebResponse response = (HttpWebResponse)request.GetResponse()) { if (response.StatusCode == HttpStatusCode.OK) { #region Get Artist Page Content using (Stream receiveStream = response.GetResponseStream()) { using (StreamReader readStream = response.CharacterSet == null ? new StreamReader(receiveStream) : new StreamReader(receiveStream, Encoding.GetEncoding(response.CharacterSet))) { artistPageContent = readStream.ReadToEnd(); } } #endregion } } ArtistEntity artist = PopulateArtistsDetails(artistPageContent, cast.link); aeList.Add(artist); } //tblMgr.UpdateArtistItemById(aeList); foreach (ArtistEntity obj in aeList) { tblMgr.UpdateArtistById(obj); } } catch (Exception ex) { Console.Write(ex.Message); } }
public void WhereLiteEquals() { ArtistEntity wretzky = Database.Query <ArtistEntity>().SingleEx(a => a.Sex == Sex.Female); BandEntity smashing = (from b in Database.Query <BandEntity>() from a in b.Members where a.ToLite().Is(wretzky.ToLite()) select b).SingleEx(); }
public void UpdateMListEntity() { using (Transaction tr = new Transaction()) { ArtistEntity artist = Database.Query <ArtistEntity>().FirstEx(); int count = Database.MListQuery((BandEntity a) => a.Members).UnsafeUpdateMList() .Set(mle => mle.Element, mle => artist) .Execute(); //tr.Commit(); } }
public void UpdateIbaLiteCoallesce() { using (Transaction tr = new Transaction()) { ArtistEntity michael = Database.Query <ArtistEntity>().SingleEx(a => a.Dead); int count = Database.Query <NoteWithDateEntity>().UnsafeUpdate() .Set(a => a.OtherTarget, a => a.OtherTarget ?? michael.ToLite()) .Execute(); //tr.Commit(); } }
public void UpdateIbaLiteConditional() { using (Transaction tr = new Transaction()) { ArtistEntity michael = Database.Query <ArtistEntity>().SingleEx(a => a.Dead); int count = Database.Query <NoteWithDateEntity>().UnsafeUpdate() .Set(a => a.OtherTarget, a => a.CreationTime > DateTime.Today ? michael.ToLite() : null) .Execute(); //tr.Commit(); } }
public void UpdateIbFieConditional() { using (Transaction tr = new Transaction()) { ArtistEntity michael = Database.Query <ArtistEntity>().SingleEx(a => a.Dead); int count = Database.Query <AlbumEntity>().UnsafeUpdate() .Set(a => a.Author, a => a.Id > 1 ? michael : null) .Execute(); //tr.Commit(); } }
public void UpdateIbaFie() { using (var tr = new Transaction()) { ArtistEntity michael = Database.Query <ArtistEntity>().SingleEx(a => a.Dead); int count = Database.Query <NoteWithDateEntity>().UnsafeUpdate() .Set(a => a.Target, a => michael) .Execute(); //tr.Commit(); } }
public void UpdateIbaConditional() { using (var tr = new Transaction()) { ArtistEntity michael = Database.Query <ArtistEntity>().SingleEx(a => a.Dead); int count = Database.Query <NoteWithDateEntity>().UnsafeUpdate() .Set(a => a.Target, a => a.CreationTime > Clock.Now ? michael : null !) .Execute(); //tr.Commit(); } }
public static bool UpdateArtistById(this IStore store, ArtistEntity artist) { Debug.Assert(artist != null); var list = new List <ArtistEntity> { artist }; var retList = store.UpdateArtistItemById(list); Debug.Assert(retList.Count == 1); var key = retList.Keys.FirstOrDefault(); return((key != null) ? retList[key] : false); }
public void UpdateMListLite() { using (Transaction tr = new Transaction()) { ArtistEntity artist = Database.Query <ArtistEntity>().FirstEx(); int count = Database.MListQuery((ArtistEntity a) => a.Friends).UnsafeUpdateMList() .Set(mle => mle.Element, mle => artist.ToLite()) .Set(mle => mle.Parent, mle => artist) .Execute(); var list = Database.MListQuery((ArtistEntity a) => a.Friends); //tr.Commit(); } }
private Artist SaveArtist(Artist artist, SoundCloudLiteContext context) { ArtistEntity result; if (artist.Id != Guid.Empty) { result = context.Artists.First(x => x.Id == artist.Id).MapToEntity(artist); } else { result = new ArtistEntity().MapToEntity(artist); result.Id = Guid.NewGuid(); context.Artists.Add(result); } return(result.MapToModel()); }
public async Task <IActionResult> Put(int id, [FromBody] ArtistEntity value) { try { var artist = myDbContext.Artist.Find(value.artistId); artist.Name = value.name; artist.Birthdate = value.birthdate; artist.Country = value.country; artist.City = value.city; myDbContext.SaveChanges(); return(Ok(artist)); } catch { return(BadRequest()); } }
private string GetTwitterHandle(string type, string name) { TableManager tbl = new TableManager(); switch (type) { case "movie": MovieEntity movie = tbl.GetMovieByUniqueName(name); return(movie.TwitterHandle); case "artist": ArtistEntity artist = tbl.GetArtist(name); return(artist.TwitterHandle); case "critics": return(string.Empty); } return(string.Empty); }
public async Task <IActionResult> Post([FromBody] ArtistEntity value) { try { var artist = new Artist() { ArtistId = value.artistId, Name = value.name, Birthdate = value.birthdate, Country = value.country, City = value.city, }; myDbContext.Add(artist); myDbContext.SaveChanges(); return(Ok(artist)); } catch { return(BadRequest()); } }
public ArtistEntity PopulateArtistsDetails(string html, string url) { try { ArtistEntity artist = new ArtistEntity(); HtmlAgilityPack.HtmlDocument htmlDoc = new HtmlAgilityPack.HtmlDocument(); htmlDoc.OptionFixNestedTags = true; htmlDoc.LoadHtml(html); if (htmlDoc.DocumentNode != null) { HtmlAgilityPack.HtmlNode bodyNode = htmlDoc.DocumentNode.SelectSingleNode("//body"); if (bodyNode == null) { Console.WriteLine("body node is null"); } else { artist.RowKey = artist.ArtistId = Guid.NewGuid().ToString(); artist.ArtistName = GetArtistName(bodyNode); artist.UniqueName = artist.ArtistName.Replace(" ", "-"); artist.Bio = GetArtistBio(bodyNode); artist.Born = GetArtistBirthDetails(bodyNode); artist.MovieList = GetMovieList(bodyNode); artist.Posters = GetArtistPosters(url + "mediaindex", artist.UniqueName, bodyNode); artist.Popularity = Util.DEFAULT_POPULARITY; artist.MyScore = Util.DEFAULT_SCORE; artist.JsonString = string.Empty; } } return(artist); } catch (Exception ex) { Console.WriteLine("Error : " + ex.Message); return(null); } }