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); }