public ResultadoTransacao Update(AlunoOT pAlunoOT)
{
List <SqlParameter> _parametrosList = new List <SqlParameter>();
InformacaoTransacao _informacaoTransacao = new InformacaoTransacao();
_parametrosList.Add(base.GetSqlParameter("p_CD_ALUNO", base.TratarNumero(pAlunoOT.Codigo), System.Data.ParameterDirection.Input, System.Data.DbType.Int32));
_parametrosList.Add(base.GetSqlParameter("p_CD_CIDADE", base.TratarNumero(pAlunoOT.Cidade.Codigo), System.Data.ParameterDirection.Input, System.Data.DbType.Int32));
_parametrosList.Add(base.GetSqlParameter("p_CD_ESTADO", base.TratarNumero(pAlunoOT.Estado.Codigo), System.Data.ParameterDirection.Input, System.Data.DbType.Int32));
_parametrosList.Add(base.GetSqlParameter("p_CD_PAIS", base.TratarNumero(pAlunoOT.Pais.Codigo), System.Data.ParameterDirection.Input, System.Data.DbType.Int32));
_parametrosList.Add(base.GetSqlParameter("p_NM_ALUNO", base.TratarString(pAlunoOT.Nome), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_DS_ENDERECO", base.TratarString(pAlunoOT.Endereco), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_DS_BAIRRO", base.TratarString(pAlunoOT.Bairro), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_DS_TELEFONE_CEL", base.TratarString(pAlunoOT.TelefoneCelular), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_DS_TELEFONE_RES", base.TratarString(pAlunoOT.TelefoneResidencial), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_DS_TELEFONE_COM", base.TratarString(pAlunoOT.TelefoneComercial), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_DS_EMAIL", base.TratarString(pAlunoOT.Email), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_CPF", base.TratarNumero(pAlunoOT.CPF), System.Data.ParameterDirection.Input, System.Data.DbType.Double));
_parametrosList.Add(base.GetSqlParameter("p_CD_STATUS", base.TratarNumero(Enumeradores.ConverterStatusShort(pAlunoOT.Status)), System.Data.ParameterDirection.Input, System.Data.DbType.Int32));
_parametrosList.Add(base.GetSqlParameter("p_RG", base.TratarString(pAlunoOT.RG), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_CD_ESTADO_RG", base.TratarNumero(pAlunoOT.EstadoRG.Codigo), System.Data.ParameterDirection.Input, System.Data.DbType.Int32));
_parametrosList.Add(base.GetSqlParameter("p_DT_NASCIMENTO", base.TratarData(pAlunoOT.DataNascimento), System.Data.ParameterDirection.Input, System.Data.DbType.DateTime));
_parametrosList.Add(base.GetSqlParameter("p_CEP", base.TratarNumero(pAlunoOT.CEP), System.Data.ParameterDirection.Input, System.Data.DbType.Int32));
_parametrosList.Add(base.GetSqlParameter("p_SEXO", base.TratarNumero(Enumeradores.ConverterSexoShort(pAlunoOT.Sexo)), System.Data.ParameterDirection.Input, System.Data.DbType.Int32));
_parametrosList.Add(base.GetSqlParameter("p_NM_PAI", base.TratarString(pAlunoOT.NomePai), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_NM_MAE", base.TratarString(pAlunoOT.NomeMae), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_NM_RESPONSAVEL", base.TratarString(pAlunoOT.NomeResponsavel), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_DS_TELEFONE_RESPONSAVEL", base.TratarString(pAlunoOT.TelefoneResponsavel), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_CD_ESTADO_CIVIL", base.TratarNumero(Enumeradores.ConverterEstadoShort(pAlunoOT.EstadoCivil)), System.Data.ParameterDirection.Input, System.Data.DbType.Int32));
_parametrosList.Add(base.GetSqlParameter("p_DS_OBSERVACAO", base.TratarString(pAlunoOT.Observacao), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_CD_SENHA", base.TratarString(pAlunoOT.Senha), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_DT_ALTERACAO_SENHA", base.TratarData(pAlunoOT.DataAlteracaoSenha), System.Data.ParameterDirection.Input, System.Data.DbType.DateTime));
_parametrosList.Add(base.GetSqlParameter("p_DT_EXPIRACAO_SENHA", base.TratarData(pAlunoOT.DataExpiracaoSenha), System.Data.ParameterDirection.Input, System.Data.DbType.DateTime));
_parametrosList.Add(base.GetSqlParameter("p_DT_ALTERACAO", base.TratarData(pAlunoOT.DataAlteracao), System.Data.ParameterDirection.Input, System.Data.DbType.DateTime));
_parametrosList.Add(base.GetSqlParameter("p_CD_USUARIO_ALTERACAO", base.TratarNumero(pAlunoOT.UsuarioAlteracao.Codigo), System.Data.ParameterDirection.Input, System.Data.DbType.Int32));
_parametrosList.Add(base.GetSqlParameter("p_IMG_FOTO", base.TratarImagem(pAlunoOT.Foto), System.Data.ParameterDirection.Input, System.Data.DbType.Binary));
_parametrosList.Add(base.GetSqlParameter("p_DS_OBJETIVO", base.TratarString(pAlunoOT.Objetivo), System.Data.ParameterDirection.Input, System.Data.DbType.String));
_parametrosList.Add(base.GetSqlParameter("p_CD_PROFISSAO", base.TratarNumero(pAlunoOT.Profissao.Codigo), System.Data.ParameterDirection.Input, System.Data.DbType.Int32));
_informacaoTransacao.SetProcedure("STP_ALTERAR_ALUNO", _parametrosList);
return(base.Executar(_informacaoTransacao));
}
