public void Inserir(SPC_CPF spc)
{
try
{
string cone = Cript_Decript.DeCifra(ConfigurationManager.AppSettings["Conexao"]);
SqlParameter[] param = new SqlParameter[0x15];
param[0] = new SqlParameter("@CPF", SqlDbType.VarChar);
param[0].Value = spc.CPF;
param[1] = new SqlParameter("@NOME", SqlDbType.VarChar);
param[1].Value = spc.Nome == null ? String.Empty : spc.Nome;
param[2] = new SqlParameter("@NOMEMAE", SqlDbType.VarChar);
param[2].Value = spc.NomeMae == null ? String.Empty : spc.NomeMae;
param[3] = new SqlParameter("@NOMEPAI", SqlDbType.VarChar);
param[3].Value = spc.NomePai == null ? String.Empty : spc.NomePai;
param[4] = new SqlParameter("@DTNASC", SqlDbType.DateTime);
param[4].Value = spc.Nasc.ToShortDateString().Equals("01/01/0001") ? null : spc.Nasc.ToShortDateString();
param[5] = new SqlParameter("@ENDERECO", SqlDbType.VarChar);
param[5].Value = spc.Ende == null ? String.Empty : spc.Ende;
param[6] = new SqlParameter("@ESTCIV", SqlDbType.VarChar);
param[6].Value = spc.EstCiv == null ? String.Empty : spc.EstCiv;
param[7] = new SqlParameter("@UF", SqlDbType.VarChar);
param[7].Value = spc.UF == null ? String.Empty : spc.UF;
param[8] = new SqlParameter("@IDADE", SqlDbType.Int);
param[8].Value = Versioned.IsNumeric(spc.Idade) ? Convert.ToInt32(spc.Idade) : 0;
param[9] = new SqlParameter("@TituloEleitor", SqlDbType.VarChar);
param[9].Value = spc.TitEleitor == null ? String.Empty : spc.TitEleitor;
param[10] = new SqlParameter("@SEXO", SqlDbType.VarChar);
param[10].Value = spc.Sexo == null ? String.Empty : spc.Sexo;
param[11] = new SqlParameter("@SIGNO", SqlDbType.VarChar);
param[11].Value = spc.Signo == null ? String.Empty : spc.Signo;
param[12] = new SqlParameter("@DTSITUACAO", SqlDbType.DateTime);
param[12].Value = spc.DtSituacao.ToShortDateString().Equals("01/01/0001") ? null : spc.DtSituacao.ToShortDateString();
param[13] = new SqlParameter("@DSCSITUACAO", SqlDbType.VarChar);
param[13].Value = spc.DscSituacao == null ? String.Empty : spc.DscSituacao;
param[14] = new SqlParameter("@UFSITUACAO", SqlDbType.VarChar);
param[14].Value = spc.UfSituacao == null ? String.Empty : spc.UfSituacao;
param[15] = new SqlParameter("@DDDCEL", SqlDbType.VarChar);
param[15].Value = spc.DDDCel == null ? String.Empty : spc.DDDCel;
param[0x10] = new SqlParameter("@TELCEL", SqlDbType.VarChar);
param[0x10].Value = spc.TelCel == null ? String.Empty : spc.TelCel;
param[0x11] = new SqlParameter("@DDDCOM", SqlDbType.VarChar);
param[0x11].Value = spc.DDDCom == null ? String.Empty : spc.DDDCom;
param[0x12] = new SqlParameter("@TELCOM", SqlDbType.VarChar);
param[0x12].Value = spc.TelCom == null ? String.Empty : spc.TelCom;
param[0x13] = new SqlParameter("@DDDRES", SqlDbType.VarChar);
param[0x13].Value = spc.DDDRes == null ? String.Empty : spc.DDDRes;
param[20] = new SqlParameter("@TELRES", SqlDbType.VarChar);
param[20].Value = spc.TelRes == null ? String.Empty : spc.TelRes;
long resultConsulta = Convert.ToInt32(SqlHelper.ExecuteScalar(cone, CommandType.StoredProcedure, "intouch..prc_SPC_Inserir_Consulta", param));
if ((spc.Cheque != null) && (spc.Cheque.Count > 0))
{
param = new SqlParameter[13];
foreach (SPC_CPF_CHEQUE item in spc.Cheque)
{
param[0] = new SqlParameter("@ID", SqlDbType.BigInt);
param[0].Value = resultConsulta;
param[1] = new SqlParameter("@ID_TP_CONSULTA", SqlDbType.Int);
param[1].Value = spc.TipoConsulta;
param[2] = new SqlParameter("@CODALINEA", SqlDbType.BigInt);
param[2].Value = DBNull.Value.Equals(item.CodAlinea) ? String.Empty : item.CodAlinea.ToString();
param[3] = new SqlParameter("@DSCALINEA", SqlDbType.VarChar);
param[3].Value = item.DscAlinea.ToString() != "" ? item.DscAlinea : String.Empty;
param[4] = new SqlParameter("@BANCO", SqlDbType.VarChar);
param[4].Value = item.Banco.ToString() != "" ? item.Banco.ToString() : String.Empty;
param[5] = new SqlParameter("@NUMAGENCIA", SqlDbType.VarChar);
param[5].Value = item.NumAgencia.ToString() != "" ? item.NumAgencia.ToString() : String.Empty;
param[6] = new SqlParameter("@NUMCTACORRENTE", SqlDbType.VarChar);
param[6].Value = item.NumCC != "" ? item.NumCC : String.Empty;
param[7] = new SqlParameter("@DTEMISSAO", SqlDbType.DateTime);
param[7].Value = item.DtEmissao.ToShortDateString().Equals("01/01/0001") ? String.Empty : item.DtEmissao.ToShortDateString();
param[8] = new SqlParameter("@NUMCHEQUE", SqlDbType.VarChar);
param[8].Value = item.NumCheque.ToString() != "" ? item.NumCheque.ToString() : String.Empty;
param[9] = new SqlParameter("@VLCHEQUE", SqlDbType.Decimal);
param[9].Value = item.VlCheque.ToString() != "" ? item.VlCheque.ToString() : String.Empty;
param[10] = new SqlParameter("@NOMEASSOCIADOCHEQUE", SqlDbType.VarChar);
param[10].Value = item.NmAssociado != "" ? item.NmAssociado : String.Empty;
param[11] = new SqlParameter("@NOMEENTIDADECHEQUE", SqlDbType.VarChar);
param[11].Value = item.NmEntidade != "" ? item.NmEntidade : String.Empty;
param[12] = new SqlParameter("@ORIGEMCHEQUE", SqlDbType.VarChar);
param[12].Value = item.Origem != "" ? item.Origem : String.Empty;
SqlHelper.ExecuteNonQuery(cone, CommandType.StoredProcedure, "intouch..prc_SPC_Inserir_Cheque", param);
}
}
if ((spc.ConsultaRealizada != null) && (spc.ConsultaRealizada.Count > 0))
{
param = new SqlParameter[8];
foreach (SPC_CPF_ConsultaRealizada item in spc.ConsultaRealizada)
{
param[0] = new SqlParameter("@ID", SqlDbType.BigInt);
param[0].Value = resultConsulta;
param[1] = new SqlParameter("@ID_TP_CONSULTA", SqlDbType.Int);
param[1].Value = spc.TipoConsulta;
param[2] = new SqlParameter("@QUANTIDADEDIASCONSULTADOS", SqlDbType.BigInt);
param[2].Value = !Versioned.IsNumeric(item.QuantidadeDiasConsultados) ? 0 : item.QuantidadeDiasConsultados;
param[3] = new SqlParameter("@DataUltimaOcorrencia", SqlDbType.DateTime);
param[3].Value = item.DataUltimaOcorrencia.ToShortDateString().Equals("01/01/0001") ? String.Empty : item.DataUltimaOcorrencia.ToShortDateString();
param[4] = new SqlParameter("@DataConsulta", SqlDbType.DateTime);
param[4].Value = item.DataConsulta.ToShortDateString().Equals("01/01/0001") ? String.Empty : item.DataConsulta.ToShortDateString();
param[5] = new SqlParameter("@NomeAssociado", SqlDbType.VarChar);
param[5].Value = item.NomeAssociado == null ? String.Empty : item.NomeAssociado;
param[6] = new SqlParameter("@NomeEntidade", SqlDbType.VarChar);
param[6].Value = item.NomeEntidade == null ? String.Empty : item.NomeEntidade;
param[7] = new SqlParameter("@Origem", SqlDbType.VarChar);
param[7].Value = item.Origem == null ? String.Empty : item.Origem;
}
SqlHelper.ExecuteNonQuery(cone, CommandType.StoredProcedure, "intouch..prc_SPC_Inserir_ConsultaRealizada", param);
}
}
catch (Exception exception1)
{
ProjectData.SetProjectError(exception1);
Exception ex = exception1;
ProjectData.ClearProjectError();
}
}
public void Inserir(SPC_CPF spc)
{
try
{
string cone = Cript_Decript.DeCifra(ConfigurationManager.AppSettings["Conexao"]);
SqlParameter[] param = new SqlParameter[0x15];
param[0] = new SqlParameter("@CPF", SqlDbType.VarChar);
param[0].Value = spc.CPF;
param[1] = new SqlParameter("@NOME", SqlDbType.VarChar);
param[1].Value = spc.Nome == null ? String.Empty : spc.Nome;
param[2] = new SqlParameter("@NOMEMAE", SqlDbType.VarChar);
param[2].Value = spc.NomeMae == null ? String.Empty : spc.NomeMae;
param[3] = new SqlParameter("@NOMEPAI", SqlDbType.VarChar);
param[3].Value = spc.NomePai == null ? String.Empty : spc.NomePai;
param[4] = new SqlParameter("@DTNASC", SqlDbType.DateTime);
param[4].Value = spc.Nasc.ToShortDateString().Equals("01/01/0001") ? null : spc.Nasc.ToShortDateString();
param[5] = new SqlParameter("@ENDERECO", SqlDbType.VarChar);
param[5].Value = spc.Ende == null ? String.Empty : spc.Ende;
param[6] = new SqlParameter("@ESTCIV", SqlDbType.VarChar);
param[6].Value = spc.EstCiv == null ? String.Empty : spc.EstCiv;
param[7] = new SqlParameter("@UF", SqlDbType.VarChar);
param[7].Value = spc.UF == null ? String.Empty : spc.UF;
param[8] = new SqlParameter("@IDADE", SqlDbType.Int);
param[8].Value = Versioned.IsNumeric(spc.Idade) ? Convert.ToInt32(spc.Idade) : 0;
param[9] = new SqlParameter("@TituloEleitor", SqlDbType.VarChar);
param[9].Value = spc.TitEleitor == null ? String.Empty : spc.TitEleitor;
param[10] = new SqlParameter("@SEXO", SqlDbType.VarChar);
param[10].Value = spc.Sexo == null ? String.Empty : spc.Sexo;
param[11] = new SqlParameter("@SIGNO", SqlDbType.VarChar);
param[11].Value = spc.Signo == null ? String.Empty : spc.Signo;
param[12] = new SqlParameter("@DTSITUACAO", SqlDbType.DateTime);
param[12].Value = spc.DtSituacao.ToShortDateString().Equals("01/01/0001") ? null : spc.DtSituacao.ToShortDateString();
param[13] = new SqlParameter("@DSCSITUACAO", SqlDbType.VarChar);
param[13].Value = spc.DscSituacao == null ? String.Empty : spc.DscSituacao;
param[14] = new SqlParameter("@UFSITUACAO", SqlDbType.VarChar);
param[14].Value = spc.UfSituacao == null ? String.Empty : spc.UfSituacao;
param[15] = new SqlParameter("@DDDCEL", SqlDbType.VarChar);
param[15].Value = spc.DDDCel == null ? String.Empty : spc.DDDCel;
param[0x10] = new SqlParameter("@TELCEL", SqlDbType.VarChar);
param[0x10].Value = spc.TelCel == null ? String.Empty : spc.TelCel;
param[0x11] = new SqlParameter("@DDDCOM", SqlDbType.VarChar);
param[0x11].Value = spc.DDDCom == null ? String.Empty : spc.DDDCom;
param[0x12] = new SqlParameter("@TELCOM", SqlDbType.VarChar);
param[0x12].Value = spc.TelCom == null ? String.Empty : spc.TelCom;
param[0x13] = new SqlParameter("@DDDRES", SqlDbType.VarChar);
param[0x13].Value = spc.DDDRes == null ? String.Empty : spc.DDDRes;
param[20] = new SqlParameter("@TELRES", SqlDbType.VarChar);
param[20].Value = spc.TelRes == null ? String.Empty : spc.TelRes;
long resultConsulta = Convert.ToInt32(SqlHelper.ExecuteScalar(cone, CommandType.StoredProcedure, "intouch..prc_SPC_Inserir_Consulta", param));
if ((spc.Cheque != null) && (spc.Cheque.Count > 0))
{
param = new SqlParameter[13];
foreach (SPC_CPF_CHEQUE item in spc.Cheque)
{
param[0] = new SqlParameter("@ID", SqlDbType.BigInt);
param[0].Value = resultConsulta;
param[1] = new SqlParameter("@ID_TP_CONSULTA", SqlDbType.Int);
param[1].Value = spc.TipoConsulta;
param[2] = new SqlParameter("@CODALINEA", SqlDbType.BigInt);
param[2].Value = DBNull.Value.Equals(item.CodAlinea) ? String.Empty : item.CodAlinea.ToString();
param[3] = new SqlParameter("@DSCALINEA", SqlDbType.VarChar);
param[3].Value = item.DscAlinea.ToString() != "" ? item.DscAlinea : String.Empty;
param[4] = new SqlParameter("@BANCO", SqlDbType.VarChar);
param[4].Value = item.Banco.ToString() != "" ? item.Banco.ToString() : String.Empty;
param[5] = new SqlParameter("@NUMAGENCIA", SqlDbType.VarChar);
param[5].Value = item.NumAgencia.ToString() != "" ? item.NumAgencia.ToString() : String.Empty;
param[6] = new SqlParameter("@NUMCTACORRENTE", SqlDbType.VarChar);
param[6].Value = item.NumCC != "" ? item.NumCC : String.Empty;
param[7] = new SqlParameter("@DTEMISSAO", SqlDbType.DateTime);
param[7].Value = item.DtEmissao.ToShortDateString().Equals("01/01/0001") ? String.Empty : item.DtEmissao.ToShortDateString();
param[8] = new SqlParameter("@NUMCHEQUE", SqlDbType.VarChar);
param[8].Value = item.NumCheque.ToString() != "" ? item.NumCheque.ToString() : String.Empty;
param[9] = new SqlParameter("@VLCHEQUE", SqlDbType.Decimal);
param[9].Value = item.VlCheque.ToString() != "" ? item.VlCheque.ToString() : String.Empty;
param[10] = new SqlParameter("@NOMEASSOCIADOCHEQUE", SqlDbType.VarChar);
param[10].Value = item.NmAssociado != "" ? item.NmAssociado : String.Empty;
param[11] = new SqlParameter("@NOMEENTIDADECHEQUE", SqlDbType.VarChar);
param[11].Value = item.NmEntidade != "" ? item.NmEntidade : String.Empty;
param[12] = new SqlParameter("@ORIGEMCHEQUE", SqlDbType.VarChar);
param[12].Value = item.Origem != "" ? item.Origem : String.Empty;
SqlHelper.ExecuteNonQuery(cone, CommandType.StoredProcedure, "intouch..prc_SPC_Inserir_Cheque", param);
}
}
if ((spc.ConsultaRealizada != null) && (spc.ConsultaRealizada.Count > 0))
{
param = new SqlParameter[8];
foreach (SPC_CPF_ConsultaRealizada item in spc.ConsultaRealizada)
{
param[0] = new SqlParameter("@ID", SqlDbType.BigInt);
param[0].Value = resultConsulta;
param[1] = new SqlParameter("@ID_TP_CONSULTA", SqlDbType.Int);
param[1].Value = spc.TipoConsulta;
param[2] = new SqlParameter("@QUANTIDADEDIASCONSULTADOS", SqlDbType.BigInt);
param[2].Value = !Versioned.IsNumeric(item.QuantidadeDiasConsultados) ? 0 : item.QuantidadeDiasConsultados;
param[3] = new SqlParameter("@DataUltimaOcorrencia", SqlDbType.DateTime);
param[3].Value = item.DataUltimaOcorrencia.ToShortDateString().Equals("01/01/0001") ? String.Empty : item.DataUltimaOcorrencia.ToShortDateString();
param[4] = new SqlParameter("@DataConsulta", SqlDbType.DateTime);
param[4].Value = item.DataConsulta.ToShortDateString().Equals("01/01/0001") ? String.Empty : item.DataConsulta.ToShortDateString();
param[5] = new SqlParameter("@NomeAssociado", SqlDbType.VarChar);
param[5].Value = item.NomeAssociado == null ? String.Empty : item.NomeAssociado;
param[6] = new SqlParameter("@NomeEntidade", SqlDbType.VarChar);
param[6].Value = item.NomeEntidade == null ? String.Empty : item.NomeEntidade;
param[7] = new SqlParameter("@Origem", SqlDbType.VarChar);
param[7].Value = item.Origem == null ? String.Empty : item.Origem;
}
SqlHelper.ExecuteNonQuery(cone, CommandType.StoredProcedure, "intouch..prc_SPC_Inserir_ConsultaRealizada", param);
}
}
catch (Exception exception1)
{
ProjectData.SetProjectError(exception1);
Exception ex = exception1;
ProjectData.ClearProjectError();
}
}