public IActionResult AddFieldBook(AddFieldBookViewModel afbvm) { if (GlobalStatic.role == "No Role") { return(View("Index")); } //string burialSiteId = context // .BurialSites // .FromSqlRaw("SELECT * FROM BurialSite WHERE Ns = {0} AND NSTop = {1} AND Ew = {2} AND EWTop = {3} AND Quadrant = {4}", afbvm.NS, afbvm.Nstop, afbvm.EW, afbvm.Ewtop, afbvm.Quadrant) // .ToList() // .First() // .BurialSiteId.ToString(); //Burial b = context.Burials.Where(o => o.BurialSiteId == v.BurialSiteId).Where(p => p.BurialNumber == v.BurialNumber).ToList().First(); string burialSiteId = context.BurialSites.Where(o => o.Ns == afbvm.NS).Where(o => o.Ew == afbvm.EW).Where(o => o.Nstop == afbvm.Nstop).Where(o => o.Ewtop == afbvm.Ewtop).Where(o => o.Quadrant == afbvm.Quadrant).ToList().First().BurialSiteId.ToString(); //field book id int maxId = (int)context.FieldBooks.Max(o => o.FieldBooksId); int fieldBooksId = maxId + 1; FieldBook fieldBook = new FieldBook { FieldBooksId = fieldBooksId, BurialSiteId = Int32.Parse(burialSiteId), BurialNumber = afbvm.BurialNumber, FieldBook1 = afbvm.FieldBook1, FieldBookPageNumber = afbvm.FieldBookPageNumber }; context.FieldBooks.Add(fieldBook); context.SaveChanges(); return(View("Index")); }
//[Authorize(Roles = "Admin,Researcher")] public async Task <IActionResult> Edit(decimal id, [Bind("FieldBookId,Name,Description")] FieldBook fieldBook) { if (id != fieldBook.FieldBookId) { return(NotFound()); } if (ModelState.IsValid) { try { //Updating the name and description _context.FieldBooks.Where(e => e.FieldBookId == id).FirstOrDefault().Name = fieldBook.Name; _context.FieldBooks.Where(e => e.FieldBookId == id).FirstOrDefault().Description = fieldBook.Description; //_context.Update(fieldBook); ///this didnt work... //_context.SaveChanges(); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FieldBookExists(fieldBook.FieldBookId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(fieldBook)); }
public async Task <IActionResult> Create([Bind("FieldBookId,Name,Description")] FieldBook fieldBook) { if (ModelState.IsValid) { _context.Add(fieldBook); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(fieldBook)); }
public IActionResult Edit(int id) { FieldBook fieldNote = _context.FieldBook .Where(x => x.Id == id).FirstOrDefault(); if (fieldNote == null) { return(NotFound()); } return(View(fieldNote)); }
public IActionResult CustomEdit(FieldBook fieldNote) { if (ModelState.IsValid) { _context.Update(fieldNote); _context.SaveChanges(); return(View("RecordDetails", new FieldNotesViewModel { fieldNotes = _context.FieldBook.Where(x => x.BurialId == fieldNote.BurialId), burial = _context.Burials.Where(x => x.BurialId == fieldNote.BurialId).FirstOrDefault(), fieldNote = fieldNote })); } return(View(fieldNote)); }
public IActionResult SingleRecord() { FieldBook Fieldnote = _context.FieldBook.FirstOrDefault(); return(View(Fieldnote)); }