public async Task <ActionResult <cojAgencyBuilding> > CreateItem(cojAgencyBuilding 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.cojAgencyBuildings.Add(newItem); await _context.SaveChangesAsync(); newItem.idRef = newItem.id; //initial new item // var _item = await _context.cojAgencyBuildings.FindAsync (newItem.id); // _item.startDate = DateTime.Now.ToString (_culture); // _item.endDate = "31/12/9999 00:00:00"; // _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, cojAgencyBuilding item) { try { if (id != item.id) { return(NoContent()); } //update endDate // var _item = await _context.cojAgencyBuildings.FindAsync (id); // _item.endDate = DateTime.Now.ToString (_culture); // _context.Entry (_item).State = EntityState.Modified; // await _context.SaveChangesAsync (); // var _items = await _context.cojAgencyBuildings.Where (a => a.idRef == item.idRef && a.endDate == "31/12/9999 00:00:00").ToListAsync (); // foreach (var _itm in _items) { // var _item = await _context.cojAgencyBuildings.FindAsync (_itm.id); // _item.endDate = DateTime.Now.ToString (_culture); // _context.Entry (_item).State = EntityState.Modified; // await _context.SaveChangesAsync (); // } //Add new cojAgencyBuilding _itemNew = new cojAgencyBuilding { idRef = item.idRef, cojLandTypeAdocNo = item.cojLandTypeAdocNo, cojLandTypeBdocNo = item.cojLandTypeBdocNo, cojLandTypeCowner = item.cojLandTypeCowner, cojLandTypeCdocNo = item.cojLandTypeCdocNo, cojLandTypeD = item.cojLandTypeD, cojLandSize = item.cojLandSize, cojLandAddress = item.cojLandAddress, code = item.code, remark = item.remark, cojAreaTotal = item.cojAreaTotal, cojAreaIndorTotal = item.cojAreaTotal, cojAreaIndorFloor = item.cojAreaIndorFloor, cojAreaCourtroom = item.cojAreaCourtroom, cojAreaCourtSize = item.cojAreaCourtSize, cojAreaWorkroom = item.cojAreaWorkroom, cojAreaWorkSize = item.cojAreaWorkSize, cojAreaWorkWC = item.cojAreaWorkWC, cojAreaServiceWC = item.cojAreaServiceWC, cojAreaOutdorTotal = item.cojAreaOutdorTotal, cojAreaOutdorParking = item.cojAreaOutdorParking, cojAreaOutdorField = item.cojAreaOutdorField, cojAreaOutdorWalkway = item.cojAreaOutdorWalkway, cojAreaOutdorOther = item.cojAreaOutdorOther, cojAreaGlass = item.cojAreaGlass, cojHouseTotal = item.cojHouseTotal, cojCondoSize = item.cojCondoSize, cojCondoUnit = item.cojCondoUnit, cojHousePosition = item.cojHousePosition, cojHousePositionUnit = item.cojHousePositionUnit, cojHouseRoom = item.cojHouseRoom, cojHouseRoomArea = item.cojHouseRoomArea, cojHouseFitness = item.cojHouseFitness, cojHouseFitnessArea = item.cojHouseFitnessArea, cojHouseCenterWC = item.cojHouseCenterWC, cojHouseTank = item.cojHouseTank, cojAreaIndorGlass = item.cojAreaIndorGlass, buildingType = item.buildingType, cojAgencyId = item.cojAgencyId //name = item.name, //land = item.land, //space = item.space, //floor = item.floor, //room = item.room, //throne = item.throne, //workarea = item.workarea, //remark = item.remark, // startDate = DateTime.Now.ToString (_culture), // endDate = "31/12/9999 00:00:00" }; _context.cojAgencyBuildings.Add(_itemNew); await _context.SaveChangesAsync(); return(Ok(_itemNew)); } catch (Exception ex) { return(BadRequest(ex.Message)); } }