/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
//Validation of parameters and user have been successful. We may now proceed to read from the database
var adoPerformance = new Performance_ADO();
int commentCode = adoPerformance.Delete(Ado, DTO, SamAccountName);
if (commentCode == 0)
{
//Can't delete performance entries so we can't proceed
Log.Instance.Debug("Can't delete Performance - request refused");
Response.error = Label.Get("error.delete", DTO.LngIsoCode);
return(false);
}
Response.data = JSONRPC.success;
return(true);
}
/// <summary>
/// Execute
/// </summary>
/// <returns></returns>
protected override bool Execute()
{
List <string> serverList = new List <string>();
List <DateTime> dateTime = new List <DateTime>();
// Dictionary to hold the results coming from the database
Dictionary <string, IndividualResults> dataCollection = new Dictionary <string, IndividualResults>();
double interval = 1; //interval for timestamps
// Dictionary to hold the server and array of results
Dictionary <string, string[]> serverResultCollection = new Dictionary <string, string[]>();
// Database read and result
Performance_ADO adoPerformance = new Performance_ADO();
ADO_readerOutput result = adoPerformance.Read(Ado, DTO.PrfDatetimeStart, DTO.PrfDatetimeEnd);
if (!result.hasData)
{
//Declare and construct the empty output object
dynamic output = new ExpandoObject();
output.datetime = new List <string>();
output.server = new List <string>();
Response.data = output;
return(true);
}
else
{
// create list of timestamps between PrfDatetimeStart start and PrfDatetimeEnd
DateTime starting = DTO.PrfDatetimeStart;
DateTime ending = DTO.PrfDatetimeEnd;
for (DateTime ts = starting; ts <= ending; ts = ts.AddMinutes(interval))
{
dateTime.Add(ts.AddTicks(-(ts.Ticks % TimeSpan.TicksPerMinute)));
}
// List containing results.data values
List <dynamic> myData = result.data;
// Cycle through and add required elements to dataCollection Dictionary
foreach (dynamic element in myData)
{
if (!serverList.Contains(element.PrfServer))
{
serverList.Add(element.PrfServer);
}
IndividualResults tempResults = new IndividualResults();
tempResults.Datetime = element.PrfDatetime;
tempResults.ServerValue = element.PrfServer;
// Retrieve data from the PrfProcessor column
tempResults.DataValue = element.PrfProcessor;
dataCollection.Add(element.PrfServer + element.PrfDatetime, tempResults);
}
// use the server list to construct an array
string[] serverArray = new string[serverList.Count];
serverArray = serverList.ToArray();
List <string> dateString = dateTime.Select(dt => dt.ToString()).ToList();
for (int i = 0; i < serverList.Count; i++)
{
string[] serverTotals = new string[dateTime.Count];
for (int j = 0; j < dateTime.Count; j++)
{
foreach (var item in dataCollection)
{
if ((item.Value.ServerValue.ToString() == serverList[i]) && (item.Value.Datetime == dateTime[j]))
{
serverTotals[j] = item.Value.DataValue.ToString();
break;
}
else
{
serverTotals[j] = null;
}
}
}
serverResultCollection.Add(serverArray[i], serverTotals);
}
// Convert Dictionary to IEnumerable
IEnumerable serverResults = serverResultCollection.Select(p => new Dictionary <string, string[]>()
{
{ p.Key, p.Value }
});
//Declare and construct the output object
dynamic output = new ExpandoObject();
output.datetime = dateString;
output.server = serverResults;
Response.data = output;
return(true);
}
}