public async Task <IActionResult> Create(Ponudum ponuda) { var query = ctx; int zadnji = query.Ponuda.OrderBy(d => d.PonudaId).Last().PonudaId; ponuda.PonudaId = zadnji + 1; if (ModelState.IsValid) { var idemo = new PonudaNatječaj(); idemo.PonudaId = ponuda.PonudaId; idemo.EvidBrojNatječaj = ponuda.EvidBrojNatječaj; var idemo2 = new PonudaPonuditelj(); idemo2.PonudaId = ponuda.PonudaId; idemo2.OibPonuditelj = ponuda.OibPonuditelj; try { ctx.Add(idemo); ctx.Add(idemo2); ctx.Add(ponuda); await ctx.SaveChangesAsync(); TempData[Constants.Message] = $"dokument {ponuda.Naslov} dodano. Id mjesta = {ponuda.PonudaId}"; TempData[Constants.ErrorOccurred] = false; return(RedirectToAction(nameof(Index))); } catch (Exception exc) { ModelState.AddModelError(string.Empty, exc.CompleteExceptionMessage()); await PrepareDropDownLists(); return(View(ponuda)); } } else { await PrepareDropDownLists(); return(View(ponuda)); } }
public async Task <IActionResult> Delete(int id, int page = 1, int sort = 1, bool ascending = true) { var ponuda = await ctx.Ponuda.FindAsync(id); if (ponuda != null) { var idemo = new PonudaNatječaj(); idemo.PonudaId = ponuda.PonudaId; idemo.EvidBrojNatječaj = ponuda.EvidBrojNatječaj; var idemo2 = new PonudaPonuditelj(); idemo2.PonudaId = ponuda.PonudaId; idemo2.OibPonuditelj = ponuda.OibPonuditelj; try { string naziv = ponuda.Naslov; ctx.Remove(idemo); ctx.Remove(idemo2); ctx.Remove(ponuda); await ctx.SaveChangesAsync(); TempData[Constants.Message] = $"dokument {naziv} sa šifrom {id} obrisano."; TempData[Constants.ErrorOccurred] = false; } catch (Exception exc) { TempData[Constants.Message] = "Pogreška prilikom brisanja dokumenta: " + exc.CompleteExceptionMessage(); TempData[Constants.ErrorOccurred] = true; } } else { TempData[Constants.Message] = $"Ne postoji dokument sa šifrom: {id}"; TempData[Constants.ErrorOccurred] = true; } return(RedirectToAction(nameof(Index), new { page, sort, ascending })); }