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