public List <SolicitacaoStatus> Search(SolicitacaoStatus obj)
{
List <SolicitacaoStatus> lstRet = new List <SolicitacaoStatus>();
using (SqlConnection oConnection = new SqlConnection(Conexao.DefaultConnection))
{
oConnection.Open();
using (SqlCommand oCommand = oConnection.CreateCommand())
{
oCommand.CommandText = Conexao.Owner + "usp_Solicitacao_Status_Search";
oCommand.CommandType = CommandType.StoredProcedure;
#region --- Parâmetros ---
oCommand.Parameters.Clear();
oCommand.Parameters.Add(new SqlParameter()
{
ParameterName = "@sos_Id",
Direction = ParameterDirection.Input,
Value = obj.SolicitacaoStatusId
});
oCommand.Parameters.Add(new SqlParameter()
{
ParameterName = "@sos_Nome",
Direction = ParameterDirection.Input,
Value = obj.Nome
});
#endregion
try
{
SqlDataReader oDr = oCommand.ExecuteReader();
while (oDr.Read())
{
SolicitacaoStatus item = new SolicitacaoStatus
{
SolicitacaoStatusId = oDr["sos_Id"].ToString(),
Nome = oDr["sos_Nome"].ToString(),
};
lstRet.Add(item);
}
}
catch (SqlException ex) when(ex.Server == ".\\SQLEXPRESS")
{
Console.WriteLine("SQL Provider Error: " + ex.Message);
}
catch (Exception ex) when(ex.InnerException.ToString() == "Parameter Error")
{
Console.WriteLine("SQL Provider Error: " + ex.Message);
}
}
oConnection.Close();
}
return(lstRet);
}
public void AlterarSolicitacao(int solicitacaoId, SolicitacaoStatus solicitacaoStatus)
{
var json = JsonConvert.SerializeObject(solicitacaoStatus);
var response = _clienteHttp.PutAsync(_clienteHttp.BaseAddress + $"/{solicitacaoId}", new StringContent(json, Encoding.UTF8, "application/json")).Result;
if (!response.IsSuccessStatusCode)
{
throw new Exception("Erro na chamada da API de atacadista.");
}
}
public SolicitacaoStatus Find(SolicitacaoStatus obj)
{
throw new NotImplementedException();
}
public long?Insert(SolicitacaoStatus obj)
{
throw new NotImplementedException();
}
public ActionResult Put(int solicitacaoId, [FromBody] SolicitacaoStatus solicitacao)
{
_solicitacaoNegocio.AlterarSolicitacao(solicitacaoId, solicitacao);
return(Ok());
}
public void AlterarSolicitacao(int solicitacaoId, SolicitacaoStatus solicitacaoStatus)
{
_solicitacaoRepositorio.AlterarSolicitacao(solicitacaoId, solicitacaoStatus);
}
public void AlterarSolicitacao(int solicitacaoId, SolicitacaoStatus solicitacaoStatus)
{
_atacadistaApi.AlterarSolicitacao(solicitacaoId, solicitacaoStatus);
}
public void Excluir(SolicitacaoStatus model)
{
_rep.Deletar(model);
}
public SolicitacaoStatus Find(SolicitacaoStatus obj)
{
return(_solicitacaoStatusRepository.Find(obj));
}
public void Salvar(SolicitacaoStatus model)
{
_rep.Salvar(model);
}
public void AdicionarSolicitacaoStatus(SolicitacaoStatus model)
{
_rep.context.SolicitacaoStatus.Add(model);
}
public void AlterarSolicitacao(int solicitacaoId, SolicitacaoStatus solicitacaoStatus)
{
return;
}
public bool Update(SolicitacaoStatus obj)
{
return(_solicitacaoStatusRepository.Update(obj));
}
public List <SolicitacaoStatus> Search(SolicitacaoStatus obj)
{
return(_solicitacaoStatusRepository.Search(obj));
}
public long?Insert(SolicitacaoStatus obj)
{
return(_solicitacaoStatusRepository.Insert(obj));
}
public void Salvar(SolicitacaoStatus model)
{
_rep.AddUpdate(model);
}
public bool Update(SolicitacaoStatus obj)
{
throw new NotImplementedException();
}
public bool Delete(SolicitacaoStatus obj)
{
return(_solicitacaoStatusRepository.Delete(obj));
}
