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); }