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