How to search for a record in C# and AngularJs!

Question

4.00/5 (1 vote)

See more:

Hi All,

Basically I am learning angular and C#.Net.. Which I am beginning to understand a little bit now.

I have crated a database in which I am adding records from the users input like so:

C#

[HttpPost]

       public HttpResponseMessage PostDs72(Persons p)
       {

           if (p == null)
               return  new HttpResponseMessage(HttpStatusCode.BadGateway);
           PeopleContext db = new PeopleContext();
           db.Persons.Add(p);
           db.SaveChanges();
           return  new HttpResponseMessage(HttpStatusCode.Created);

       }

in the code above is the c# code that is adding or creating a new person in the table Persons.

And in angular side of things this is what I have done:

PHP

$scope.createPerson = function () {
           $http({
               method: 'POST',
               url: '/api/Persons',
               data: JSON.stringify($scope.newperson),
               headers: { 'Content-Type': 'application/JSON' }

           }).success(function (data) {

               $scope.status = " Saved";
               Getinfo();
           }).error(function (error) {

               $scope.status = 'Unabale to save ' + error.message;
           });
       };

this is the angular that code that is creating a new person. or function creating a new person

and in my HTML this is what I have done

HTML

<input type="text" name="FirsName" data-ng-model="newperson.FirstName" placeholder="Enter First Name" required />
           <input type="text" name="LastName" data-ng-model="newperson.Last" placeholder="Enter Last Name" required />
           <input class="search" type="button" value="Add Person" data-ng-show="DisplaySave" data-ng-click="createPerson()"

And that is how I am adding people onto my database.

Now I am stuck! How do I go on in about search for record by their last name provided in a search textbox? can some one plsease help?

If this was windows forms I would code something like

C#

SELECT * FROM Persons WHERE LastName = '"textbox1.text"'

now ofcourse this is not winsforms but is there anyone that can help?

Thank you

Posted 10-Aug-14 9:28am

1Future

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

2irfanshaikh · Answer 1 · 2014-10-08T01:31:00

I think below code will help you:

C# code is for Web API

C#

[HttpGET]
public HttpResponseMessage Get([FromUri]string name)
{
    PeopleContext db = new PeopleContext();
    Person person = db.Persons.FirstOrDefault(x => x.Name == name); //Get the person by name
    return  new HttpResponseMessage(person);
 }

Below code is for AngularJS you have to bind the search textbox with your angularJS field i.e. data-ng-model="searchName" and you can retrive this value by using $scope.searchName.

JavaScript

$scope.getPerson = function (string name) {
           $http({
               method: 'GET',
               url: '/api/Persons?name=' + name,
               headers: { 'Content-Type': 'application/JSON' }
 
           }).success(function (data) {
 //Your Code to displaying Person details on WEb Page
           }).error(function (error) {
 
               $scope.status = 'Unabale to save ' + error.message;
           });
       };

Please don't ask how to bind this with HTML page because that you have to do it from your own.

Also read EntityFramework and AngularJS