public IActionResult GetAllOrders(int id, int pagenum = 0, int maxitems = 0)
{
String name = "";
foreach (Claim c in User.Claims)
{
if (c.Type == "name")
{
name = c.Value;
break;
}
}
if (name != "")
{
if (_reports.isAllowed(name, id))
{
ServerResults result = new ServerResults();
result.count = _reports.GetFindingsCount(id)[0].TotalServers;
result.results = _reports.GetServerSummary(id, pagenum, maxitems);
return(Ok(result));
}
else
{
return(Unauthorized());
}
}
else
{
return(BadRequest());
}
}
public List <ServerStatus> getServerStatus()
{
string returnStr = "";
//try
//{
string conString = ConfigurationManager.ConnectionStrings["VitalSignsConnectionString"].ToString();
List <ServerResults> lp = new List <ServerResults>();
List <ServerStatus> lSS = new List <ServerStatus>();
ServerStatus SS = new ServerStatus();
VSAdaptor VSA = new VSAdaptor();
StringBuilder s = new StringBuilder();
s.Append("SELECT COUNT(*) CNT,StatusCode from Status where StatusCode in ('Issue','Maintenance','Not Responding','OK') group by StatusCode");
DataTable DT = VSA.FetchData(conString, s.ToString());
SS.ServerType = "All";
foreach (DataRow dr in DT.Rows)
{
ServerResults sr = new ServerResults();
sr.Total = Convert.ToInt32(dr[0].ToString());
sr.Status = dr[1].ToString();
lp.Add(sr);
}
SS.ServerResults = lp.ToArray();
lSS.Add(SS);
StringBuilder s1 = new StringBuilder();
s1.Append("SELECT COUNT(*) CNT,StatusCode,Type from Status WHERE StatusCode in ('Issue','Maintenance','Not Responding','OK') group by StatusCode,Type union SELECT COUNT(*) CNT,StatusCode,SecondaryRole+' (*)' from Status WHERE StatusCode in ('Issue','Maintenance','Not Responding','OK') group by StatusCode,SecondaryRole order by Type");
DT = VSA.FetchData(conString, s1.ToString());
List <ServerResults> lp1 = new List <ServerResults>();
string serverType = "";
ServerStatus SS2 = new ServerStatus();
foreach (DataRow dr in DT.Rows)
{
ServerResults sr = new ServerResults();
sr.Total = Convert.ToInt32(dr[0].ToString());
sr.Status = dr[1].ToString();
if ((serverType != "" && serverType != dr[2].ToString()))
{
ServerStatus SS1 = new ServerStatus();
SS1.ServerType = serverType;
SS1.ServerResults = lp1.ToArray();
lSS.Add(SS1);
lp1.Clear();
}
lp1.Add(sr);
serverType = dr[2].ToString();
}
DT.Dispose();
SS2.ServerType = serverType;
SS2.ServerResults = lp1.ToArray();
lSS.Add(SS2);
return(lSS);
//}
//catch (Exception ex)
//{
// returnStr = ex.Message.ToString();
//}
}