/// <summary> /// Insert/Update Assigned Unit Picklist /// </summary> /// <param name="db">DB Context</param> /// <param name="se">Picklist Assigned Unit Model</param> /// <returns></returns> public async Task <bool> AssignedUnitUpdateAsync(PicklistAssignedUnit se) { bool result = true; using (_context) { try { var model = await _context.PicklistAssignedUnit.FirstOrDefaultAsync(p => p.UnitID == se.UnitID); if (model == null) { _context.PicklistAssignedUnit.Add(se); } else { _context.PicklistAssignedUnit.Update(se); } await _context.SaveChangesAsync(); } catch (Exception e) { result = false; } } return(result); }
public async Task <ActionResult <PicklistAssignedUnit> > PostAssignedUnit([FromBody] SimpleModel list) { PicklistAssignedUnit model = Newtonsoft.Json.JsonConvert.DeserializeObject <PicklistAssignedUnit>(list.Name); var response = this.StatusCode((int)HttpStatusCode.OK, await _service.AssignedUnitUpdateAsync(model)); _service.Dispose(); return(response); }
public bool SendUpdateAssignedUnit() { bool result = false; DataTable table = getTable($"SELECT * FROM armyunit WHERE UnitID = {this.ReferenceID}"); if (table.Rows.Count > 0) { PicklistAssignedUnit dtSet = Mapper.DynamicMap <IDataReader, List <PicklistAssignedUnit> >(table.CreateDataReader()).First(); var json = JsonConvert.SerializeObject(dtSet); this.List = new SimpleModel(); this.List.Code = this.Code; this.List.SiteCode = this.SiteCode; this.List.IsSCMLocation = this.IsSupplyChain; this.List.Name = json; _messageSender = new RestClientMessageSender(); var response = (RestResponseBase)_messageSender.sendRequest <PicklistAssignedUnit>(this); if (response.Content != string.Empty) { result = ((response.Content == "true") ? true : false); } /** * Insert / Queue value to tmp_update table to process by auto snyc when request failed */ if (!result && this.FailOver) { queueFailedRequest(this.Module.ToString(), this.ReferenceID.ToString()); } } else { result = true; } return(result); }