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 JsonResult ControlLogin(string _email, string _password) { try { var person = PersonDB.GetInstance().ControlPerson(_email, _password); if (person != null) { HttpContext.Session.SetString("ActivePerson", JsonConvert.SerializeObject(person)); // var projects = ProjectDB.GetInstance().GetAllProject(); // if (projects.Count > 0) // { // HttpContext.Session.SetString("SelectedProject", JsonConvert.SerializeObject(projects.FirstOrDefault())); // } return(Json(true)); } return(Json(false)); } catch (Exception exc) { throw exc; } }
public IActionResult Index() { var returnList = new List <HomeViewModel>(); var personId = JsonConvert.DeserializeObject <Person>(HttpContext.Session.GetString("ActivePerson")).Id; var list = ProjectDB.GetInstance().GetAllProject(personId); list.ForEach(item => { var assignedPerson = PersonDB.GetInstance().GetPersonById(item.ProjectLeader); var step = StepDB.GetInstance().GetAllNotificationByProjectId(item.Id); returnList.Add(new HomeViewModel() { AssigneeUserName = $"{assignedPerson.Name} {assignedPerson.Surname}", Code = item.Code, Description = item.Description, Id = item.Id, Name = item.Name, ProjectLeader = item.ProjectLeader, ShortName = item.ShortName, Status = item.Status, Kalan = step }); }); return(View(returnList)); }
public JsonResult DeletePerson(int _personId) { try { var result = PersonDB.GetInstance().DeletePerson(_personId); return(Json(result)); } catch (Exception exc) { throw exc; } }
public JsonResult SavePerson(int _id, string _name, string _surname, string _mail, string _password, int _teamId, bool _isAdmin) { try { var result = PersonDB.GetInstance().SavePerson(_id, _name, _surname, _mail, _password, _teamId, _isAdmin); return(Json(result != null)); } catch (Exception exc) { throw exc; } }
public JsonResult GetAllPerson() { try { var list = PersonDB.GetInstance().GetAllPerson(); return(Json(list)); } catch (Exception exc) { throw exc; } }
public JsonResult GetKullaniciById(int _kullaniciId) { try { var kullanici = PersonDB.GetInstance().GetPersonById(_kullaniciId); var returnObj = kullanici.Name + " " + kullanici.Surname; return(Json(returnObj)); } 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 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 GetAllPersonForMessageSend() { try { var users = PersonDB.GetInstance().GetAllPerson(); var userId = JsonConvert.DeserializeObject <Person>(HttpContext.Session.GetString("ActivePerson")).Id; var control = users.FirstOrDefault(x => x.Id == userId); if (control != null) { users.Remove(control); } return(Json(users.OrderBy(x => x.Name).ThenBy(x => x.Surname).ToList())); } 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)); }