public DataForTCP GetDataFromSpreadsheetTCP()
{
ExcelPackage package = new ExcelPackage(new System.IO.FileInfo("wwwroot/xls/NOAA_Solar_Calculations_day.xlsx"));
ExcelWorksheet sheet = package.Workbook.Worksheets[1];
var start = sheet.Dimension.Start;
var end = sheet.Dimension.End;
List <DateTime> TimeFractions = new List <DateTime>();
List <double> AngleH = new List <double>();
List <double> AngleA = new List <double>();
int row_start = 71;//start.Row; 7 AM
int row = row_start;
//Parse rows one by one
while (row <= (row_start + num_interval * interval))
{
//Add the thing from this row to each
TimeFractions.Add(Convert.ToDateTime(sheet.Cells[row, 5].Text));
AngleH.Add(Convert.ToDouble(sheet.Cells[row, 33].Text));
AngleA.Add(Convert.ToDouble(sheet.Cells[row, 34].Text));
//increment row
row = row + interval;
}
//Closes package
package.Dispose();
//Return
var Data = new DataForTCP();
Data.dates = TimeFractions;
Data.angleH = AngleH;
Data.angleA = AngleA;
return(Data);
}
//Listen for incoming TCP Requests
public void TCPListen()
{
DataForTCP datas = GetDataFromSpreadsheetTCP();
string times = datas.GenerateTCPString();
try
{
//DataForTCP data1 = GetDataFromSpreadsheetTCP();
//Init server
Int32 port1 = 12345;
IPAddress localIP = GetIP();
server = new TcpListener(localIP, port1);
server.Start();
//Reading buffer
//Byte[] bytes = new Byte[256];
//String data = null;
//Listen
while (true)
{
Console.Write("Waiting for a connection... ");
// Perform a blocking call to accept requests.
TcpClient client = server.AcceptTcpClient();
Console.WriteLine("Connected!");
//data = null;
// Get a stream object for reading and writing
NetworkStream stream = client.GetStream();
int i;
DataForTCP data = GetDataFromSpreadsheetTCP();
string time = data.GenerateTCPString();
//string time = "Hello";
byte[] msg = System.Text.Encoding.ASCII.GetBytes(time);
stream.Write(msg, 0, msg.Length);
// Send back a response.
//byte[] msg =
//stream.Write(msg, 0, msg.Length);
// Loop to receive all the data sent by the client.
/*
* while ((i = stream.Read(bytes, 0, bytes.Length)) != 0)
* {
* // Translate data bytes to a ASCII string.
* data = System.Text.Encoding.ASCII.GetString(bytes, 0, i);
* Console.WriteLine("Received: {0}", data);
*
* // Process the data sent by the client.
* data = data.ToUpper();
*
* byte[] msg = System.Text.Encoding.ASCII.GetBytes(data);
*
* // Send back a response.
* stream.Write(msg, 0, msg.Length);
* Console.WriteLine("Sent: {0}", data);
* }
*/
// Shutdown and end connection
client.Close();
}
}
catch (SocketException e)
{
Console.WriteLine("SocketException: {0}", e);
}
finally
{
// Stop listening for new clients.
server.Stop();
}
Console.WriteLine("\nHit enter to continue...");
Console.Read();
}
