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