public async Task CreateNode([FromBody] MeterLocationTree meterLocationTree)
{
if (meterLocationTree != null)
{
await _meterLocationTreeService.AddLocationElement(meterLocationTree);
}
}
public async Task DeleteNode(int id)
{
MeterLocationTree meterLocationTree = _dbContext.MeterLocationTree.Find(id);
var trees = _dbContext.MeterLocationTree.AsEnumerable().Where(p => p.Path.Compare(meterLocationTree.Path)).ToList();
_dbContext.MeterLocationTree.RemoveRange(trees);
await _dbContext.SaveChangesAsync();
}
public async Task <string> CreateNode(int count)
{
TimeSpan startTime = new TimeSpan(DateTime.Now.Ticks);
//int[] cityPath = new int [0];
int[] streetPath = new int[0];
int[] housePath = new int[0];
int[] meterPath = new int[0];
for (int i = 1; i <= count; i++)
{
MeterLocationTree city = new MeterLocationTree();
city.LocationElement = $"Місто{i}";
city.Path = new int[0];
await AddLocationElement(city);
Array.Resize(ref streetPath, city.Path.Length);
Array.Copy(city.Path, streetPath, city.Path.Length);
for (int k = 1; k <= 2; k++)
{
MeterLocationTree street = new MeterLocationTree();
street.LocationElement = $"Вулиця{i}{k}";
Array.Copy(streetPath, street.Path = new int[streetPath.Length], streetPath.Length);
await AddLocationElement(street);
Array.Resize(ref housePath, street.Path.Length);
Array.Copy(street.Path, housePath, street.Path.Length);
for (int t = 1; t <= 2; t++)
{
MeterLocationTree house = new MeterLocationTree();
house.LocationElement = $"Дім{i}{k}{t}";
Array.Copy(housePath, house.Path = new int[housePath.Length], housePath.Length);
await AddLocationElement(house);
Array.Resize(ref meterPath, house.Path.Length);
Array.Copy(house.Path, meterPath, house.Path.Length);
for (int z = 1; z <= 2; z++)
{
MeterLocationTree meter = new MeterLocationTree();
meter.LocationElement = $"Лічильник{i}{k}{t}{z}";
Array.Copy(meterPath, meter.Path = new int[meterPath.Length], meterPath.Length);
await AddLocationElement(meter);
}
}
}
}
await _dbContext.SaveChangesAsync();
TimeSpan finishTime = new TimeSpan(DateTime.Now.Ticks);
return(finishTime.Subtract(startTime).ToString());
}
public async Task AddLocationElement(MeterLocationTree meterLocationTree)
{
if (meterLocationTree.Path == null)
{
meterLocationTree.Path = new int[0];
}
_dbContext.MeterLocationTree.Add(meterLocationTree);
_dbContext.SaveChanges();
var path = meterLocationTree.Path.ToList();
path.Add(meterLocationTree.Id);
meterLocationTree.Path = path.ToArray();
_dbContext.MeterLocationTree.Update(meterLocationTree);
await _dbContext.SaveChangesAsync();
}
public async Task UpdateNode(int?parentId, MeterLocationTree meterLocationTree)
{
if (_dbContext.MeterLocationTree.Any(p => p.Id == meterLocationTree.Id))
{
var childNode = _dbContext.MeterLocationTree.Find(meterLocationTree.Id);
if (parentId != null)
{
var parentNode = _dbContext.MeterLocationTree.Find(parentId);
if (parentNode.Path.IsChildOf(childNode.Path))
{
throw new Exception("Parent node cannot be moved to its child node!");
}
else if (parentNode != null || parentId == 0)
{
List <int> path = null;
if (parentId == 0)
{
path = new List <int>();
}
else
{
path = parentNode.Path.ToList();
}
path.Add(meterLocationTree.Id);
var childList = _dbContext.MeterLocationTree.AsEnumerable().Where(p => p.Path.IsChildOf(childNode.Path)).ToList();
if (childList != null)
{
foreach (var child in childList)
{
var pathForChild = new List <int>();
pathForChild.AddRange(path);
int indexOfId = child.Path.ToList().IndexOf(child.Id);
var temp = child.Path.ToList().GetRange(indexOfId, child.Path.Length - indexOfId);
child.Path = pathForChild.Concat(temp).ToArray();
_dbContext.MeterLocationTree.Update(child);
}
}
childNode.Path = path.ToArray();
}
}
if (!childNode.LocationElement.Equals(meterLocationTree.LocationElement) && !string.IsNullOrEmpty(meterLocationTree.LocationElement))
{
childNode.LocationElement = meterLocationTree.LocationElement;
}
_dbContext.MeterLocationTree.Update(childNode);
await _dbContext.SaveChangesAsync();
}
}
