public ActionResult AssignProjects(GroupProject gp, FormCollection collection)
{
Group g = gbs.GetGroupById(gp.Group.GroupId);
gp.Group = g;
gp.Projects = gbs.GetProjectsByState(ProjectState.Approved);
gp.ProjectTypes = gbs.GetProjectTypes();
g.ProjectRankings.Clear();
foreach (Project p in gp.Projects)
{
var value = collection["project" + p.ProjectId];
if (!value.Equals("0"))
{
ProjectRanking pr = new ProjectRanking();
pr.Group = g;
pr.GroupGroupId = g.GroupId;
pr.ProjectId = p.ProjectId.ToString();
pr.Rank = value.ToString();
g.ProjectRankings.Add(pr);
}
}
if (g.ProjectRankings.Count == 5)
{
gbs.AddProjectPreference(g);
return(RedirectToAction("Details", new { id = Convert.ToInt32(Session["Id"]) }));
}
else
{
ViewBag.CountError = "You must select 5 projects";
gp.Projects = gbs.GetProjectsByState(ProjectState.Approved);
return(View(gp));
}
}
public ActionResult GroupDetail(int id)
{
GroupProject gp = new GroupProject();
gp = _gbs.GetGroupProject(id);
return(View(gp));
}
public ActionResult AssignProjects(int id)
{
GroupProject gp = new GroupProject();
gp.Group = gbs.GetGroupById(id);
gp.Projects = gbs.GetProjectsByState(ProjectState.Approved);
gp.ProjectTypes = gbs.GetProjectTypes();
return(View(gp));
}
public ActionResult Details()
{
int UserId = Convert.ToInt32(Session["Id"]);
GroupProject gp = new GroupProject();
gp = gbs.GetGroupDetails(UserId);
if (gp.Group.Owner != null && UserId == gp.Group.Owner.Value)
{
ViewBag.Owner = true;
}
return(View(gp));
}
public ActionResult ProjectMatch()
{
ProjectMatchGroup pmg = new ProjectMatchGroup();
pmg.Projects = _pm.GetProjects().Where(item => item.State.Equals(ProjectState.Approved)).ToList();
List <Group> groups = _gbs.GetGroups().Where(item => item.ProjectRankings.Count == 5 && !item.Status.Equals(GroupState.Assigned)).ToList();
foreach (Group g in groups)
{
GroupProject gp = new GroupProject();
gp = _gbs.GetGroupProject(g.GroupId);
pmg.GroupProjects.Add(gp);
}
return(View(pmg));
}
public ActionResult ProjectMatch(int[] groupId, int[] projectId)
{
if (groupId == null)
{
ViewBag.SubmitMessage = "Group and Project must be selected.";
}
else
{
for (int i = 0; i < groupId.Count(); i++)
{
if (groupId[i] != 0 && projectId[i] != 0)
{
Group g = _gbs.GetGroupById(groupId[i]);
Project p = _gbs.GetProjectById(projectId[i]);
p.State = ProjectState.Assinged;
g.Status = GroupState.Assigned;
g.Project = p;
_gbs.EditGroup(g);
}
}
// ViewBag.SubmitMessage = "Success!";
}
ProjectMatchGroup pmg = new ProjectMatchGroup();
pmg.Projects = _pm.GetProjects().Where(item => item.State.Equals(ProjectState.Approved)).ToList();
List <Group> groups = _gbs.GetGroups().Where(item => item.ProjectRankings.Count == 5 && !item.Status.Equals(GroupState.Assigned)).ToList();
foreach (Group g in groups)
{
GroupProject gp = new GroupProject();
gp = _gbs.GetGroupProject(g.GroupId);
pmg.GroupProjects.Add(gp);
}
return(View(pmg));
}
private IQueryable <DepartmentView> SelectDepartmentView(Expression <Func <DepartmentView, bool> > Expression, string Sorting = null, string Filtering = null)
{
var Query = from tbl in DbSet
join project in (Context.Set <Project>()
.GroupBy(c => c.DepartmentID)
.Select(g => new { DepartmentID = g.Key, ProjectsCount = g.Count() })
) on tbl.ID equals project.DepartmentID into GroupProject
from projectCount in GroupProject.DefaultIfEmpty()
select new DepartmentView()
{
ID = tbl.ID,
Name = tbl.Name,
CustomerID = tbl.CustomerID,
IsActive = tbl.IsActive,
IsAllowDelete = (projectCount == null?0: projectCount.ProjectsCount) == 0
};
if ((Filtering ?? "") != "")
{
Expression = Expression.And(tbl =>
tbl.ID.ToString().Contains(Filtering) ||
tbl.Name.ToString().Contains(Filtering) ||
(tbl.IsActive == true ? "true" : "false").Contains(Filtering)
);
}
if (Expression != null)
{
Query = Query.Where(Expression);
}
if (Sorting != null)
{
//Sorting = Sorting.Replace("JobID", "JobName");
Query = Query.GetOrderByQuery(Sorting);
}
return(Query);
}
public GroupProject GetGroupDetails(int id)
{
GroupProject gp = new GroupProject();
Student s = (Student)_users.GetUserById(id);
Group g = new Group();
if (s.Group != null)
{
g = _groups.GetGroupById(s.Group.GroupId);
Skillset sk = _groups.GetSkillByGroupId(s.Group.GroupId);
if (sk != null)
{
g.Skillset = sk;
}
}
gp.Group = g;
gp.Group.ProjectRankings = _projects.GetProjectRankingByGroupId(g.GroupId).ToList();
foreach (ProjectRanking pr in gp.Group.ProjectRankings)
{
gp.Projects.Add(_projects.GetProjectById(Convert.ToInt32(pr.ProjectId)));
}
return(gp);
}
public GroupProject GetGroupProject(int id)
{
GroupProject gp = new GroupProject();
Group g = new Group();
g = _groups.GetGroupById(id);
Skillset sk = _groups.GetSkillByGroupId(g.GroupId);
if (sk != null)
{
g.Skillset = sk;
}
// g.Project = g.Project != null ? g.Project : null;
gp.Group = g;
gp.Group.ProjectRankings = _projects.GetProjectRankingByGroupId(g.GroupId).ToList();
foreach (ProjectRanking pr in gp.Group.ProjectRankings)
{
gp.Projects.Add(_projects.GetProjectById(Convert.ToInt32(pr.ProjectId)));
}
return(gp);
}
