public async Task <IActionResult> Create([Bind("QuoteId,EndlasNumber,ShortDescription")] Quote quote) { // 1. check that endlas number is unique in both quotes and work var quoteDuplicates = await _repo.GetDuplicateQuotes(quote); var workDuplicates = await _repo.GetDuplicateWork(quote); if (quoteDuplicates.Count() > 0 || workDuplicates.Count() > 0) { ViewBag.HasDuplicate = "true"; ViewBag.EndlasNumber = quote.EndlasNumber; return(View(quote)); } if (ModelState.IsValid) { // assign new id quote.QuoteId = Guid.NewGuid(); SetUIDs(); await _repo.AddQuote(quote); return(RedirectToAction(nameof(Index))); } return(View(quote)); }