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