public void AddRequestItem(LaboratorioRequisicaoExameDetalhesDTO dto)
{
try
{
ComandText = "stp_CLI_LABORATORIO_REQUISICAO_EXAME_DETAILS_ADICIONAR";
AddParameter("@REQUEST_ID", dto.RequisicaoID);
AddParameter("@EXAME_ID", dto.ExameID);
AddParameter("@ORDER_ITEM_ID", dto.OrderItemID <= 0 ? (object)DBNull.Value : dto.OrderItemID);
AddParameter("@DELIVERY_DATE", dto.PrevisionDeliveryDate);
AddParameter("@UTILIZADOR", dto.Utilizador);
AddParameter("@PRECO_UNITARIO", dto.PrecoUnitario);
AddParameter("@DESCONTO", dto.Desconto);
AddParameter("@VALOR_DESCONTO", dto.ValorDesconto);
AddParameter("@VALOR_UTENTE", dto.ValorUtente);
AddParameter("@VALOR_ENTIDADE", dto.ValorEntidade);
AddParameter("@VALOR_TOTAL", dto.ValorTotal);
ExecuteNonQuery();
dto.Sucesso = true;
}
catch (Exception ex)
{
dto.Sucesso = false;
dto.MensagemErro = ex.Message.Replace("'", "");
}
finally
{
FecharConexao();
}
}
public List <LaboratorioRequisicaoExameDetalhesDTO> GetRequestDetailsList(LaboratorioRequisicaoExameDetalhesDTO dto)
{
var lista = new List <LaboratorioRequisicaoExameDetalhesDTO>();
try
{
ComandText = "stp_CLI_LABORATORIO_REQUISICAO_EXAME_DETAILS_OBTERPORFILTRO";
AddParameter("REQUEST_ID", dto.RequisicaoID);
AddParameter("EXAME_ID", dto.ExameID);
MySqlDataReader dr = ExecuteReader();
int ordem = 1;
while (dr.Read())
{
dto = new LaboratorioRequisicaoExameDetalhesDTO
{
NroOrdenacao = ordem,
RequisicaoID = int.Parse(dr[0].ToString()),
ExameID = int.Parse(dr[1].ToString()),
PrevisionDeliveryDate = DateTime.Parse(dr[2].ToString()),
ProcessBeginDate = dr[3].ToString() != "" ? DateTime.Parse(dr[3].ToString()) : DateTime.MinValue,
CollectionDate = dr[4].ToString() != "" ? DateTime.Parse(dr[4].ToString()) : DateTime.MinValue,
ProfessionalCollectionID = dr[5].ToString() != "" ? int.Parse(dr[5].ToString()) : -1,
IsSelfCollection = dr[6].ToString() != "1" ? false : true,
ProcessProfessionalID = dr[7].ToString() != "" ? int.Parse(dr[7].ToString()) : -1,
TechnicalNotes = dr[8].ToString(),
ResultReferenceValue = dr[9].ToString() != "" ? decimal.Parse(dr[9].ToString()) : 0,
Result = dr[10].ToString(),
ResultNotes = dr[11].ToString(),
ResultDate = dr[12].ToString() != "" ? DateTime.Parse(dr[12].ToString()) : DateTime.MinValue,
ProcessEndDate = dr[13].ToString() != "" ? DateTime.Parse(dr[13].ToString()) : DateTime.MinValue,
Status = dr[14].ToString() != "" ? int.Parse(dr[14].ToString()) : 1,
PrecoUnitario = decimal.Parse(dr[19].ToString()),
Desconto = decimal.Parse(dr[20].ToString()),
ValorDesconto = decimal.Parse(dr[21].ToString()),
ValorUtente = decimal.Parse(dr[22].ToString()),
ValorEntidade = decimal.Parse(dr[23].ToString()),
ValorTotal = decimal.Parse(dr[24].ToString()),
Descricao = dr[26].ToString(),
};
dto.LookupField1 = new StatusDAO().CustomerRequestServicesItemStatusList().Where(t => t.Codigo == dto.Status).SingleOrDefault().Descricao;
lista.Add(dto);
ordem++;
}
}
catch (Exception ex)
{
dto.Sucesso = false;
dto.MensagemErro = ex.Message.Replace("'", "");
}
finally
{
FecharConexao();
}
return(lista);
}
