public async Task <ActionResult <cojUser> > CreateCOJUser(cojUser newUser) { try { //check duplicate item id, code, name if (newUser.id != 0) { return(NoContent()); } // newUser.startDate = DateTime.Now.ToString(_culture); newUser.endDate = "31/12/9999 00:00:00"; _context.cojUsers.Add(newUser); await _context.SaveChangesAsync(); newUser.idRef = newUser.id; //initial new item // var _item = await _context.cojUsers.FindAsync (newUser.id); // _item.startDate = DateTime.Now.ToString (_culture); // _item.endDate = "31/12/9999 00:00:00"; // _item.idRef = newUser.id; // _context.Entry (_item).State = EntityState.Modified; // await _context.SaveChangesAsync(); return(CreatedAtAction(nameof(GetUser), new { id = newUser.id }, newUser)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public async Task <IActionResult> UpdateCOJUser(long id, cojUser user) { try { if (id != user.id) { return(NoContent()); } //update endDate // var _item = await _context.cojUsers.FindAsync(id); // _item.endDate = DateTime.Now.ToString(_culture); // _context.Entry(_item).State = EntityState.Modified; // await _context.SaveChangesAsync(); // var _items = await _context.cojUsers.Where (a => a.idRef == user.idRef && a.endDate == "31/12/9999 00:00:00").ToListAsync (); // foreach (var _itm in _items) { // var _item = await _context.cojUsers.FindAsync (_itm.id); // _item.endDate = DateTime.Now.ToString (_culture); // _context.Entry (_item).State = EntityState.Modified; // await _context.SaveChangesAsync (); // } cojUser _itemNew = new cojUser { idRef = user.idRef, userId = user.userId, password = user.password, firstName = user.firstName, lastName = user.lastName, position = user.position, cojAgencyId = user.cojAgencyId, email = user.email, phone = user.phone, status = user.status, securityKey = user.securityKey // startDate = DateTime.Now.ToString(_culture), // endDate = "31/12/9999 00:00:00" }; _context.cojUsers.Add(_itemNew); await _context.SaveChangesAsync(); return(Ok(_itemNew)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }