public ProjectDetails GetProjectDetailsByProjectName(string projectName)
        {
            ProjectDetails objProjectDetails = new ProjectDetails();

            using (var context = new FSD_SBAEntities())
            {
                var projectDetail = context.GetProjectDetailsByProjectName(projectName);
                foreach (var project in projectDetail)
                {
                    objProjectDetails.ProjectId     = project.Project_ID;
                    objProjectDetails.ProjectName   = project.Project_Name;
                    objProjectDetails.StartDate     = project.Start_Date;
                    objProjectDetails.EndDate       = project.End_Date;
                    objProjectDetails.Priority      = project.Priority;
                    objProjectDetails.Manager       = project.Manager;
                    objProjectDetails.NumberofTasks = project.CountOfTasks;
                    objProjectDetails.Completed     = project.Status;
                }
            }
            return(objProjectDetails);
        }