Click here to Skip to main content
15,886,199 members
Articles / Web Development / ASP.NET

Real time, Asynchronous Web Pages using jTable, SignalR and ASP.NET MVC

Rate me:
Please Sign up or sign in to vote.
4.95/5 (86 votes)
17 Jan 2012CPOL8 min read 300.7K   10.9K   239  
Real time, asynchronous web pages using jTable, SignalR and ASP.NET MVC
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using System.Web.Mvc;
using Hik.JTable.Models;
using Hik.JTable.Repositories;
using Hik.JTable.Sessions;
using SignalR.Hubs;

namespace jTableWithSignalR.Controllers
{
    public class HomeController : Controller
    {
        private static readonly Random _rnd = new Random();

        private readonly IRepositoryContainer _repository;

        public HomeController()
        {
            _repository = ApplicationRepository.GetRepository(RepositorySize.Small, "realtime");
        }

        public ActionResult Index()
        {
            ViewBag.ClientName = "user-" + _rnd.Next(10000, 99999);
            return View();
        }

        [HttpPost]
        public JsonResult StudentList()
        {
            try
            {
                List<Student> students = _repository.StudentRepository.GetAllStudents();
                return Json(new { Result = "OK", Records = students });
            }
            catch (Exception ex)
            {
                return Json(new { Result = "ERROR", Message = ex.Message });
            }
        }

        [HttpPost]
        public JsonResult CreateStudent(Student student)
        {
            try
            {
                //Validation
                if (!ModelState.IsValid)
                {
                    return Json(new { Result = "ERROR", Message = "Form is not valid! Please correct it and try again." });
                }

                Student addedStudent = _repository.StudentRepository.AddStudent(student);

                //Inform all connected clients
                var clientName = Request["clientName"];
                Task.Factory.StartNew(
                    () =>
                    {
                        var clients = Hub.GetClients<RealTimeJTableDemoHub>();
                        clients.RecordCreated(clientName, student);
                    });

                //Return result to current (caller) client
                return Json(new { Result = "OK", Record = addedStudent });
            }
            catch (Exception ex)
            {
                return Json(new { Result = "ERROR", Message = ex.Message });
            }
        }

        [HttpPost]
        public JsonResult UpdateStudent(Student student)
        {
            try
            {
                //Validation
                if (!ModelState.IsValid)
                {
                    return Json(new { Result = "ERROR", Message = "Form is not valid! Please correct it and try again." });
                }

                //Update in the database
                _repository.StudentRepository.UpdateStudent(student);

                //Inform all connected clients
                var clientName = Request["clientName"];
                Task.Factory.StartNew(
                    () =>
                    {
                        var clients = Hub.GetClients<RealTimeJTableDemoHub>();
                        clients.RecordUpdated(clientName, student);
                    });

                //Return result to current (caller) client
                return Json(new { Result = "OK" });
            }
            catch (Exception ex)
            {
                return Json(new { Result = "ERROR", Message = ex.Message });
            }
        }

        [HttpPost]
        public JsonResult DeleteStudent(int studentId)
        {
            try
            {
                //Delete from database
                _repository.StudentRepository.DeleteStudent(studentId);

                //Inform all connected clients
                var clientName = Request["clientName"];
                Task.Factory.StartNew(
                    () =>
                    {
                        var clients = Hub.GetClients<RealTimeJTableDemoHub>();
                        clients.RecordDeleted(clientName, studentId);
                    });

                //Return result to current (caller) client
                return Json(new { Result = "OK" });
            }
            catch (Exception ex)
            {
                return Json(new { Result = "ERROR", Message = ex.Message });
            }
        }

        [HttpPost]
        public JsonResult GetCityOptions()
        {
            try
            {
                var cities = _repository.CityRepository.GetAllCities().Select(c => new { DisplayText = c.CityName, Value = c.CityId });
                return Json(new { Result = "OK", Options = cities });
            }
            catch (Exception ex)
            {
                return Json(new { Result = "ERROR", Message = ex.Message });
            }
        }
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

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


Written By
Founder Volosoft
Turkey Turkey
I have started programming at 14 years old using Pascal as hobby. Then I interested in web development (HTML, JavaScript, ASP...) before university.

I graduated from Sakarya University Computer Engineering. At university, I learned C++, Visual Basic.NET, C#, ASP.NET and Java. I partly implemented ARP, IP and TCP protocols in Java as my final term project.

Now, I am working on Windows and web based software development mostly using Microsoft technologies in my own company.

My open source projects:

* ABP Framework: https://abp.io
* jTable: http://jtable.org
* Others: https://github.com/hikalkan

My personal web site:

https://halilibrahimkalkan.com

Comments and Discussions