public SCMContratoBE SelectID(SCMContratoBE obj)
{
SCMContratoBE contrato = new SCMContratoDao().Select <SCMContratoBE>(obj).FirstOrDefault <SCMContratoBE>();
contrato.Cliente = new GlobaisClienteBLL().SelectID(new GlobaisClienteBE {
cli_id = contrato.cli_id
});
return(contrato);
}
public List <NTNotasEmitidasBE> CarregaNotasEmitidas(NTNotasBE obj, string tipoSelect = "Emitidas")
{
List <NTNotasEmitidasBE> result = new List <NTNotasEmitidasBE>();
GlobaisClienteDao cliente = new GlobaisClienteDao();
SCMContratoDao contrato = new SCMContratoDao();
SqlDataReader dr = new BaseDados().RetornaDataReader(this.procedure, tipoSelect, this.conectionString, obj);
if (dr.HasRows)
{
while (dr.Read())
{
NTNotasEmitidasBE item = new NTNotasEmitidasBE();
item.not_id = DBNull.Value.Equals(dr["not_id"]) ? 0 : Convert.ToInt32(dr["not_id"]);
item.log_id = DBNull.Value.Equals(dr["log_id"]) ? 0 : Convert.ToInt32(dr["log_id"]);
//item.user_id = DBNull.Value.Equals(dr["user_id"]) ? 0 : Convert.ToInt32(dr["user_id"]);
item.log_cadastro = Convert.ToDateTime(dr["log_cadastro"]);
item.log_alteracao = DBNull.Value.Equals(dr["log_alteracao"]) ? default(DateTime) : Convert.ToDateTime(dr["log_alteracao"]);
item.log_exclusao = DBNull.Value.Equals(dr["log_exclusao"]) ? default(DateTime) : Convert.ToDateTime(dr["log_exclusao"]);
item.log_ativo = DBNull.Value.Equals(dr["log_ativo"]) ? false : Convert.ToBoolean(dr["log_ativo"]);
item.not_numero = DBNull.Value.Equals(dr["not_numero"]) ? 0 : Convert.ToInt32(dr["not_numero"]);
item.cli_id = DBNull.Value.Equals(dr["cli_id"]) ? 0 : Convert.ToInt32(dr["cli_id"]);
item.cont_id = DBNull.Value.Equals(dr["cont_id"]) ? 0 : Convert.ToInt32(dr["cont_id"]);
item.conf_id = DBNull.Value.Equals(dr["conf_id"]) ? 0 : Convert.ToInt32(dr["conf_id"]);
item.not_tipoReceita = dr["not_tipoReceita"].ToString();
item.not_codReceita = dr["not_codReceita"].ToString();
item.not_dtEmissao = DBNull.Value.Equals(dr["not_dtEmissao"]) ? default(DateTime) : Convert.ToDateTime(dr["not_dtEmissao"]);
item.not_dtVencimento = DBNull.Value.Equals(dr["not_dtVencimento"]) ? default(DateTime) : Convert.ToDateTime(dr["not_dtVencimento"]);
item.not_pis = DBNull.Value.Equals(dr["not_pis"]) ? 0 : Convert.ToDecimal(dr["not_pis"]);
item.not_confins = DBNull.Value.Equals(dr["not_confins"]) ? 0 : Convert.ToDecimal(dr["not_confins"]);
item.not_cssl = DBNull.Value.Equals(dr["not_cssl"]) ? 0 : Convert.ToDecimal(dr["not_cssl"]);
item.not_irrf = DBNull.Value.Equals(dr["not_irrf"]) ? 0 : Convert.ToDecimal(dr["not_irrf"]);
item.not_totalbruto = DBNull.Value.Equals(dr["not_totalbruto"]) ? 0 : Convert.ToDecimal(dr["not_totalbruto"]);
item.not_totalliquido = DBNull.Value.Equals(dr["not_totalliquido"]) ? 0 : Convert.ToDecimal(dr["not_totalliquido"]);
item.not_preenchida = DBNull.Value.Equals(dr["not_preenchida"]) ? 0 : Convert.ToInt32(dr["not_preenchida"]);
item.not_emitida = DBNull.Value.Equals(dr["not_emitida"]) ? false : Convert.ToBoolean(dr["not_emitida"]);
item.not_situacao = dr["not_situacao"].ToString();
item.not_chave = dr["not_chave"].ToString();
//Lote
item.Lote = new NTLoteBE();
item.Lote.lote_serie = dr["lote_serie"].ToString();
item.Lote.lote_modulo = dr["lote_modulo"].ToString();
item.Lote.lote_emissao = DBNull.Value.Equals(dr["lote_emissao"]) ? default(DateTime) : Convert.ToDateTime(dr["lote_emissao"]);
//Retorno
item.res_id = DBNull.Value.Equals(dr["res_id"]) ? 0 : Convert.ToInt32(dr["res_id"]);
item.res_numeroNota = DBNull.Value.Equals(dr["res_numeroNota"]) ? 0 : Convert.ToInt32(dr["res_numeroNota"]);
item.res_codigoVerificacao = DBNull.Value.Equals(dr["res_codigoVerificacao"]) ? 0 : Convert.ToInt32(dr["res_codigoVerificacao"]);
item.res_dataEmissao = dr["res_dataEmissao"].ToString();
item.Cliente = cliente.CarregaClienteCompleto(new GlobaisClienteBE {
cli_id = item.cli_id
}).FirstOrDefault <GlobaisClienteBE>();
item.Contrato = contrato.SelectId <SCMContratoBE>(new SCMContratoBE {
cont_id = item.cont_id
});
result.Add(item);
}
dr.Close();
}
dr.Close();
return(result);
}
