public async Task <ActionResult <cojAgency> > CreateItem(cojAgency newItem) { try { //check duplicate item id, code, name if (newItem.id != 0) { return(NoContent()); } newItem.startDate = DateTime.Now.ToString(_culture); newItem.endDate = "31/12/9999 00:00:00"; _context.cojAgencys.Add(newItem); await _context.SaveChangesAsync(); newItem.idRef = newItem.id; //initial new item // var _item = await _context.cojAgencys.FindAsync (newItem.id); // _item.startDate = DateTime.Now.ToString (_culture); // _item.endDate = "31/12/9999 00:00:00"; // _item.createDate = DateTime.Now.ToString (_culture); // _item.idRef = newItem.id; // _context.Entry (_item).State = EntityState.Modified; // await _context.SaveChangesAsync (); return(CreatedAtAction(nameof(GetItem), new { id = newItem.id }, newItem)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }
public async Task <IActionResult> UpdateItem(long id, cojAgency item) { try { if (id != item.id) { return(NoContent()); } //update endDate // var _item = await _context.cojAgencys.FindAsync (id); // _item.endDate = DateTime.Now.ToString (_culture); // _item.updateDate = DateTime.Now.ToString (_culture); // _item.userUpdate = item.userUpdate; // _context.Entry (_item).State = EntityState.Modified; // await _context.SaveChangesAsync (); // var _items = await _context.cojAgencys.Where (a => a.idRef == item.idRef && a.endDate == "31/12/9999 00:00:00").ToListAsync (); // foreach (var _itm in _items) { // var _item = await _context.cojAgencys.FindAsync (_itm.id); // _item.endDate = DateTime.Now.ToString (_culture); // _item.updateDate = DateTime.Now.ToString (_culture); // _item.userUpdate = item.userUpdate; // _context.Entry (_item).State = EntityState.Modified; // await _context.SaveChangesAsync (); // } //Add new cojAgency _itemNew = new cojAgency { idRef = item.idRef, itemSort = item.itemSort, code = item.code, name = item.name, address = item.address, agencyGroup = item.agencyGroup, agencyType = item.agencyType, courtType = item.courtType, agencyHost = item.agencyHost, remark = item.remark, createDate = DateTime.Now.ToString(_culture), // startDate = DateTime.Now.ToString (_culture), // endDate = "31/12/9999 00:00:00", status = item.status, dateOpen = item.dateOpen, dateClose = item.dateClose, userCreate = item.userCreate, userUpdate = item.userUpdate, userAudit = item.userAudit, userAuditDate = item.userAuditDate, userApprove = item.userApprove, userApproveDate = item.userApproveDate, acctSort = item.acctSort, fundCenterCode = item.fundCenterCode, activityCode = item.activityCode, govtAcctCode = item.govtAcctCode, acctRemark = item.acctRemark, isAcctAgency = item.isAcctAgency, acctAgencyType = item.acctAgencyType, updateDate = DateTime.Now.ToString(_culture) }; _context.cojAgencys.Add(_itemNew); await _context.SaveChangesAsync(); return(Ok(_itemNew)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }