/// <summary>
/// Registro todos os cpfs e chaves(RECID) do arquivo de identificacao
/// </summary>
/// <param name="idArquivo"></param>
/// <param name="cpf"></param>
/// <param name="chave"></param>
public static void InsereCRICargaDet(int idArquivo, string chave, upSight.CartaoCorp.EnumRetornoBase.TipoIdentificacao tpIdentificacao, string identificacao, EnumRetornoBase.StatusCartao statusCartao, decimal valor)
{
using (SqlConnection cnx = new SqlConnection(ConfigurationManager.ConnectionStrings["Global"].ConnectionString))
{
try
{
string query = " INSERT crpCRICargaDetalhe(IdArquivo, TpIdentificacao, Identificacao, StatusCart, Valor, Chave, Retorno, DtRetorno) " +
" SELECT @IdArquivo, @TpIdentificacao, @Identificacao, @StatusCart, @Valor, @Chave, NULL, NULL ";
using (SqlCommand cmd = new SqlCommand(query, cnx))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("IdArquivo", SqlDbType.Int).Value = idArquivo;
cmd.Parameters.Add("TpIdentificacao", SqlDbType.TinyInt).Value = Convert.ToByte(tpIdentificacao);
cmd.Parameters.Add("Identificacao", SqlDbType.VarChar, 32).Value = identificacao;
cmd.Parameters.Add("StatusCart", SqlDbType.TinyInt).Value = Convert.ToByte(statusCartao);
cmd.Parameters.Add("Valor", SqlDbType.Money).Value = valor;
cmd.Parameters.Add("Chave", SqlDbType.VarChar, 15).Value = chave;
cnx.Open();
cmd.ExecuteNonQuery();
}
}
catch (SqlException sqlExc)
{
if (BDGeral.TS.TraceError)
Trace.TraceError("{0}: {1}", new object[] { "u.G.S.CRP.CrgCrtRetSql", sqlExc });
throw;
}
catch (Exception e)
{
if (BDGeral.TS.TraceError)
Trace.TraceError("{0}: {1}", new object[] { "u.G.S.CRP.CrgCrtRetEx", e });
throw;
}
}
}
/// <summary>
/// Monta os dados que irão compor o lote
/// </summary>
/// <param name="idArquivo"></param>
/// <param name="codPrgCarga"></param>
/// <param name="statusProc"></param>
/// <param name="numCartoes"></param>
/// <param name="numReject"></param>
/// <param name="numLinha"></param>
/// <returns></returns>
private ACSOPRGCR_RLoteEN MontaLote(int idArquivo, string codPrgCarga, int numRejeit, int numCart, int numLinha, EnumRetornoBase.StatusProcessamento statusProc)
{
var acsPrgCrgLoteEN = new ACSOPRGCR_RLoteEN()
{
IdArquivo = idArquivo,
CodPrgCrg = codPrgCarga,
StatusProc = statusProc,
NumCart = numCart,
NumRejeit = numRejeit,
NumLinha = numLinha
};
return acsPrgCrgLoteEN;
}
