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