public PartialViewResult Create() { var _project = mongoDatabase.GetCollection<Project>("Project"); var _employee = mongoDatabase.GetCollection<Employee>("Employee"); IList<Project> listProject = new List<Project>(); var getAllProjects = _project.FindAs(typeof(Project), Query.NE("Name", "null")); foreach (Project proj in getAllProjects) { listProject.Add(proj); } var selectProj = new SelectList(listProject, "ProjectId", "Name", listProject[0].ProjectId); ViewData["Project"] = selectProj; IList<Employee> listEmployee = new List<Employee>(); var getAllEmployees = _employee.FindAs(typeof(Employee), Query.NE("IsActive", false)); foreach (Employee emp in getAllEmployees) { listEmployee.Add(emp); } var selectEmp = new SelectList(listEmployee, "EmpId", "FullName", 1); ViewData["Employee"] = selectEmp; List<Status> listStatus = new List<Status>(); Status stT3 = new Status() { Name = "Not Started" }; listStatus.Add(stT3); Status stT1 = new Status() { Name = "In-Process" }; listStatus.Add(stT1); Status stT2 = new Status() { Name = "Complete" }; listStatus.Add(stT2); Status stT5 = new Status() { Name = "Waiting Approval" }; listStatus.Add(stT5); Status stT6 = new Status() { Name = "On Hold" }; listStatus.Add(stT6); Status stT4 = new Status() { Name = "Cancelled" }; listStatus.Add(stT4); var selectSt = new SelectList(listStatus, "Name", "Name", listStatus[0].Name); ViewData["Status"] = selectSt; List<Status> listPriority = new List<Status>(); Status stP3 = new Status() { Name = "Very Urgent" }; listPriority.Add(stP3); Status stP1 = new Status() { Name = "Urgent" }; listPriority.Add(stP1); Status stP2 = new Status() { Name = "Normal" }; listPriority.Add(stP2); var selectPriority = new SelectList(listPriority, "Name", "Name", listPriority[0].Name); ViewData["Priority"] = selectPriority; return PartialView(); }
public PartialViewResult Monitor(string Id) { var _task = mongoDatabase.GetCollection<Task>("Task"); var _employee = mongoDatabase.GetCollection<Employee>("Employee"); var _monitor = mongoDatabase.GetCollection<DevBase>("DevBase"); var getBase = _monitor.FindAs(typeof(DevBase), Query.EQ("TaskId", Id)); if (getBase.Count() > 0) { foreach (DevBase mon in getBase) { if (mon.EmpId.Equals(Id) && mon != null) { return EditMonitor(mon.Id.ToString()); } } } ObjectId taskId; var isValid = ObjectId.TryParse(Id, out taskId); string EmpId = ""; if (isValid) { var getQuery = Query<Task>.EQ(e => e.TaskId, taskId); IList<Task> listTask = new List<Task>(); var tsk = _task.FindOne(getQuery); EmpId = tsk.AssignedTo[0].EmpId.ToString(); listTask.Add(tsk); var selectTask = new SelectList(listTask, "TaskId", "Name", tsk.TaskId); ViewData["Task"] = selectTask; } ObjectId empId; isValid = ObjectId.TryParse(EmpId, out empId); if (isValid) { var getQuery = Query<Employee>.EQ(e => e.EmpId, empId); IList<Employee> listEmp = new List<Employee>(); var emp = _employee.FindOne(getQuery); listEmp.Add(emp); var selectEmp = new SelectList(listEmp, "EmpId", "FullName", emp.EmpId); ViewData["Employee"] = selectEmp; } List<Status> listStatus = new List<Status>(); Status stT3 = new Status() { Name = "Not Started" }; listStatus.Add(stT3); Status stT1 = new Status() { Name = "In-Process" }; listStatus.Add(stT1); Status stT2 = new Status() { Name = "Complete" }; listStatus.Add(stT2); Status stT5 = new Status() { Name = "Waiting Approval" }; listStatus.Add(stT5); Status stT6 = new Status() { Name = "On Hold" }; listStatus.Add(stT6); Status stT4 = new Status() { Name = "Cancelled" }; listStatus.Add(stT4); var selectSt = new SelectList(listStatus, "Name", "Name", listStatus[1].Name); ViewData["Status"] = selectSt; return PartialView(); }
public PartialViewResult Edit(string Id) { var _tickets = mongoDatabase.GetCollection<TicketBase>("TicketBase"); ObjectId tickId; var isValid = ObjectId.TryParse(Id, out tickId); if (isValid) { var getQuery = Query<TicketBase>.EQ(e => e.Id, tickId); var tick = _tickets.FindOne(getQuery); var _project = mongoDatabase.GetCollection<Project>("Project"); var _employee = mongoDatabase.GetCollection<Employee>("Employee"); ObjectId projId; isValid = ObjectId.TryParse(tick.ProjectId, out projId); IList<Project> listProject = new List<Project>(); if (isValid) { getQuery = Query<Project>.EQ(e => e.ProjectId, projId); Project proj = _project.FindOne(getQuery); listProject.Add(proj); var selectProj = new SelectList(listProject, "ProjectId", "Name", proj.ProjectId); ViewData["Project"] = selectProj; } ObjectId empId; isValid = ObjectId.TryParse(tick.AssignedToId, out empId); IList<Employee> listEmployee = new List<Employee>(); if (isValid) { getQuery = Query<Employee>.EQ(e => e.EmpId, empId); Employee emp = _employee.FindOne(getQuery); listEmployee.Add(emp); var selectEmp = new SelectList(listEmployee, "EmpId", "FullName", tick.AssignedToId); ViewData["Employee"] = selectEmp; } List<Status> listStatus = new List<Status>(); Status stT3 = new Status() { Name = "Not Started" }; listStatus.Add(stT3); Status stT1 = new Status() { Name = "In-Process" }; listStatus.Add(stT1); Status stT2 = new Status() { Name = "Complete" }; listStatus.Add(stT2); Status stT5 = new Status() { Name = "Waiting Approval" }; listStatus.Add(stT5); Status stT6 = new Status() { Name = "On Hold" }; listStatus.Add(stT6); Status stT4 = new Status() { Name = "Cancelled" }; listStatus.Add(stT4); var selectSt = new SelectList(listStatus, "Name", "Name", tick.Status); ViewData["Status"] = selectSt; List<Status> listPriority = new List<Status>(); Status stP3 = new Status() { Name = "Very Urgent" }; listPriority.Add(stP3); Status stP1 = new Status() { Name = "Urgent" }; listPriority.Add(stP1); Status stP2 = new Status() { Name = "Normal" }; listPriority.Add(stP2); var selectPriority = new SelectList(listPriority, "Name", "Name", tick.Priority); ViewData["Priority"] = selectPriority; return PartialView("Edit",tick); } else { return PartialView("Error"); } }
public PartialViewResult EditMonitor(string Id) { var _monitor = mongoDatabase.GetCollection<DevBase>("DevBase"); var _task = mongoDatabase.GetCollection<Task>("Task"); var _employee = mongoDatabase.GetCollection<Employee>("Employee"); ObjectId monId; var isValid = ObjectId.TryParse(Id, out monId); if (isValid) { var getQuery = Query<DevBase>.EQ(e => e.Id, monId); var mon = _monitor.FindOne(getQuery); ObjectId taskId; isValid = ObjectId.TryParse(mon.TaskId, out taskId); if (isValid) { getQuery = Query<Task>.EQ(e => e.TaskId, taskId); IList<Task> listTask = new List<Task>(); var tsk = _task.FindOne(getQuery); listTask.Add(tsk); var selectTask = new SelectList(listTask, "TaskId", "Name", tsk.TaskId); ViewData["Task"] = selectTask; } ObjectId empId; isValid = ObjectId.TryParse(mon.EmpId, out empId); if (isValid) { getQuery = Query<Employee>.EQ(e => e.EmpId, empId); IList<Employee> listEmp = new List<Employee>(); var emp = _employee.FindOne(getQuery); if (emp != null && emp.IsActive == true) { listEmp.Add(emp); var selectEmp = new SelectList(listEmp, "EmpId", "FullName", emp.EmpId); ViewData["Employee"] = selectEmp; } } List<Status> listStatus = new List<Status>(); Status stT3 = new Status() { Name = "Not Started" }; listStatus.Add(stT3); Status stT1 = new Status() { Name = "In-Process" }; listStatus.Add(stT1); Status stT2 = new Status() { Name = "Complete" }; listStatus.Add(stT2); Status stT5 = new Status() { Name = "Waiting Approval" }; listStatus.Add(stT5); Status stT6 = new Status() { Name = "On Hold" }; listStatus.Add(stT6); Status stT4 = new Status() { Name = "Cancelled" }; listStatus.Add(stT4); var selectSt = new SelectList(listStatus, "Name", "Name", mon.Status); ViewData["Status"] = selectSt; return PartialView("EditMonitor", mon); } else { return PartialView("Error"); } }