public async Task <IActionResult> iycfForm(string id) { if (id == null) { return(NotFound()); } var item = await _context.Nmr.SingleOrDefaultAsync(m => m.Nmrid == id); if (item == null) { return(NotFound()); } if (item.StatusId == 3 || item.HfactiveStatusId != 1) { return(BadRequest()); } if (User.Identity.Name != item.UserName) { return(BadRequest()); } var model = new TblIycf(); model.Nmrid = item.Nmrid; return(View("iycf", model)); }
public async Task <IActionResult> DeleteTblIycf([FromRoute] int id, [FromRoute] string nmrid) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } TblIycf tblIycf = await _context.TblIycf.Where(m => m.Iycfid == id && m.Nmrid == nmrid).Include(m => m.Nmr).SingleOrDefaultAsync(); if (tblIycf == null) { return(NotFound()); } if (tblIycf.Nmr.StatusId == 3 || tblIycf.Nmr.HfactiveStatusId != 1) { return(BadRequest()); } var user = tblIycf.UserName; if (tblIycf.UserName != user) { return(Unauthorized()); } tblIycf.UpdateDate = DateTime.Now; tblIycf.Nmr.StatusId = 2; _context.TblIycf.Remove(tblIycf); await _context.SaveChangesAsync(); return(Ok(tblIycf)); }
public IActionResult Create(string nmrid) { if (nmrid == null) { return(BadRequest()); } int[] query = _context.TblIycf.Where(m => m.Nmrid == nmrid).Select(m => m.Iycfid).ToArray(); int[] model = _context.TlkpIycf.Where(m => m.Active.Equals(true) && !query.Contains(m.Iycfid)).Select(m => m.Iycfid).ToArray(); var user = User.Identity.Name; foreach (int id in model) { TblIycf item = new TblIycf(); item.UserName = user; item.Nmrid = nmrid; item.Iycfid = id; _context.TblIycf.Add(item); } _context.SaveChanges(); return(NoContent()); }
public async Task <IActionResult> PutTblIycf([FromRoute] int id, [FromRoute] string nmrid, [FromBody] TblIycf item) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != item.Iycfid || nmrid != item.Nmrid) { return(BadRequest()); } var nmr = await _context.Nmr.SingleOrDefaultAsync(m => m.Nmrid == nmrid); if (nmr == null) { return(BadRequest()); } if (nmr.StatusId == 3 || nmr.HfactiveStatusId != 1) { return(BadRequest()); } var user = User.Identity.Name; if (nmr.UserName != user) { return(Unauthorized()); } item.UpdateDate = DateTime.Now; nmr.StatusId = 2; _context.Entry(item).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblIycfExists(id, nmrid)) { return(NotFound()); } else { throw; } } return(NoContent()); }