public ActionResult TaskClose(FormCollection collection)
{
try
{
//связь статусы-задачи
var service_task_status_change = new STaskStatusChange.TaskStatusChangeClient();
//связь статусы-заявки
var service_request_status_change = new SRequestStatusChange.RequestStatusChangeClient();
//задача
var service_task = new STask.TaskClient();
var task_st_change = new DTOlib.TaskStatusChange();
task_st_change.old_status = 2;
task_st_change.new_status = 3;
task_st_change.task_id = Int32.Parse(collection["task_id"]);
service_task_status_change.Insert(task_st_change);
var request_st_change = new DTOlib.RequestStatusChange();
request_st_change.old_status = 2;
request_st_change.new_status = 3;
request_st_change.request_id = Int32.Parse(collection["request_id"]);
service_request_status_change.Insert(request_st_change);
var task = new DTOlib.Task();
int id_task = service_task.Update(task_st_change.task_id, collection["note"], Int32.Parse(collection["total_time"]));
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
return(View());
}
}
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 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());
}
}