public int UpdateData(List <DadosVariaveisDTO> listObj, int idPessoa)
{
RepList <PessoaDTO> listProjeto = new RepList <PessoaDTO>();
RepGen <PessoaDTO> sqlCommand = new RepGen <PessoaDTO>();
// ************************
// DELETE
// ************************
var param = new DynamicParameters();
param.Add("@idPessoa", idPessoa, DbType.String);
var result = sqlCommand.ExecuteSQLCommand("delete TB_PessoaDV where idPessoa = @idPessoa", param);
// ************************
// INSERT
// ************************
foreach (var item in listObj)
{
var param2 = new DynamicParameters();
param2.Add("@idPessoa", idPessoa, DbType.String);
param2.Add("@idDadoVariavel", item.idDadoVariavel, DbType.Int32);
result = sqlCommand.ExecuteSQLCommand("INSERT INTO TB_PessoaDV (idPessoa, idDadoVariavel) VALUES (@idPessoa, @idDadoVariavel)", param2);
}
return(result);
}
public int InsertData(FrequenciaDTO _item)
{
RepGen <FrequenciaDTO> sqlCommand = new RepGen <FrequenciaDTO>();
string query = "INSERT INTO TB_Frequencia VALUES (";
var param = new DynamicParameters();
param.Add("@dtFrequencia", _item.dtFrequencia, DbType.DateTime);
param.Add("@idTurma", _item.idTurma, DbType.Int32);
param.Add("@idDisciplina", _item.idDisciplina, DbType.Int32);
param.Add("@dtCadastro", DateTime.Now, DbType.DateTime);
param.Add("@dtUltAlteracao", DateTime.Now, DbType.DateTime);
param.Add("@idPessoaUltAlteracao", _item.idPessoaUltAlteracao, DbType.Int32);
foreach (var item in param.ParameterNames)
{
query += "@" + item + ",";
}
query = query.Remove(query.Length - 1) + ")";
query += "; SELECT CAST(scope_identity() AS int)";
var result = sqlCommand.ExecuteSQLCommand(query, param);
return(result);
}
public int InsertData(TurmaDTO _turmaDTO)
{
RepList <TurmaDTO> listProjeto = new RepList <TurmaDTO>();
RepGen <TurmaDTO> sqlCommand = new RepGen <TurmaDTO>();
string query = "INSERT INTO TB_Turmas VALUES (";
var param = new DynamicParameters();
param.Add("@nomeTurma", _turmaDTO.nomeTurma, DbType.String);
param.Add("@descricaoTurma", _turmaDTO.descricaoTurma, DbType.String);
param.Add("@descricaoPeriodo", _turmaDTO.descricaoPeriodo, DbType.String);
param.Add("@horaInicio", _turmaDTO.horaInicio, DbType.String);
param.Add("@horaTermino", _turmaDTO.horaTermino, DbType.String);
param.Add("@idPessoaEducador", _turmaDTO.idPessoaEducador, DbType.Int32);
param.Add("@dtCadastro", DateTime.Now, DbType.DateTime);
param.Add("@flagAtivo", _turmaDTO.flagAtivo, DbType.Boolean);
param.Add("@dtUltAlteracao", DateTime.Now, DbType.DateTime);
param.Add("@idPessoaUltAlteracao", _turmaDTO.idPessoaUltAlteracao, DbType.Int32);
param.Add("@idProjeto", _turmaDTO.idProjeto, DbType.Int32);
foreach (var item in param.ParameterNames)
{
query += "@" + item + ",";
}
query = query.Remove(query.Length - 1) + ")";
query += "; SELECT CAST(scope_identity() AS int)";
var result = sqlCommand.ExecuteSQLCommand(query, param);
return(result);
}
public int InsertData(ContatoDTO objectDTO)
{
RepList <ContatoDTO> listProjeto = new RepList <ContatoDTO>();
RepGen <ContatoDTO> sqlCommand = new RepGen <ContatoDTO>();
string query = "INSERT INTO TB_Contatos VALUES (";
var param = new DynamicParameters();
param.Add("@idPai", objectDTO.idPai, DbType.Int32);
param.Add("@idMae", objectDTO.idMae, DbType.Int32);
param.Add("@telefone1", objectDTO.telefone1, DbType.String);
param.Add("@contato1", objectDTO.contato1, DbType.String);
param.Add("@telefone2", objectDTO.telefone2, DbType.String);
param.Add("@contato2", objectDTO.contato2, DbType.String);
param.Add("@telefone3", objectDTO.telefone3, DbType.String);
param.Add("@contato3", objectDTO.contato3, DbType.String);
foreach (var item in param.ParameterNames)
{
query += "@" + item + ",";
}
query = query.Remove(query.Length - 1) + ")";
query += "; SELECT CAST(scope_identity() AS int)";
var result = sqlCommand.ExecuteSQLCommand(query, param);
return(result);
}
public int InsertData(ProjetoDTO objectDTO)
{
RepList <ProjetoDTO> listProjeto = new RepList <ProjetoDTO>();
RepGen <ProjetoDTO> sqlCommand = new RepGen <ProjetoDTO>();
string query = "INSERT INTO TB_Projetos VALUES (";
var param = new DynamicParameters();
param.Add("@nomeProjeto", objectDTO.nomeProjeto, DbType.String);
param.Add("@descricaoProjeto", objectDTO.descricaoProjeto, DbType.String);
param.Add("@dtInicio", objectDTO.dtInicio, DbType.Date);
param.Add("@dtTermino", objectDTO.dtTermino, DbType.Date);
//param.Add("@idPessoaResposavel", objectDTO.idPessoaResposavel, DbType.Int32);
param.Add("@nomeResposavel", objectDTO.nomeResposavel, DbType.String);
param.Add("@dtCadastro", DateTime.Now, DbType.DateTime);
param.Add("@flagAtivo", objectDTO.flagAtivo, DbType.Boolean);
param.Add("@dtUltAlteracao", DateTime.Now, DbType.DateTime);
param.Add("@idPessoaUltAlteracao", objectDTO.idPessoaUltAlteracao, DbType.Int32);
foreach (var item in param.ParameterNames)
{
query += "@" + item + ",";
}
query = query.Remove(query.Length - 1) + ")";
query += "; SELECT CAST(scope_identity() AS int)";
var result = sqlCommand.ExecuteSQLCommand(query, param);
return(result);
}
public int InsertData(EscolaDTO objectDTO)
{
RepList <EscolaDTO> listProjeto = new RepList <EscolaDTO>();
RepGen <EscolaDTO> sqlCommand = new RepGen <EscolaDTO>();
string query = "INSERT INTO TB_ESCOLAS VALUES (";
var param = new DynamicParameters();
param.Add("@nomeEscola", objectDTO.nomeEscola, DbType.String);
param.Add("@observacoes", objectDTO.observacoes, DbType.String);
param.Add("@idEndereco", objectDTO.idEndereco, DbType.Int32);
param.Add("@dtCadastro", DateTime.Now, DbType.DateTime);
param.Add("@flagAtivo", objectDTO.flagAtivo, DbType.Boolean);
param.Add("@dtUltAlteracao", DateTime.Now, DbType.DateTime);
param.Add("@idPessoaUltAlteracao", objectDTO.idPessoaUltAlteracao, DbType.Int32);
foreach (var item in param.ParameterNames)
{
query += "@" + item + ",";
}
query = query.Remove(query.Length - 1) + ")";
query += "; SELECT CAST(scope_identity() AS int)";
var result = sqlCommand.ExecuteSQLCommand(query, param);
return(result);
}
public int InsertData(EnderecoDTO objectDTO)
{
RepList <EnderecoDTO> listProjeto = new RepList <EnderecoDTO>();
RepGen <EnderecoDTO> sqlCommand = new RepGen <EnderecoDTO>();
string query = "INSERT INTO TB_Enderecos VALUES (";
var param = new DynamicParameters();
param.Add("@CEP", objectDTO.CEP, DbType.String);
param.Add("@logradouro", objectDTO.logradouro, DbType.String);
param.Add("@complemento", objectDTO.complemento, DbType.String);
param.Add("@numero", objectDTO.numero, DbType.String);
param.Add("@idBairro", objectDTO.idBairro, DbType.Int32);
param.Add("@nomeBairro", objectDTO.nomeBairro, DbType.String);
param.Add("@idCidade", objectDTO.idCidade, DbType.Int32);
param.Add("@nomeCidade", objectDTO.nomeCidade, DbType.String);
param.Add("@siglaUF", objectDTO.siglaUF, DbType.String);
foreach (var item in param.ParameterNames)
{
query += "@" + item + ",";
}
query = query.Remove(query.Length - 1) + ")";
query += "; SELECT CAST(scope_identity() AS int)";
var result = sqlCommand.ExecuteSQLCommand(query, param);
return(result);
}
public int GerarFrequencia(FrequenciaDTO _item)
{
RepGen <FrequenciaDTO> sqlCommand = new RepGen <FrequenciaDTO>();
string query = "EXEC SPR_GerarFrequencia ";
var param = new DynamicParameters();
param.Add("@idFrequencia", _item.idFrequencia, DbType.Int32);
param.Add("@dtFrequencia", _item.dtFrequencia, DbType.DateTime);
foreach (var item in param.ParameterNames)
{
query += "@" + item + ",";
}
query = query.Remove(query.Length - 1);
var result = sqlCommand.ExecuteSQLCommand(query, param);
return(result);
}
public int InsertData(PessoaDTO objectDTO)
{
RepList <PessoaDTO> listProjeto = new RepList <PessoaDTO>();
RepGen <PessoaDTO> sqlCommand = new RepGen <PessoaDTO>();
string query = "INSERT INTO TB_Pessoas VALUES (";
var param = new DynamicParameters();
param.Add("@nomePessoa", objectDTO.nomePessoa, DbType.String);
param.Add("@dtNascimento", objectDTO.dtNascimento, DbType.DateTime);
param.Add("@idTipoPessoa", objectDTO.idTipoPessoa, DbType.Int32);
param.Add("@idGenero", objectDTO.idGenero, DbType.Int32);
param.Add("@dtAtivacao", objectDTO.dtAtivacao, DbType.DateTime);
param.Add("@numeroRG", objectDTO.numeroRG, DbType.String);
param.Add("@numeroCPF", objectDTO.numeroCPF, DbType.String);
param.Add("@observacoes", objectDTO.observacoes, DbType.String);
param.Add("@idEndereco", objectDTO.idEndereco, DbType.Int32);
param.Add("@idContato", objectDTO.idContato, DbType.Int32);
param.Add("@idEscola", objectDTO.idEscola, DbType.Int32);
param.Add("@fotoBase64", objectDTO.fotoBase64, DbType.String);
param.Add("@flagResponsavel", objectDTO.flagResponsavel, DbType.Int32);
param.Add("@idSituacao", objectDTO.idSituacao, DbType.Int32);
param.Add("@dtCadastro", DateTime.Now, DbType.DateTime);
param.Add("@flagAtivo", objectDTO.flagAtivo, DbType.Boolean);
param.Add("@dtUltAlteracao", DateTime.Now, DbType.DateTime);
param.Add("@idPessoaUltAlteracao", objectDTO.idPessoaUltAlteracao, DbType.Int32);
foreach (var item in param.ParameterNames)
{
query += "@" + item + ",";
}
query = query.Remove(query.Length - 1) + ")";
query += "; SELECT CAST(scope_identity() AS int)";
var result = sqlCommand.ExecuteSQLCommand(query, param);
return(result);
}
public int UpdateListaChamada(FrequenciaDTO _item)
{
RepGen <FrequenciaDTO> sqlCommand = new RepGen <FrequenciaDTO>();
string query = "EXEC SPR_AtualizaListaChamada ";
var param = new DynamicParameters();
param.Add("@idFrequencia", _item.idFrequencia, DbType.Int32);
param.Add("@idPessoa", _item.idPessoa, DbType.Int32);
param.Add("@flagPresenca", _item.flagPresenca, DbType.Boolean);
foreach (var item in param.ParameterNames)
{
query += "@" + item + ",";
}
query = query.Remove(query.Length - 1);
var result = sqlCommand.ExecuteSQLCommand(query, param);
return(result);
}