c# - Passing date from ngModel to stored procedure in WebAPI and SQL Server -

i have created stored procedure corresponding results sql server db contains chosen date datepicker directive in angular app. don't know how access webapi stored procedure in sql server db. in following code show approach:

created stored procedure in sql server:

use [sample_db] go set ansi_nulls on go set quoted_identifier on go  create procedure getdatum     @dt datetime begin     set nocount on;      select b.id, b.datum, b.num_aucts     dbo.beispiels b     b.datum = @dt end go 

ctrl in angular:

//resource webapi var resource = $resource(baseurl + '/api/beispiels/:id', {     id: '@id' }, {});  $scope.list = resource.query();  //definitions of datepicker (uibootstrap) $scope.open = function ($event) {    $event.preventdefault();    $event.stoppropagation();     $scope.opened = true; };  $scope.dateoptions = {    formatyear: 'yy',    startingday: 1 }; 

view in angular app:

<div class="row">     <div class="col-md-6">         <p class="input-group">             <input type="text"                     class="form-control"                     datepicker-popup                     ng-model="dt"                     is-open="opened"                     min-date=""                     max-date=""                     datepicker-options="dateoptions"                    ng-required="true"                     close-text="close"                     />             <span class="input-group-btn">                 <button type="button" class="btn btn-default" ng-click="open($event)">                    <i class="glyphicon glyphicon-calendar"></i>                 </button>             </span>         </p>     </div> </div> <div class="row">     <div class="col-md-6">         <table class="table table-bordered">             <th>id</th>             <th>datum</th>             <th>num aucts</th>             <tr ng-repeat="liste in list">                 <td>{{ liste.id }}</td>                 <td>{{ liste.datum }}</td>                 <td>{{ liste.num_aucts }}</td>             </tr>         </table>     </div> </div> 

webapi controller:

... public class beispielscontroller : apicontroller {    private eascontext db = new eascontext();     // get: api/beispiels    [httpget]    public iqueryable<beispiel> getbeispiels()    {       return db.beispiels.asqueryable();    } ... } 

db context:

public partial class eascontext : dbcontext {     public eascontext()       : base("name=eascontext")     {     }      protected override void onmodelcreating(dbmodelbuilder modelbuilder)     {        throw new unintentionalcodefirstexception();     }      public virtual objectresult<getdatum> getdatum(nullable<system.datetime> dt)      {          var dtparameter = dt.hasvalue ?          new objectparameter("dt", dt) :          new objectparameter("dt", typeof(system.datetime));           return ((iobjectcontextadapter)this).objectcontext.executefunction<getdatum>("getdatum", dtparameter);      } ... 

i want synchronize ngmodel value dt value stored procedure @dt, means, when user click on datepicker , chooses date. date displayed in ngmodel input field , should insert stored procedure , returns result example data date have "2013/01/03" or else.