using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Threading.Tasks;
using System.Data;
using System.Data.Entity;
using FWC.Models;

namespace FWC.Controllers
{

    public class CalendarController : Controller
    {
        private FieldCalendarProdEntities db = new FieldCalendarProdEntities();
        /// <summary>
        /// GetProjectCompletionList
        /// </summary>
        /// <param name="prefixText"></param>
        /// <param name="count"></param>
        /// <returns></returns>
        public async Task<ActionResult> GetProjectCompletionList(string prefixText, int count)
        {
            //Get student name of string type
            //var studentName = db.Database.SqlQuery<RQ>("Select ProjectID, ClientName from WorkRequests").ToList();

            var pr = await db.WorkRequests.Where(w => w.ProjectID.Contains(prefixText) && (w.CurStatus == "Open" || w.CurStatus == "In Progress")).Select(p => new { p.ProjectID }).Distinct().OrderBy(w => w.ProjectID).ToListAsync();
            List<string> arr = new List<string>();
            foreach (var p in pr)
            {
                arr.Add(p.ProjectID);
            }
            JsonDataEx data = new JsonDataEx { d = arr };
            return Json(data);
        }

        protected override void Dispose(bool disposing)
        {
            db.Dispose();
            base.Dispose(disposing);
        }

    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    class MyClass : IDisposable
    {
        //The managed resource handle

        public MyClass(string path)
        {
        }

        public void Dispose()
        {
            Dispose(true);
            GC.SuppressFinalize(this);
        }

        protected virtual void Dispose(bool disposing)
        {
            if (disposing == true)
            {
                MessageBox.Show("close");
            }
        }

        ~MyClass()
        {
            Dispose(false);
        }
    }
}