public AtendimentoItemDTO AdicionarItem(AtendimentoItemDTO dto) { try { ComandText = "stp_REST_ATENDIMENTO_ITEM_ADICIONAR"; AddParameter("@ATENDIMENTO", dto.Atendimento); AddParameter("@ARTIGO", dto.Artigo); AddParameter("@QUANTIDADE", dto.Quantidade); AddParameter("@PRECO", dto.Preco); AddParameter("@TOTAL", dto.Total); AddParameter("@SOLICITANTE", dto.Solicitante); AddParameter("@ORDEM", dto.NroOrdenacao); AddParameter("@PEDIDO_ID", dto.OrderID == null ? (object)DBNull.Value : (int)dto.OrderID); AddParameter("@DELETED", dto.Deleted ? 0 : 1); AddParameter("@DELETED_BY", dto.UpdatedBy); AddParameter("@DELETED_DATE", dto.UpdatedDate == DateTime.MinValue ? (object)DBNull.Value : dto.UpdatedDate); AddParameter("@MOTIVO_ANULACAO", dto.DeleteNotes); AddParameter("@OBSERVACOES", dto.Notes); AddParameter("@ITEM_STATUS", dto.Situacao); AddParameter("@COOKER", dto.Cooker <= 0 ? (object)DBNull.Value : (int)dto.Cooker); AddParameter("@DESCONTO", dto.DescontoLinha); AddParameter("@PRIORIDADE", dto.Prioridade); AddParameter("@IMPOSTO", dto.ValorImposto); AddParameter("@ISPAID", dto.IsPaid ? 1 : 0); AddParameter("@TAX_ID", dto.TaxID); AddParameter("@TAX_VALUE", dto.TaxValue); AddParameter("@DISCOUNT_VALUE", dto.DiscountValue); AddParameter("@WAREHOUSE_ID", dto.WareHouseName); if (dto.NroOrdenacao <= 0) { dto.NroOrdenacao = -1; } ExecuteNonQuery(); dto.Sucesso = true; } catch (Exception ex) { dto.MensagemErro = ex.Message.Replace("'", string.Empty); } finally { FecharConexao(); } return(dto); }
public List <AtendimentoItemDTO> ObterItens(AtendimentoDTO dto) { List <AtendimentoItemDTO> lista = new List <AtendimentoItemDTO>(); AtendimentoItemDTO item; try { ComandText = "stp_REST_ATENDIMENTO_ITEM_OBTERFILTRO"; AddParameter("ATENDIMENTO", dto.Codigo); MySqlDataReader dr = ExecuteReader(); while (dr.Read()) { item = new AtendimentoItemDTO { Atendimento = int.Parse(dr[0].ToString()), Artigo = int.Parse(dr[1].ToString()), Designacao = dr[2].ToString(), Quantidade = !string.IsNullOrEmpty(dr[3].ToString()) ? decimal.Parse(dr[3].ToString()) : 0, Preco = !string.IsNullOrEmpty(dr[4].ToString()) ? decimal.Parse(dr[4].ToString()) : 0, Total = (decimal.Parse(dr[4].ToString()) * decimal.Parse(dr[3].ToString())), Solicitante = dr[6].ToString(), NroOrdenacao = int.Parse(dr[7].ToString()), OrderID = int.Parse(dr[8].ToString()), Saved = true, Deleted = int.Parse(dr[9].ToString()) == 1 ? false : true, UpdatedBy = dr[10].ToString(), UpdatedDate = DateTime.Parse(dr[11].ToString() != null && dr[10].ToString() != "" ? dr[11].ToString() : DateTime.MinValue.ToShortDateString()), Notes = dr[12].ToString(), DeleteNotes = dr[13].ToString(), Situacao = dr[14].ToString(), Cooker = int.Parse(dr[15].ToString()), DescontoLinha = decimal.Parse(dr[16].ToString()), Prioridade = dr[17].ToString(), ValorImposto = decimal.Parse(dr[18].ToString()), SocialName = dr[19].ToString(), IsPaid = dr[20].ToString() != "1" ? false :true, TaxID = int.Parse(dr[21].ToString() == "" ? "-1" : dr[21].ToString()), TaxValue = decimal.Parse(dr[22].ToString() == "" ? "0" : dr[22].ToString()), DiscountValue = decimal.Parse(dr[23].ToString() == "" ? "0" : dr[23].ToString()), WareHouseName = dr[24].ToString() == "" ? "-1" : dr[24].ToString() }; lista.Add(item); } } catch (Exception ex) { dto.Sucesso = false; dto.MensagemErro = ex.Message.Replace("'", ""); } finally { FecharConexao(); } return(lista); }