public JsonResult GetGorevByBoardId(int _sprintId) { try { var stepList = StepDB.GetInstance().GetGorevBySprintId(_sprintId); var backLogDetailList = new List <BacklogDetail>(); foreach (var item in stepList) { var assigneeUser = PersonDB.GetInstance().GetPersonById(item.AssigneeUser); var milestone = MilestoneDB.GetInstance().GetMilestoneById(item.MilestoneId); backLogDetailList.Add(new BacklogDetail() { SprintId = item.SprintId, AssigneeUserName = $"{assigneeUser.Name} {assigneeUser.Surname}", Descripton = item.Description, DetailName = item.Name, MilestoneName = milestone.Name, AssignedPersonNames = StepDB.GetInstance().GetStepPersonsByStepId(item.Id), StepId = item.Id }); } return(Json(backLogDetailList)); } catch (System.Exception exc) { throw exc; } }
public IActionResult Index() { var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id; var dateList = MilestoneDB.GetInstance().GetProjectStartAndEndDate(_projectId); var dddd = MilestoneDB.GetInstance().GetTotalProjectPercent(_projectId); return(View(dateList)); }
public JsonResult DeleteMilestone(int _projeId) { try { var result = MilestoneDB.GetInstance().DeleteMilestone(_projeId); return(Json(result)); } catch (System.Exception exc) { throw exc; } }
public JsonResult GetMilestoneInfo() { try { var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id; var list = MilestoneDB.GetInstance().GetMilestoneInfo(_projectId); return(Json(list)); } catch (System.Exception exc) { throw exc; } }
public JsonResult GetMilestoneById(int _milestoneId) { try { var milestone = MilestoneDB.GetInstance().GetMilestoneById(_milestoneId); return(Json(milestone)); } catch (System.Exception exc) { throw exc; } }
public IActionResult Index() { var milestoneDetailList = new MilestoneViewModel(); milestoneDetailList.MilestoneList = MilestoneDB.GetInstance().GetAllMilestone(JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id); milestoneDetailList.PersonList = PersonDB.GetInstance().GetAllPerson(); //milestoneDetailList.SprintList = SprintDB.GetInstance().GetAllSprint(); var personId = JsonConvert.DeserializeObject <Person>(HttpContext.Session.GetString("ActivePerson")).Id; milestoneDetailList.ProjectList = ProjectDB.GetInstance().GetAllProject(personId); return(View(milestoneDetailList)); }
public JsonResult GetAllStep() { try { var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id; var stepList = StepDB.GetInstance().GetAllStep(_projectId); var backLogDetailList = new List <BacklogDetail>(); foreach (var item in stepList) { var assigneeUser = PersonDB.GetInstance().GetPersonById(item.AssigneeUser); var milestone = MilestoneDB.GetInstance().GetMilestoneById(item.MilestoneId); if (milestone == null) { continue; } backLogDetailList.Add(new BacklogDetail() { SprintId = item.SprintId, AssigneeUserName = $"{assigneeUser.Name} {assigneeUser.Surname}", Descripton = item.Description, DetailName = item.Name, MilestoneName = milestone.Name, AssignedPersonNames = StepDB.GetInstance().GetStepPersonsByStepId(item.Id), StepId = item.Id, MilestoneId = item.MilestoneId, StepEndDate = Convert.ToDateTime(item.EndDate), StepStartDate = Convert.ToDateTime(item.StartDate), StepStatus = item.Status }); } var projectMilestones = MilestoneDB.GetInstance().GetAllMilestoneByProjectId(_projectId); var projectMilestoneIds = projectMilestones.Select(x => x.Id).ToList(); backLogDetailList = backLogDetailList.Where(x => projectMilestoneIds.Contains(x.MilestoneId)).ToList(); return(Json(backLogDetailList)); } catch (Exception exc) { throw exc; } }
public JsonResult GetAllStepForPano() { try { var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id; var boardList = BoardDB.GetInstance().GetBoardByProjectId(_projectId); var boardDetailList = new List <BoardRepo>(); var personId = JsonConvert.DeserializeObject <Person>(HttpContext.Session.GetString("ActivePerson")).Id; foreach (var item in boardList) { var stepList = BoardDB.GetInstance().GetStepByBoardId(item.Id, personId); foreach (var step in stepList) { var assigneeUser = PersonDB.GetInstance().GetPersonById(step.AssigneeUser); var milestone = MilestoneDB.GetInstance().GetMilestoneById(step.MilestoneId); if (milestone == null) { continue; } boardDetailList.Add(new BoardRepo() { SprintId = step.SprintId, AssigneeUserName = $"{assigneeUser.Name} {assigneeUser.Surname}", Descripton = step.Description, DetailName = step.Name, MilestoneName = milestone.Name, AssignedPersonNames = StepDB.GetInstance().GetStepPersonsByStepId(step.Id), StepId = step.Id, BoardId = item.Id }); } } return(Json(boardDetailList)); } catch (System.Exception exc) { throw exc; } }
public JsonResult SaveMilestone(string _titleMilestone, string _endDate, string _startDate, string _description, int _milestoneId) { var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id; try { if (_milestoneId == 0) { var milestone = new Milestone() { Name = _titleMilestone, Description = _description, StartDate = DateTime.ParseExact(_startDate, "dd/MM/yyyy", CultureInfo.InvariantCulture), EndDate = DateTime.ParseExact(_endDate, "dd/MM/yyyy", CultureInfo.InvariantCulture), ProjectId = _projectId, Status = 1 }; var result = MilestoneDB.GetInstance().SaveMilestone(milestone); return(Json(result != null)); } else { var milestone = new Milestone() { Name = _titleMilestone, Description = _description, StartDate = DateTime.ParseExact(_startDate, "dd/MM/yyyy", CultureInfo.InvariantCulture), EndDate = DateTime.ParseExact(_endDate, "dd/MM/yyyy", CultureInfo.InvariantCulture), ProjectId = _projectId, Id = _milestoneId, Status = 1 }; var result = MilestoneDB.GetInstance().UpdateMilestone(milestone); return(Json(result != null)); } } catch (Exception exc) { throw exc; } }
public JsonResult GetMilestonesAndSprintsByProjectId(int _projectId) { try { var personId = JsonConvert.DeserializeObject <Person>(HttpContext.Session.GetString("ActivePerson")).Id; var milestones = MilestoneDB.GetInstance().GetAllMilestoneByProjectId(_projectId); var sprints = SprintDB.GetInstance().GetAllSprintByProjectId(_projectId); var persons = PersonDB.GetInstance().GetHeadOfDepartmentsUsers(personId); return(Json(new { Milestones = milestones.Where(x => x.Status < 3).ToList().OrderBy(x => x.Id).ToList(), Sprints = sprints.Where(x => x.Status < 3).ToList().OrderBy(x => x.Id).ToList(), Persons = persons.OrderBy(x => x.Name).ThenBy(x => x.Surname).ToList() })); } catch (Exception exc) { throw exc; } }
public JsonResult SaveMilestone(string _titleMilestone, string _endDate, string _startDate, string _description, int _projectID, int _milestoneId) { try { if (_milestoneId == 0) { var milestone = new Milestone() { Name = _titleMilestone, Description = _description, StartDate = DateTime.ParseExact(_startDate, "dd/MM/yyyy", CultureInfo.InvariantCulture), EndDate = DateTime.ParseExact(_endDate, "dd/MM/yyyy", CultureInfo.InvariantCulture), ProjectId = _projectID }; var result = MilestoneDB.GetInstance().SaveMilestone(milestone); return(Json(result != null)); } else { var milestone = new Milestone() { Name = _titleMilestone, Description = _description, StartDate = DateTime.ParseExact(_startDate, "dd/MM/yyyy", CultureInfo.InvariantCulture), EndDate = DateTime.ParseExact(_endDate, "dd/MM/yyyy", CultureInfo.InvariantCulture), ProjectId = _projectID, Id = _milestoneId }; var result = MilestoneDB.GetInstance().UpdateMilestone(milestone); return(Json(result != null)); } } catch (Exception exc) { throw exc; } }
public IActionResult Index() { var backLogDetailList = new List <BacklogDetail>(); var _projectId = JsonConvert.DeserializeObject <Project>(HttpContext.Session.GetString("SelectedProject")).Id; var stepList = StepDB.GetInstance().GetAllStep(_projectId); foreach (var item in stepList) { var assigneeUser = PersonDB.GetInstance().GetPersonById(item.AssigneeUser); var milestone = MilestoneDB.GetInstance().GetMilestoneById(item.MilestoneId); if (milestone == null) { continue; } backLogDetailList.Add(new BacklogDetail() { SprintId = item.SprintId, AssigneeUserName = $"{assigneeUser.Name} {assigneeUser.Surname}", Descripton = item.Description, DetailName = item.Name, MilestoneName = milestone.Name, AssignedPersonNames = StepDB.GetInstance().GetStepPersonsByStepId(item.Id), StepId = item.Id, StepStatus = item.Status }); } var viewModel = new BacklogViewModel() { SprintList = SprintDB.GetInstance().GetAllSprintByProjectId(_projectId), Details = backLogDetailList }; return(View(viewModel)); }