public IActionResult Details(int id) { int translationId = 0; ViewBag.BookTransferLanguage = 0; Source source = _db.Sources.FirstOrDefault(b => b.Id == id); source.Authors = _db.SourceAuthors.Where(c => c.SourceId == source.Id).Select(s => s.Author).ToList(); source.BusinessProcesses = _db.SourceBusinessProcesses.Where(s => s.SourceId == source.Id) .Select(s => s.BusinessProcess).ToList(); SourceIdAndEnglishSourceId sourceIdAndEnglishSourceId = _db.SourceIdAndEnglishSourceIds .FirstOrDefault(b => b.SourceId == id); if (sourceIdAndEnglishSourceId != null) { translationId = sourceIdAndEnglishSourceId.EnglishSourceId; ViewBag.BookTransferLanguage = "en"; } if (sourceIdAndEnglishSourceId == null) { sourceIdAndEnglishSourceId = _db.SourceIdAndEnglishSourceIds.FirstOrDefault(b => b.EnglishSourceId == id); } if (translationId == 0 && sourceIdAndEnglishSourceId != null) { translationId = sourceIdAndEnglishSourceId.SourceId; ViewBag.BookTransferLanguage = "ru"; } ViewBag.BookTransferId = translationId; return(View(source)); }
public IActionResult Index() { List <Source> sources = _db.Sources.Where(b => b.Active).ToList(); ; foreach (var source in sources) { SourceIdAndEnglishSourceId sourceIdAndEnglishSourceId = _db.SourceIdAndEnglishSourceIds.FirstOrDefault(b => b.SourceId == source.Id); int translationId = 0; if (sourceIdAndEnglishSourceId == null) { sourceIdAndEnglishSourceId = _db.SourceIdAndEnglishSourceIds.FirstOrDefault(b => b.EnglishSourceId == source.Id); } if (sourceIdAndEnglishSourceId != null) { translationId = sourceIdAndEnglishSourceId.EnglishSourceId; } source.TranslationID = translationId; source.Authors = _db.SourceAuthors.Where(b => b.SourceId == source.Id).Select(a => a.Author).ToList(); source.BusinessProcesses = _db.SourceBusinessProcesses.Where(b => b.SourceId == source.Id) .Select(b => b.BusinessProcess).ToList(); } return(View(sources)); }
public void SaveBookIdAndEnglishBookId(SourceCreateViewModel model, Source source) { SourceIdAndEnglishSourceId sourceIdAndEnglishSourceId = new SourceIdAndEnglishSourceId() { SourceId = model.SourceId, EnglishSourceId = source.Id }; _db.SourceIdAndEnglishSourceIds.Add(sourceIdAndEnglishSourceId); _db.SaveChanges(); }