Bootstrap and Web API

-
Hi Guys,

This time I made a small webpage which consumes a JSON Web API Restfully. Hope you like it.











Solution

1) Create a Solution like following 

 Add New Project -> ASP.NET MVC 4 Web Application



 Select Web API as the Project Template

The Solution will look as following



















Right Click on Controllers -> Add -> Controller as follows name it as the TimeLogController. Remember you have to call it as Timelog if you name it TimeLog[Controller].













Then Open App_Start -> WebApiConfig.cs and add the following line to enable JSON format (default is XML format)

 //Add this to allow Json format through 
config.Formatters.JsonFormatter.SupportedMediaTypes.Add(new MediaTypeHeaderValue("text/html"));

 Then Create a LINQ-SQL Classes for your database objects and add the following code to the TimeLogController.

 using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Web.Http;

 namespace MyWebAPI.Controllers
{
    public class TimeLogController : ApiController
    {
        /// <summary>
        /// GET api/timelog
        /// </summary>
        /// <returns></returns>
        public List<EP_TimeLog> Get()
        {
            using (TimeLogDataContext context = new TimeLogDataContext())
            {
                var timeLogs = from r in context.EP_TimeLogs
                               select r;

                 return timeLogs.ToList();
            }
            
        }

         /// <summary>
        /// GET api/timelog/id
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public List<EP_TimeLog> Get(long id)
        {
            using (TimeLogDataContext context = new TimeLogDataContext())
            {
                var timeLogs = from r in context.EP_TimeLogs
                               where r.ID == id
                               select r;

                 return timeLogs.ToList();
            }
        }
    }
}

 Finally add the TimeLogs.html file and call the API using jquery.

 <!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <title>Time Logs </title>
</head>
<body>
   

     <div class="panel panel-primary">
           <div class="panel-heading">
             <h1 >My Time Logs</h1>   
       
            </div>
    <div class="panel-body">
             
                   <div class="table-responsive">
                       <table class="table table-striped table-hover" id="timelogs"  width="100%"  >
<thead>
            <tr>


                
</tr>
<tr>
            <th>
                    Name
                </th>
                <th>
                    Description
                </th>
                <th>
                    Start Time
                </th>
                 <th>
                    End Time
                </th>
                <th>
                    Duration (Mins)
                </th>
           
                
</tr>

</thead>
<tbody>
</tbody>

</table>
                   </div>
            
             
            </div>
         </div>

    <script src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-2.0.3.min.js"></script>
    <script src="Content/js/bootstrap.js"></script>
    <script src="Content/js/bootstrap.min.js"></script>
    <link href="Content/css/bootstrap.css" rel="stylesheet" />
    <link href="Content/css/bootstrap.min.css" rel="stylesheet" />
  <script>
      var uri = 'api/timelog';

       $(document).ready(function () {
          // Send an AJAX request
          $.getJSON(uri)
              .done(function (data) {
                  // On success, 'data' contains a list of timelogs.
                  $.each(data, function (key, item) {
                      // Add a list item for the timelog.
                      var row = '<td>' + item.Name + '</td><td>' + item.Description + '</td>'
                      + "<td>" + item.StartTime.replace("T", " ") + "</td><td>" + item.EndTime.replace("T", " ") + "<td>" + item.Duration + "</td>";
                      $('<tr>', { html: row })  
                          .appendTo($('#timelogs'));
                  });
              });
      });

       
     
  </script>

 </body>

</html>

Comments

Post a Comment

Popular posts from this blog

Secure .NET Core Api Server and Client

-
Image
 Hi Guys, Recently I had a requirement to create a JWT token based WebApi server and a WebApi Client to consume it using .NET Core. So first I created two .NET Core Web Api projects as shown below. In the appsettings.json file of both the WebApi Server and the Client. I added the following values. "JwtConfig": { "Key": "dsadsagfaqrergsdsfdffdsfdsffdsfdsfdsfdsfdfdsfsfdsfd", //Some Secure Key longer the better "AudienceId": 7895, //Some Secure Audience Id "HostUrl": "https://somesecureurl.com" //Some Host Url } Now we will first look at implementation of the WebApi Server. 1) First we must create code to Generate the JWT token, this can be achieved by creating JWTTokenManager.cs file and adding following code public interface IJwtTokenManager { string Authenticate(string userName, string password); } public class JwtTokenManager : IJwtTokenManager { private readonly IConfiguration _c...
Read more

Calling ChatGPT using .NET Core

-
Image
  Hi Guys, With the immense hype created by ChatGPT every technology is adopting ways to integrate ChatGPT to their frameworks. Hence, a brilliant team led by Hassan Habib  has managed to give .NET Developers a way to call ChatGPT programmatically and get the responses. Remember this is still a new project you might encounter some issues, but the Standard.AI.OpenAI team is ready to help us developers in this journey. The source code can be found here. 1) First you must register yourself at https://platform.openai.com 2) Then you must generate an API Key as shown below. 3) Now you can start integrating your .NET Core applications to use openai. For this purpose I use a console application (.NET 7).  4) Install the Nuget package Standard.AI.OpenAI 5) Copy paste the below code using Microsoft.AspNetCore.Mvc; using Standard.AI.OpenAI.Brokers.DateTimes; using Standard.AI.OpenAI.Clients.OpenAIs; using Standard.AI.OpenAI.Models.Configurations; using Standard.AI.OpenAI.Model...
Read more

Windows Desktop Watermark with username

-
Image
 Hi Guys, I recently had a requirement from a client to implement a way to protect sensitive documents from being photographed from mobile devices and shared online. To mitigate this issue I made a windows application using C#.  When the exe runs it will read current logged in users' domain user account and display his username throughout the screen. I have given options to change the displayed text to username, hostname of the computer or any custom texts. You can get this application from the following url  Desktop watermark Note: This is works only in Windows Operating Systems
Read more