public IActionResult Raise_Request(Enter_Request enter_Request) { var rowsaffected = _context.Database.ExecuteSqlRaw("EXEC Enter_Request @Name, @Room, @Row, @Seat, @Problem, @ModuleID", new SqlParameter("@Name", enter_Request.Name.ToString()), new SqlParameter("@Room", enter_Request.Room.ToString()), new SqlParameter("@Row", enter_Request.Row), new SqlParameter("@Seat", enter_Request.Seat), new SqlParameter("@Problem", enter_Request.Problem.ToString()), new SqlParameter("@ModuleID", enter_Request.ModuleID)); Alert(enter_Request); ViewBag.Success = rowsaffected; return(View("Index")); }
private void Alert(Enter_Request enter_Request) { //SMB109 URI string URI = "http://192.168.0.50/api/stlaB2I6VZ8O80Qepc-1xfmLrHgyTFvB9IGupaQz/lights/"; //colours are Red 0 or 65535, Orange = 10?, yellow = 12750, Green = 25500, Blue = 46920 int[] lightsArray = new int[] { 0, 5000, 12750, 25500, 46920 }; //Get the row ID plus the seat ID to map to the lights URI = URI + enter_Request.Row.ToString() + "/state"; using (HttpClient client = new HttpClient()) { client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); HttpContent content = new StringContent("{\"on\" : true, \"hue\": " + lightsArray[enter_Request.Seat - 1].ToString() + "}", Encoding.UTF8, "application/json"); HttpResponseMessage response = client.PutAsync(URI, content).Result; } }