// NEW CODE
/// <summary>
/// Get report XML and measurement XML, parse them in Xdocuments, and create CSV
/// </summary>
/// <param name="start"></param>
/// <param name="stop"></param>
/// <returns></returns>
//async public Task<string> TaskCreateCSVString(string start, string stop)
//{
// _start = start;
// _stop = stop;
// List<KeyValuePair<string, string>> pairs = new List<KeyValuePair<string, string>>
// {
// new KeyValuePair<string, string>("start", _start),
// new KeyValuePair<string, string>("stop", _stop),
// new KeyValuePair<string, string>("type", "by_15min"),
// new KeyValuePair<string, string>("tags", "Allt"),
// new KeyValuePair<string, string>("user", _user),
// new KeyValuePair<string, string>("pass", _pass),
// };
// // Get XML as strings, parse them and fill XDocuments
// string reportRes =await GetReport(_ip);
// _reportDoc = XDocument.Parse(reportRes);
// FormCustomConsole.WriteLine("-------Start of XML documents:");
// FormCustomConsole.WriteLine(_reportDoc.ToString());
// string measurementRes = await HTTPClientClass.PostRequest("http://"+_ip+"/custom.xml", pairs);
// _measurementDoc = XDocument.Parse(measurementRes);
// FormCustomConsole.WriteLine(_measurementDoc.ToString());
// FormCustomConsole.WriteLine("-------End of XML documents:");
// return CreateCSVFromXML(start, stop);
//}
async public static Task <string> GetReport(string ip)
{
return(await HTTPClientClass.GetRequest("http://" + ip + "/report.xml"));
}
async private void downloadCSVToolStripMenuItem_Click(object sender, EventArgs e)
{
var cells = dataGridView1.SelectedCells;
Console.WriteLine("Number of cells: " + dataGridView1.SelectedCells.Count);
List <int> indexes = new List <int>();
if (dataGridView1.SelectedCells.Count < 0) // Check if nothing is selected
{
return;
}
// ------------- FIND FIRST AND LAST (SELECTED) INDEX IN DATAGRID
foreach (DataGridViewTextBoxCell item in cells)
{
int temp = item.RowIndex * 96 + item.ColumnIndex - 1; // Convert to data array index
if (temp < 0) // Check if header is selected
{
return;
}
indexes.Add(temp);
}
// Find min and max indexes
int indexMin = indexes.First();
int indexMax = indexes.First();
foreach (var item in indexes)
{
if (indexMin > item)
{
indexMin = item;
}
}
foreach (var item in indexes)
{
if (indexMax < item)
{
indexMax = item;
}
}
// ---------- INDEXES FOUND
//DEBUG
Stopwatch stopWatch = new Stopwatch();
stopWatch.Start();
// debug
// Now select time period based on min-max
var startDate = dataPtr.data[indexMin].date;
var endDate = dataPtr.data[indexMax].date;
// Get username and password from textboxes
string username = textBoxUsername.Text;
string password = textBoxPassword.Text;
// Create array of date pairs if xml data needs to be fragmented
List <CustomXmlDatePair> datePeriodsList = CustomXmlDatePair.FragmentDate(startDate, endDate);
// ----- Instantiate ntpm object
string ip;
try
{
// Get IP and Port from database
ip = GetIPAndPort();
}
catch (Exception)
{
MessageBox.Show("Couldn't get IP and Port from database");
return; // abort
}
// ----------------------------------- Get and parse report.xml
string reportRes;
XDocument reportDoc;
try
{
reportRes = await NTPMControllerClass.GetReport(ip); // Get xml report from NTPM
reportDoc = XDocument.Parse(reportRes);
}
catch (Exception)
{
MessageBox.Show("Couldn't get or parse report.xml");
return; // abort
}
// Create header dates
string headerStartTime = HelperClass.ConvertToNtpmCustomXmlTime(startDate);
string headerEndTime = HelperClass.ConvertToNtpmCustomXmlTime(endDate);
string csvHeader = NTPMControllerClass.CreateCSVHeader(headerStartTime, headerEndTime, reportDoc);
FormCustomConsole.WriteLine("StartTime: " + headerStartTime);
FormCustomConsole.WriteLine("EndTime: " + headerEndTime);
// now we only need to fill values with each row
// --------------------------------Get and parse measurement.xml
List <XDocument> measurementDoc = new List <XDocument>();
List <string> measurementRows = new List <string>();
foreach (var datePeriod in datePeriodsList)
{
Console.WriteLine("Parsing period: " + datePeriod.startHeader + "---" + datePeriod.endHeader);
await HelperRetryClass.DoWithRetryAsync(async() =>
{
FormCustomConsole.WriteLine("Loading: " + datePeriod.startHeader + "---" + datePeriod.endHeader);
List <KeyValuePair <string, string> > pairs = NTPMControllerClass.GetPairsForCustomXmlPostMethod(datePeriod.startHeader, datePeriod.endHeader, username, password);
string measurementRes = await HTTPClientClass.PostRequest("http://" + ip + "/custom.xml", pairs);
XDocument tempMeasure = XDocument.Parse(measurementRes);
NTPMControllerClass.CheckErrorTag(tempMeasure);
string measureRow = NTPMControllerClass.CreateCSVMeasurementRow(tempMeasure);
// At this point, download and parsing is ok
measurementRows.Add(measureRow);
measurementDoc.Add(tempMeasure);
},
TimeSpan.FromSeconds(1));
}
// now form whole string (HEADER + TAGS + MEASUREMENT ROWS)
StringBuilder sFinal = new StringBuilder();
sFinal.Append(csvHeader);
foreach (var item in measurementRows)
{
sFinal.Append(item);
sFinal.Append("\r\n");
}
sFinal.Remove(sFinal.Length - 2, 2); // Remove last new line
// Write elapsed time
stopWatch.Stop();
FormCustomConsole.WriteLine("XML fetching operation finished in: " + (stopWatch.ElapsedMilliseconds / 1000).ToString() + "seconds");
// --------------------------------------- Finaly save file
string fileName = XmlHelper.FindFirstDescendant("hostname", reportDoc).Trim();
string fileMac = XmlHelper.FindFirstDescendant("mac", reportDoc).Replace(':', '-');
string fileType = "by_15min";
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel File|*.csv";
// Create file name (based on downloaded data)
sfd.FileName = fileName + "_" + fileMac + "_" + headerStartTime + "_" + headerEndTime + "_" + fileType;
if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string path = sfd.FileName;
StreamWriter sw = new StreamWriter(File.Create(path));
sw.Write(sFinal.ToString());
sw.Dispose();
}
}
async void DEBUGFUNC()
{
try
{
#warning CHANGE DATE FORMAT
DateTime startDate = new DateTime(2017, 10, 10, 0, 0, 0);
DateTime endDate = new DateTime(2017, 10, 10, 23, 45, 0);
// Create array of date pairs if xml data needs to be fragmented
List <CustomXmlDatePair> datePeriodsList = CustomXmlDatePair.FragmentDate(startDate, endDate);
string ip = "192.168.2.21";
string reportRes;
XDocument reportDoc;
try
{
reportRes = await NTPMControllerClass.GetReport(ip);
reportDoc = XDocument.Parse(reportRes);
}
catch (Exception)
{
MessageBox.Show("Couldn't get or parse report.xml");
return; // abort
}
// Create header dates
string headerStartTime = HelperClass.ConvertToNtpmCustomXmlTime(startDate);
string headerEndTime = HelperClass.ConvertToNtpmCustomXmlTime(endDate);
string csvHeader = NTPMControllerClass.CreateCSVHeader(headerStartTime, headerEndTime, reportDoc);
// now we only need to fill values with each row
// ---- Get and parse measurement.xml
List <XDocument> measurementDoc = new List <XDocument>();
List <string> measurementRows = new List <string>();
foreach (var datePeriod in datePeriodsList)
{
Console.WriteLine("Parsing period: " + datePeriod.startHeader + "---" + datePeriod.endHeader);
await HelperRetryClass.DoWithRetryAsync(async() =>
{
// Generate the random number between 1-2
Random rnd = new Random();
var result = rnd.Next(1, 10);
if (result == 2)
{
throw new Exception("Random throw for debug");
}
List <KeyValuePair <string, string> > pairs = NTPMControllerClass.GetPairsForCustomXmlPostMethod(datePeriod.startHeader, datePeriod.endHeader, "neticoadmin", "neticoadmin");
string measurementRes = await HTTPClientClass.PostRequest("http://" + ip + "/custom.xml", pairs);
XDocument tempMeasure = XDocument.Parse(measurementRes);
//FormCustomConsole.WriteLine(tempMeasure.ToString());
NTPMControllerClass.CheckErrorTag(tempMeasure);
string measureRow = NTPMControllerClass.CreateCSVMeasurementRow(tempMeasure);
// At this point, download and parsing is ok
measurementRows.Add(measureRow);
measurementDoc.Add(tempMeasure);
},
TimeSpan.FromSeconds(2));
}
StringBuilder sFinal = new StringBuilder();
sFinal.Append(csvHeader);
foreach (var item in measurementRows)
{
sFinal.Append(item);
sFinal.Append("\r\n");
}
sFinal.Remove(sFinal.Length - 2, 2); // Remove last new line
Console.WriteLine("After task create CSV");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}