public IList <TarefaDTO> CarregarDadosCmbVersao()
{
try
{
SqlConnection connection = new SqlConnection();
connection.ConnectionString = Properties.Settings.Default.CST;
SqlCommand command = new SqlCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "SELECT DISTINCT versao FROM TAREFA";
command.Connection = connection;
SqlDataReader DR;
IList <TarefaDTO> listTarefaDTO = new List <TarefaDTO>();
connection.Open();
DR = command.ExecuteReader();
if (DR.HasRows)
{
while (DR.Read())
{
TarefaDTO TAREFA = new TarefaDTO();
TAREFA.Versao = Convert.ToString(DR["versao"]);
listTarefaDTO.Add(TAREFA);
}
}
return(listTarefaDTO);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <List <Tarefa> > GetTarefas(TarefaDTO tarefa)
{
var SearchId = new ObjectId(tarefa.Id);
var filter = Builders <User> .Filter.Eq("Id", SearchId);
var result = await _user.Find(filter).FirstOrDefaultAsync();
return(result.Assignments);
}
public async Task <List <Tarefa> > CreateTask(TarefaDTO tarefa)
{
var SearchId = new ObjectId(tarefa.Id);
var filter = Builders <User> .Filter.Eq("Id", SearchId);
var updateDef = Builders <User> .Update.Set("Assignments", tarefa.Tarefas);
var result = await _user.FindOneAndUpdateAsync(filter, updateDef);
return(result.Assignments);
}
public int GravarDados(TarefaDTO TAREFA)
{
try
{
return(new TarefaDAL().InserirDados(TAREFA));
}
catch (Exception ex)
{
throw ex;
}
}
public IHttpActionResult PostTarefa(TarefaDTO tarefaDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var tarefaDomain = AutoMapper.Mapper.Map <Tarefa>(tarefaDTO);
_tarefaService.Adicionar(tarefaDomain);
return(CreatedAtRoute("DefaultApi", new { id = tarefaDomain.TarefaId }, tarefaDomain));
}
public int InserirDados(TarefaDTO TAREFA)
{
try
{
SqlConnection connection = new SqlConnection();
connection.ConnectionString = Properties.Settings.Default.CST;
SqlCommand command = new SqlCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "USE TAREFAS_BOMBEIRO;\n" +
"GO\n" +
"INSERT INTO TAREFA (task, cliente, urgencia, tempo, versao, motivo, taskorigem, data,obs, AREA, TIME, atendente, trello) VALUES " +
"(@task, @cliente, @urgencia, @tempo, @versao, @motivo, @taskorigem, @data, @obs, @AREA, @TIME, @atendente, @trello)";
command.Parameters.Add("task", System.Data.SqlDbType.Int).Value = TAREFA.Task;
command.Parameters.Add("cliente", System.Data.SqlDbType.VarChar).Value = TAREFA.Cliente;
command.Parameters.Add("urgencia", System.Data.SqlDbType.Int).Value = TAREFA.Urgencia;
command.Parameters.Add("tempo", System.Data.SqlDbType.Int).Value = TAREFA.Tempo;
command.Parameters.Add("versao", System.Data.SqlDbType.VarChar).Value = TAREFA.Task;
command.Parameters.Add("motivo", System.Data.SqlDbType.Int).Value = TAREFA.Motivo;
command.Parameters.Add("taskorigem", System.Data.SqlDbType.Int).Value = TAREFA.TaskOrigem;
command.Parameters.Add("data", System.Data.SqlDbType.DateTime).Value = TAREFA.Data;
command.Parameters.Add("obs", System.Data.SqlDbType.VarChar).Value = TAREFA.Obs;
command.Parameters.Add("AREA", System.Data.SqlDbType.Int).Value = TAREFA.Area;
command.Parameters.Add("TIME", System.Data.SqlDbType.Int).Value = TAREFA.Time;
command.Parameters.Add("atendente", System.Data.SqlDbType.VarChar).Value = TAREFA.Atendente;
command.Parameters.Add("trello", System.Data.SqlDbType.VarChar).Value = TAREFA.Trello;
connection.Open();
int qtd = command.ExecuteNonQuery();
return(qtd);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Tarefa()
{
ModelState.Clear();
TarefaDTO dto = new TarefaDTO
{
Items = await servico.ReadAllAsync()
};
//List<ProtectModel> protect = new List<ProtectModel>();
//foreach (var item in dto.Items)
//{
// var dados = new ProtectModel();
// dados.Id = EncryptString(item.Id.ToString(), key);
// dados.Nome = item.Nome;
// dados.Completa = item.Completa;
// protect.Add(dados);
//}
return(View(dto));
}
private void btnGravar_Click(object sender, EventArgs e)
{
//inserir função para gravar na base de dados
try
{
TarefaDTO TAREFA = new TarefaDTO();
TAREFA.Task = int.Parse(txtTask.Text);
TAREFA.Cliente = txtCliente.Text;
TAREFA.Urgencia = int.Parse(txtUrgencia.Text);
TAREFA.Tempo = int.Parse(txtTempo.Text);
TAREFA.Versao = cmbVersao.Text;
TAREFA.Motivo = int.Parse(cmbMotivo.Text);
TAREFA.TaskOrigem = int.Parse(txtTaskOrigem.Text);
TAREFA.Data = DateTime.Parse(lblData.Text);
TAREFA.Obs = txtObs.Text;
TAREFA.Area = int.Parse(cmbArea.Text);
TAREFA.Time = int.Parse(cmbTime.Text);
TAREFA.Atendente = lblAtendente.Text;
TAREFA.Trello = txtTrelloURL.Text;
//jogando dados na base
int x = new TarefaBLL().GravarDados(TAREFA);
if (x > 0)
{
MessageBox.Show("Inserção concluida com sucesso.");
}
//limpar campos
LimparCampos();
}
catch (Exception ex)
{
MessageBox.Show("Não conseguiu fazer a inserção." + ex.Message);
}
}
public IHttpActionResult PutTarefa(int id, TarefaDTO tarefaDTO)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tarefaDTO.TarefaId)
{
return(BadRequest());
}
try
{
var tarefaDomain = AutoMapper.Mapper.Map <Tarefa>(tarefaDTO);
_tarefaService.Alterar(tarefaDomain);
}
catch (Exception)
{
return(BadRequest());
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void Delete(TarefaDTO entity)
{
var filter = Builders <TarefaDTO> .Filter.Eq(u => u.Id, entity.Id);
mongoDbContext.Tarefas.DeleteOne(filter);
}
public void Update(TarefaDTO entity)
{
var filter = Builders <TarefaDTO> .Filter.Eq(u => u.Id, entity.Id);
mongoDbContext.Tarefas.ReplaceOne(filter, entity);
}
public void Create(TarefaDTO entity)
{
mongoDbContext.Tarefas.InsertOne(entity);
}
public async Task <List <Tarefa> > GetTarefas(TarefaDTO tarefa)
{
List <Tarefa> Novatarefas = await _taskRepository.GetTarefas(tarefa);
return(Novatarefas);
}
public async Task <List <Tarefa> > CreateTask(TarefaDTO tarefa)
{
List <Tarefa> Novatarefas = await _taskRepository.CreateTask(tarefa);
return(Novatarefas);
}
public async Task <IActionResult> GetTarefas(TarefaDTO tarefas)
{
List <Tarefa> Novastarefas = await _taskService.GetTarefas(tarefas);
return(Ok(Novastarefas));
}
public async Task <IActionResult> ChangeUserData(TarefaDTO tarefas)
{
List <Tarefa> Novastarefas = await _taskService.CreateTask(tarefas);
return(Ok(Novastarefas));
}
