public ActionResult ViewTaskComment()
{
ViewBag.ProjectName = new SelectList(Dropdownlist.GetAllProjects(), "Value", "Text");
var taskComents = (from tb_ProjectTask in dbContext.tb_ProjectTasks
join tb_TaskComment in dbContext.tb_TaskComments on tb_ProjectTask.ProjectTaskId equals tb_TaskComment.TaskId
join tb_UserInfo in dbContext.tb_UserInfos on tb_ProjectTask.UserId equals tb_UserInfo.UserInfoId
//where tb_ProjectTask.ProjectTaskId == taskId
select new ViewComment
{
TaskId = tb_ProjectTask.ProjectTaskId,
Cmnt = tb_TaskComment.Comment,
UserId = tb_TaskComment.UpdateId,
AssignBy = tb_UserInfo.Name,
CommentDateTime = tb_ProjectTask.DueDate
}).ToList();
ViewBag.ViewTaskComment = taskComents;
return(View());
}
public ActionResult AssignResourcePerson()
{
ViewBag.ProjectName = new SelectList(Dropdownlist.GetAllProjects(), "Value", "Text");
ViewBag.UserName = new SelectList(Dropdownlist.GetAllUsers(), "Value", "Text");
var model = (from tb_AssignPerson in dbContext.tb_AssignPersons
join tb_UserInfo in dbContext.tb_UserInfos on tb_AssignPerson.UserId equals tb_UserInfo.UserInfoId
join tb_ProjectInfo in dbContext.tb_ProjectInfos on tb_AssignPerson.ProjectId equals tb_ProjectInfo.ProjectInfoId
select new AssignPersonList
{
ProjectId = tb_AssignPerson.ProjectId,
ProjectName = tb_ProjectInfo.Name,
UserId = tb_AssignPerson.UserId,
PersonName = tb_UserInfo.Name,
PersonDesignation = tb_UserInfo.Designation,
}).ToList();
ViewBag.assignPersonList = model;
return(View());
}
public ActionResult AddComment()
{
ViewBag.ProjectName = new SelectList(Dropdownlist.GetAllProjects(), "Value", "Text");
return(View());
}
public ActionResult CreateTask()
{
ViewBag.ProjectName = new SelectList(Dropdownlist.GetAllProjects(), "Value", "Text");
ViewBag.Priority = new SelectList(Dropdownlist.GetPriority(), "Value", "Text");
return(View());
}
