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