public async Task <NetworkPoint> CreateNetworkPointAsync(NetworkPoint networkPoint)
{
networkPoint.Id = Guid.NewGuid();
_context.Add(networkPoint);
await _context.SaveChangesAsync();
return(networkPoint);
}
private TcpBridgeSettings GetBridgeSettings(EzServerSettings settings, List <NetworkPoint> clients)
{
NetworkPoint listenPoint = new NetworkPoint(settings.BridgeListenEndPoint);
NetworkPoint publicPoint = new NetworkPoint(settings.BridgePublicEndPoint);
TcpBridgeSettings bridgeSettings = new TcpBridgeSettings(listenPoint, publicPoint, clients);
bridgeSettings.ServerSettings = settings.BridgeServerSettings;
return(bridgeSettings);
}
public TcpBridgeSettings(TcpBridgeSettings settings)
{
PublicEndPoint = new NetworkPoint(settings.PublicEndPoint);
ListenEndPoint = new NetworkPoint(settings.ListenEndPoint);
ClientEndPoints = new List <NetworkPoint>();
foreach (NetworkPoint tcpEndpoint in settings.ClientEndPoints)
{
ClientEndPoints.Add(new NetworkPoint(tcpEndpoint));
}
ServerSettings = new AsyncEventSettings(settings.ServerSettings);
}
public NetworkPointViewModel ConvertFromNetworkPointToViewModel(NetworkPoint networkPoint)
{
var networkPointModel = new NetworkPointViewModel()
{
Id = networkPoint.Id,
Name = networkPoint.Name,
Latitude = networkPoint.Geoposition?.Latitude,
Longitude = networkPoint.Geoposition?.Longitude,
Country = networkPoint.Geoposition?.Country,
Region = networkPoint.Geoposition?.Region,
City = networkPoint.Geoposition?.City,
Address = networkPoint.Geoposition?.Address
};
return(networkPointModel);
}
public TcpBridgeSettings(NetworkPoint listenEndPoint, NetworkPoint publicEndPoint, List <NetworkPoint> clientEndPoints)
{
PublicEndPoint = new NetworkPoint(publicEndPoint);
ListenEndPoint = new NetworkPoint(listenEndPoint);
ClientEndPoints = new List <NetworkPoint>();
foreach (NetworkPoint tcpEndpoint in clientEndPoints)
{
ClientEndPoints.Add(new NetworkPoint(tcpEndpoint));
}
if (!ClientEndPoints.Contains(PublicEndPoint))
{
ClientEndPoints.Add(PublicEndPoint);
}
ServerSettings = new AsyncEventSettings();
}
public NetworkPoint ConvertFromViewModelToNetworkPoint(NetworkPointViewModel networkPointModel)
{
var networkPoint = new NetworkPoint()
{
Id = networkPointModel.Id,
Name = networkPointModel.Name,
Geoposition = new Geoposition()
{
Longitude = networkPointModel.Longitude,
Latitude = networkPointModel.Latitude,
Country = networkPointModel.Country,
Region = networkPointModel.Region,
City = networkPointModel.City,
Address = networkPointModel.Address
}
};
return(networkPoint);
}
public IInstructionReceiver Create(string address)
{
var networkAddress = new NetworkAddress(address);
var networkPoint = new NetworkPoint(
networkAddress,
NetworkTunnelFactory,
SocketFactory,
_recorder);
var nodeGateWay = new NodeGateway(
networkPoint,
SessionFactory,
_recorder);
var instructionReceiver = new InstructionReceiver(
nodeGateWay,
new SessionHolder(_recorder),
_recorder);
return(instructionReceiver);
}
public async Task <NetworkPoint> CreateNetworkPointAsync(NetworkPointViewModel networkPointModel)
{
var networkPoint = new NetworkPoint
{
Name = networkPointModel.Name,
Id = Guid.NewGuid(),
Geoposition = new Geoposition()
{
Longitude = networkPointModel.Longitude,
Latitude = networkPointModel.Latitude,
Country = networkPointModel.Country,
Region = networkPointModel.Region,
City = networkPointModel.City,
Address = networkPointModel.Address,
Id = Guid.NewGuid()
},
Network = _context.Networks.FirstOrDefault(item => item.Id == networkPointModel.NetworkId)
};
_context.Add(networkPoint);
await _context.SaveChangesAsync();
return(networkPoint);
}
public async Task <ActionResult> OnPostImport()
{
try
{
IFormFile file = Request.Form.Files[0];
var networkId = Request.Form["networkId"].ToString();
//fdata.append('networkName', $('#networkName').val());
//fdata.append('networkNameCell', $('#networkNameCell').val());
//fdata.append('nameCell', $('#nameCell').val());
//fdata.append('cityCell', $('#cityCell').val());
//fdata.append('addressCell', $('#addressCell').val());
//fdata.append('regionCell', $('#regionCell').val());
int nameCell = Convert.ToInt32(Request.Form["nameCell"]);
int addressCell = Convert.ToInt32(Request.Form["addressCell"].ToString());
int cityCell = Convert.ToInt32(Request.Form["cityCell"].ToString());
int regionCell = Convert.ToInt32(Request.Form["regionCell"].ToString());
int networkNameCell = Convert.ToInt32(Request.Form["networkNameCell"].ToString());
string networkName = Request.Form["networkName"].ToString();
//int nameCell = 2;
//int addressCell = 4;
//int cityCell = 3;
//int regionCell = 5;
//int networkNameCell = 1;
//string networkName = "АНЦ";
string folderName = "Upload";
string webRootPath = _hostingEnvironment.WebRootPath;
string newPath = Path.Combine(webRootPath, folderName);
StringBuilder sb = new StringBuilder();
if (!Directory.Exists(newPath))
{
Directory.CreateDirectory(newPath);
}
var network = await _service.GetNetwork(new Guid(networkId));
if (file.Length > 0)
{
string sFileExtension = Path.GetExtension(file.FileName).ToLower();
ISheet sheet;
string fullPath = Path.Combine(newPath, file.FileName);
using (var stream = new FileStream(fullPath, FileMode.Create))
{
file.CopyTo(stream);
stream.Position = 0;
if (sFileExtension == ".xls")
{
HSSFWorkbook hssfwb = new HSSFWorkbook(stream); //This will read the Excel 97-2000 formats
sheet = hssfwb.GetSheetAt(0); //get first sheet from workbook
}
else
{
XSSFWorkbook hssfwb = new XSSFWorkbook(stream); //This will read 2007 Excel format
sheet = hssfwb.GetSheetAt(0); //get first sheet from workbook
}
IRow headerRow = sheet.GetRow(0); //Get Header Row
int cellCount = headerRow.LastCellNum;
var networkPointList = new List <NetworkPoint>();
for (int i = (sheet.FirstRowNum + 1); i <= sheet.LastRowNum; i++) //Read Excel File
{
IRow row = sheet.GetRow(i);
if (row == null)
{
continue;
}
if (row.Cells.All(d => d.CellType == CellType.Blank))
{
continue;
}
var currentPoint = new NetworkPoint()
{
Network = network
};
var currentNetworkName = row.GetCell(networkNameCell)?.ToString();
if (currentNetworkName != networkName)
{
continue;
}
currentPoint.Name = row.GetCell(nameCell).ToString();
currentPoint.Geoposition = new Geoposition()
{
Country = "Україна",
City = row.GetCell(cityCell)?.ToString(),
Region = row.GetCell(regionCell)?.ToString(),
Address = row.GetCell(addressCell)?.ToString()
};
currentPoint.Geoposition = await Helpers.GeocodingHelper.GetCoordinatesByAddressAsync(currentPoint.Geoposition);
networkPointList.Add(currentPoint);
}
await _networkPointService.AddNetworkPoints(new Guid(networkId), networkPointList);
}
Directory.Delete(newPath, true);
}
return(Content("Import finished."));
}
catch (Exception ex)
{
return(Content("Import failed." + ex.Message));
}
}
public TcpBridgeRegistration(NetworkPoint networkPoint)
{
SourceIp = networkPoint.Address.ToString();
SourcePort = networkPoint.Port;
}
public async Task UpdateNetworkPointAsync(NetworkPoint networkPoint)
{
_context.Update(networkPoint);
await _context.SaveChangesAsync();
}
