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 AddTask(FormCollection form) { var service_task = new STask.TaskClient(); var service_task_st_change = new STaskStatusChange.TaskStatusChangeClient(); var service_request_task = new SRequest_Task.Request_TaskClient(); var service_request_st_change = new SRequestStatusChange.RequestStatusChangeClient(); var service_request = new SRequest.RequestClient(); var new_task = new DTOlib.Task(); var task_st_change = new DTOlib.TaskStatusChange(); var request_task = new DTOlib.Request_Task(); var request_st_change = new DTOlib.RequestStatusChange(); var request = new DTOlib.Request(); int id_adrc = -1; if (form["address-new"] == "") { Int32.TryParse(form["address"], out id_adrc); } else { var service_address = new SAddress.AddressClient(); var new_address = new DTOlib.Address(); string s = form["X"]; float.TryParse(form["X"].Replace(".", ","), out new_address.X); float.TryParse(form["Y"].Replace(".", ","), out new_address.Y); new_address.address_name = form["address-new"]; id_adrc = service_address.Insert(new_address); } new_task.task_note = form["note"]; new_task.address_id = id_adrc; Int32.TryParse(form["service_list"], out new_task.service_id); task_st_change.old_status = null; task_st_change.new_status = 1; int id_task = service_task.Insert(new_task); task_st_change.task_id = id_task; service_task_st_change.Insert(task_st_change); Int32.TryParse(form["request_list"], out request_task.request_id); Int32.TryParse(form["brigade_list"], out request_task.brigade_id); request_task.task_id = id_task; int res = service_request_task.Insert(request_task); //создана задача request_st_change = service_request_st_change.SelectLastStatus(request_task.request_id); request_st_change.old_status = request_st_change.new_status; request_st_change.new_status = 2; if (res > -1) { return(Redirect(Request.UrlReferrer.ToString())); } else { ViewBag.ErrorMessage = "Произошла ошибка при записи"; return(Index()); } }