public async Task <ActionResult <CrossReference> > PostCrossReference(CrossReference crossReference)
{
_context.CrossReferences.Add(crossReference);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCrossReference", new { id = crossReference.Id }, crossReference));
}
public static IEnumerable <CrossReference> Load(CrossReferenceFile source)
{
using StreamReader reader = File.OpenText(source.Filename);
var options = new CsvOptions {
HeaderMode = source.HeaderMode, RowsToSkip = source.RowsToSkip, Separator = source.Separator[0]
};
foreach (var row in CsvReader.Read(reader, options))
{
foreach (var xref in source.Items)
{
var data = new CrossReference
{
Child = new GeoEntityId
{
Name = xref.Child != null ? row[(int)xref.Child] : null,
Reference = xref.ChildRef != null ? row[(int)xref.ChildRef] : null,
DataType = xref.ChildDataType
},
Parent = new GeoEntityId
{
Name = xref.Parent != null ? row[(int)xref.Parent] : null,
Reference = xref.ParentRef != null ? row[(int)xref.ParentRef] : null,
DataType = xref.ParentDataType
},
};
yield return(data);
}
}
}
public async Task <IActionResult> PutCrossReference(int id, CrossReference crossReference)
{
if (id != crossReference.Id)
{
return(BadRequest());
}
_context.Entry(crossReference).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CrossReferenceExists(id))
{
return(NotFound());
}
throw;
}
return(NoContent());
}
public void ScanCondition(ref CrossReference lookup)
{
for (int i = 0; i < instructionlist.Count; i++)
{
instructionlist[i].ScanInstruction(ref lookup);
}
}
public void ScanObjects(ref CrossReference lookup)
{
foreach (GraphicsList graphiclist in _graphicpageslist)
{
graphiclist.ScanObjects(ref lookup);
}
}
bool CompileGraphicDispalyExpression(tblDisplay _tbldisplay, SimpleOperation simpleoperation, DisplayObjectParameters _Parameters)
{
Compiler compiler = new Compiler();
CrossReference Lookup = ((TabDisplayPageControl)parentDrawGraphic.Parentpagelist.Parenttabgraphicpagecontrol).tbldisplay.crossreference;
return(compiler.CompileGraphicDispalyExpression(_tbldisplay, simpleoperation, _Parameters));
}
/// <summary>
/// 使用された相互参照の情報をフィルタする
/// </summary>
/// <returns>相互参照リスト</returns>
public List <CrossReference> GetUsedCrossReference()
{
// 振る舞いが空白の場合、空リストを戻る
if (string.IsNullOrWhiteSpace(this.Text))
{
return(new List <CrossReference>());
}
List <CrossReference> rst = new List <CrossReference>();
foreach (CrossReference crossReference in this.CrossReferenceList)
{
// 相互参照対象を強調表示する
string crossReferenceName = crossReference.Name;
int nameIdx = this.Text.IndexOf(crossReferenceName);
// 該当クラスの名前は振る舞いに存在する場合
if (nameIdx != -1)
{
// 相互参照要素を追加する
CrossReference cr = new CrossReference()
{
// GUID
ElementGUID = crossReference.ElementGUID,
// 名前
Name = crossReference.Name,
// クラスフラグ
classflg = crossReference.classflg,
// 属性・操作一覧
AttributesMethods = new List <AttributeMethod>()
};
// 属性・操作を強調表示する
foreach (AttributeMethod attributeMethod in crossReference.AttributesMethods)
{
// 相互参照要素名．属性・操作名
string attributeName = crossReference.Name + HALF_DOT + attributeMethod.Name;
int attributeIdx = this.Text.IndexOf(attributeName);
if (attributeIdx != -1)
{
// 属性・操作を追加する
AttributeMethod am = new AttributeMethod()
{
// 名前
Name = attributeMethod.Name,
// GUID
GUID = attributeMethod.GUID
};
cr.AttributesMethods.Add(am);
}
}
rst.Add(cr);
}
}
return(rst);
}
public override void ScanObjects(ref CrossReference lookup)
{
//drawexpressionCollection.ScanField(ref lookup);
foreach (DisplayObjectDynamicProperty displayobjectdynamicproperty in drawexpressionCollection.objDisplayObjectDynamicPropertys.list)
{
foreach (DisplayObjectDynamicPropertyCondition displayobjectdynamicpropertycondition in displayobjectdynamicproperty.ConditionList)
{
displayobjectdynamicpropertycondition.SimpleOperation.ScanCondition(ref lookup);
}
}
}
/// <summary>
/// Load the GraphicsList from data pulled from disk
/// </summary>
/// <param name="info">Data from disk</param>
/// <param name="orderNumber">Layer number to be loaded</param>
//public void LoadFromStream(SerializationInfo info, int orderNumber)
//{
// graphicsList = new ArrayList();
// // Get number of DrawObjects in this GraphicsList
// int numberObjects = info.GetInt32(
// String.Format(CultureInfo.InvariantCulture,
// "{0}{1}",
// entryCount, orderNumber));
// for (int i = 0; i < numberObjects; i++)
// {
// string typeName;
// typeName = info.GetString(
// String.Format(CultureInfo.InvariantCulture,
// "{0}{1}",
// entryType, i));
// object drawObject;
// drawObject = Assembly.GetExecutingAssembly().CreateInstance(
// typeName);
// // Let the Draw Object load itself
// ((DrawObject)drawObject).LoadFromStream(info, orderNumber, i);
// graphicsList.Add(drawObject);
// }
//}
/// <summary>
/// Save GraphicsList to the stream
/// </summary>
/// <param name="info">Stream to place the GraphicsList into</param>
/// <param name="orderNumber">Layer Number the List is on</param>
//public void SaveToStream(SerializationInfo info, int orderNumber)
//{
// // First store the number of DrawObjects in the list
// info.AddValue(
// String.Format(CultureInfo.InvariantCulture,
// "{0}{1}",
// entryCount, orderNumber),
// graphicsList.Count);
// // Next save each individual object
// int i = 0;
// foreach (DrawObject o in graphicsList)
// {
// info.AddValue(
// String.Format(CultureInfo.InvariantCulture,
// "{0}{1}",
// entryType, i),
// o.GetType().FullName);
// // Let each object save itself
// o.SaveToStream(info, orderNumber, i);
// i++;
// }
//}
/// <summary>
/// Draw all the visible objects in the List
/// </summary>
/// <param name="g">Graphics to draw on</param>
//public void DrawControl(Graphics g)
//{
// int numberObjects = graphicsList.Count;
// for (int i = 0 ; i < numberObjects ; i++)
// {
// DrawObject o;
// o = (DrawObject)graphicsList[i];
// if (LayerIsEnable(o))
// {
// if (o.IntersectsWith(Rectangle.Round(g.ClipBounds)))
// o.Draw(g);
// if (o.Selected)
// o.DrawTracker(g);
// }
// }
//}
public void ScanObjects(ref CrossReference lookup)
{
//GraphicPagesList[ActivePageNo].ScanObjects(ref lookup);
int numberObjects = graphicsList.Count;
for (int i = 0; i < numberObjects; i++)
{
DrawObject o;
o = (DrawObject)graphicsList[i];
o.ScanObjects(ref lookup);
}
}
public static AddressCrossReference ToDomain(this CrossReference crossReference)
{
return(new AddressCrossReference
{
CrossRefKey = crossReference.CrossRefKey,
UPRN = crossReference.UPRN,
Code = crossReference.Code,
Name = crossReference.Name,
Value = crossReference.Value,
EndDate = crossReference?.EndDate
});
}
public long Add(string source,
CrossReferenceType sourceType,
string destination,
CrossReferenceType destinationType)
{
long sourceId = GetIdByName(source, sourceType);
long destinationId = GetIdByName(destination, destinationType);
if (IdValidator.IsInvalid(sourceId) || IdValidator.IsInvalid(destinationId))
{
return(IdValidator.INVALID_ID);
}
if (sourceId == destinationId &&
string.Equals(source, destination, StringComparison.InvariantCultureIgnoreCase))
{
//саму на себя ссылку нельзя добавлять
return(IdValidator.INVALID_ID);
}
long result = IdValidator.INVALID_ID;
var parsedSourceType = (int)sourceType;
var parsedDestinationType = (int)destinationType;
Adapter.ActionByContext(c => {
CrossReference crossReference =
c.CrossReference.FirstOrDefault(
e =>
e.SourceId == sourceId && e.SourceType == parsedSourceType && e.DestinationId == destinationId &&
e.DestinationType == parsedDestinationType);
if (crossReference != null)
{
result = crossReference.Id;
return;
}
crossReference = new CrossReference {
SourceId = sourceId,
SourceType = parsedSourceType,
DestinationId = destinationId,
DestinationType = parsedDestinationType
};
c.CrossReference.Add(crossReference);
c.SaveChanges();
if (IdValidator.IsInvalid(crossReference.Id))
{
return;
}
result = crossReference.Id;
});
return(result);
}
internal void Add(CrossReference RefObject)
{
int index;
try
{
index = base.List.Add(RefObject);
mCanonicalLookup.Add(RefObject.CanonicalName, index);
mNetBIOSLookup.Add(RefObject.NetBIOSName, index);
}
catch (COMException ex)
{
mProcessLog += ex.Message;
}
}
public ResultAndError <CrossReference> Add(CrossReference c)
{
ResultAndError <CrossReference> result = new ResultAndError <CrossReference>();
try
{
db.CrossReferences.Add(c);
db.SaveChanges();
return(result.AddResult(c));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public bool DeleteMulti(IEnumerable <string> CrossReferences)
{
List <CrossReference> oCrossReferences = new List <CrossReference>();
foreach (string CrossReferenceNo in CrossReferences)
{
CrossReference oCrossReference = Get(CrossReferenceNo);
if (oCrossReference != null)
{
oCrossReferences.Add(oCrossReference);
}
}
db.CrossReferences.RemoveRange(oCrossReferences);
db.SaveChanges();
return(true);
}
public string GetUrl(HttpRequestBase request, CrossReference crossReference)
{
if (crossReference.Type == CrossReferenceType.GroupWord)
{
return(UrlBuilder.GetGroupWordsUrl(request, crossReference.ReferenceName));
}
if (crossReference.Type == CrossReferenceType.GroupSentence)
{
return(UrlBuilder.GetGroupSentencesUrl(request, crossReference.ReferenceName));
}
if (crossReference.Type == CrossReferenceType.VisualDictionary)
{
return(UrlBuilder.GetVisualDictionaryUrl(request, crossReference.ReferenceName));
}
return(null);
}
public bool UpdateMulti(IEnumerable <CrossReference> oCrossReferences, bool insertIfNoExists = false)
{
foreach (CrossReference CrossReference in oCrossReferences)
{
CrossReference old = Get(CrossReference.ItemNo);
if (old == null && insertIfNoExists)
{
Add(CrossReference);
}
else
{
db.Entry(old).CurrentValues.SetValues(CrossReference);
}
}
db.SaveChanges();
return(true);
}
public IActionResult Edit(int id, [Bind("Id,ServerId,RegulationId,BranchId,CompanyId")]
CrossReference crossReference)
{
if (id != crossReference.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
ApiConsumer.Put <Branch>(crossReference, _options.Value.ApiUrl + $"CrossReference/{id}");
}
catch (DbUpdateConcurrencyException)
{
if (!CrossReferenceExists(crossReference.Id))
{
return(NotFound());
}
throw;
}
return(RedirectToAction(nameof(Index)));
}
var response =
ApiConsumer.Get <CrossReference>(_options.Value.ApiUrl + $"CrossReference/{id}");
var server = ApiConsumer.Get <List <Server> >(_options.Value.ApiUrl + "server");
var regulation = ApiConsumer.Get <List <Regulation> >(_options.Value.ApiUrl + "regulation");
var branch = ApiConsumer.Get <List <Branch> >(_options.Value.ApiUrl + "branch");
var company = ApiConsumer.Get <List <Company> >(_options.Value.ApiUrl + "company");
ViewData["BranchId"] = new SelectList(branch.Data, "Id", "Name", response.Data.BranchId);
ViewData["CompanyId"] = new SelectList(company.Data, "Id", "Name", response.Data.CompanyId);
ViewData["RegulationId"] = new SelectList(regulation.Data, "Id", "Name", response.Data.RegulationId);
ViewData["ServerId"] = new SelectList(server.Data, "Id", "Name", response.Data.ServerId);
return(View(crossReference));
}
public ResultAndError <CrossReference> Update(CrossReference cr, bool insertIfNoExists = false)
{
ResultAndError <CrossReference> result = new ResultAndError <CrossReference>();
try
{
CrossReference old = Get(cr.ItemNo);
if (old == null && insertIfNoExists)
{
return(Add(cr));
}
db.Entry(old).CurrentValues.SetValues(cr);
db.SaveChanges();
return(result.AddResult(cr));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public ResultAndError <bool> Delete(string id)
{
ResultAndError <bool> result = new ResultAndError <bool>();
try
{
CrossReference CrossReference = Get(id);
if (CrossReference == null)
{
return(result.AddError("No se encontro la tarifa con el id " + id));
}
db.CrossReferences.Remove(CrossReference);
db.SaveChanges();
return(result.AddResult(true));
}
catch (Exception e)
{
return(result.AddError(e, HttpStatusCode.InternalServerError));
}
}
public IActionResult Create([Bind("Id,ServerId,RegulationId,BranchId,CompanyId")]
CrossReference crossReference)
{
if (ModelState.IsValid)
{
ApiConsumer.Post <Branch>(crossReference, _options.Value.ApiUrl + "CrossReference");
return(RedirectToAction(nameof(Index)));
}
var server = ApiConsumer.Get <List <Server> >(_options.Value.ApiUrl + "server");
var regulation = ApiConsumer.Get <List <Regulation> >(_options.Value.ApiUrl + "regulation");
var branch = ApiConsumer.Get <List <Branch> >(_options.Value.ApiUrl + "branch");
var company = ApiConsumer.Get <List <Company> >(_options.Value.ApiUrl + "company");
ViewData["BranchId"] = new SelectList(branch.Data, "Id", "Name", crossReference.BranchId);
ViewData["CompanyId"] = new SelectList(company.Data, "Id", "Name", crossReference.CompanyId);
ViewData["RegulationId"] = new SelectList(regulation.Data, "Id", "Name", crossReference.RegulationId);
ViewData["ServerId"] = new SelectList(server.Data, "Id", "Name", crossReference.ServerId);
return(View(crossReference));
}
/// <summary>
/// Dereference indirect object
/// </summary>
/// <param name="objectReference">Object to dereference</param>
/// <returns>Dereferenced object, or original object if not an indirect object</returns>
private IPDFObject GetObject(IPDFObject objectReference)
{
if (CrossReference == null)
{
throw new PDFMissingCrossreferenceTableException();
}
IPDFObject reference = objectReference;
while (reference.Type == PDFObjectType.IndirectReference)
{
int Offset = CrossReference.OffsetForObject((PDFIndirectObject)reference);
if (Offset == 0)
{
return(new PDFNull());
}
reference = LoadObjectAtOffset(Offset);
}
return(reference);
}
public async Task SearchAddressReturnsAddressesInHackneyBoroughForAGivenCrossReference()
{
var uprnOne = _faker.Random.Int();
var uprnTwo = _faker.Random.Int();
var crossReferenceOne = new CrossReference {
Code = "000ABC", Value = "100000"
};
var crossReferenceTwo = new CrossReference {
Code = "123XYZ", Value = "100000"
};
var hackneyBoroughOne = new NationalAddress {
UPRN = uprnOne, Gazetteer = "Hackney", NeverExport = false
};
var hackneyBoroughTwo = new NationalAddress {
UPRN = uprnTwo, Gazetteer = "Hackney", NeverExport = false
};
var record = await TestDataHelper.InsertAddressInDbAndEs(DatabaseContext, ElasticsearchClient,
request : hackneyBoroughOne).ConfigureAwait(true);
TestDataHelper.InsertCrossReference(DatabaseContext, uprnOne, crossReferenceOne);
await TestDataHelper.InsertAddressInDbAndEs(DatabaseContext, ElasticsearchClient, request : hackneyBoroughTwo).ConfigureAwait(true);
TestDataHelper.InsertCrossReference(DatabaseContext, uprnTwo, crossReferenceTwo);
await AddSomeRandomAddressToTheDatabase().ConfigureAwait(true);
var queryString = $"cross_ref_code={crossReferenceOne.Code}&cross_ref_value={crossReferenceOne.Value}&format=Detailed";
var response = await CallEndpointWithQueryParameters(queryString).ConfigureAwait(true);
response.StatusCode.Should().Be(200);
var returnedAddress = await response.ConvertToSearchAddressResponseObject().ConfigureAwait(true);
returnedAddress.Data.Addresses.Count.Should().Be(1);
returnedAddress.Data.Addresses.First().AddressKey.Should().Be(record.AddressKey);
}
public CrossReferenceCollection(string UserName, string Password, AuthenticationTypes AuthType)
{
try
{
// Obtain NETBIOS only if LDAP accessible to prevent error
DirectoryEntry rootLDAP = new DirectoryEntry("LDAP://rootDSE", UserName, Password, AuthType);
string crossRefPath = "LDAP://CN=Partitions," + rootLDAP.Properties["configurationNamingContext"].Value.ToString();
DirectoryEntry objCrossRefContainer;
if ((UserName.Length > 0) && (Password.Length > 0))
{
objCrossRefContainer = new DirectoryEntry(crossRefPath, UserName, Password, AuthType);
}
else
{
objCrossRefContainer = new DirectoryEntry(crossRefPath);
}
DirectoryEntry objCrossRef;
foreach (DirectoryEntry tempLoopVar_objCrossRef in objCrossRefContainer.Children)
{
objCrossRef = tempLoopVar_objCrossRef;
if (!Convert.ToBoolean(objCrossRef.Properties["nETBIOSName"].Value == null))
{
string netBIOSName = Convert.ToString(objCrossRef.Properties["nETBIOSName"].Value);
string canonicalName = Convert.ToString(objCrossRef.Properties["dnsRoot"].Value);
string domainPath = Convert.ToString(objCrossRef.Properties["nCName"].Value);
CrossReference crossRef = new CrossReference(domainPath, netBIOSName, canonicalName);
this.Add(crossRef);
}
}
//mProcessLog += "Accessing LDAP : OK"
}
catch (COMException ex)
{
//mProcessLog += "Accessing LDAP : FAIL" & "<br>"
mProcessLog += ex.Message + "<br>";
}
}
/// <summary>
/// 操作の所属クラスの接続要素を取得する
/// </summary>
/// <param name="method">EA.Method</param>
public IList <CrossReference> GetConnectionClassList()
{
IList <CrossReference> crList = new List <CrossReference>();
ElementsXmlReader elemReader = new ElementsXmlReader(ProjectSetting.getVO().projectPath);
foreach (ConnectorVO convo in this.element.connectors)
{
CrossReference cref = new CrossReference();
cref.Name = convo.targetObjName;
cref.ElementGUID = convo.targetObjGuid;
ElementVO destObject = elemReader.readElementByGUID(cref.ElementGUID);
// タイプ
cref.Type = convo.connectorType;
// コメント
// cref.Notes = connector.Notes;
cref.Notes = destObject.notes;
// パッケージ
// cref.PackageName = repository.GetPackageByID(targetElement.PackageID).Name;
cref.PackageName = "packageName";
// 属性・操作一覧
cref.AttributesMethods = this.GetAttributesMethodsFromElement(destObject);
// クラスフラグ
cref.classflg = false;
// 削除権限フラグ
cref.CanDelete = false;
crList.Add(cref);
}
return(crList);
}
public virtual void ScanObjects(ref CrossReference lookup)
{
}
public static CrossReference InsertCrossReference(AddressesContext context, long uprn, CrossReference record = null)
{
if (record == null)
{
var fixture = new Fixture();
record = fixture.Build <CrossReference>()
.With(cr => cr.UPRN, uprn)
.Create();
}
record.UPRN = uprn;
context.AddressCrossReferences.Add(record);
context.SaveChanges();
return(record);
}
public IActionResult UpdCrossReference([FromBody] CrossReference crossReference, bool insertIfNoExists = false)
{
return(Ok(cBS.Update(crossReference, insertIfNoExists)));
}
public void ScanObjects(ref CrossReference lookup)
{
Pages().ScanObjects(ref lookup);
}
public Task CreateAsync(CrossReference crossReference) => _repository.CreateAsync(crossReference);
internal void Add( CrossReference RefObject )
{
int index;
try
{
index = base.List.Add( RefObject );
mCanonicalLookup.Add( RefObject.CanonicalName, index );
mNetBIOSLookup.Add( RefObject.NetBIOSName, index );
}
catch( COMException ex )
{
mProcessLog += ex.Message;
}
}
public CrossReferenceCollection( string UserName, string Password, AuthenticationTypes AuthType )
{
try
{
// Obtain NETBIOS only if LDAP accessible to prevent error
DirectoryEntry rootLDAP = new DirectoryEntry( "LDAP://rootDSE", UserName, Password, AuthType );
string crossRefPath = "LDAP://CN=Partitions," + rootLDAP.Properties["configurationNamingContext"].Value.ToString();
DirectoryEntry objCrossRefContainer;
if( ( UserName.Length > 0 ) && ( Password.Length > 0 ) )
{
objCrossRefContainer = new DirectoryEntry( crossRefPath, UserName, Password, AuthType );
}
else
{
objCrossRefContainer = new DirectoryEntry( crossRefPath );
}
DirectoryEntry objCrossRef;
foreach( DirectoryEntry tempLoopVar_objCrossRef in objCrossRefContainer.Children )
{
objCrossRef = tempLoopVar_objCrossRef;
if( !Convert.ToBoolean( objCrossRef.Properties["nETBIOSName"].Value == null ) )
{
string netBIOSName = Convert.ToString( objCrossRef.Properties["nETBIOSName"].Value );
string canonicalName = Convert.ToString( objCrossRef.Properties["dnsRoot"].Value );
string domainPath = Convert.ToString( objCrossRef.Properties["nCName"].Value );
CrossReference crossRef = new CrossReference( domainPath, netBIOSName, canonicalName );
this.Add( crossRef );
}
}
//mProcessLog += "Accessing LDAP : OK"
}
catch( COMException ex )
{
//mProcessLog += "Accessing LDAP : FAIL" & "<br>"
mProcessLog += ex.Message + "<br>";
}
}
public static CrossReference InsertCrossReference(AddressesContext context, long uprn, CrossReference record = null)
{
var fixture = new Fixture();
var randomCrossReference = fixture.Build <CrossReference>()
.With(cr => cr.UPRN, uprn)
.Create();
if (record?.UPRN != null && record.UPRN != 0)
{
randomCrossReference.UPRN = record.UPRN;
}
if (record?.CrossRefKey != null)
{
randomCrossReference.CrossRefKey = record.CrossRefKey;
}
if (record?.Code != null)
{
randomCrossReference.Code = record.Code;
}
if (record?.Name != null)
{
randomCrossReference.Name = record.Name;
}
if (record?.Value != null)
{
randomCrossReference.Value = record.Value;
}
if (record?.EndDate != null)
{
randomCrossReference.EndDate = record.EndDate;
}
context.AddressCrossReferences.Add(randomCrossReference);
context.SaveChanges();
return(randomCrossReference);
}
