public async System.Threading.Tasks.Task <object> PostReclamacaoAsync(ReclamacaoInstalacaoViewModel viewModel)
{
try
{
OracleCommand orcCommand = new OracleCommand();
orcCommand.Parameters.add(new OracleParameter("V_CODIGOCLIENTE", viewModel.CodigoCliente));
orcCommand.Parameters.add(new OracleParameter("V_CODIGOINSTALACAO", viewModel.CodigoInstalacao));
orcCommand.Parameters.add(new OracleParameter("V_CODIGOREGIAO", viewModel.CodigoRegiao));
orcCommand.Parameters.add(new OracleParameter("V_DATACADASTRO", viewModel.DataCadastro));
orcCommand.Parameters.add(new OracleParameter("V_DESCRICAOOPCIONAL", viewModel.DescricaoOpcional));
orcCommand.Parameters.add(new OracleParameter("V_STATUS", viewModel.Status));
var result = await DbControl.ExecuteProcWithReturnAsync(
StoredProcedure.InsertReclamacaoInstalacao,
orcCommand);
return(result);
}
catch (Exception x)
{
//TODO: Adicionar log para Exception
return(new HttpResponseMessage(System.Net.HttpStatusCode.ExpectationFailed));
}
}
public async System.Threading.Tasks.Task <object> PostClienteAsync(ClienteViewModel viewModel)
{
try
{
OracleCommand orcCommand = new OracleCommand();
orcCommand.Parameters.add(new OracleParameter("V_CEP", viewModel.CEP));
orcCommand.Parameters.add(new OracleParameter("V_CIDADE", viewModel.Cidade));
orcCommand.Parameters.add(new OracleParameter("V_DATANASCIMENTO", viewModel.DataNascimento));
orcCommand.Parameters.add(new OracleParameter("V_ENDERECO", viewModel.Endereco));
orcCommand.Parameters.add(new OracleParameter("V_ESTADO", viewModel.Estado));
orcCommand.Parameters.add(new OracleParameter("V_NOME", viewModel.Nome));
orcCommand.Parameters.add(new OracleParameter("V_SOBRENOME", viewModel.Sobrenome));
var result = await DbControl.ExecuteProcWithReturnAsync(
StoredProcedure.InsertCliente,
orcCommand);
return(result);
}
catch (Exception x)
{
//TODO: Adicionar log para Exception
return(new HttpResponseMessage(System.Net.HttpStatusCode.ExpectationFailed));
}
}
public async System.Threading.Tasks.Task <object> GetRegiaoAsync()
{
try
{
List <Regiao> result = await DbControl.ExecuteProcWithReturnAsync <ReclamacaoInstalacao>(
StoredProcedure.GetRegiao,
new OracleCommand());
return(result);
}
catch (Exception x)
{
//TODO: Adicionar log para Exception
return(new HttpResponseMessage(System.Net.HttpStatusCode.ExpectationFailed));
}
}
public async System.Threading.Tasks.Task <object> PostFeedbackAsync(FeedbackViewModel viewModel)
{
try
{
//TODO: Criar proc
var result = await DbControl.ExecuteProcWithReturnAsync(
StoredProcedure.InsertFeedback,
new OracleCommand());
return(result);
}
catch (Exception x)
{
//TODO: Adicionar log para Exception
return(new HttpResponseMessage(System.Net.HttpStatusCode.ExpectationFailed));
}
}
public async System.Threading.Tasks.Task <object> PostRegiaoAsync(RegiaoViewModel viewModel)
{
try
{
OracleCommand orcCommand = new OracleCommand();
orcCommand.Parameters.add(new OracleParameter("V_NOME", viewModel.Nome));
var result = await DbControl.ExecuteProcWithReturnAsync(
StoredProcedure.InsertRegiao,
orcCommand);
return(result);
}
catch (Exception x)
{
//TODO: Adicionar log para Exception
return(new HttpResponseMessage(System.Net.HttpStatusCode.ExpectationFailed));
}
}
public async System.Threading.Tasks.Task <object> PostChamadoAsync(ChamadoViewModel viewModel)
{
try
{
OracleCommand orcCommand = new OracleCommand();
orcCommand.Parameters.Add(new OracleParameter("V_CODIGO_CLIENTE", viewModel.CodigoCliente));
orcCommand.Parameters.Add(new OracleParameter("V_CODIGO_REGIAO", viewModel.CodigoRegiao));
orcCommand.Parameters.Add(new OracleParameter("V_DESCRICAO", viewModel.Descricao));
var result = await DbControl.ExecuteProcWithReturnAsync(
StoredProcedure.InsertChamado,
orcCommand);
return(result);
}
catch (Exception x)
{
//TODO: Adicionar log para Exception
return(new HttpResponseMessage(System.Net.HttpStatusCode.ExpectationFailed));
}
}