public ActionResult Index() { if (!Auth()) { return(Redirect("/Home/Index")); } //заявки var service_request = new SRequest.RequestClient(); ViewBag.RequestList = service_request.SelectNewRequests(); //статусы заявки var service_request_status = new SRequestStatus.RequestStatusClient(); ViewBag.RequestStatusList = service_request_status.SelectAll(); //связь статусы-заявки var service_request_status_change = new SRequestStatusChange.RequestStatusChangeClient(); var ids = new List <int>(); foreach (var item in ViewBag.RequestList) { ids.Add(item.id); } ViewBag.RequestStatusChangeList = service_request_status_change.Select(ids); //адреса var service_address = new SAddress.AddressClient(); ViewBag.AddressList = service_address.SelectAddresses(); //услуги var service_sevices = new SService.ServiceClient(); ViewBag.ServiceList = service_sevices.SelectServices(); //задачи var service_tasks = new STask.TaskClient(); ViewBag.TaskList = service_tasks.SelectNewTasks(); //статусы задачи var service_task_status = new STaskStatus.TaskStatusClient(); ViewBag.TaskStatusList = service_task_status.SelectAll(); //связь статусы-задачи var service_task_status_change = new STaskStatusChange.TaskStatusChangeClient(); ids = new List <int>(); foreach (var item in ViewBag.TaskList) { ids.Add(item.id); } ViewBag.TaskStatusChangeList = service_task_status_change.Select(ids); //бригады var service_brigades = new SBrigade.BrigadeClient(); ViewBag.BrigadeList = service_brigades.SelectBrigades(); return(View()); }
public ActionResult Index() { if (!Auth()) { return(Redirect("/Home/Index")); } int brigade_id = -1; var br = new SBrigade.BrigadeClient(); Int32.TryParse(Request.Cookies["user"].Value, out brigade_id); ////// try { brigade_id = br.SelectBrigadeID(brigade_id); if (brigade_id <= -1) { return(View()); } var ids = new List <int>(); var service_request_task = new SRequest_Task.Request_TaskClient(); //id задач на бригаде ids = service_request_task.SelectTasksID(brigade_id); //задачи var service_tasks = new STask.TaskClient(); ids = service_request_task.SelectTasksID(brigade_id); var service_brigade_task = new SBrigadeNewTasks.BrigadeNewTasksClient(); var intersect = ids.Select(i => i).Intersect(service_tasks.SelectTaskIDs_ByStatus(1)); ViewBag.Brigadeview = service_brigade_task.SelectIn(intersect.ToList()); //Текущие задачи var service_brigade_task_inwork = new SBrigadeInWorkTasks.BrigadeInWorkTasksClient(); intersect = ids.Select(i => i).Intersect(service_tasks.SelectTaskIDs_ByStatus(2)); ViewBag.Brigadeview_inwork = service_brigade_task_inwork.SelectIn(intersect.ToList()); return(View()); } catch (Exception e) { return(View()); } }
public ActionResult Index() { if (!Auth()) { return(Redirect("/Home/Index")); } //бригады var service_brigades = new SBrigade.BrigadeClient(); ViewBag.BrigadeList = service_brigades.SelectBrigades(); //законченные задачи var service_brigade_end_tasks = new SBrigadeEndedTasks.BrigadeEndedTasksClient(); ViewBag.EndedTasksList = service_brigade_end_tasks.SelectAll(); return(View()); }