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