public HttpResponseMessage GetSystemStats() { SystemStats toReturn = new SystemStats(); using (SqlConnection connection = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["DBCS"].ConnectionString)) { string cmdString = "SELECT * FROM dbo.GetServiceData()"; SqlDataAdapter da = new SqlDataAdapter(cmdString, connection); DataSet set = new DataSet(); try { da.Fill(set); DataRow row = set.Tables[0].Rows[0]; toReturn.ApplicationsNumber = Convert.ToInt32(row["CurrentAppsNumber"]) + Convert.ToInt32(row["DoneAppsNumber"]); toReturn.ServicesNumber = Convert.ToInt32(row["ServicesNumber"]); toReturn.UsersNumber = Convert.ToInt32(row["UsersNumber"]); toReturn.DialoguesNumber = Convert.ToInt32(row["DialoguesNumber"]); } catch (Exception ex) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, ex.Message)); } } return(Request.CreateResponse(HttpStatusCode.OK, toReturn)); }
public ActionResult Index(string message) { if (User.Identity.IsAuthenticated) { return(RedirectToAction("Main", "Service", null)); } try { if (message != null) { string[] parameters = message.Split('|'); ViewData["message"] = parameters[1]; ViewData["message_state"] = parameters[0]; } using (HttpClient client = WebApiClient.InitializeClient(Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/")) { HttpResponseMessage response = client.GetAsync("api/ServiceApi/SystemStats").Result; if (response.IsSuccessStatusCode) { SystemStats stats = response.Content.ReadAsAsync <SystemStats>().Result; ViewData["UsersNumber"] = stats.UsersNumber; ViewData["ServicesNumber"] = stats.ServicesNumber; ViewData["ApplicationsNumber"] = stats.ApplicationsNumber; ViewData["DialoguesNumber"] = stats.DialoguesNumber; } else { return(View("Error")); } } return(View()); } catch { return(View("Error")); } }