public void Edit(TaskStateDTO taskState)
{
if (taskState == null)
{
throw new ValidationException("The ID does not exist", "");
}
var taskStateResult = MapperForCRUD(taskState);
Database.TaskStates.Update(taskStateResult);
Database.Save();
}
public void Update(TaskStateDTO taskStateDTO)
{
var taskState = Database.TaskStates.GetById(taskStateDTO.StateId);
if (taskState != null)
{
_mapper.Map(taskStateDTO, taskState);
Database.Save();
}
}
public void Save(TaskStateDTO taskStateDTO)
{
var taskState = new TaskState
{
StateName = taskStateDTO.StateName,
UserTasks = _mapper.Map <List <UserTask> >(taskStateDTO.UserTasks)
};
Database.TaskStates.Create(taskState);
Database.Save();
}
public TaskDetailsModel(string id_task)
{
task = taskProvider.getTask(id_task).Result;
this.stageDTO = processManagmentProvider.getStage(task.stage_id).Result;
createdBy = userProvider.getUserbyID(task.createdBy).Result;
taskState = taskProvider.getTaskState(task.taskState_id).Result;
taskType = taskProvider.getTaskType(task.type_id).Result;
if (taskType.needConfirm == "True")
{
taskResponsablesModel = new TaskResponsablesModel(task);
}
if (taskType.formNeeded == "True")
{
formQuestionsModel = new FormQuestionsModel(task);
}
}
public async Task <TaskStateDTO> getTaskState(string id_taskState)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(_BaseAddress);
TaskStateDTO task = new TaskStateDTO();
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", getToken());
HttpResponseMessage response = client.GetAsync("api/tasks/taskStates?id_taskState=" + id_taskState).Result;
if (response.IsSuccessStatusCode)
{
string result = await response.Content.ReadAsStringAsync();
task = new JavaScriptSerializer().Deserialize <TaskStateDTO>(result);
}
return(task);
}
}
public static TaskStateDTO getTaskState(string id_taskType)
{
TaskStateDTO taskState = new TaskStateDTO();
using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString))
{
SqlCommand command = new SqlCommand("usp_get_taskState", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@id_taskState", SqlDbType.Int);
command.Parameters["@id_taskState"].Value = id_taskType;
command.Connection.Open();
SqlDataReader rdr = command.ExecuteReader();
while (rdr.Read())
{
taskState.id_taskState = rdr["id_taskState"].ToString();
taskState.state_name = rdr["state_name"].ToString();
taskState.state_color = rdr["state_color"].ToString();
taskState.state_sColor = rdr["state_sColor"].ToString();
}
};
return(taskState);
}
public static List <TaskStateDTO> getTaskStates()
{
List <TaskStateDTO> taskStates = new List <TaskStateDTO>();
using (SqlConnection connection = new SqlConnection(WebConfigurationManager.ConnectionStrings["connectionRRHHDatabase"].ConnectionString))
{
SqlCommand command = new SqlCommand("usp_get_taskStates", connection);
command.CommandType = CommandType.StoredProcedure;
command.Connection.Open();
SqlDataReader rdr = command.ExecuteReader();
while (rdr.Read())
{
TaskStateDTO taskState = new TaskStateDTO();
taskState.id_taskState = rdr["id_taskState"].ToString();
taskState.state_name = rdr["state_name"].ToString();
taskState.state_color = rdr["state_color"].ToString();
taskState.state_sColor = rdr["state_sColor"].ToString();
taskStates.Add(taskState);
}
};
return(taskStates);
}
private TaskState MapperForCRUD(TaskStateDTO taskStatesDTO)
{
return(Mapper.Map <TaskStateDTO, TaskState>(taskStatesDTO));
}
public TaskStateDTO getTaskState(string id_taskState)
{
TaskStateDTO taskState = TaskData.getTaskState(id_taskState);
return(taskState);
}
private TaskStateViewModel MapperForCRUD(TaskStateDTO taskStateDTO)
{
return(Mapper.Map <TaskStateDTO, TaskStateViewModel>(taskStateDTO));
}
