Convert PHP snippet to C# API

Hi I need the following code converted from PHP to C#. I want the data to be returned in the following format: [{"name":"Booked","data":[2,3,2]},{"name":"Capacity","data":[10,15,15]},{"name":"Vacancies","data":[8,12,13]}] PHP code: private function getDailyVacancies() { if ($this->get_request_method() != "GET") { $this->response('', 406); } $today = date('Ymd'); $sqlbooking = "select COUNT([login to view URL]) as Total,classroom from Attendance INNER JOIN Classroom ON [login to view URL] = [login to view URL] where DropDate = '$today' AND [login to view URL] = 0 AND IsAbsent = 1 GROUP BY Classroom ORDER BY [login to view URL]"; //echo $sqlbooking; //die; $bookings = $this->db->rawQuery($sqlbooking, null); $capacities = $this->db->rawQuery("SELECT [login to view URL] AS Total FROM Attendance INNER JOIN Classroom ON [login to view URL] = [login to view URL] where DropDate = '$today' AND IsAbsent = 1 AND Active = 0 GROUP BY [login to view URL] ORDER BY [login to view URL]", null); $result = array(); $rowsBooked = array(); foreach ($bookings as $booking) { $rowsBooked['name'] = 'Booked'; $rowsBooked['data'][] = $booking['Total']; } $rowsCapacity = array(); foreach ($capacities as $capacity) { $rowsCapacity['name'] = 'Capacity'; $rowsCapacity['data'][] = $capacity['Total']; } array_push($result, $rowsBooked); array_push($result, $rowsCapacity); $arr1 = array(); foreach ($bookings as $booking) { $arr1[] = $booking['Total']; } $arr2 = array(); foreach ($capacities as $capacity) { $arr2[] = $capacity['Total']; } $subtracted = array_map(function ($x, $y) { return $y - $x; }, $arr1, $arr2); $vacancies = array_combine(array_keys($arr1), $subtracted); $rowsVacancies = array(); foreach ($vacancies as $vacancy) { $rowsVacancies['name'] = 'Vacancies'; $rowsVacancies['data'][] = $vacancy; } array_push($result, $rowsVacancies); if ($this->db->count > 0) { $this->response($this->json_numeric($result), 200); // send user details } $this->response('', 204); }