public static bool updateResponsableTask(TaskResponsableDTO pTaskResponsable)
{
using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString))
{
SqlCommand command = new SqlCommand("usp_update_taskTarget", connection);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add("@id_task", SqlDbType.Int);
command.Parameters["@id_task"].Value = pTaskResponsable.task_id;
command.Parameters.Add("@id_user", SqlDbType.Int);
command.Parameters["@id_user"].Value = pTaskResponsable.user_id;
command.Parameters.Add("@isConfirmed", SqlDbType.Bit);
command.Parameters["@isConfirmed"].Value = pTaskResponsable.isConfirmed;
command.Parameters.Add("@userLog", SqlDbType.Int);
command.Parameters["@userLog"].Value = pTaskResponsable.userLog;
command.Connection.Open();
string result = command.ExecuteNonQuery().ToString();
if (result != "0")
{
return(true);
}
};
return(false);
}
public ActionResult _ConfirrmTask(string id_task)
{
if (ModelState.IsValid)
{
var parameters = Request.Params;
TaskProvider taskProvider = new TaskProvider();
TaskResponsableDTO taskResponsableDTO = new TaskResponsableDTO();
taskResponsableDTO.task_id = id_task;
taskResponsableDTO.user_id = Request.Cookies["user_id"].Value;
taskResponsableDTO.isConfirmed = "True";
taskResponsableDTO.userLog = Request.Cookies["user_id"].Value;
if (taskProvider.putTaskResponsable(taskResponsableDTO).Result)
{
List <TaskResponsableDTO> taskResponsables = taskProvider.getTaskResponsables(id_task).Result;
bool isTaskCompleted = true;
foreach (var user in taskResponsables)
{
if (user.isConfirmed == "False")
{
isTaskCompleted = false;
}
}
if (isTaskCompleted)
{
completeTask(id_task);
}
return(Content(isTaskCompleted ? "True" : id_task));
}
}
return(new HttpStatusCodeResult(404, "Error, no se puede agregar la notificación"));
}
public static List <TaskResponsableDTO> getTaskResponsables(string task_id)
{
List <TaskResponsableDTO> taskResponsables = new List <TaskResponsableDTO>();
using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString))
{
SqlCommand command = new SqlCommand("usp_get_taskTargets", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@task_id", SqlDbType.Int);
command.Parameters["@task_id"].Value = task_id;
command.Connection.Open();
SqlDataReader rdr = command.ExecuteReader();
while (rdr.Read())
{
TaskResponsableDTO taskResponsable = new TaskResponsableDTO();
taskResponsable.user_id = rdr["user_id"].ToString();
taskResponsable.isConfirmed = rdr["isConfirmed"].ToString();
taskResponsable.name = rdr["name"].ToString();
taskResponsable.sLastName = rdr["sLastName"].ToString();
taskResponsable.fLastName = rdr["fLastName"].ToString();
taskResponsable.userName = rdr["userName"].ToString();
taskResponsable.email = rdr["email"].ToString();
byte[] photo = (byte[])rdr["photoData"];
taskResponsable.photoData = Convert.ToBase64String(photo);
taskResponsables.Add(taskResponsable);
}
};
return(taskResponsables);
}
public IHttpActionResult putTaskResponsable(TaskResponsableDTO responsableDTO)
{
if (!TaskData.updateResponsableTask(responsableDTO))
{
return(BadRequest());
}
return(Ok());
}
public IHttpActionResult postTaskResponsablesGroup(TaskResponsableDTO responsableDTO)
{
if (!TaskData.insertResponsableGroup(responsableDTO))
{
return(BadRequest());
}
return(Ok());
}
public async Task <bool> putTaskResponsable(TaskResponsableDTO taskResponsable)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(_BaseAddress);
var userJson = new JavaScriptSerializer().Serialize(taskResponsable);
HttpContent contentPost = new StringContent(userJson, Encoding.UTF8, "application/json");
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", getToken());
HttpResponseMessage response = client.PutAsync("api/tasks/responsables", contentPost).Result;
return(response.IsSuccessStatusCode);
}
}
public ActionResult _AddTaskResponsableGroup(string id_task, string group_id)
{
if (ModelState.IsValid)
{
TaskResponsableDTO taskResponsable = new TaskResponsableDTO();
taskResponsable.user_id = group_id;
taskResponsable.task_id = id_task;
taskResponsable.userLog = Request.Cookies["user_id"].Value;
if (taskProvider.postResponsableGroup(taskResponsable).Result)
{
return(new HttpStatusCodeResult(200));
}
}
return(new HttpStatusCodeResult(404, "Can't find that"));
}
public ActionResult _EditTaskResponsable(string id_task, string id_user, string isConfirmed)
{
if (ModelState.IsValid)
{
TaskResponsableDTO taskResponsable = new TaskResponsableDTO();
taskResponsable.user_id = id_user;
taskResponsable.task_id = id_task;
taskResponsable.isConfirmed = isConfirmed;
taskResponsable.userLog = Request.Cookies["user_id"].Value;
if (taskProvider.putTaskResponsable(taskResponsable).Result)
{
return(new HttpStatusCodeResult(200));
}
}
return(new HttpStatusCodeResult(404, "Can't find that"));
}
public ActionResult _AddTaskResponsableUser(string id_task, List <string> selected_userParticipants_id)
{
if (ModelState.IsValid)
{
List <TaskResponsableDTO> responsables = new List <TaskResponsableDTO>();
foreach (var responsable_id in selected_userParticipants_id)
{
TaskResponsableDTO taskResponsable = new TaskResponsableDTO();
taskResponsable.user_id = responsable_id;
taskResponsable.task_id = id_task;
taskResponsable.userLog = Request.Cookies["user_id"].Value;
responsables.Add(taskResponsable);
}
List <TaskResponsableDTO> adddedResponsables = taskProvider.postResponsableUser(responsables).Result;
int addedCount = adddedResponsables.Count;
int errorCount = responsables.Count - addedCount;
TaskDTO taskDTO = taskProvider.getTask(id_task).Result;
var result = new { usersAdded = addedCount, usersError = errorCount, viewHtml = PartialView("/Views/Tasks/_Tasks/_TaskDetails/_TaskResponsablesList.cshtml", new Model.TaskResponsablesModel(taskDTO)).RenderToString() };
return(Json(result));
}
return(new HttpStatusCodeResult(404, "Can't find that"));
}
