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