public IHttpActionResult GetCapacidadeMaximaFuncionario()
{
int result = -1;
try {
result = PriIntegration.GetCapacidadeMaximaFuncionario();
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception) {
return(InternalServerError());
}
if (result < 0)
{
return(InternalServerError());
}
else
{
Dictionary <string, int> response = new Dictionary <string, int>();
response.Add("capacidade", result);
return(Ok(response));
}
}
public static ObjetivoEstado getObjetivoVendedor(string idVendedor)
{
SqlConnection cnn = new SqlConnection(connectionString);
cnn.Open();
string queryString = "SELECT Objetivo FROM ObjetivoVendedor WHERE VendedorID = @vendedor";
SqlCommand command = new SqlCommand(queryString, cnn);
command.Parameters.AddWithValue("@vendedor", idVendedor);
SqlDataReader reader = command.ExecuteReader();
ObjetivoEstado obj = null;
if (reader.Read())
{
obj = new ObjetivoEstado();
obj.Vendedor = idVendedor;
obj.Valor = reader.GetFloat(0);
obj.ValorCumprido = PriIntegration.getVendedorVendasMes(idVendedor);
}
reader.Close();
cnn.Close();
return(obj);
}
public Artigo(Interop.GcpBE800.GcpBEArtigo objArtigo, double pvp1)
{
CodArtigo = objArtigo.get_Artigo();
DescArtigo = objArtigo.get_Descricao();
if (objArtigo.get_Marca() != "")
{
Marca = PriEngine.Engine.Comercial.Marcas.DaValorAtributo(objArtigo.get_Marca(), "Descricao");
}
if (objArtigo.get_Modelo() != "" && objArtigo.get_Marca() != "")
{
Modelo = PriEngine.Engine.Comercial.Modelos.DaValorAtributo(objArtigo.get_Marca(), objArtigo.get_Modelo(), "Descricao");
}
Preco = Math.Round(pvp1 * (1 + Convert.ToDouble(objArtigo.get_IVA()) / 100.0), 2);
Especificacoes = PriIntegration.ListaEspecificacoesArtigo(CodArtigo);
int cdu_tipo = PriEngine.Engine.Comercial.Artigos.DaValorAtributo(CodArtigo, "CDU_Tipo");
Tipo = PriIntegration.GetTipoArtigo(cdu_tipo).CDU_TipoArtigo;
StdBECamposChave cdu_tipo_chave = new StdBECamposChave();
cdu_tipo_chave.AddCampoChave("CDU_IdTipo", cdu_tipo);
int cdu_categoria = PriEngine.Engine.TabelasUtilizador.DaValorAtributo("TDU_TipoArtigo", cdu_tipo_chave, "CDU_Categoria");
StdBECamposChave cdu_categoria_chave = new StdBECamposChave();
cdu_categoria_chave.AddCampoChave("CDU_IdCategoria", cdu_categoria);
Categoria = PriEngine.Engine.TabelasUtilizador.DaValorAtributo("TDU_Categoria", cdu_categoria_chave, "CDU_Categoria");
Stock = objArtigo.get_StkActual();
Stock_armazem = PriIntegration.getStock_armazem(CodArtigo);
Relacionados = PriIntegration.getRelacionados(CodArtigo, cdu_tipo, pvp1);
}
public IHttpActionResult GetArmazemPrincipal()
{
string result = null;
try {
result = PriIntegration.GetArmazemPrincipal();
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception) {
return(InternalServerError());
}
if (result == null)
{
return(InternalServerError());
}
else
{
Dictionary <string, string> response = new Dictionary <string, string>();
response.Add("armazem-principal", result);
return(Ok(response));
}
}
public void TestMethod1()
{
var balanceSheet = PriIntegration.GetBalanceSheet();
BalanceSheet sheet = new BalanceSheet(balanceSheet);
String i = sheet.moeda;
Dictionary <String, Metric> m = sheet.metrics;
}
public IHttpActionResult GetAssign(int funcionario)
{
try {
// Verificar se este funcionario ainda tem waves pendentes
// Se tem, retornar essa wave
dynamic pendingWave = PriIntegration.GetWaveActual(funcionario);
if (pendingWave != null)
{
return(Ok(pendingWave));
}
// Verificar se existem replenishment lines pendentes
// Se sim, retorna uma nova replenishment wave
Wave <ReplenishmentLine> pendingReplenishmentWave = PriIntegration.GetProximaReplenishmentOrder(funcionario);
if (pendingReplenishmentWave != null)
{
return(Ok(pendingReplenishmentWave));
}
// Por fim, verificar se existem picking waves pendentes
// Se sim, retorna uma nova picking wave
Wave <PickingLine> pendingPickingWave = PriIntegration.GetProximaPickingWave(funcionario);
if (pendingPickingWave != null)
{
return(Ok(pendingPickingWave));
}
} catch (InvalidOperationException invalidOperation) {
return(BadRequest(invalidOperation.Message));
} catch (Exception e) {
return(InternalServerError(e));
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostTerminateReplenishment(WaveCompletion wave)
{
try {
PriIntegration.TerminarReplenishmentOrder(wave.IDFuncionario, wave.WaveID, wave.Lines);
} catch (InvalidOperationException invalidOperation) {
return(BadRequest(invalidOperation.Message));
} catch (Exception e) {
return(InternalServerError(e));
}
return(Ok());
}
// POST: api/armazem
/*
* Body: Object
* armazemOrigem: string,
* serie: string,
* artigos: Array
* Object
* artigo: string,
* localizacaoOrigem: string,
* localizacaoDestino: string,
* armazemDestino: string,
* quantidade: uint
*/
public IHttpActionResult Post(TransferenciaArmazem transferencia)
{
try {
if (PriIntegration.GerarTransferenciaArmazem(transferencia))
{
return(Ok());
}
else
{
return(BadRequest());
}
} catch (Exception e) {
return(InternalServerError(new Exception(e.Message)));
}
}
// GET: api/armazem
public IHttpActionResult Get()
{
List <Armazem> listaArmazens = null;
try {
listaArmazens = PriIntegration.GetArmazens();
} catch (Exception) {
return(InternalServerError());
}
if (listaArmazens == null)
{
return(NotFound());
}
else
{
return(Ok(listaArmazens));
}
}
// GET api/artigo
public IHttpActionResult Get()
{
List <Artigo> listaFinal = null;
try {
listaFinal = PriIntegration.ListaArtigos();
} catch (Exception) {
return(InternalServerError());
}
if (listaFinal == null)
{
return(BadRequest());
}
else
{
return(Ok(listaFinal));
}
}
public IHttpActionResult PostCapacidadeMaximaFuncionario(Dictionary <string, int> request)
{
if (!request.ContainsKey("capacidade"))
{
return(BadRequest("A resposta deve conter um objecto com a propriedade 'capacidade'"));
}
int novaCapacidade = request["capacidade"];
try {
PriIntegration.SetCapacidadeMaximaFuncionario(novaCapacidade);
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception) {
return(InternalServerError());
}
return(Ok());
}
public IHttpActionResult PostArmazemPrincipal(Dictionary <string, string> request)
{
if (!request.ContainsKey("armazem"))
{
return(BadRequest("A resposta deve conter um objecto com a propriedade 'armazem'"));
}
string novoArmazemPrincipal = request["armazem"];
try {
PriIntegration.SetArmazemPrincipal(novoArmazemPrincipal);
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception) {
return(InternalServerError());
}
return(Ok());
}
public IHttpActionResult GetEncomendasProntas(string filial, string serie, int nDoc)
{
List <EncomendaCliente> encomendas = null;
try {
encomendas = PriIntegration.GetEncomendasPassiveisDeTransformacao(filial, serie, nDoc);
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception e) {
return(InternalServerError(e));
}
if (encomendas == null || encomendas.Count < 1)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(Ok(encomendas));
}
}
public IHttpActionResult GetEncomendasOrdenadasPorDataECliente(string filial, string serie, bool descDate, bool descCliente)
{
List <EncomendaCliente> encomendas = null;
try {
encomendas = PriIntegration.GetEncomendasClientesPorOrdenacao(filial, serie, true, descDate, true, descCliente);
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception e) {
return(InternalServerError(e));
}
if (encomendas == null || encomendas.Count < 1)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(Ok(encomendas));
}
}
// GET: api/cliente
public IHttpActionResult Get()
{
List <Cliente> clientes = null;
try {
clientes = PriIntegration.GetListaClientes();
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception) {
return(InternalServerError());
}
if (clientes == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(Ok(clientes));
}
}
public IHttpActionResult GetEncomendaByClienteAndNumber(string id, string filial, string serie, int n)
{
List <EncomendaCliente> encomendas = null;
try {
encomendas = PriIntegration.GetEncomendasClientes(filial, serie, id, n);
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception e) {
return(InternalServerError(e));
}
if (encomendas == null || encomendas.Count < 1)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(Ok(encomendas));
}
}
// GET api/artigo/{artigo-id}
public IHttpActionResult Get(string id)
{
Artigo artigo = null;
try {
artigo = PriIntegration.ObterArtigo(id);
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception e) {
return(InternalServerError(e));
}
if (artigo == null)
{
return(BadRequest());
}
else
{
return(Ok(artigo));
}
}
// GET: api/armazem/{armazem-id}
public IHttpActionResult Get(string id)
{
List <LocalizacaoArmazem> listaLocalizacoes = null;
try {
listaLocalizacoes = PriIntegration.GetLocalizacoesArmazens(id);
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception) {
return(InternalServerError());
}
if (listaLocalizacoes == null)
{
return(NotFound());
}
else
{
return(Ok(listaLocalizacoes));
}
}
// GET: api/cliente/{cliente-id}
public IHttpActionResult Get(string id)
{
Cliente cliente = null;
try {
cliente = PriIntegration.GetClienteInfo(id);
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception) {
return(InternalServerError());
}
if (cliente == null)
{
return(NotFound());
}
else
{
return(Ok(cliente));
}
}
public IHttpActionResult PostNewWaves(GenerateWavesRequest request)
{
bool result = false;
try {
result = PriIntegration.GerarPickingOrders(request.Filial, request.Serie, request.Encomendas);
} catch (InvalidOperationException invalidOperation) {
return(BadRequest(invalidOperation.Message));
} catch (Exception e) {
return(InternalServerError(e));
}
if (!result)
{
return(NotFound());
}
else
{
return(Ok());
}
}
public IHttpActionResult GetAvisos()
{
List <string> result = null;
try {
result = PriIntegration.GetAvisosPorLer();
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception) {
return(InternalServerError());
}
if (result == null)
{
return(InternalServerError());
}
else
{
return(Ok(result));
}
}
public IHttpActionResult PostEncomendas(PedidoTransformacaoECL encomenda)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try {
if (PriIntegration.GerarGuiaRemessa(encomenda))
{
return(Ok());
}
else
{
return(BadRequest());
}
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception e) {
return(InternalServerError(e));
}
}
public IHttpActionResult GetPendingReplenishment(int offset)
{
List <WaveStatus> result = null;
try {
result = PriIntegration.GetPendingReplenishmentWave(offset);
} catch (InvalidOperationException invalidOperation) {
return(BadRequest(invalidOperation.Message));
} catch (Exception e) {
return(InternalServerError(e));
}
if (result == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(Ok(result));
}
}
public IHttpActionResult GetQuantidadeAvisos()
{
int result = -1;
try {
result = PriIntegration.GetNumeroAvisosPorLer();
} catch (InvalidOperationException e) {
return(BadRequest(e.Message));
} catch (Exception) {
return(InternalServerError());
}
if (result < 0)
{
return(InternalServerError());
}
Dictionary <string, int> resultBody = new Dictionary <string, int>();
resultBody.Add("quantidade", result);
return(Ok(resultBody));
}
public Dictionary <int, Dictionary <string, ClassLine> > GetBalanceSheet()
{
return(PriIntegration.GetBalanceSheet());
}
public IEnumerable <Sale> GetSales(DateTime initialDate, DateTime finalDate)
{
return(PriIntegration.GetSales(initialDate, finalDate));
}
public IEnumerable <Pending> GetPendingReceivables(DateTime initialDate, DateTime finalDate)
{
return(PriIntegration.GetPendingReceivables(initialDate, finalDate));
}
public IEnumerable <Purchase> GetPurchases(DateTime initialDate, DateTime finalDate)
{
return(PriIntegration.GetPurchases(initialDate, finalDate));
}
public IEnumerable <EmployeeMovement> GetEmployeeMovements(DateTime initialDate, DateTime finalDate)
{
return(PriIntegration.GetEmployeesMovements(initialDate, finalDate));
}
public IEnumerable <OvertimeHours> GetOvertimeHours(DateTime initialDate, DateTime finalDate)
{
return(PriIntegration.GetOvertimeHours(initialDate, finalDate));
}
