public JsonResult GetProjects(string sidx, string sord, int page, int rows)  //Gets the todo Lists.
        {
            #region MyRegion
            int pageIndex = Convert.ToInt32(page) - 1;
            int pageSize  = rows;
            // FinanceToolEntities2 db = new FinanceToolEntities2();
            var ProjectResults = db.Usp_GetProjectMasterDetails().Select(
                project => new
            {
                project.ProjectID,
                project.OpportunityName,
                project.ProjectName,
                project.poavilable,
                project.pobalance,
                project.SOWStatus,
                project.Note,
                project.Createdby,
                project.Createddate,
                project.Modifiedby,
                project.ModifiedDate,
                project.ProjectCode
            }).ToList();



            int totalRecords = ProjectResults.Count();
            var totalPages   = (int)Math.Ceiling((float)totalRecords / (float)rows);

            var customerResults2 = ProjectResults.OrderByDescending(s => s.ProjectName);

            var customerResults3 = customerResults2.Skip(pageIndex * pageSize).Take(pageSize);
            var jsonData         = new
            {
                total = totalPages,
                page,
                records = totalRecords,
                rows    = customerResults3
            };
            return(Json(jsonData, JsonRequestBehavior.AllowGet));

            #endregion
        }