public int UpdatePassword(UsuarioDTO objectDTO)
{
RepList <UsuarioDTO> listProjeto = new RepList <UsuarioDTO>();
RepGen <UsuarioDTO> sqlCommand = new RepGen <UsuarioDTO>();
string query = "UPDATE TB_Usuarios SET ";
string where = string.Empty;
var param = new DynamicParameters();
param.Add("@senha", objectDTO.senha, DbType.String);
foreach (var item in param.ParameterNames)
{
query += " " + item + " = @" + item + ",";
}
query = query.Remove(query.Length - 1);
where += " WHERE idUsuario = " + objectDTO.idUsuario.ToString();
query += where;
var result = sqlCommand.ExecuteSQL(query, param);
return(result);
}
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 UpdateData(UsuarioDTO objectDTO)
{
RepList <UsuarioDTO> listProjeto = new RepList <UsuarioDTO>();
RepGen <UsuarioDTO> sqlCommand = new RepGen <UsuarioDTO>();
string query = "UPDATE TB_Usuarios SET ";
string where = string.Empty;
var param = new DynamicParameters();
param.Add("@nomeUsuario", objectDTO.nomeUsuario, DbType.String);
param.Add("@login", objectDTO.login, DbType.String);
//param.Add("@senha", objectDTO.senha, DbType.String);
param.Add("@idPerfil", objectDTO.idPerfil, DbType.Int32);
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 + " = @" + item + ",";
}
query = query.Remove(query.Length - 1);
where += " WHERE idUsuario = " + objectDTO.idUsuario.ToString();
query += where;
var result = sqlCommand.ExecuteSQL(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 UpdateData(EnderecoDTO objectDTO)
{
RepList <EnderecoDTO> listEndereco = new RepList <EnderecoDTO>();
RepGen <EnderecoDTO> sqlCommand = new RepGen <EnderecoDTO>();
string query = "UPDATE TB_Enderecos SET ";
string where = string.Empty;
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 + " = @" + item + ",";
}
query = query.Remove(query.Length - 1);
where += " WHERE idEndereco = " + objectDTO.idEndereco.ToString();
query += where;
var result = sqlCommand.ExecuteSQL(query, param);
return(result);
}
public int UpdateData(ContatoDTO objectDTO)
{
RepList <ContatoDTO> listEndereco = new RepList <ContatoDTO>();
RepGen <ContatoDTO> sqlCommand = new RepGen <ContatoDTO>();
string query = "UPDATE TB_Contatos SET ";
string where = string.Empty;
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 + " = @" + item + ",";
}
query = query.Remove(query.Length - 1);
where += " WHERE idContato = " + objectDTO.idContato.ToString();
query += where;
var result = sqlCommand.ExecuteSQL(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(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 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(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 CancelarMatricula(MatriculaDTO _item)
{
RepGen <MatriculaDTO> sqlCommand = new RepGen <MatriculaDTO>();
string query = "UPDATE TB_Matricula SET ";
string where = string.Empty;
var param = new DynamicParameters();
param.Add("@dtCancelamento", 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 + " = @" + item + ",";
}
query = query.Remove(query.Length - 1);
where += " WHERE idMatricula = " + _item.idMatricula.ToString();
query += where;
var result = sqlCommand.ExecuteSQL(query, param);
return(result);
}
public int UpdateData(EscolaDTO objectDTO)
{
RepList <EscolaDTO> listProjeto = new RepList <EscolaDTO>();
RepGen <EscolaDTO> sqlCommand = new RepGen <EscolaDTO>();
string query = "UPDATE TB_ESCOLAS SET ";
string where = string.Empty;
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("@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 + " = @" + item + ",";
}
query = query.Remove(query.Length - 1);
where += " WHERE idEscola = " + objectDTO.idEscola.ToString();
query += where;
var result = sqlCommand.ExecuteSQL(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 UpdateData(FrequenciaDTO _item)
{
RepGen <FrequenciaDTO> sqlCommand = new RepGen <FrequenciaDTO>();
string query = "UPDATE TB_Frequencia SET ";
string where = string.Empty;
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("@dtUltAlteracao", DateTime.Now, DbType.DateTime);
param.Add("@idPessoaUltAlteracao", _item.idPessoaUltAlteracao, DbType.Int32);
foreach (var item in param.ParameterNames)
{
query += " " + item + " = @" + item + ",";
}
query = query.Remove(query.Length - 1);
where += " WHERE idFrequencia = " + _item.idTurma.ToString();
query += where;
var result = sqlCommand.ExecuteSQL(query, param);
return(result);
}
public static string GetDateChangePassword()
{
RepGen repGen = new RepGen();
string pass = repGen.ReturnScalar("SELECT password FROM tbl_Passwords WHERE p_type='entry_date_edit'", new Dapper.DynamicParameters());
return(pass);
}
public string InsertUpdate(string DesgCode, string DesgDesc, string AddEditTag)
{
RepGen reposGen = new RepGen();
DynamicParameters param = new DynamicParameters();
param.Add("@DesgCode", DesgCode);
param.Add("@DesgDesc", DesgDesc);
param.Add("@AddEditTag", AddEditTag);
return(reposGen.ExecuteNonQuery_SP("sp_DesignationAddUpdate", param));
}
public int ExcluirMatricula(MatriculaDTO _item)
{
RepGen <MatriculaDTO> sqlCommand = new RepGen <MatriculaDTO>();
string query = "DELETE TB_Matricula Where idMatricula = " + _item.idMatricula;
var param = new DynamicParameters();
var result = sqlCommand.ExecuteSQL(query, param);
return(result);
}
private void BtnSave_Click(object sender, EventArgs e)
{
try
{
int serial_id = ConvertTo.IntVal(txtEmpCode.Tag);
var str = "sp_GatePassData_AddEdit";
RepGen reposGen = new RepGen();
DynamicParameters param = new DynamicParameters();
param.Add("@serial_id", serial_id);
param.Add("@entry_date", ConvertTo.DateFormatDb(DateTime.Now));//Convert.ToDateTime(DateTime.Now).ToString("yyyy-MM-dd")
param.Add("@status_id", txtStatusCode.Text);
param.Add("@employee_code", txtEmpCode.Text);
param.Add("@attendance_date", ConvertTo.DateFormatDb(ConvertTo.DateTimeVal(DtDate.Text)));//Convert.ToDateTime(DtDate.Text).ToString("yyyy-MM-dd")
param.Add("@attendance_out", timeEdit_Time_Out.Text);
param.Add("@attendance_in", timeEdit_Time_In.Text);
param.Add("@output", dbType: DbType.Int32, direction: ParameterDirection.Output);
param.Add("@Returnvalue", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue);
string intResult = reposGen.ExecuteNonQuery_SP(str, param);
if (intResult.Equals("0"))
{
int outputVal = param.Get <int>("@output");
int returnVal = param.Get <int>("@Returnvalue");
PrintLogWin.PrintLog("outputVal => " + outputVal);
PrintLogWin.PrintLog("returnVal => " + returnVal);
txtEmpCode.Tag = outputVal;
ProjectFunctions.SpeakError("Record has been saved");
LoadGatePassDataGrid();
}
else
{
ProjectFunctions.SpeakError("Error in save record.");
PrintLogWin.PrintLog(intResult);
}
//this.Close();
}
catch (Exception ex)
{
ProjectFunctions.SpeakError("Error in save record.");
PrintLogWin.PrintLog(ex);
}
}
public int UpdateData(PessoaDTO objectDTO)
{
RepList <PessoaDTO> listProjeto = new RepList <PessoaDTO>();
RepGen <PessoaDTO> sqlCommand = new RepGen <PessoaDTO>();
string query = "UPDATE TB_Pessoas SET ";
string where = string.Empty;
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("@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 + " = @" + item + ",";
}
query = query.Remove(query.Length - 1);
where += " WHERE idPessoa = " + objectDTO.idPessoa.ToString();
query += where;
var result = sqlCommand.ExecuteSQL(query, param);
return(result);
}
public async Task <string> InsertUpdate(AttendanceModel attendanceModel, string AddEditTag)
{
RepGen reposGen = new RepGen();
DynamicParameters param = new DynamicParameters();
param.Add("@serial_id", attendanceModel.serial_id);
param.Add("@attendance_date", attendanceModel.attendance_date);
param.Add("@employee_code", attendanceModel.employee_code);
//param.Add("@status_id", attendanceModel.status_id);
param.Add("@attendance_in", attendanceModel.attendance_in);
param.Add("@attendance_out", attendanceModel.attendance_out);
//param.Add("@shift_id", attendanceModel.shift_id);
//param.Add("@attendance_source", attendanceModel.attendance_source);
param.Add("@gate_pass_time", attendanceModel.gate_pass_time);
param.Add("@ot_deducton_time", attendanceModel.ot_deducton_time);
param.Add("@AddEditTag", AddEditTag);
return(await reposGen.ExecuteNonQuery_Async("sp_EmployeeAttendance", param));
}
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);
}
public int UpdateData(ProjetoDTO objectDTO)
{
RepList <ProjetoDTO> listProjeto = new RepList <ProjetoDTO>();
RepGen <ProjetoDTO> sqlCommand = new RepGen <ProjetoDTO>();
string query = "UPDATE TB_Projetos SET ";
string where = string.Empty;
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("@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 + " = @" + item + ",";
}
query = query.Remove(query.Length - 1);
where += " WHERE idProjeto = " + objectDTO.idProjeto.ToString();
query += where;
var result = sqlCommand.ExecuteSQL(query, param);
return(result);
}
public int UpdateData(TurmaDTO _turmaDTO)
{
RepList <TurmaDTO> listProjeto = new RepList <TurmaDTO>();
RepGen <TurmaDTO> sqlCommand = new RepGen <TurmaDTO>();
string query = "UPDATE TB_Turmas SET ";
string where = string.Empty;
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("@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 + " = @" + item + ",";
}
query = query.Remove(query.Length - 1);
where += " WHERE idTurma = " + _turmaDTO.idTurma.ToString();
query += where;
var result = sqlCommand.ExecuteSQL(query, param);
return(result);
}
