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);
}
