private async void appBarButtonRefresh_Click(object sender, RoutedEventArgs e)
{
var artistLibraryList = await ConnectionHelper.ExecuteRequest(_remote.Host, _remote.Port, _remote.User, _remote.Pass, JsonHelper.JsonCommandAudioLibraryGetArtist());
if (artistLibraryList != "statusError" && artistLibraryList != "connectionError")
{
var artistList = GetInformationHelper.getAudioLibraryArtist(artistLibraryList);
if (artistList != null)
{
// clear the database
deleteArtist();
using (var db = new ArtistContext())
{
try
{
db.Artists.AddRange(artistList);
db.SaveChanges();
loadMusic();
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
}
}
}
// GET: Artist
/// <summary>
/// 選択済みアーティスト一覧の表示
/// </summary>
/// <returns>一覧画面の表示</returns>
public ActionResult Index()
{
var context = new ArtistContext();
var data = context.GetAll();
return(View(data));
}
public override async Task OnStartAsync(StartKind startKind, IActivatedEventArgs args)
{
using (var db = new MovieContext())
{
db.Database.Migrate();
}
using (var db = new TvShowContext())
{
db.Database.Migrate();
}
using (var db = new ArtistContext())
{
db.Database.Migrate();
}
using (var db = new RemoteContext())
{
db.Database.Migrate();
// if database is empty go to remotelistpage
if (await db.Remotes.CountAsync() == 0)
{
NavigationService.Navigate(typeof(Views.RemotesListPage));
}
// else go to mainpage
else
{
NavigationService.Navigate(typeof(Views.MainPage));
}
}
var settings = SettingsService.Instance;
var settingVersion = settings.SettingVersion;
var packageVersion = Package.Current.Id.Version;
if (settingVersion != $"{packageVersion.Major}.{packageVersion.Minor}.{packageVersion.Build}.{packageVersion.Revision}")
{
var updateDialog = new ContentDialog()
{
Title = $"{packageVersion.Major}.{packageVersion.Minor}.{packageVersion.Build}.{packageVersion.Revision}",
Content = "Thanks for all the donations, requests and bugs reported" + Environment.NewLine + Environment.NewLine +
"I've been really busy at this time so unfortunately, I had little time for developing mrRemote. However, a few bugs have been fixed and some requested feature has been added." + Environment.NewLine + Environment.NewLine +
"Go to Settings->Changelog for a complete list of the changes.",
PrimaryButtonText = "Continue"
};
await updateDialog.ShowAsync();
settings.SettingVersion = $"{packageVersion.Major}.{packageVersion.Minor}.{packageVersion.Build}.{packageVersion.Revision}";
}
await Task.CompletedTask;
}
// delete all artist in database
private void deleteArtist()
{
using (var db = new ArtistContext())
{
try
{
db.Artists.RemoveRange(db.Artists.ToList());
db.SaveChanges();
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
}
}
public ActionResult Create(Artist artist)
{
try
{
var context = new ArtistContext();
context.Add(artist, "TestUser");
//TODO Productデータがなかったら取得スレッドを動かすかどうか検討
//TODO その場合Redis登録時にすでに存在するかの判定が必要
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
private void textBoxSearch_TextChanged(object sender, TextChangedEventArgs e)
{
using (var db = new ArtistContext())
{
if (db.Artists.Count() > 0)
{
var query = (from p in db.Artists where (p.Label.Contains(textBoxSearch.Text) || p.Genre.Contains(textBoxSearch.Text)) orderby p.Label select p).ToList();
GridViewArtists.ItemsSource = query;
relativePanelNoList.Visibility = Visibility.Collapsed;
}
else
{
GridViewArtists.ItemsSource = null;
relativePanelNoList.Visibility = Visibility.Visible;
}
}
}
// load music
private void loadMusic()
{
using (var db = new ArtistContext())
{
if (db.Artists.Count() > 0)
{
var query = (from p in db.Artists orderby p.Label select p).ToList();
GridViewArtists.ItemsSource = query;
relativePanelNoList.Visibility = Visibility.Collapsed;
}
else
{
GridViewArtists.ItemsSource = null;
relativePanelNoList.Visibility = Visibility.Visible;
}
}
}
public ArtistController(ArtistContext artistContext)
{
_artistContext = artistContext;
}
public ArtistRepository(ArtistContext context)
{
this.context = context;
}
public RecordsController(ArtistContext context)
{
_context = context;
}
static void Main(string[] args)
{
var optionsBuilder = new DbContextOptionsBuilder <ArtistContext>()
.UseSqlServer(@"Server=DESKTOP-5A54U6A;Database=ArtistContext;Trusted_Connection=True;MultipleActiveResultSets=true");
using (var context = new ArtistContext(optionsBuilder.Options))
{
Console.WriteLine("Starting parsing of artists...");
using (var reader = new StreamReader(@"C:\Users\dahi1\musicbrainzdata\mbdump\artist"))
{
int counter = 1;
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
Console.WriteLine(line);
var values = line.Split('\t');
Console.WriteLine($"Extracted {values.Length} values");
Artist art;
try
{
art = new Artist() // See order here -> https://github.com/metabrainz/musicbrainz-server/blob/master/admin/sql/CreateTables.sql#L208
{
Gid = new Guid(values[1]),
Name = values[2],
Sort_name = values[3],
Begin_date_year = values[4] == "\\N" ? null : (int?)int.Parse(values[4]),
Begin_date_month = values[5] == "\\N" ? null : (int?)int.Parse(values[5]),
Begin_date_day = values[6] == "\\N" ? null : (int?)int.Parse(values[6]),
End_date_year = values[7] == "\\N" ? null : (int?)int.Parse(values[7]),
End_date_month = values[8] == "\\N" ? null : (int?)int.Parse(values[8]),
End_date_day = values[9] == "\\N" ? null : (int?)int.Parse(values[9]),
Type = values[10] == "\\N" ? null : (int?)int.Parse(values[10]),
Area = values[11] == "\\N" ? null : (int?)int.Parse(values[11]),
Gender = values[12] == "\\N" ? null : (int?)int.Parse(values[12]),
Comment = values[13],
Edits_pending = values[14] == "\\0" ? null : (int?)int.Parse(values[14]),
Last_updated = values[15] == "\\N" ? null : (DateTime?)DateTime.Parse(values[15]),
Ended = values[16] == "t",
Begin_area = values[17] == "\\N" ? null : (int?)int.Parse(values[17]),
End_area = values[18] == "\\N" ? null : (int?)int.Parse(values[18])
};
}
catch (Exception e)
{
Console.WriteLine("Couldn't parse artist");
Console.WriteLine(e);
continue;
}
Console.WriteLine($"Successfully parsed artist {art.Name}");
context.Artists.Add(art);
if (counter >= 100)
{
try
{
Console.WriteLine("Saving batch of artists to DB...");
var result = context.SaveChanges();
Console.WriteLine($"Saved {result} artists !");
counter = 0;
}
catch (Exception e)
{
Console.WriteLine("Couldn't save artists to database");
Console.WriteLine(e);
return;
}
}
counter++;
}
}
try
{
Console.WriteLine("Finished parsing artists, saving to database...");
var result = context.SaveChanges();
Console.WriteLine($"Saved {result} artists !");
}
catch (Exception e)
{
Console.WriteLine("Couldn't save artists to database");
Console.WriteLine(e);
return;
}
Console.WriteLine("Starting parsing of releases...");
using (var reader = new StreamReader(@"C:\Users\dahi1\musicbrainzdata\mbdump\release"))
{
int counter = 1;
while (!reader.EndOfStream)
{
var line = reader.ReadLine();
Console.WriteLine(line);
var values = line.Split('\t');
Console.WriteLine($"Extracted {values.Length} values");
Release rel;
try
{
rel = new Release() // See order here -> https://github.com/metabrainz/musicbrainz-server/blob/master/admin/sql/CreateTables.sql#L208
{
Gid = new Guid(values[1]),
Name = values[2],
Artist_credit = int.Parse(values[3]),
Release_group = int.Parse(values[4]),
Status = values[5] == "\\N" ? null : (int?)int.Parse(values[5]),
Packaging = values[6] == "\\N" ? null : (int?)int.Parse(values[6]),
Language = values[7] == "\\N" ? null : (int?)int.Parse(values[7]),
Script = values[8] == "\\N" ? null : (int?)int.Parse(values[8]),
Barcode = values[9],
Comment = values[10],
Edits_pending = values[11] == "\\0" ? null : (int?)int.Parse(values[11]),
Quality = values[12] == "\\-1" ? null : (int?)int.Parse(values[12]),
Last_updated = values[13] == "\\N" ? null : (DateTime?)DateTime.Parse(values[13])
};
}
catch (Exception e)
{
Console.WriteLine("Couldn't parse release");
Console.WriteLine(e);
continue;
}
Console.WriteLine($"Successfully parsed release {rel.Name}");
context.Releases.Add(rel);
if (counter >= 100)
{
try
{
Console.WriteLine("Saving batch of releases to DB...");
var result = context.SaveChanges();
Console.WriteLine($"Saved {result} releases !");
counter = 0;
}
catch (Exception e)
{
Console.WriteLine("Couldn't save releases to database");
Console.WriteLine(e);
return;
}
}
counter++;
}
}
try
{
Console.WriteLine("Finished parsing releases, saving to database...");
var result = context.SaveChanges();
Console.WriteLine($"Saved {result} releases !");
}
catch (Exception e)
{
Console.WriteLine("Couldn't save releases to database");
Console.WriteLine(e);
return;
}
}
}
public ArtistRepository(ArtistContext artistContext)
{
this.artistContext = artistContext;
}
public ArtistSkillsController(ArtistContext context)
{
_context = context;
}
public ArtistService(ArtistContext artistContext)
{
_artistContext = artistContext;
GenerateData();
}
public MovieService(ArtistContext db, IMapper mapper)
{
_db = db;
_mapper = mapper;
}
public ReviewsController(ArtistContext context)
{
_context = context;
}
public MavelCharacterService(ArtistContext db, IMapper mapper)
{
_db = db;
_mapper = mapper;
}
public Repository(ArtistContext context)
{
Context = context;
}
public HomeController(ArtistContext context)
{
_context = context;
}
public UsersController(ArtistContext context)
{
_context = context;
}
public SongRepository(ArtistContext context) : base(context)
{
}
public ArtistCart(ArtistContext _context)
{
context = _context;
}
public ArtistNameService(ArtistContext paraContext, ILogger <ArtistNameService> logger)
{
_paraContext = paraContext ?? throw new ArgumentNullException(nameof(paraContext));
_logger = logger;
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new ArtistContext(
serviceProvider.GetRequiredService <
DbContextOptions <ArtistContext> >()))
{
Artist artist1 = new Artist()
{
Name = "Robert John Downey Jr",
DayOfBirth = DateTime.Parse("1965-4-4"),
Education = "Santa Monica High School",
Hometown = "New York"
};
Artist artist2 = new Artist()
{
Name = "Christopher Robert Evans",
DayOfBirth = DateTime.Parse("1981-6-13"),
Education = "Unknown",
Hometown = "Boston,Massachusetts,US"
};
Artist artist3 = new Artist()
{
Name = "Elizabeth Chase Olsen",
DayOfBirth = DateTime.Parse("1989-2-16"),
Education = "New York University",
Hometown = "Los Angeles,California,US"
};
//----------------------------------------------------
MavelCharacter character1 = new MavelCharacter()
{
Name = "Tony stark",
HeroName = "Iron man",
Power = "Smart,Rich,Iron man suit",
Artist = artist1
};
MavelCharacter character2 = new MavelCharacter()
{
Name = "Steven Rogers",
HeroName = "Captain America",
Power = "Sodier and Shield",
Artist = artist2
};
MavelCharacter character3 = new MavelCharacter()
{
Name = "Wanda Maximoff",
HeroName = "Scarlet Witch",
Power = "Mind Stone",
Artist = artist3
};
//-----------------------------------------------------------
List <Movies> movies = new List <Movies>()
{
new Movies()
{
Name = "Sherlock Holmes",
ReleaseYear = 2011,
Role = "Sherlock Holmes",
Artist = artist1
},
new Movies()
{
Name = "Game 6",
ReleaseYear = 2005,
Role = "Steven Schwimmer",
Artist = artist1
},
new Movies()
{
Name = "The Judge",
ReleaseYear = 2014,
Role = "Hank Palmer",
Artist = artist1
}
//--------------------------------
,
new Movies()
{
Name = "Fantastic Four",
ReleaseYear = 2005,
Role = "Johnny Storm",
Artist = artist2
},
new Movies()
{
Name = "Scott Pilgrim vs the World",
ReleaseYear = 2010,
Role = "Lucas Lee",
Artist = artist2
},
new Movies()
{
Name = "Cellular",
ReleaseYear = 2004,
Role = "Ryan",
Artist = artist2
}
//-----------------------------------
,
new Movies()
{
Name = "Silent House",
ReleaseYear = 2011,
Role = "Sarah",
Artist = artist3
},
new Movies()
{
Name = "Very Good Girls",
ReleaseYear = 2013,
Role = "Gerry Fields",
Artist = artist3
},
new Movies()
{
Name = "Oldboy",
ReleaseYear = 2014,
Role = "Marie Sebastian",
Artist = artist3
}
};
context.Artists.Add(artist1);
context.Artists.Add(artist2);
context.Artists.Add(artist3);
context.MavelCharacters.Add(character1);
context.MavelCharacters.Add(character2);
context.MavelCharacters.Add(character3);
foreach (var item in movies)
{
context.Movies.Add(item);
}
context.SaveChanges();
}
}
public ArtistsController(ArtistContext context, IWebHostEnvironment hostEnvironment)
{
_context = context;
this._hostEnvironment = hostEnvironment;
}
public AlbumRepository(ArtistContext context) : base(context)
{
this.db = context;
}
public ArtistService(ArtistContext context)
{
this.context = context;
}
