public SalaDeAulaDto ListarSalaDeAula(int id)
{
List <SalaDeAulaDto> list = new List <SalaDeAulaDto>();
SalaDeAula SalaDeAula; SalaDeAulaDto SalaDeAulaDto = null;
List <SqlParameter> pars = new List <SqlParameter>();
SqlCommand cmd = new SqlCommand("select sda.Id,sda.semestre,sda.disciplinaId,sda.Nota,sda.pessoaId,sda.turmaId,p.Nome from SalaDeAula sda, Pessoa p where p.Id = sda.pessoaId and sda.Id = @Id");
pars.Add(new SqlParameter("id", id));
cmd.Parameters.AddRange(pars.ToArray());
DataSet ds = Conexao.ExecutarDataSet(cmd);
foreach (DataRow item in ds.Tables[0].Rows)
{
SalaDeAula = new SalaDeAula();
SalaDeAula.Id = item.ToInteger("id");
SalaDeAula.Semestre = item.ToString("semestre");
SalaDeAula.Disciplina = new Disciplina();
SalaDeAula.Disciplina.Id = item.ToInteger("disciplinaId");
SalaDeAula.Nota = item.ToDecimalOrNull("Nota");
SalaDeAula.Pessoa = new Pessoa();
SalaDeAula.Pessoa.Id = item.ToInteger("pessoaId");
SalaDeAula.Pessoa.Nome = item.ToString("Nome");
SalaDeAula.Turma = new Turma();
SalaDeAula.Turma.Id = item.ToInteger("turmaId");
SalaDeAulaDto = SalaDeAula.ToDto();
}
return(SalaDeAulaDto);
}
public void SalvarSalaDeAula(SalaDeAulaDto SalaDeAula)
{
//DeletarSalaDeAula(SalaDeAula);
string comando = string.Empty;
List <SqlParameter> pars = new List <SqlParameter>();
if (SalaDeAula.Id > 0)
{
comando = string.Format("update SalaDeAula set Nota = @Nota, PessoaId = @PessoaId, DisciplinaId = @DisciplinaId, Semestre = @Semestre where Id = @Id");
pars.Add(new SqlParameter("Nota", SalaDeAula.Nota));
pars.Add(new SqlParameter("pessoaId", SalaDeAula.PessoaId));
pars.Add(new SqlParameter("disciplinaId", SalaDeAula.DisciplinaId));
pars.Add(new SqlParameter("turmaId", SalaDeAula.TurmaId));
pars.Add(new SqlParameter("semestre", SalaDeAula.Semestre));
pars.Add(new SqlParameter("Id", SalaDeAula.Id));
}
else
{
comando = string.Format("insert into SalaDeAula (Nota,PessoaId,DisciplinaId,Semestre,TurmaId) values (@Nota,@pessoaId,@disciplinaId,@semestre,@turmaId)");
pars.Add(new SqlParameter("Nota", SalaDeAula.Nota));
pars.Add(new SqlParameter("pessoaId", SalaDeAula.PessoaId));
pars.Add(new SqlParameter("disciplinaId", SalaDeAula.DisciplinaId));
pars.Add(new SqlParameter("turmaId", SalaDeAula.TurmaId));
pars.Add(new SqlParameter("semestre", SalaDeAula.Semestre));
}
SqlCommand cmd = new SqlCommand(comando);
cmd.Parameters.AddRange(pars.ToArray());
int retorno = Conexao.ExecuteNonQuery(cmd);
}
public SalaDeAulaDto ToDto()
{
SalaDeAulaDto dto = new SalaDeAulaDto();
dto.Id = this.Id;
dto.Semestre = this.Semestre;
if (this.Pessoa != null)
{
dto.PessoaId = this.Pessoa.Id;
dto.PessoaNome = this.Pessoa.Nome;
}
if (this.Disciplina != null)
{
dto.DisciplinaId = this.Disciplina.Id;
}
if (this.Nota != null)
{
dto.Nota = this.Nota;
}
if (this.Turma != null)
{
dto.TurmaId = this.Turma.Id;
}
return(dto);
}
private void dgSalaDeAula_RowEditEnding(object sender, Microsoft.Windows.Controls.DataGridRowEditEndingEventArgs e)
{
SalaDeAulaDto SalaDeAulaDto = e.Row.DataContext as SalaDeAulaDto;
SalaDeAulaDto.TurmaId = TurmaId;
SalvarSalaDeAula(SalaDeAulaDto);
}
public ProcessamentoDto CargaAlterarSalaDeAula(int tamanho)
{
string comando = string.Empty;
long memoria = 0; long memoriaTotal = 0;
long cpuUso = 0; long cpuUsoTotal = 0;
List <SqlParameter> pars = new List <SqlParameter>();
SalaDeAulaDto SalaDeAula = null;
Stopwatch st = new Stopwatch();
List <SalaDeAulaDto> list = new List <SalaDeAulaDto>();
foreach (var item in ListarSalaDeAulaPorTurma(new TurmaDto()
{
Id = 1
}).Take(tamanho))
{
SalaDeAula = new SalaDeAulaDto();
SalaDeAula.Id = item.Id;
SalaDeAula.TurmaId = item.TurmaId;
SalaDeAula.DisciplinaId = item.DisciplinaId;
SalaDeAula.Nota = item.Nota;
SalaDeAula.Semestre = item.Semestre;
SalaDeAula.PessoaId = item.PessoaId;
list.Add(SalaDeAula);
}
foreach (var item in list)
{
comando = string.Format("update SalaDeAula set Nota = @Nota, PessoaId = @PessoaId, DisciplinaId = @DisciplinaId, Semestre = @Semestre where Id = @Id");
pars = new List <SqlParameter>();
pars.Add(new SqlParameter("TurmaId", item.TurmaId));
pars.Add(new SqlParameter("DisciplinaId", item.DisciplinaId));
pars.Add(new SqlParameter("Nota", item.Nota));
pars.Add(new SqlParameter("Semestre", item.Semestre));
pars.Add(new SqlParameter("PessoaId", item.PessoaId));
pars.Add(new SqlParameter("Id", item.Id));
SqlCommand cmd = new SqlCommand(comando);
cmd.Parameters.AddRange(pars.ToArray());
cpuUso = Process.GetCurrentProcess().TotalProcessorTime.Milliseconds;
memoria = Process.GetCurrentProcess().PrivateMemorySize64;
st.Start();
Conexao.ExecuteNonQuery(cmd);
st.Stop();
memoriaTotal += (Process.GetCurrentProcess().PrivateMemorySize64 - memoria);
cpuUsoTotal += (Process.GetCurrentProcess().TotalProcessorTime.Milliseconds - cpuUso);
}
return(new ProcessamentoDto()
{
Tempo = st.ElapsedMilliseconds, Memoria = memoriaTotal, Cpu = cpuUsoTotal, Tamanho = tamanho
});
}
public void DeletarSalaDeAulaTurma(SalaDeAulaDto salaDeAulaDto)
{
var graphClient = ConexaoGrafo.Client;
graphClient.Cypher.Match("(turma)-[esta:ESTA]->(salaDeAula)")
.Where <SalaDeAulaDto>(salaDeAula => salaDeAula.Id == salaDeAulaDto.Id)
.Delete("esta")
.ExecuteWithoutResults();
graphClient.Dispose();
}
public void DeletarSalaDeAulaDisciplina(SalaDeAulaDto salaDeAulaDto)
{
var graphClient = ConexaoGrafo.Client;
graphClient.Cypher.Match("(disciplina)-[tem:TEM]->(salaDeAula)")
.Where <SalaDeAulaDto>(salaDeAula => salaDeAula.Id == salaDeAulaDto.Id)
.Delete("tem")
.ExecuteWithoutResults();
graphClient.Dispose();
}
public void SalvarSalaDeAulaTurma(SalaDeAulaDto salaDeAulaDto)
{
var graphClient = ConexaoGrafo.Client;
graphClient.Cypher.Match("(turma:Turma)", "(salaDeAula:SalaDeAula)")
.Where <SalaDeAulaDto>(salaDeAula => salaDeAula.Id == salaDeAulaDto.Id)
.AndWhere <TurmaDto>(turma => turma.Id == salaDeAulaDto.TurmaId)
.Create("(turma)-[esta:ESTA]->(salaDeAula)")
.ExecuteWithoutResults();
graphClient.Dispose();
}
public void SalvarSalaDeAulaPessoa(SalaDeAulaDto salaDeAulaDto)
{
var graphClient = ConexaoGrafo.Client;
graphClient.Cypher.Match("(pessoa:Pessoa)", "(salaDeAula:SalaDeAula)")
.Where <SalaDeAulaDto>(salaDeAula => salaDeAula.Id == salaDeAulaDto.Id)
.AndWhere <PessoaDto>(pessoa => pessoa.Id == salaDeAulaDto.PessoaId)
.Create("(pessoa)-[esta:ESTA]->(salaDeAula)")
.ExecuteWithoutResults();
graphClient.Dispose();
}
public void SalvarSalaDeAulaDisciplina(SalaDeAulaDto salaDeAulaDto)
{
var graphClient = ConexaoGrafo.Client;
graphClient.Cypher.Match("(disciplina:Disciplina)", "(salaDeAula:SalaDeAula)")
.Where <SalaDeAulaDto>(salaDeAula => salaDeAula.Id == salaDeAulaDto.Id)
.AndWhere <DisciplinaDto>(disciplina => disciplina.Id == salaDeAulaDto.DisciplinaId)
.Create("(disciplina)-[tem:TEM]->(salaDeAula)")
.ExecuteWithoutResults();
graphClient.Dispose();
}
public SalaDeAulaDto ListarSalaDeAula(int id)
{
var graphClient = ConexaoGrafo.GetConnection();
SalaDeAulaDto salaDeAulaDto = graphClient.Cypher.Match($"(salaDeAula:SalaDeAula)")
.Where <SalaDeAulaDto>(salaDeAula => salaDeAula.Id == id)
.Return(salaDeAula => salaDeAula.As <SalaDeAulaDto>())
.Results
.SingleOrDefault();
graphClient.Dispose();
return(salaDeAulaDto);
}
public ProcessamentoDto CargaInserirSalaDeAula(int tamanho)
{
string comando = string.Empty;
long memoria = 0; long memoriaTotal = 0;
long cpuUso = 0; long cpuUsoTotal = 0;
List <SqlParameter> pars = new List <SqlParameter>();
SalaDeAulaDto SalaDeAula = null;
Stopwatch st = new Stopwatch();
List <SalaDeAulaDto> list = new List <SalaDeAulaDto>();
for (int i = 0; i < tamanho; i++)
{
SalaDeAula = new SalaDeAulaDto();
SalaDeAula.TurmaId = 1;
SalaDeAula.DisciplinaId = i % 2 == 0 ? 1 : 2;
SalaDeAula.Nota = i % 2 == 0 ? 7 : 6;
SalaDeAula.Semestre = "2018.2";
SalaDeAula.PessoaId = i;
list.Add(SalaDeAula);
}
foreach (var item in list)
{
comando = string.Format("insert into SalaDeAula (TurmaId,DisciplinaId,Nota,Semestre,PessoaId) values (@TurmaId,@DisciplinaId,@Nota,@Semestre,@PessoaId)");
pars = new List <SqlParameter>();
pars.Add(new SqlParameter("TurmaId", item.TurmaId));
pars.Add(new SqlParameter("DisciplinaId", item.DisciplinaId));
pars.Add(new SqlParameter("Nota", item.Nota));
pars.Add(new SqlParameter("Semestre", item.Semestre));
pars.Add(new SqlParameter("PessoaId", item.PessoaId));
SqlCommand cmd = new SqlCommand(comando);
cmd.Parameters.AddRange(pars.ToArray());
cpuUso = Process.GetCurrentProcess().TotalProcessorTime.Milliseconds;
memoria = Process.GetCurrentProcess().PrivateMemorySize64;
st.Start();
Conexao.ExecuteNonQuery(cmd);
st.Stop();
memoriaTotal += (Process.GetCurrentProcess().PrivateMemorySize64 - memoria);
cpuUsoTotal += (Process.GetCurrentProcess().TotalProcessorTime.Milliseconds - cpuUso);
}
return(new ProcessamentoDto()
{
Tempo = st.ElapsedMilliseconds, Memoria = memoriaTotal, Cpu = cpuUsoTotal, Tamanho = tamanho
});
}
public void DeletarSalaDeAula(SalaDeAulaDto SalaDeAula)
{
List <SqlParameter> pars = new List <SqlParameter>();
SqlCommand cmd = new SqlCommand(string.Format("delete from SalaDeAula where Id = @Id"));
//pars.Add(new SqlParameter("conceitoId", SalaDeAula.ConceitoId));
//pars.Add(new SqlParameter("pessoaId", SalaDeAula.PessoaId));
//pars.Add(new SqlParameter("disciplinaId", SalaDeAula.DisciplinaId));
//pars.Add(new SqlParameter("semestre", SalaDeAula.Semestre));
//pars.Add(new SqlParameter("turmaId", SalaDeAula.TurmaId));
pars.Add(new SqlParameter("Id", SalaDeAula.Id));
cmd.Parameters.AddRange(pars.ToArray());
int retorno = Conexao.ExecuteNonQuery(cmd);
}
public ProcessamentoDto CargaExcluirSalaDeAula(int tamanho)
{
string comando = string.Empty;
long memoria = 0; long memoriaTotal = 0;
long cpuUso = 0; long cpuUsoTotal = 0;
SalaDeAulaDto SalaDeAula = null;
Stopwatch st = new Stopwatch();
List <SalaDeAulaDto> list = new List <SalaDeAulaDto>();
foreach (var item in ListarSalaDeAulaPorTurma(new TurmaDto()
{
Id = 1
}).Where(x => x.Id > 11).Take(tamanho))
{
SalaDeAula = new SalaDeAulaDto();
SalaDeAula.Id = item.Id;
list.Add(SalaDeAula);
}
foreach (var item in list)
{
DeletarSalaDeAulaDisciplina(item);
DeletarSalaDeAulaPessoa(item);
DeletarSalaDeAulaTurma(item);
var graphClient = ConexaoGrafo.Client;
cpuUso = Process.GetCurrentProcess().TotalProcessorTime.Milliseconds;
memoria = Process.GetCurrentProcess().PrivateMemorySize64;
st.Start();
graphClient.Cypher.Match($"(salaDeAula:SalaDeAula)")
.Where <PessoaDto>(salaDeAula => salaDeAula.Id == item.Id)
.DetachDelete("salaDeAula")
.ExecuteWithoutResults();
st.Stop();
memoriaTotal += (Process.GetCurrentProcess().PrivateMemorySize64 - memoria);
cpuUsoTotal += (Process.GetCurrentProcess().TotalProcessorTime.Milliseconds - cpuUso);
graphClient.Dispose();
}
return(new ProcessamentoDto()
{
Tempo = st.ElapsedMilliseconds, Memoria = memoriaTotal, Cpu = cpuUsoTotal, Tamanho = tamanho
});
}
public void DeletarSalaDeAula(SalaDeAulaDto salaDeAulaDto)
{
DeletarSalaDeAulaDisciplina(salaDeAulaDto);
DeletarSalaDeAulaPessoa(salaDeAulaDto);
DeletarSalaDeAulaTurma(salaDeAulaDto);
var graphClient = ConexaoGrafo.Client;
graphClient.Cypher.Match($"(salaDeAula:SalaDeAula)")
.Where <PessoaDto>(salaDeAula => salaDeAula.Id == salaDeAulaDto.Id)
.DetachDelete("salaDeAula")
.ExecuteWithoutResults();
graphClient.Dispose();
}
public void SalvarSalaDeAula(SalaDeAulaDto salaDeAulaDto)
{
var graphClient = ConexaoGrafo.Client;
if (salaDeAulaDto.Id > 0)
{
graphClient.Cypher.Match("(salaDeAula:SalaDeAula)")
.Where <SalaDeAulaDto>(salaDeAula => salaDeAula.Id == salaDeAulaDto.Id)
.Set("salaDeAula.Nota = {Nota}")
.Set("salaDeAula.PessoaId = {PessoaId}")
.Set("salaDeAula.Semestre = {Semestre}")
.Set("salaDeAula.TurmaId = {TurmaId}")
.Set("salaDeAula.DisciplinaId = {DisciplinaId}")
.WithParam("Nota", salaDeAulaDto.Nota)
.WithParam("PessoaId", salaDeAulaDto.PessoaId)
.WithParam("Semestre", salaDeAulaDto.Semestre)
.WithParam("TurmaId", salaDeAulaDto.TurmaId)
.WithParam("DisciplinaId", salaDeAulaDto.DisciplinaId)
.ExecuteWithoutResults();
}
else
{
salaDeAulaDto.Id = graphClient.Cypher.Match($"(salaDeAula:SalaDeAula)")
.Return(() => Neo4jClient.Cypher.Return.As <int>("MAX(salaDeAula.Id)"))
.Results
.SingleOrDefault() + 1;
graphClient.Cypher.Create("(salaDeAula:SalaDeAula{ Id: {Id}, PessoaId: {PessoaId}, Semestre: {Semestre} , TurmaId: {TurmaId}, DisciplinaId: {DisciplinaId},Nota: {Nota} } )")
.WithParam("PessoaId", salaDeAulaDto.PessoaId)
.WithParam("Semestre", salaDeAulaDto.Semestre)
.WithParam("TurmaId", salaDeAulaDto.TurmaId)
.WithParam("DisciplinaId", salaDeAulaDto.DisciplinaId)
.WithParam("Nota", salaDeAulaDto.Nota)
.WithParam("Id", salaDeAulaDto.Id)
.ExecuteWithoutResults();
}
DeletarSalaDeAulaDisciplina(salaDeAulaDto);
DeletarSalaDeAulaPessoa(salaDeAulaDto);
DeletarSalaDeAulaTurma(salaDeAulaDto);
SalvarSalaDeAulaDisciplina(salaDeAulaDto);
SalvarSalaDeAulaPessoa(salaDeAulaDto);
SalvarSalaDeAulaTurma(salaDeAulaDto);
graphClient.Dispose();
}
private void SalvarSalaDeAula(SalaDeAulaDto SalaDeAulaDto)
{
if (SalaDeAulaDto != null)
{
var confirmaInserir = MessageBox.Show(string.Format("Confirma salvar {0} ?", SalaDeAulaDto.Id), "Confirmação", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (confirmaInserir == MessageBoxResult.Yes)
{
App.Server.SalvarSalaDeAula(SalaDeAulaDto);
MessageBox.Show(string.Format("{0} alterado.", SalaDeAulaDto.Semestre), "Sucesso", MessageBoxButton.OK, MessageBoxImage.Information);
this.CarregarDados();
}
else
{
this.CarregarDados();
}
}
}
public ProcessamentoDto CargaExcluirSalaDeAula(int tamanho)
{
string comando = string.Empty;
long memoria = 0; long memoriaTotal = 0;
long cpuUso = 0; long cpuUsoTotal = 0;
List <SqlParameter> pars = new List <SqlParameter>();
SalaDeAulaDto SalaDeAula = null;
Stopwatch st = new Stopwatch();
List <SalaDeAulaDto> list = new List <SalaDeAulaDto>();
foreach (var item in ListarSalaDeAulaPorTurma(new TurmaDto()
{
Id = 1
}).Where(x => x.Id > 11).Take(tamanho))
{
SalaDeAula = new SalaDeAulaDto();
SalaDeAula.Id = item.Id;
list.Add(SalaDeAula);
}
foreach (var item in list)
{
comando = string.Format("delete from SalaDeAula where Id = @Id");
pars = new List <SqlParameter>();
pars.Add(new SqlParameter("Id", item.Id));
SqlCommand cmd = new SqlCommand(comando);
cmd.Parameters.AddRange(pars.ToArray());
cpuUso = Process.GetCurrentProcess().TotalProcessorTime.Milliseconds;
memoria = Process.GetCurrentProcess().PrivateMemorySize64;
st.Start();
Conexao.ExecuteNonQuery(cmd);
st.Stop();
memoriaTotal += (Process.GetCurrentProcess().PrivateMemorySize64 - memoria);
cpuUsoTotal += (Process.GetCurrentProcess().TotalProcessorTime.Milliseconds - cpuUso);
}
return(new ProcessamentoDto()
{
Tempo = st.ElapsedMilliseconds, Memoria = memoriaTotal, Cpu = cpuUsoTotal, Tamanho = tamanho
});
}
public SalaDeAula FromDto(SalaDeAulaDto dto)
{
SalaDeAula salaDeAula = new SalaDeAula();
salaDeAula.Id = dto.Id;
salaDeAula.Semestre = dto.Semestre;
salaDeAula.Pessoa = new Pessoa()
{
Id = dto.PessoaId
};
salaDeAula.Disciplina = new Disciplina()
{
Id = dto.DisciplinaId
};
salaDeAula.Nota = dto.Nota;
salaDeAula.Turma = new Turma()
{
Id = dto.TurmaId
};
return(salaDeAula);
}
private void dgSalaDeAula_PreviewKeyDown(object sender, System.Windows.Input.KeyEventArgs e)
{
if (e.Key == Key.Delete)
{
var grid = (Microsoft.Windows.Controls.DataGrid)sender;
if (grid.SelectedItems.Count > 0)
{
var result = MessageBox.Show(string.Format("Confirma remover SalaDeAula ?"), "Remover", MessageBoxButton.YesNo, MessageBoxImage.Exclamation);
if (result == MessageBoxResult.Yes)
{
foreach (var row in grid.SelectedItems)
{
SalaDeAulaDto SalaDeAulaDto = row as SalaDeAulaDto;
App.Server.DeletarSalaDeAula(SalaDeAulaDto);
}
MessageBox.Show("SalaDeAula removida.", "Sucesso", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
this.CarregarDados();
}
}
}
}
public ProcessamentoDto CargaInserirSalaDeAula(int tamanho)
{
string comando = string.Empty;
long memoria = 0; long memoriaTotal = 0;
long cpuUso = 0; long cpuUsoTotal = 0;
SalaDeAulaDto salaDeAulaDto = null;
Stopwatch st = new Stopwatch();
List <SalaDeAulaDto> list = new List <SalaDeAulaDto>();
for (int i = 0; i < tamanho; i++)
{
salaDeAulaDto = new SalaDeAulaDto();
salaDeAulaDto.TurmaId = 1;
salaDeAulaDto.DisciplinaId = i % 2 == 0 ? 1 : 2;
salaDeAulaDto.Nota = i % 2 == 0 ? 7 : 6;
salaDeAulaDto.Semestre = "2018.2";
salaDeAulaDto.PessoaId = i;
list.Add(salaDeAulaDto);
}
foreach (var item in list)
{
var graphClient = ConexaoGrafo.Client;
item.Id = graphClient.Cypher.Match($"(salaDeAula:SalaDeAula)")
.Return(() => Neo4jClient.Cypher.Return.As <int>("MAX(salaDeAula.Id)"))
.Results
.SingleOrDefault() + 1;
cpuUso = Process.GetCurrentProcess().TotalProcessorTime.Milliseconds;
memoria = Process.GetCurrentProcess().PrivateMemorySize64;
st.Start();
graphClient.Cypher.Create("(salaDeAula:SalaDeAula{ Id: {Id}, PessoaId: {PessoaId}, Semestre: {Semestre} , TurmaId: {TurmaId}, DisciplinaId: {DisciplinaId},Nota: {Nota} } )")
.WithParam("PessoaId", item.PessoaId)
.WithParam("Semestre", item.Semestre)
.WithParam("TurmaId", item.TurmaId)
.WithParam("DisciplinaId", item.DisciplinaId)
.WithParam("Nota", item.Nota)
.WithParam("Id", item.Id)
.ExecuteWithoutResults();
st.Stop();
memoriaTotal += (Process.GetCurrentProcess().PrivateMemorySize64 - memoria);
cpuUsoTotal += (Process.GetCurrentProcess().TotalProcessorTime.Milliseconds - cpuUso);
DeletarSalaDeAulaDisciplina(item);
DeletarSalaDeAulaPessoa(item);
DeletarSalaDeAulaTurma(item);
SalvarSalaDeAulaDisciplina(item);
SalvarSalaDeAulaPessoa(item);
SalvarSalaDeAulaTurma(item);
graphClient.Dispose();
}
return(new ProcessamentoDto()
{
Tempo = st.ElapsedMilliseconds, Memoria = memoriaTotal, Cpu = cpuUsoTotal, Tamanho = tamanho
});
}
public ProcessamentoDto CargaAlterarSalaDeAula(int tamanho)
{
string comando = string.Empty;
long memoria = 0; long memoriaTotal = 0;
long cpuUso = 0; long cpuUsoTotal = 0;
SalaDeAulaDto SalaDeAula = null;
Stopwatch st = new Stopwatch();
List <SalaDeAulaDto> list = new List <SalaDeAulaDto>();
foreach (var item in ListarSalaDeAulaPorTurma(new TurmaDto()
{
Id = 1
}).Take(tamanho))
{
SalaDeAula = new SalaDeAulaDto();
SalaDeAula.Id = item.Id;
SalaDeAula.TurmaId = item.TurmaId;
SalaDeAula.DisciplinaId = item.DisciplinaId;
SalaDeAula.Nota = item.Nota;
SalaDeAula.Semestre = item.Semestre;
SalaDeAula.PessoaId = item.PessoaId;
list.Add(SalaDeAula);
}
foreach (var item in list)
{
var graphClient = ConexaoGrafo.Client;
cpuUso = Process.GetCurrentProcess().TotalProcessorTime.Milliseconds;
memoria = Process.GetCurrentProcess().PrivateMemorySize64;
st.Start();
graphClient.Cypher.Match("(salaDeAula:SalaDeAula)")
.Where <SalaDeAulaDto>(salaDeAula => salaDeAula.Id == item.Id)
.Set("salaDeAula.Nota = {Nota}")
.Set("salaDeAula.PessoaId = {PessoaId}")
.Set("salaDeAula.Semestre = {Semestre}")
.Set("salaDeAula.TurmaId = {TurmaId}")
.Set("salaDeAula.DisciplinaId = {DisciplinaId}")
.WithParam("Nota", item.Nota)
.WithParam("PessoaId", item.PessoaId)
.WithParam("Semestre", item.Semestre)
.WithParam("TurmaId", item.TurmaId)
.WithParam("DisciplinaId", item.DisciplinaId)
.ExecuteWithoutResults();
st.Stop();
memoriaTotal += (Process.GetCurrentProcess().PrivateMemorySize64 - memoria);
cpuUsoTotal += (Process.GetCurrentProcess().TotalProcessorTime.Milliseconds - cpuUso);
DeletarSalaDeAulaDisciplina(item);
DeletarSalaDeAulaPessoa(item);
DeletarSalaDeAulaTurma(item);
SalvarSalaDeAulaDisciplina(item);
SalvarSalaDeAulaPessoa(item);
SalvarSalaDeAulaTurma(item);
graphClient.Dispose();
}
return(new ProcessamentoDto()
{
Tempo = st.ElapsedMilliseconds, Memoria = memoriaTotal, Cpu = cpuUsoTotal, Tamanho = tamanho
});
}
public void SalvarSalaDeAula(SalaDeAulaDto turma)
{
negocio.SalvarSalaDeAula(turma);
}
public void DeletarSalaDeAula(SalaDeAulaDto turma)
{
negocio.DeletarSalaDeAula(turma);
}