public async Task <IActionResult> Edit(int id, [Bind("EmpNumber,MaritalStatus,Age,Over18,NumCompaniesWorked,NumWorkingYears,DistanceFromHome,Education,EducationField,Gender")] PrimaryTable primaryTable)
{
if (id != primaryTable.EmpNumber)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(primaryTable);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PrimaryTableExists(primaryTable.EmpNumber))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(primaryTable));
}
public void SetPrimaryEnd(IKey key)
{
var oldPrimaryTable = PrimaryTable;
PrimaryTable = key.Parent;
PrimaryKey = key;
oldPrimaryTable.RemoveRelationship(this);
PrimaryTable.AddRelationship(this);
}
public async Task <IActionResult> Create([Bind("EmpNumber,MaritalStatus,Age,Over18,NumCompaniesWorked,NumWorkingYears,DistanceFromHome,Education,EducationField,Gender")] PrimaryTable primaryTable)
{
if (ModelState.IsValid)
{
_context.Add(primaryTable);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(primaryTable));
}
public void DeleteSelf()
{
// Delete all mapped references
//List<ITable> associationTables = this.GetMappingSet().GetAssociationTablesFor(this.Database).ToList();
foreach (ITable associationTable in this.GetMappingSet().GetAssociationTablesFor(this.Database))
{
foreach (Relationship rel in associationTable.Relationships.Where(r => r.PrimaryTable == this.PrimaryTable || r.PrimaryTable == this.ForeignTable))
{
foreach (var reference in associationTable.MappedReferences())
{
List <ITable> sourceEntityMappedTables = ((EntityLayer.EntityImpl)reference.SourceEntity).MappedTables().ToList();
List <ITable> targetEntityMappedTables = ((EntityLayer.EntityImpl)reference.TargetEntity).MappedTables().ToList();
if (sourceEntityMappedTables.Contains(this.ForeignTable) ||
sourceEntityMappedTables.Contains(this.PrimaryTable) ||
targetEntityMappedTables.Contains(this.ForeignTable) ||
targetEntityMappedTables.Contains(this.PrimaryTable))
{
reference.DeleteSelf();
}
}
}
}
//List<EntityLayer.Reference> mappedReferences = this.MappedReferences().ToList();
foreach (var reference in this.MappedReferences())
{
reference.DeleteSelf();
}
var mappingSet = this.GetMappingSet();
if (mappingSet != null)
{
mappingSet.RemoveMappingsContaining(this);
}
if (PrimaryTable != null)
{
PrimaryTable.RemoveRelationship(this);
}
if (ForeignTable != null)
{
ForeignTable.RemoveRelationship(this);
}
Database.RemoveRelationship(this);
}
public override void ResolveCollision(UTXOIndex tablePrimary)
{
KeyValuePair <byte[], uint[]> collisionItem =
CollisionTable.First(k => BitConverter.ToInt32(k.Key, 0) == tablePrimary.PrimaryKey);
CollisionTable.Remove(collisionItem.Key);
if (!tablePrimary.AreCollisionBitsFull() ||
!HasCountCollisions(tablePrimary.PrimaryKey, COUNT_COLLISIONS_MAX))
{
tablePrimary.DecrementCollisionBits(Address);
}
collisionItem.Value[0] |= tablePrimary.GetCollisionBits();
PrimaryTable.Add(tablePrimary.PrimaryKey, collisionItem.Value);
}
public string GenerateQuery(PrimaryTable input)
{
StringBuilder query = new StringBuilder("Select * From ");
query.Append(input.Name + " Where ");
for (int i = 0; i < input.Columns.Count(); i++)
{
var queryParameter = input.Columns[i];
var operatorFactory = new OperatorFactory();
var operatorType = operatorFactory.GetOperator(queryParameter.SqlOperator);
var generatedQuery = operatorType.GenerateQuery(queryParameter);
query.Append(generatedQuery);
if (i < input.Columns.Count() - 1)
{
query.Append(" and ");
}
}
return(query.ToString());
}
void LoadPrimaryData(byte[] buffer)
{
int index = 0;
int key;
int uintLength;
uint[] value;
while (index < buffer.Length)
{
key = BitConverter.ToInt32(buffer, index);
index += 4;
int byteLength = VarInt.GetInt32(buffer, ref index);
uintLength = byteLength >> 2;
value = new uint[uintLength];
Buffer.BlockCopy(buffer, index, value, 0, byteLength);
index += byteLength;
PrimaryTable.Add(key, value);
}
}
public override bool TryGetValueInPrimaryTable(int primaryKey)
{
PrimaryKey = primaryKey;
return(PrimaryTable.TryGetValue(primaryKey, out UTXOPrimary));
}
public override void Clear()
{
PrimaryTable.Clear();
CollisionTable.Clear();
}
public override void AddUTXOAsPrimary(int primaryKey)
{
PrimaryTable.Add(primaryKey, UTXO);
}
public override void RemovePrimary()
{
PrimaryTable.Remove(PrimaryKey);
}
public override string ToString()
{
return(string.Format("PC: {0}{1}", Source == PrimaryTable ? PrimaryTable.ToString() : "." + Source, ColumnName));
}
