public async Task <IActionResult> LoadFromText()
{
string jsonString = ReadWriteFile.ReadTextAsJson(@"g:\covertext.txt");
List <CoverModel> CoverList = JsonConvert.DeserializeObject <List <CoverModel> >(jsonString);
List <CastModel> CastList = new List <CastModel>();
foreach (var cover in CoverList)
{
CastModel cast = new CastModel();
cast.firstname = cover.cast;
cast.lastname = cover.filename;
CastList.Add(cast);
}
// Sort CastList
//List<CastModel> sortedCastList = CastList.OrderBy(x => x.firstname.ToLower()).ToList();
List <CastModel> sortedCastList = CastList;
// Clear DBSet
doruContext.CastSet.RemoveRange(doruContext.CastSet);
foreach (var cast in sortedCastList)
{
doruContext.CastSet.Add(cast);
}
await doruContext.SaveChangesAsync();
return(NoContent());
}
public async Task <IActionResult> LoadFromText()
{
string jsonString = ReadWriteFile.ReadTextAsJson(@"g:\covertext.txt");
List <CoverModel> CoverList = JsonConvert.DeserializeObject <List <CoverModel> >(jsonString);
// Sort CoverList
//List<CoverModel> sortedCoverList = CoverList.OrderBy(x => x.series.ToLower()).ToList();
List <CoverModel> sortedCoverList = CoverList;
// Clear DBSet
doruContext.CoverSet.RemoveRange(doruContext.CoverSet);
foreach (var cover in sortedCoverList)
{
doruContext.CoverSet.Add(cover);
}
await doruContext.SaveChangesAsync();
return(NoContent());
}
public async Task <IActionResult> LoadCover()
{
string jsonString = ReadWriteFile.ReadTextAsJson(@"g:\cover.json");
List <CoverModel> coverList = JsonConvert.DeserializeObject <List <CoverModel> >(jsonString);
while (doruContext.CoverSet.Count() > 0)
{
var cover = doruContext.CoverSet.First();
doruContext.CoverSet.Remove(cover);
await doruContext.SaveChangesAsync();
}
foreach (var cover in coverList)
{
doruContext.CoverSet.Add(cover);
await doruContext.SaveChangesAsync();
}
return(NoContent());
}
public async Task <IActionResult> UploadFromCoverTextFile()
{
string jsonString = ReadWriteFile.ReadTextAsJson(@"g:\covertext.txt");
List <CoverModel> CoverList = JsonConvert.DeserializeObject <List <CoverModel> >(jsonString);
// Sort CoverList
//List<CoverModel> sortedCoverList = CoverList.OrderBy(x => x.series.ToLower()).ToList();
List <CoverModel> sortedCoverList = CoverList;
//// Clear DBSet
//doruDB.Cover.RemoveRange(doruDB.Cover);
// build a dictionary of key: filename and value: id
// build a list of not existed CoverModel by comparing to dictionary
// add not existed CoverModel to dbcontext
foreach (var cover in sortedCoverList)
{
doruDB.Cover.Add(cover);
}
await doruDB.SaveChangesAsync();
return(NoContent());
}
