Pass value from Angular controller to C# API

Question

I currently have a C# controller with a method AddOne():

public void AddOne(int num)
    {
        using (cnxn)
        {
            using (SqlCommand sc = new SqlCommand("INSERT INTO Employees VALUES('this','works'," + num +")", cnxn))
            {
                cnxn.Open();
                sc.ExecuteNonQuery();
                cnxn.Close();
            }
        }
    }

And then for my Angular code, I have a controller EntriesController:

var EntriesController = function ($scope, $stateParams, $location, $http) {
    $scope.Entries = {
        num: 10
    };

    $scope.addValues = function () {

        $http.post('Data/addOne', { num });
    }

}

EntriesController.$inject = ['$scope', '$stateParams', '$location', '$http'];

I have the EntriesController's addValues() function registered to a button on a view which does send insert values into my database if I hardcode them like this:

AddOne:

public void AddOne()
{
    using (cnxn)
    {
        using (SqlCommand sc = new SqlCommand("INSERT INTO Employees VALUES('this','works',10)", cnxn))
        {
             cnxn.Open();
             sc.ExecuteNonQuery();
             cnxn.Close();
        }
    }
}

and the addValues():

$scope.addValues = function () {

    $http.post('Data/addOne');
}

How can I pass data from my Angular's post to my C#'s controller? Thanks, everyone!

WakaChewbacca · Accepted Answer · 2016-07-31 21:45:59Z

I was quite the fool. I needed to pass $scope.Entries with $http.post() and then name the parameters in my C# controller's AddOne() method accordingly. Ex: For the following Angular Controller:

var EntriesController = function ($scope, $stateParams, $location, $http) {
    $scope.Entries = {
        firstName: '',
        lastName: '',
        num: 12
    };
    $scope.addValues = function () {
        $http.post('/Data/addOne', $scope.Entries)

    };
}

My C# controller's AddOne() method to process the post:

 public void AddOne(string firstName, string lastName, int num)
 {
      using (cnxn)
      {
          using (SqlCommand sc = new SqlCommand("INSERT INTO TableName VALUES('"+ firstName +"','"+ lastName +"',"+num+")", cnxn))
          {
              cnxn.Open();
              sc.ExecuteNonQuery();
              cnxn.Close();
          }
      }
 }

Woot.

A G · Accepted Answer · 2016-07-31 19:09:36Z

0

decorate addone method with [HttpPost]

[HttpPost]
public void AddOne()
{
}

answered Jul 31, 2016 at 19:09

A G

22.9k12 gold badges94 silver badges113 bronze badges

Collectives™ on Stack Overflow

Pass value from Angular controller to C# API

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related