public ActionResult ViewAllProjects() { var isReporting = (bool)Session["IsRerportingPerson"]; ModelState.Clear(); int userId = int.Parse(Session["UserID"].ToString()); DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Models.Projects objproject = new DSRCManagementSystem.Models.Projects(); List <Projects> projectData = new List <Projects>(); if (isReporting) { projectData = (from p in db.Projects join pt in db.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID where p.IsDeleted != true || p.IsDeleted == null && p.IsActive == true select new Projects() { ProjectID = p.ProjectID, ProjectName = p.ProjectName, ProjectCode = p.ProjectCode, ProjectType = pt.ProjectTypeName, RAGStatus = p.RAGStatus, RAGComments = p.RAGComments ?? "Comments not added", CommentsCreated = p.CommentsCreated }).OrderBy(x => x.RAGStatus).ToList(); } else { projectData = (from p in db.Projects join pt in db.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID where p.IsDeleted != true || p.IsDeleted == null && p.IsActive == true select new Projects() { ProjectID = p.ProjectID, ProjectName = p.ProjectName, ProjectCode = p.ProjectCode, ProjectType = pt.ProjectTypeName, RAGStatus = p.RAGStatus, RAGComments = p.RAGComments ?? "Comments not added", CommentsCreated = p.CommentsCreated }).OrderBy(x => x.RAGStatus).ToList(); } ViewBag.ProjectTypeList = new SelectList(objproject.GetProjectTypeList(), "ProjectTypeID", "ProjectTypeName"); return(View(projectData)); }
public ActionResult ViewAllProjects(FormCollection form) { List <Projects> projectData = new List <Projects>(); if (ModelState.IsValid) { var isReporting = (bool)Session["IsRerportingPerson"]; int userId = int.Parse(Session["UserID"].ToString()); DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); string projectID = (form["ProjectTypeDL"] == "") ? "0" : form["ProjectTypeDL"].ToString(); int projectTypeID = int.Parse(projectID.ToString()); bool status = form["Inactive"].Contains("true"); DSRCManagementSystem.Models.Projects objproject = new DSRCManagementSystem.Models.Projects(); ViewBag.ProjectTypeList = new SelectList(objproject.GetProjectTypeList(), "ProjectTypeID", "ProjectTypeName", projectID); //List<Projects> datas = new List<Projects>(); if (projectTypeID == 0) { if (isReporting) { if (!status) { projectData = (from p in db.Projects join pt in db.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID where p.IsDeleted != true || p.IsDeleted == null && p.IsActive == true select new Projects() { ProjectID = p.ProjectID, ProjectName = p.ProjectName, ProjectCode = p.ProjectCode, ProjectType = pt.ProjectTypeName, RAGStatus = p.RAGStatus, RAGComments = p.RAGComments ?? "Comments not added", CommentsCreated = p.CommentsCreated }).OrderBy(x => x.RAGStatus).ToList(); } else { projectData = (from p in db.Projects join pt in db.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID where p.IsDeleted == true || p.IsDeleted == null && p.IsActive == false select new Projects() { ProjectID = p.ProjectID, ProjectName = p.ProjectName, ProjectCode = p.ProjectCode, ProjectType = pt.ProjectTypeName, RAGStatus = p.RAGStatus, RAGComments = p.RAGComments ?? "Comments not added", CommentsCreated = p.CommentsCreated }).OrderBy(x => x.RAGStatus).ToList(); } } else { if (!status) { projectData = (from p in db.Projects join pt in db.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID where p.IsDeleted != true || p.IsDeleted == null && p.IsActive == true select new Projects() { ProjectID = p.ProjectID, ProjectName = p.ProjectName, ProjectCode = p.ProjectCode, ProjectType = pt.ProjectTypeName, RAGStatus = p.RAGStatus, RAGComments = p.RAGComments ?? "Comments not added", CommentsCreated = p.CommentsCreated }).OrderBy(x => x.RAGStatus).ToList(); } else { projectData = (from p in db.Projects join pt in db.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID where p.IsDeleted == true || p.IsDeleted == null && p.IsActive == false select new Projects() { ProjectID = p.ProjectID, ProjectName = p.ProjectName, ProjectCode = p.ProjectCode, ProjectType = pt.ProjectTypeName, RAGStatus = p.RAGStatus, RAGComments = p.RAGComments ?? "Comments not added", CommentsCreated = p.CommentsCreated }).OrderBy(x => x.RAGStatus).ToList(); } } } else { if (isReporting) { if (!status) { projectData = (from p in db.Projects join pt in db.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID where pt.ProjectTypeID == projectTypeID && (p.IsDeleted != true || p.IsDeleted == null && p.IsActive == true) select new Projects() { ProjectID = p.ProjectID, ProjectName = p.ProjectName, ProjectCode = p.ProjectCode, ProjectType = pt.ProjectTypeName, RAGStatus = p.RAGStatus, RAGComments = p.RAGComments ?? "Comments not added", CommentsCreated = p.CommentsCreated }).OrderBy(x => x.RAGStatus).ToList(); } else { projectData = (from p in db.Projects join pt in db.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID where pt.ProjectTypeID == projectTypeID && (p.IsDeleted == true || p.IsDeleted == null && p.IsActive == false) select new Projects() { ProjectID = p.ProjectID, ProjectName = p.ProjectName, ProjectCode = p.ProjectCode, ProjectType = pt.ProjectTypeName, RAGStatus = p.RAGStatus, RAGComments = p.RAGComments ?? "Comments not added", CommentsCreated = p.CommentsCreated }).OrderBy(x => x.RAGStatus).ToList(); } } else { if (!status) { projectData = (from p in db.Projects join pt in db.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID where pt.ProjectTypeID == projectTypeID && (p.IsDeleted != true || p.IsDeleted == null && p.IsActive == true) select new Projects() { ProjectID = p.ProjectID, ProjectName = p.ProjectName, ProjectCode = p.ProjectCode, ProjectType = pt.ProjectTypeName, RAGStatus = p.RAGStatus, RAGComments = p.RAGComments ?? "Comments not added", CommentsCreated = p.CommentsCreated }).OrderBy(x => x.RAGStatus).ToList(); } else { projectData = (from p in db.Projects join pt in db.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID where pt.ProjectTypeID == projectTypeID && (p.IsDeleted == true || p.IsDeleted == null && p.IsActive == false) select new Projects() { ProjectID = p.ProjectID, ProjectName = p.ProjectName, ProjectCode = p.ProjectCode, ProjectType = pt.ProjectTypeName, RAGStatus = p.RAGStatus, RAGComments = p.RAGComments ?? "Comments not added", CommentsCreated = p.CommentsCreated }).OrderBy(x => x.RAGStatus).ToList(); } } } return(View(projectData)); } else { DSRCManagementSystem.Models.Projects objproject = new DSRCManagementSystem.Models.Projects(); ViewBag.ProjectTypeList = new SelectList(objproject.GetProjectTypeList(), "ProjectTypeID", "ProjectTypeName"); return(View(projectData)); } }