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

namespace AgentUnsoldReturnTicketApplication.Models
{
    public class LotteryTicketDistribution
    {
        public string IssueNumber { get; set; }

        public string StartingNumber { get; set; }

        public string EndingNumber { get; set; }

        public int DistributionRange { get; set; }

    }
}

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data.SqlClient;

using System.Data;

using System.Linq;

using System.Web;

namespace AgentUnsoldReturnTicketApplication.Models
{
    public class LotteryDistributionDB
    {
        //database connection string
        string connectionString =
        ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

        //Return the list of distributions
        public List<LotteryTicketDistribution> distributionList()
        {
            List<LotteryTicketDistribution> dl = new
            List<LotteryTicketDistribution>();
            using (SqlConnection con = new SqlConnection(connectionString))
            {
                con.Open();
                SqlCommand cmd = new
                SqlCommand("spGetLotteryTicketDistribution",con);
                cmd.CommandType = CommandType.StoredProcedure;
                SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    dl.Add(
                        new LotteryTicketDistribution {
                        IssueNumber = dr["IssueNo"].ToString(),
                        //IssueDate = Convert.ToDateTime(dr["IssueDate"]),
                        StartingNumber = dr["NoFrom"].ToString(),
                        EndingNumber = dr["NoTo"].ToString(),
                        DistributionRange =Convert.ToInt32(dr["TotalTicket"])
                    });
                }
            }
            return dl;
        }

    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using AgentUnsoldReturnTicketApplication.Models;

namespace AgentUnsoldReturnTicketApplication.Controllers
{
    public class HomeController : Controller
    {
        LotteryDistributionDB db = new LotteryDistributionDB();

        public ActionResult Index()
        {
            var dl = db.distributionList();
            return Json(new { data = dl}, JsonRequestBehavior.AllowGet);
        }
    }
}

[1]: https://i.stack.imgur.com/zNVhc.png