public Boolean alterarFuncionario(Funcionario objFuncionarioAlterar) { try { if (!temDuplicidade(objFuncionarioAlterar, "Alterar")) { db = ServidorSingleton.obterServidor().OpenClient(); Funcionario objFuncionarioProt = FactoryClasses.criarFuncionario(); objFuncionarioProt.Codigo = objFuncionarioAlterar.Codigo; IObjectSet leitor = db.QueryByExample(objFuncionarioProt); if (leitor.HasNext()) { Funcionario objFuncionario = (Funcionario)leitor.Next(); //Atribui o cargo IObjectSet leitorCargo = db.QueryByExample(objFuncionarioAlterar.Cargo); if (leitorCargo.HasNext()) { Cargo objCargo = (Cargo)leitorCargo.Next(); objFuncionario.Cargo = objCargo; } leitorCargo = null; objFuncionario.DataAdmissao = objFuncionarioAlterar.DataAdmissao; objFuncionario.DataDemissao = objFuncionarioAlterar.DataDemissao; objFuncionario.Email = objFuncionarioAlterar.Email; objFuncionario.Login = objFuncionarioAlterar.Login; objFuncionario.Nome = objFuncionarioAlterar.Nome; objFuncionario.Senha = objFuncionarioAlterar.Senha; objFuncionario.Telefone = objFuncionarioAlterar.Telefone; db.Store(objFuncionario); db.Commit(); leitor = null; return true; } else { leitor = null; return false; } } else { return false; } } catch (Exception ex) { db.Rollback(); throw new Exception("Erro atualizando o funcionario :" + ex.ToString()); } finally { db.Close(); db.Dispose(); } }
public Boolean alterarFilme(clsFilme objAtualizar) { try { db = ServidorSingleton.obterServidor().OpenClient(); clsFilme filmeBuscar = new clsFilme(); filmeBuscar.Codigo = objAtualizar.Codigo; IObjectSet leitor = db.QueryByExample(filmeBuscar); if (leitor.HasNext()) { clsFilme objFilme = (clsFilme)leitor.Next(); objFilme.Ano = objAtualizar.Ano; objFilme.Avaliacao = objAtualizar.Avaliacao; objFilme.TituloBr = objAtualizar.TituloBr; objFilme.TituloOriginal = objAtualizar.TituloOriginal; IObjectSet leitorGenero = db.QueryByExample(objAtualizar.Genero); if (leitorGenero.HasNext()) { objFilme.Genero = (clsGenero)leitorGenero.Next(); } leitorGenero = null; IObjectSet leitorStatus = db.QueryByExample(objAtualizar.Status); if (leitorStatus.HasNext()) { objFilme.Status = (clsStatus)leitorStatus.Next(); } leitorStatus = null; db.Store(objFilme); db.Commit(); return true; } else { return false; } leitor = null; } catch (Exception ex) { db.Rollback(); throw new Exception("Erro atualizando o filme :" + ex.ToString()); } finally { db.Close(); db.Dispose(); } }
public EditAuthorWindow(ref IObjectContainer db, Author author) { InitializeComponent(); _db = db; _author = author; Title += _author.LastName; // fill form LastNameTxtBox.Text = _author.LastName; BirthDatepicker.SelectedDate = _author.BirthDate; var collection = new ObservableCollection<PublicationEditableGrid>(); foreach (var item in _db.QueryByExample(new Publication())) { var itemPub = item as Publication; collection.Add(new PublicationEditableGrid() { Title = itemPub.Title, Year = itemPub.Year, IsAuthor = _author.Publications.Contains(itemPub) }); } publicationsGrid.ItemsSource = collection.OrderBy(x => x.Title); publicationsGrid.SelectedItem = null; }
public Boolean alterarStatus(clsStatus objAtualizar) { try { if (!temDuplicidade(objAtualizar, "Alterar")) { clsStatus objStatusBuscar = new clsStatus(); objStatusBuscar.Codigo = objAtualizar.Codigo; db = ServidorSingleton.obterServidor().OpenClient(); IObjectSet leitor = db.QueryByExample(objStatusBuscar); clsStatus objStatus = (clsStatus)leitor.Next(); objStatus.Descricao = objAtualizar.Descricao; db.Store(objStatus); db.Commit(); db.Close(); db.Dispose(); return true; } else { return false; } } catch (Exception ex) { throw new Exception("Erro atualizando o status :" + ex.ToString()); } }
public static void ClearDatabase(IObjectContainer db) { IObjectSet result = db.QueryByExample(typeof(Pilot)); while (result.HasNext()) { db.Delete(result.Next()); } }
public static void DeleteAll(IObjectContainer db) { IObjectSet result = db.QueryByExample(typeof(Object)); foreach (object item in result) { db.Delete(item); } }
private static void AllObjectsOfAType(IObjectContainer container) { // #example: All objects of a type by passing the type IList result = container.QueryByExample(typeof (Pilot)); // #end example ListResult(result); }
public static void RetrieveAllSnapshots(IObjectContainer db) { IObjectSet result = db.QueryByExample(typeof(SensorReadout)); while (result.HasNext()) { Console.WriteLine(result.Next()); } }
private static void AllObjects(IObjectContainer container) { // #example: All objects IList result = container.QueryByExample(null); // #end example ListResult(result); }
public static void RetrieveCarByPilotQBE(IObjectContainer db) { Pilot pilotproto = new Pilot("Rubens Barrichello", 0); Car carproto = new Car(null); carproto.Pilot = pilotproto; IObjectSet result = db.QueryByExample(carproto); ListResult(result); }
public static void UpdatePilot(IObjectContainer db) { IObjectSet result = db.QueryByExample(new Pilot("Michael Schumacher", 0)); Pilot found = (Pilot)result.Next(); found.AddPoints(11); db.Store(found); Console.WriteLine("Added 11 points for {0}", found); RetrieveAllPilots(db); }
public static void CarSnapshotRollback(IObjectContainer db) { IObjectSet result = db.QueryByExample(new Car("BMW")); Car car = (Car)result.Next(); car.Snapshot(); db.Store(car); db.Rollback(); Console.WriteLine(car); }
public static void RetrieveCarQBE(IObjectContainer db) { SensorReadout protoReadout = new SensorReadout(new double[] { 0.6, 0.2 }, DateTime.MinValue, null); IList protoHistory = new ArrayList(); protoHistory.Add(protoReadout); Car protoCar = new Car(null, protoHistory); IObjectSet result = db.QueryByExample(protoCar); ListResult(result); }
private static void QueryForAge(IObjectContainer container) { // #example: Query for 33 year old pilots Pilot theExample = new Pilot(); theExample.Age = 33; IList result = container.QueryByExample(theExample); // #end example ListResult(result); }
private static void QueryForName(IObjectContainer container) { // #example: Query for John by example Pilot theExample = new Pilot(); theExample.Name = "John"; IList result = container.QueryByExample(theExample); // #end example ListResult(result); }
public static void RetrieveSnapshotsSequentially(IObjectContainer db) { IObjectSet result = db.QueryByExample(typeof (Car)); Car car = (Car) result.Next(); SensorReadout readout = car.History; while (readout != null) { Console.WriteLine(readout); readout = readout.Next; } }
private static void QueryForNameAndAge(IObjectContainer container) { // #example: Query a 29 years old Jo Pilot theExample = new Pilot(); theExample.Name = "Jo"; theExample.Age = 29; IList result = container.QueryByExample(theExample); // #end example ListResult(result); }
public Boolean atualizarSolicitacao(SolicitacaoMateriais objSolicitacao) { SolicitacaoMateriais objSolicitacaoProt = FactoryClasses.criarSolicitacaoMateriais(); objSolicitacaoProt.Codigo = objSolicitacao.Codigo; try { db = ServidorSingleton.obterServidor().OpenClient(); IObjectSet leitor = db.QueryByExample(objSolicitacaoProt); if (leitor.HasNext()) { SolicitacaoMateriais objSolicitacaoCache = (SolicitacaoMateriais)leitor.Next(); objSolicitacaoCache.GestorObra = objSolicitacao.GestorObra; int i = 0; foreach (Materiais material in objSolicitacaoCache.Materiais) { if (material.Codigo == objSolicitacao.Codigo) { Fornecedor objFornecedor = FactoryClasses.criarFornecedor(); objFornecedor.Codigo = objSolicitacao.Materiais[i].Fornecedor.Codigo; material.Fornecedor = objFornecedor; } i++; } objSolicitacaoCache.Materiais = objSolicitacao.Materiais; objSolicitacaoCache.Status = objSolicitacao.Status; objSolicitacaoCache.DataEntrega = objSolicitacao.DataEntrega; objSolicitacaoCache.NumNotaFiscal = objSolicitacao.NumNotaFiscal; objSolicitacaoCache.DataEntrega = objSolicitacao.DataEntrega; objSolicitacaoCache.Msg = objSolicitacao.Msg; db.Store(objSolicitacaoCache); db.Commit(); db.Close(); db.Dispose(); return true; } else { db.Close(); db.Dispose(); return false; } } catch (Exception e) { db.Rollback(); db.Close(); db.Dispose(); throw new Exception("Erro atualizando a solicitação :" + e.Message); } }
private Boolean temDuplicidadeEng(EngenheiroCampo objEng) { bool retorno; db = ServidorSingleton.obterServidor().OpenClient(); IObjectSet leitor = db.QueryByExample(objEng); if (leitor.HasNext()) { retorno = true; } else { retorno = false; } leitor = null; return retorno; }
public Boolean alterarFornecedor(Fornecedor objFornecedorAtualizar) { try { if (!temDuplicidade(objFornecedorAtualizar, "Alterar")) { db = ServidorSingleton.obterServidor().OpenClient(); Fornecedor objFornecedorPrototipo = FactoryClasses.criarFornecedor(); objFornecedorPrototipo.Codigo = objFornecedorAtualizar.Codigo; IObjectSet leitor = db.QueryByExample(objFornecedorPrototipo); if (leitor.HasNext()) { Fornecedor objFornecedor = (Fornecedor)leitor.Next(); objFornecedor.Cidade = objFornecedorAtualizar.Cidade; objFornecedor.Cnpj = objFornecedorAtualizar.Cnpj; objFornecedor.Email = objFornecedorAtualizar.Email; objFornecedor.Endereco = objFornecedorAtualizar.Endereco; objFornecedor.InscrEstadual = objFornecedorAtualizar.InscrEstadual; objFornecedor.RazaoSocial = objFornecedorAtualizar.RazaoSocial; db.Store(objFornecedor); db.Commit(); leitor = null; return true; } else { leitor = null; return false; } } else { return false; } } catch (Exception ex) { db.Rollback(); throw new Exception("Erro atualizando o fornecedor :" + ex.ToString()); } finally { db.Close(); db.Dispose(); } }
public AddAuthorWindow(ref IObjectContainer db) { InitializeComponent(); _db = db; var collection = new ObservableCollection<PublicationEditableGrid>(); foreach (var item in _db.QueryByExample(new Publication())) { var itemPub = item as Publication; collection.Add(new PublicationEditableGrid() { Title = itemPub.Title, Year = itemPub.Year, IsAuthor = false }); } publicationsGrid.ItemsSource = collection.OrderBy(x => x.Title); publicationsGrid.SelectedItem = null; }
public ProxyAuthenticator ReturnProxyAuthenticationInfo() { try { if (Db4oClient.RecentConnFile == null) { Db4oClient.RecentConnFile = Config.OMNConfigDatabasePath(); } _container = Db4oClient.RecentConn; IObjectSet ObjSet = _container.QueryByExample(typeof(ProxyAuthenticator)); return ObjSet.Count > 0 ? (ProxyAuthenticator) ObjSet.Next() : null; } catch (Exception e) { LoggingHelper.HandleException(e); return null; } }
public Boolean alterarCliente(Cliente objClienteAtualizar) { try { if (!temDuplicidade(objClienteAtualizar, "Alterar")) { db = ServidorSingleton.obterServidor().OpenClient(); Cliente objClientePrototipo = FactoryClasses.criarCliente(); objClientePrototipo.Codigo = objClienteAtualizar.Codigo; IObjectSet leitor = db.QueryByExample(objClientePrototipo); if (leitor.HasNext()) { Cliente objCliente = (Cliente)leitor.Next(); objCliente.Cnpj = objClienteAtualizar.Cnpj; objCliente.Nome = objClienteAtualizar.Nome; db.Store(objCliente); db.Commit(); leitor = null; return true; } else { leitor = null; return false; } } else { return false; } } catch (Exception ex) { db.Rollback(); throw new Exception("Erro atualizando o cliente :" + ex.ToString()); } finally { db.Close(); db.Dispose(); } }
public EditPublicationWindow(ref IObjectContainer db, dynamic publication) { InitializeComponent(); TypeCombo.ItemsSource = StaticData.publicationTypes; _db = db; _publication = publication; _isBook = _publication is Book; Title += _publication.Title; // fill form TitleTxtBox.Text = _publication.Title; PublisherTxtBox.Text = _publication.Publisher; YearTxtBox.Text = _publication.Year.ToString(); if (_isBook) { TypeCombo.SelectedIndex = 1; PriceTxtBox.Text = _publication.Price.ToString(); PageFromTxtBox.Text = String.Empty; PageToTxtBox.Text = String.Empty; } else { TypeCombo.SelectedIndex = 0; PriceTxtBox.Text = String.Empty; PageFromTxtBox.Text = _publication.PageFrom.ToString(); PageToTxtBox.Text = _publication.PageTo.ToString(); } TypeCombo.IsEnabled = false; toggleTxtBoxesVisibility(); var collection = new ObservableCollection<AuthorEditableGrid>(); foreach (var item in _db.QueryByExample(new Author())) { var itemAut = item as Author; collection.Add(new AuthorEditableGrid() { LastName = itemAut.LastName, BirthDate = itemAut.BirthDate.ToShortDateString(), IsPublication = _publication.Authors.Contains(itemAut) }); } authorsGrid.ItemsSource = collection.OrderBy(x => x.LastName); authorsGrid.SelectedItem = null; }
public AddPublicationWindow(ref IObjectContainer db) { InitializeComponent(); TypeCombo.ItemsSource = StaticData.publicationTypes; _db = db; var collection = new ObservableCollection<AuthorEditableGrid>(); foreach (var item in _db.QueryByExample(new Author())) { var itemAut = item as Author; collection.Add(new AuthorEditableGrid() { LastName = itemAut.LastName, BirthDate = itemAut.BirthDate.ToShortDateString(), IsPublication = false }); } authorsGrid.ItemsSource = collection.OrderBy(x => x.LastName); authorsGrid.SelectedItem = null; }
static EventHandler<CancellableObjectEventArgs> IncrementIds(IObjectServer server, IObjectContainer container) { // mostly taken from Tuna Toksoz' excellent article at http://tunatoksoz.com/post/Id-Generation-for-db4o.aspx return (sender, args) => { var entity = args.Object as Entity; if (entity != null) { var set = container.QueryByExample(new IncrementTypeValuePair {Type = args.Object.GetType()}); IncrementTypeValuePair pair; if (set.Count == 0) pair = new IncrementTypeValuePair {Type = args.Object.GetType()}; else pair = (IncrementTypeValuePair) set[0]; entity.Id = ++pair.Value; var client = server.OpenClient(); client.Store(pair); client.Commit(); } }; }
public clsFilme listarFilmePorCodigo(clsFilme objFilme) { db = ServidorSingleton.obterServidor().OpenClient(); try { IObjectSet leitor = db.QueryByExample(objFilme); if (leitor.HasNext()) { return (clsFilme)leitor.Next(); } else { return null; } } catch(Exception ex) { throw new Exception("Erro obtendo os dados do filme :" + ex.ToString()); } }
private bool historyAES() { try { ArrayList parts = new ArrayList(); try { banco.Close(); } catch (Exception) { } finally { banco = Db4oFactory.OpenFile(caminhoBanco); } dataGridViewAES.Rows.Clear(); //Usuario new_user = new Usuario(); //new_user.nome = usuario.nome; IObjectSet retorno = banco.QueryByExample(usuario); string msg = ""; bool exists = false; if (retorno.HasNext()) { Usuario tmp = (Usuario)retorno.Next(); if (!String.IsNullOrEmpty(tmp.historicoAES)) { msg = tmp.historicoAES; exists = true; } } if (exists == true) { foreach (string splitado in msg.Split('ק')) { parts.Add(splitado); } for (int i = 0; i < parts.Count; i++) { dataGridViewAES.Rows.Add(parts[i], parts[i + 1], parts[i + 2], parts[i + 3]); i += 3; } parts.Clear(); banco.Close(); return(true); } else { if (contador_entra == 0) { contador_entra++; banco.Close(); return(false); } else { banco.Close(); MessageBox.ShowMessageBoxOK("warning", "Não há atividades registradas no AES!", "Histórico vazio", DarkTheme); return(false); } } } catch (Exception) { return(false); } }
public static void UpdatePhone() { IEmbeddedConfiguration config = Db4oEmbedded.NewConfiguration(); config.Common.ObjectClass(typeof(Person)).CascadeOnUpdate(true); using (IObjectContainer db = Db4oEmbedded.OpenFile(config, @"C:\DBO\ODB.yap")) { string userSurename; Console.WriteLine("\nInsert person surename who phone You want modificate: \n"); userSurename = Console.ReadLine(); string TempPhoneNumber; Console.WriteLine("\nSelect phone witch You want modificate by number: \n"); Console.WriteLine("Number: \n"); TempPhoneNumber = Console.ReadLine(); string forStoreNumber = ""; IObjectSet result = db.QueryByExample(new Person(null, userSurename, new Address(null, null, null), new Phone(null, null, null))); Person found; if (result.HasNext()) { found = (Person)result.Next(); foreach (Phone phones in found.PersonPhones.Where(x => x.Number == TempPhoneNumber)) { Console.Write("Person phone - Number: "); phones.Number = Console.ReadLine().ToString(); forStoreNumber = phones.Number; Console.Write("Person phone - Operator: "); phones.Operator = Console.ReadLine().ToString(); Console.Write("Person phone - Phone type: "); phones.PhoneType = Console.ReadLine().ToString(); } foreach (var item in found.PersonPhones) { Console.WriteLine(item.Number); } db.Activate(found, 100); db.Store(found.PersonPhones.Find(x => x.Number == forStoreNumber)); } else { Console.WriteLine("\nThis peron don't exist in database"); } } }
public virtual void Update(T entidade) { Type tipo = typeof(T); string nomeProprieadeID = getNomePropriedadeID <T>(); string nomeProprieadeGUID = getNomePropriedadeGUID <T>(); IObjectContainer db = Db4oFactory.OpenFile(nomeBanco); try { if (!string.IsNullOrEmpty(nomeProprieadeID)) { var properties = tipo.GetProperties(); PropertyInfo propertyInfo = properties.FirstOrDefault(x => x.Name.Equals(nomeProprieadeID)); var id = (int)propertyInfo.GetValue(entidade, null); var instanceQuery = (T)defineInstanciaID(id, tipo, nomeProprieadeID); //atualizar(entidade, properties, instanceQuery); IObjectSet result = db.QueryByExample(instanceQuery); var found = (T)result.Next(); foreach (var propInfo in properties) { var v = propInfo.GetValue(entidade, null); propInfo.SetValue(found, v, null); } db.Store(found); } else if (!string.IsNullOrEmpty(nomeProprieadeGUID)) { var properties = tipo.GetProperties(); PropertyInfo propertyInfo = properties.FirstOrDefault(x => x.Name.Equals(nomeProprieadeGUID)); var guid = (string)propertyInfo.GetValue(entidade, null); var instanceQuery = (T)defineInstanciaGuid(guid, tipo, nomeProprieadeGUID); IObjectSet result = db.QueryByExample(instanceQuery); var found = (T)result.Next(); foreach (var propInfo in properties) { var v = propInfo.GetValue(entidade, null); propInfo.SetValue(found, v, null); } db.Store(found); } } catch (Exception ex) { db.Rollback(); throw new Exception("Erro ao inserir entidade: " + ex.Message); } finally { db.Close(); } }
private void tbcMenuHistorico_SelectedIndexChanged(object sender, EventArgs e) { if (tbcMenuHistorico.SelectedIndex == 2) { try { banco.Close(); } finally { banco = Db4oFactory.OpenFile(caminhoBanco); } dgvHistoricoRSA.Rows.Clear(); IObjectSet pesquisar = banco.QueryByExample(usuario); if (pesquisar.HasNext()) { Usuario usuarioRSA = (Usuario)pesquisar.Next(); if (String.IsNullOrEmpty(usuarioRSA.historicoRSA)) { MessageBox.ShowMessageBoxOK("warning", "Não há atividades registradas no RSA!", "Histórico vazio", DarkTheme); return; } for (int pos = 0; pos < 4; pos++) { teste[pos] = ""; } for (int i = 0; i < usuarioRSA.historicoRSA.Length; i++) { if (!usuarioRSA.historicoRSA[i].Equals('ק')) { write += usuarioRSA.historicoRSA[i]; } else { for (int index = 0; index < 4; index++) { if (teste[index].Equals("")) { teste[index] = write; write = ""; } } cont = 0; for (int index = 0; index < 4; index++) { if (!teste[index].Equals("")) { cont++; } } if (cont == 4) { dgvHistoricoRSA.Rows.Add(teste); for (int pos = 0; pos < 4; pos++) { teste[pos] = ""; } teste[0] = write; write = ""; } } } banco.Close(); } } if (tbcMenuHistorico.SelectedIndex == 3) { try { banco.Close(); } finally { banco = Db4oFactory.OpenFile(caminhoBanco); } dgvHistoricoEsteganografia.Rows.Clear(); IObjectSet pesquisar = banco.QueryByExample(usuario); if (pesquisar.HasNext()) { Usuario usuarioEsteganografia = (Usuario)pesquisar.Next(); if (String.IsNullOrEmpty(usuarioEsteganografia.historicoEsteganografia)) { banco.Close(); MessageBox.ShowMessageBoxOK("warning", "Não há atividades registradas na Esteganografia!", "Histórico vazio", DarkTheme); return; } for (int pos = 0; pos < 4; pos++) { teste[pos] = ""; } for (int i = 0; i < usuarioEsteganografia.historicoEsteganografia.Length; i++) { if (!usuarioEsteganografia.historicoEsteganografia[i].Equals('ק')) { write += usuarioEsteganografia.historicoEsteganografia[i]; } else { for (int index = 0; index < 4; index++) { if (teste[index].Equals("")) { teste[index] = write; write = ""; } } cont = 0; for (int index = 0; index < 4; index++) { if (!teste[index].Equals("")) { cont++; } } if (cont == 4) { dgvHistoricoEsteganografia.Rows.Add(teste); for (int pos = 0; pos < 4; pos++) { teste[pos] = ""; } teste[0] = write; write = ""; } banco.Close(); } } } } if (tbcMenuHistorico.SelectedIndex == 0) { if (!historyAES()) { return; } } if (tbcMenuHistorico.SelectedIndex == 1) { // AES COM ARQUIVO if (!historyAESArquivo()) { return; } } if (tbcMenuHistorico.SelectedIndex == 4) { try { banco.Close(); } finally { banco = Db4oFactory.OpenFile(caminhoBanco); } dgvCesar.Rows.Clear(); IObjectSet procurar = banco.QueryByExample(usuario); if (procurar.HasNext()) { Usuario usuarioCesar = (Usuario)procurar.Next(); if (String.IsNullOrEmpty(usuarioCesar.historicoCesar)) { banco.Close(); MessageBox.ShowMessageBoxOK("warning", "Não foi salva nenhuma atividade em Cifra de Cesar!!", "Histórico vazio", DarkTheme); return; } for (int pos = 0; pos < 5; pos++) { teste2[pos] = ""; } for (int i = 0; i < usuarioCesar.historicoCesar.Length; i++) { if (!usuarioCesar.historicoCesar[i].Equals('ק')) { write += usuarioCesar.historicoCesar[i]; } else { for (int index = 0; index < 5; index++) { if (teste2[index].Equals("")) { teste2[index] = write; write = ""; } } cont = 0; for (int index = 0; index < 5; index++) { if (!teste2[index].Equals("")) { cont++; } } if (cont == 5) { dgvCesar.Rows.Add(teste2); for (int pos = 0; pos < 5; pos++) { teste2[pos] = ""; } teste2[0] = write; write = ""; } banco.Close(); } } } } if (tbcMenuHistorico.SelectedIndex == 5) { try { banco.Close(); } finally { banco = Db4oFactory.OpenFile(caminhoBanco); } dgvMorse.Rows.Clear(); IObjectSet procurar = banco.QueryByExample(usuario); if (procurar.HasNext()) { Usuario usuarioMorse = (Usuario)procurar.Next(); if (String.IsNullOrEmpty(usuarioMorse.historicoMorse)) { banco.Close(); MessageBox.ShowMessageBoxOK("warning", "Não foi salva nenhuma atividade em Código Morse!!", "Histórico vazio", DarkTheme); return; } for (int pos = 0; pos < 4; pos++) { teste[pos] = ""; } for (int i = 0; i < usuarioMorse.historicoMorse.Length; i++) { if (!usuarioMorse.historicoMorse[i].Equals('ק')) { write += usuarioMorse.historicoMorse[i]; } else { for (int index = 0; index < 4; index++) { if (teste[index].Equals("")) { teste[index] = write; write = ""; } } cont = 0; for (int index = 0; index < 4; index++) { if (!teste[index].Equals("")) { cont++; } } if (cont == 4) { dgvMorse.Rows.Add(teste); for (int pos = 0; pos < 4; pos++) { teste[pos] = ""; } teste[0] = write; write = ""; } banco.Close(); } } } } }
public static void RetrieveAllSensorReadoutsQBEAlternative(IObjectContainer db) { IObjectSet result = db.QueryByExample(typeof(SensorReadout)); ListResult(result); }
private void btnEnviar_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(txtEmail.Text)) { MessageBox.ShowMessageBoxOK("warning", "Insira um endereço de e-mail", "Aviso", DarkTheme); return; } else { if (!cboxEmail.Checked) { Usuario usuario = new Usuario(); usuario.email = txtEmail.Text; IObjectSet pesquisa = banco.QueryByExample(usuario); if (pesquisa.HasNext()) { usuario = (Usuario)pesquisa.Next(); //Gerar senha aleatoria for (int i = 0; i < 5; i++) { novaSenha += Convert.ToChar(gerador.Next(65, 90)); novaSenha += gerador.Next(0, 10).ToString(); } MD5 md5 = MD5.Create(); byte[] hash = md5.ComputeHash(Encoding.UTF8.GetBytes(novaSenha)); StringBuilder stringg = new StringBuilder(); for (int i = 0; i < hash.Length; i++) { stringg.Append(hash[i].ToString("x2")); // hexa } usuario.senha = stringg.ToString(); banco.Store(usuario); informacoes = "Informações da conta" + "\n" + "\nNome : " + usuario.nome + "\nUsuario : " + usuario.usuario + "\n" + "\nAbaixo está sua nova senha, utilize-a para" + "\nfazer login e altere-a no Menu Principal" + "\n" + "\nNova senha : " + novaSenha; } else { MessageBox.ShowMessageBoxOK("warning", "Este e-mail não está cadastrado", "Aviso", DarkTheme); txtEmail.Focus(); return; } } else { if (String.IsNullOrEmpty(txtNome.Text)) { MessageBox.ShowMessageBoxOK("warning", "Você deve digitar um nome!", "Aviso", DarkTheme); txtNome.Focus(); return; } Usuario usuario = new Usuario(); usuario.nome = txtNome.Text; IObjectSet pesquisa = banco.QueryByExample(usuario); if (pesquisa.HasNext()) { usuario = (Usuario)pesquisa.Next(); //Gerar senha aleatoria for (int i = 0; i < 5; i++) { novaSenha += Convert.ToChar(gerador.Next(65, 90)); novaSenha += gerador.Next(0, 10).ToString(); } MD5 md5 = MD5.Create(); byte[] hash = md5.ComputeHash(Encoding.UTF8.GetBytes(novaSenha)); StringBuilder stringg = new StringBuilder(); for (int i = 0; i < hash.Length; i++) { stringg.Append(hash[i].ToString("x2")); // hexa } usuario.senha = stringg.ToString(); banco.Store(usuario); informacoes = "Informações da conta" + "\n" + "\nNome : " + usuario.nome + "\nUsuario : " + usuario.usuario + "\n" + "\nAbaixo está sua nova senha, utilize-a para" + "\nfazer login e altere-a no Menu Principal" + "\n" + "\nNova senha : " + novaSenha; } else { MessageBox.ShowMessageBoxOK("warning", "Este nome não está cadastrado", "Aviso", DarkTheme); return; } } try { MailMessage email = new MailMessage(); email.From = new MailAddress("*****@*****.**"); email.To.Add(new MailAddress(txtEmail.Text)); email.Subject = "iCrypto: Informações da conta e nova senha"; email.Body = informacoes; SmtpClient cliente = new SmtpClient("smtp.live.com", 587); using (cliente) { cliente.Credentials = new System.Net.NetworkCredential("*****@*****.**", "projeto1osemestre2020criptografia"); cliente.EnableSsl = true; cliente.Send(email); } MessageBox.ShowMessageBoxOK("warning", "E-mail enviado com sucesso!", "Aviso", DarkTheme); banco.Close(); this.Close(); } catch (Exception erro) { MessageBox.ShowMessageBoxOK("null", erro.Message, "", DarkTheme); } } }
public static void UpdateAddress() { IEmbeddedConfiguration config = Db4oEmbedded.NewConfiguration(); config.Common.ObjectClass(typeof(Person)).CascadeOnUpdate(true); using (IObjectContainer db = Db4oEmbedded.OpenFile(config, @"C:\DBO\ODB.yap")) { string userSurename; Console.WriteLine("\nInsert person surename who address You want modificate: \n"); userSurename = Console.ReadLine(); string TempAddressCity; string TempAddressStreet; Console.WriteLine("\nSelect address witch You want modificate by city and street: \n"); Console.WriteLine("Street: \n"); TempAddressStreet = Console.ReadLine(); Console.WriteLine("City: \n"); TempAddressCity = Console.ReadLine(); string forStoreStreet = ""; string forStoreCity = ""; IObjectSet result = db.QueryByExample(new Person(null, userSurename, new Address(null, null, null), new Phone(null, null, null))); Person found; if (result.HasNext()) { found = (Person)result.Next(); foreach (Address address in found.PersonAddresses.Where((x => x.City == TempAddressCity)).Where((x => x.Street == TempAddressStreet))) { Console.Write("Person address - Street: "); address.Street = Console.ReadLine().ToString(); forStoreStreet = address.Street; Console.Write("Person address - City: "); address.City = Console.ReadLine().ToString(); forStoreCity = address.City; Console.Write("Person address - Postal code: "); address.PostalCode = Console.ReadLine().ToString(); } foreach (var item in found.PersonAddresses) { Console.WriteLine(item.City); } db.Activate(found, 100); db.Store(found.PersonAddresses.Find(x => (x.City == forStoreCity) && (x.Street == forStoreStreet))); } else { Console.WriteLine("\nThis peron don't exist in database"); } } }
public static void ListAllCars(IObjectContainer db) { IObjectSet result = db.QueryByExample(typeof(Car)); ListResult(result); }
private void btnCadastrar_Click(object sender, EventArgs e) { if (validarCampos() && validarSMTP()) { Usuario usuario = new Usuario(); if (cboxSMTP.Checked) { try { ServidorSMTP smtp = new ServidorSMTP(); smtp.emailSMTP = txtEmailSMTP.Text; smtp.senhaSMTP = txtSenhaSMTP.Text; smtp.servidorSMTP = txtServidor.Text; smtp.portaSMTP = Convert.ToInt32(txtPorta.Text); smtp.SSL = cboxSSL.Checked; usuario.servidorSMTP = smtp; } catch (FormatException) { MessageBox.ShowMessageBoxOK("error", "A porta deve ser um número!", "Formato incorreto", DarkTheme); txtPorta.Focus(); return; } } usuario.nome = txtNome.Text; IObjectSet procurar = banco.QueryByExample(usuario); if (procurar.HasNext()) { usuario = (Usuario)procurar.Next(); if (usuario.nome.Equals(txtNome.Text)) { MessageBox.ShowMessageBoxOK("warning", "Este nome já está sendo utilizado", "Aviso", DarkTheme); txtNome.Focus(); return; } } usuario.email = txtEmail.Text; Usuario u2 = new Usuario(); u2.email = txtEmail.Text; IObjectSet p2 = banco.QueryByExample(u2); if (p2.HasNext()) { Usuario u = (Usuario)p2.Next(); if (u.email.Equals(txtEmail.Text)) { MessageBox.ShowMessageBoxOK("warning", "Este e-mail já está sendo utilizado", "Aviso", DarkTheme); txtEmail.Focus(); return; } } usuario.usuario = txtUsuario.Text; Usuario u3 = new Usuario(); u3.usuario = txtUsuario.Text; IObjectSet p3 = banco.QueryByExample(u3); if (p3.HasNext()) { Usuario u = (Usuario)p3.Next(); if (u.usuario.Equals(txtUsuario.Text)) { MessageBox.ShowMessageBoxOK("warning", "Este usuário já está sendo utilizado", "Aviso", DarkTheme); txtEmail.Focus(); return; } } Usuario u4 = new Usuario(); // hash da senha MD5 md5 = MD5.Create(); byte[] hash = md5.ComputeHash(Encoding.UTF8.GetBytes(txtSenha.Text)); StringBuilder stringg = new StringBuilder(); for (int i = 0; i < hash.Length; i++) { stringg.Append(hash[i].ToString("x2")); // hexa } usuario.senha = stringg.ToString(); u4.senha = txtSenha.Text; banco.Store(usuario); MessageBox.ShowMessageBoxOK("correct", "Cadastro realizado com sucesso!", "", DarkTheme); banco.Close(); this.Close(); } }
public Boolean alterarMaterial(Materiais objMaterialAtualizar) { try { if (!temDuplicidade(objMaterialAtualizar, "Alterar")) { db = ServidorSingleton.obterServidor().OpenClient(); //Carrega o fornecedor IObjectSet leitorFornecedor = db.QueryByExample(objMaterialAtualizar.Fornecedor); if (leitorFornecedor.HasNext()) { objMaterialAtualizar.Fornecedor = (Fornecedor)leitorFornecedor.Next(); } leitorFornecedor = null; //Carrega o comprador IObjectSet leitorComprador = db.QueryByExample(objMaterialAtualizar.Comprador); if (leitorComprador.HasNext()) { objMaterialAtualizar.Comprador = (Comprador)leitorComprador.Next(); } leitorComprador = null; Materiais objMaterialPrototipo = FactoryClasses.criarMateriais(); objMaterialPrototipo.Codigo = objMaterialAtualizar.Codigo; IObjectSet leitor = db.QueryByExample(objMaterialPrototipo); if (leitor.HasNext()) { Materiais objMaterial = (Materiais)leitor.Next(); objMaterial.Unidade = objMaterialAtualizar.Unidade; objMaterial.Comprador = objMaterialAtualizar.Comprador; objMaterial.Descricao = objMaterialAtualizar.Descricao; objMaterial.DescricaoPopular = objMaterialAtualizar.DescricaoPopular; objMaterial.Fornecedor = objMaterialAtualizar.Fornecedor; objMaterial.ValorCompra = objMaterialAtualizar.ValorCompra; objMaterial.ValorVenda = objMaterialAtualizar.ValorVenda; db.Store(objMaterial); db.Commit(); leitor = null; return(true); } else { leitor = null; return(false); } } else { return(false); } } catch (Exception ex) { db.Rollback(); throw new Exception("Erro atualizando o material :" + ex.ToString()); } finally { db.Close(); db.Dispose(); } }
public void SaveModifiedPersonToDatabase() { IObjectContainer db = Db4oFactory.OpenFile("person.data"); var personToModifiy = db.QueryByExample(new PersonModel(SelectedPerson.Name)).Next() as PersonModel; var allPeopleInDatabase = db.QueryByExample(new PersonModel()); List <PersonModel> personHelperList = new List <PersonModel>(); foreach (var person in allPeopleInDatabase) { var p = (PersonModel)person; personHelperList.Add(p); } if (Name == null) { MessageBox.Show("Nie można dodać osoby bez imienia", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error); db.Close(); } else if (Name != SelectedPerson.Name && personHelperList.Any(x => x.Name == Name)) { MessageBox.Show("Osoba z podanym imieniem jest już w bazie", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error); db.Close(); } else { personToModifiy.Name = Name; if (Name != SelectedPerson.Name) { if (personToModifiy.Father != String.Empty && personToModifiy.Father != null) { var father = db.QueryByExample(new PersonModel(personToModifiy.Father)).Next() as PersonModel; var child = father.Children.Where(x => x == SelectedPerson.Name).FirstOrDefault(); var newNameChild = Name; int index = father.Children.IndexOf(child); if (index != -1) { father.Children[index] = newNameChild; } db.Store(father.Children); } if (personToModifiy.Mother != String.Empty && personToModifiy.Mother != null) { var mother = db.QueryByExample(new PersonModel(personToModifiy.Mother)).Next() as PersonModel; var child = mother.Children.Where(x => x == SelectedPerson.Name).FirstOrDefault(); var newNameChild = Name; int index = mother.Children.IndexOf(child); if (index != -1) { mother.Children[index] = newNameChild; } db.Store(mother.Children); } } personToModifiy.BirthDate = BirthDate; if (DeathDate != null) { bool isDeathDatePossible = IsDeathDatePossible(DeathDate.Value, personToModifiy, db); if (isDeathDatePossible == true) { personToModifiy.DeathDate = DeathDate; } else { db.Close(); MessageBox.Show("Nie można ustawić podanej daty śmierci - osoba posiada dzieci urodzone później" , "Błąd", MessageBoxButton.OK, MessageBoxImage.Error); return; } } if (Gender == EGender.brak) { personToModifiy.Gender = null; if (SelectedPerson.Gender == EGender.Male) { var personsChildren = db.QueryByExample(PersonModel.WithFather(Name)); List <PersonModel> children = new List <PersonModel>(); foreach (var child in personsChildren) { children.Add(child as PersonModel); } foreach (var child in children) { child.Father = String.Empty; } foreach (var child in personsChildren) { db.Store(child); } if (personToModifiy.Children != null) { personToModifiy.Children = null; } } else if (SelectedPerson.Gender == EGender.Female) { var personsChildren = db.QueryByExample(PersonModel.WithMother(Name)); List <PersonModel> children = new List <PersonModel>(); foreach (var child in personsChildren) { children.Add(child as PersonModel); } foreach (var child in children) { child.Mother = String.Empty; } foreach (var child in personsChildren) { db.Store(child); } if (personToModifiy.Children != null) { personToModifiy.Children = null; } } } else { personToModifiy.Gender = Gender; if (SelectedPerson.Gender != Gender) { if (personToModifiy.Children != null) { personToModifiy.Children = null; if (Gender == EGender.Male && SelectedPerson.Gender == EGender.Female) { var personsChildren = db.QueryByExample(PersonModel.WithMother(Name)); List <PersonModel> children = new List <PersonModel>(); foreach (var child in personsChildren) { children.Add(child as PersonModel); } foreach (var child in children) { child.Mother = String.Empty; } foreach (var child in personsChildren) { db.Store(child); } } else if (Gender == EGender.Female && SelectedPerson.Gender == EGender.Male) { var personsChildren = db.QueryByExample(PersonModel.WithFather(Name)); List <PersonModel> children = new List <PersonModel>(); foreach (var child in personsChildren) { children.Add(child as PersonModel); } foreach (var child in children) { child.Father = String.Empty; } foreach (var child in personsChildren) { db.Store(child); } } } } } if (Father != null) { if (Father != null && Father.Name == "-brak-") { personToModifiy.Father = String.Empty; var previousFather = db.QueryByExample(new PersonModel(SelectedPerson.Father)).Next() as PersonModel; previousFather.Children.Remove(personToModifiy.Name); if (previousFather.Children.Count == 0) { previousFather.Children = null; } db.Store(previousFather); } else { personToModifiy.Father = Father.Name; var newFather = db.QueryByExample(new PersonModel(Father.Name)).Next() as PersonModel; if (newFather.Children == null) { newFather.Children = new List <string>(); newFather.Children.Add(Name); db.Store(newFather); } else { newFather.Children.Add(Name); db.Store(newFather.Children); } if (SelectedPerson.Father != null && SelectedPerson.Father != String.Empty) { var previousFather = db.QueryByExample(new PersonModel(SelectedPerson.Father)).Next() as PersonModel; previousFather.Children.Remove(personToModifiy.Name); if (previousFather.Children.Count == 0) { previousFather.Children = null; } db.Store(previousFather); } } } else { if (SelectedPerson.Father != String.Empty && SelectedPerson.BirthDate != BirthDate) { MessageBox.Show("Ojciec musi zostać wybrany", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error); db.Close(); return; } } if (Mother != null) { if (Mother.Name == "-brak-") { personToModifiy.Mother = String.Empty; var previousMother = db.QueryByExample(new PersonModel(SelectedPerson.Mother)).Next() as PersonModel; previousMother.Children.Remove(personToModifiy.Name); if (previousMother.Children.Count == 0) { previousMother.Children = null; } db.Store(previousMother); } else { personToModifiy.Mother = Mother.Name; var newMother = db.QueryByExample(new PersonModel(Mother.Name)).Next() as PersonModel; if (newMother.Children == null) { newMother.Children = new List <string>(); newMother.Children.Add(Name); db.Store(newMother); } else { newMother.Children.Add(Name); db.Store(newMother.Children); } if (SelectedPerson.Mother != null && SelectedPerson.Mother != String.Empty) { var previousMother = db.QueryByExample(new PersonModel(SelectedPerson.Mother)).Next() as PersonModel; previousMother.Children.Remove(personToModifiy.Name); if (previousMother.Children.Count == 0) { previousMother.Children = null; } db.Store(previousMother); } } } else { if (SelectedPerson.Mother != String.Empty && SelectedPerson.BirthDate != BirthDate) { MessageBox.Show("Matka musi zostać wybrana", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error); db.Close(); return; } } } db.Store(personToModifiy); db.Close(); NotifyOfPropertyChange(() => AllPeopleInDatabase); Name = null; Father = null; Mother = null; Gender = null; BirthDate = null; DeathDate = null; }
public void AddPersonToDatabase() { if (Name == null) { MessageBox.Show("Nie można dodać osoby bez imienia", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error); } else { IObjectContainer db = Db4oFactory.OpenFile("person.data"); var allPeopleInDatabase = db.QueryByExample(new PersonModel()); List <PersonModel> personHelperList = new List <PersonModel>(); foreach (var person in allPeopleInDatabase) { var p = (PersonModel)person; personHelperList.Add(p); } if (personHelperList.Any(x => x.Name == Name)) { MessageBox.Show("Osoba o podanym imieniu jest już w bazie", "Błąd", MessageBoxButton.OK, MessageBoxImage.Error); db.Close(); Name = null; return; } else { PersonModel newPerson = new PersonModel { Name = Name, BirthDate = BirthDate, DeathDate = DeathDate, }; if (Gender == EGender.brak) { newPerson.Gender = null; } else { newPerson.Gender = Gender; } if (Father != null) { newPerson.Father = Father.Name; } if (Mother != null) { newPerson.Mother = Mother.Name; } if (newPerson.Father != null) { var newPersonFather = (PersonModel)db.QueryByExample(new PersonModel(newPerson.Father)).Next(); if (newPersonFather.Children == null) { newPersonFather.Children = new List <string>(); newPersonFather.Children.Add(newPerson.Name); db.Store(newPersonFather); } else { newPersonFather.Children.Add(newPerson.Name); db.Store(newPersonFather.Children); } } if (newPerson.Mother != null) { var newPersonMother = (PersonModel)db.QueryByExample(new PersonModel(newPerson.Mother)).Next(); if (newPersonMother.Children == null) { newPersonMother.Children = new List <string>(); newPersonMother.Children.Add(newPerson.Name); db.Store(newPersonMother); } else { newPersonMother.Children.Add(newPerson.Name); db.Store(newPersonMother.Children); } } db.Store(newPerson); db.Close(); Name = null; Father = null; Mother = null; BirthDate = null; DeathDate = null; Gender = null; NotifyOfPropertyChange(nameof(PossibleFathers)); NotifyOfPropertyChange(nameof(PossibleMothers)); } } }
public static void RetrieveAll(IObjectContainer db) { IObjectSet result = db.QueryByExample(new Employee(0, null, null, 0, null, null)); ListResult(result); }
protected void AssertAliasedData(IObjectContainer container) { AssertAliasedData(container.QueryByExample(GetAliasedDataType())); AssertAliasedData(QueryAliasedData(container)); }
public static void RetrieveAllCompany(IObjectContainer db) { IObjectSet result = db.QueryByExample(typeof(Company)); ListResult(result); }
public static void ModifyPhone(IObjectContainer db) { Console.WriteLine("Podaj osobę, której chcesz zmodyfikować telefon:"); Console.WriteLine(); Console.Write("Imię:\t\t"); string firstName = Console.ReadLine(); Console.Write("Nazwisko:\t"); string lastName = Console.ReadLine(); try { Person ex = new Person(firstName, lastName); IObjectSet result = db.QueryByExample(ex); Person found = (Person)result.Next(); if (found.Phones == null) { Console.WriteLine(); Console.WriteLine("Brak telefonów w bazie."); return; } else { Console.WriteLine("Telefony:\t"); foreach (var phone in found.Phones) { Console.WriteLine($"\t\t{phone}"); } } Console.WriteLine(); Console.WriteLine("Podaj numer telefonu do zmiany:"); Console.WriteLine(); var phoneNumber = Console.ReadLine(); int selectedPhone = found.Phones.FindIndex(x => x.Number == phoneNumber); if (found.Phones[selectedPhone].Number != phoneNumber) { Console.WriteLine("Taki numer nie istnieje. Nie można kontynuować."); return; } Console.WriteLine(); Console.WriteLine("Podaj nowy telefon:"); Console.WriteLine(); Console.Write("Numer\t\t"); found.Phones[selectedPhone].Number = Console.ReadLine(); Console.Write("Operator\t"); found.Phones[selectedPhone].Type = Console.ReadLine(); Console.Write("Typ\t\t"); found.Phones[selectedPhone].OperatorName = Console.ReadLine(); db.Store(found); Console.WriteLine("Pomyślnie zmieniono telefon!"); } catch (Exception e) { Console.WriteLine(); Console.WriteLine("Taki obiekt nie istnieje. Nie można kontynuować."); } }
public static void RetrieveAllEmployee(IObjectContainer db) { IObjectSet result = db.QueryByExample(typeof(Employee)); ListResult(result); }
public static void RetrieveAllObjects(IObjectContainer db) { IObjectSet result = db.QueryByExample(new object()); ListResult(result); }
public void DeletePerson() { if (SelectedPerson == null) { MessageBox.Show("Nie wybrano osoby", "Informacja", MessageBoxButton.OK, MessageBoxImage.Information); return; } else { var result = MessageBox.Show("Czy chcesz usunąć wybraną osobę?", "Pytanie", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { IObjectContainer db = Db4oFactory.OpenFile("person.data"); var personToRemove = db.QueryByExample(new PersonModel(SelectedPerson.Name)).Next(); var personToRemoveAsPersonModel = personToRemove as PersonModel; if (personToRemoveAsPersonModel.Children != null) { if (personToRemoveAsPersonModel.Gender == EGender.Male) { var personsChildren = db.QueryByExample(PersonModel.WithFather(personToRemoveAsPersonModel.Name)); var childrenAsPersonModel = new List <PersonModel>(); foreach (var child in personsChildren) { childrenAsPersonModel.Add(child as PersonModel); } foreach (var child in childrenAsPersonModel) { child.Father = null; db.Store(child); } personToRemoveAsPersonModel.Children = null; } else { var personsChildren = db.QueryByExample(PersonModel.WithMother(personToRemoveAsPersonModel.Name)); var childrenAsPersonModel = new List <PersonModel>(); foreach (var child in personsChildren) { childrenAsPersonModel.Add(child as PersonModel); } foreach (var child in childrenAsPersonModel) { child.Mother = null; db.Store(child); } personToRemoveAsPersonModel.Children = null; } } if (personToRemoveAsPersonModel.Father != null && personToRemoveAsPersonModel.Father != String.Empty) { var personsFather = db.QueryByExample(new PersonModel(personToRemoveAsPersonModel.Father)).Next(); var personsFatherAsPersonModel = personsFather as PersonModel; personsFatherAsPersonModel.Children.Remove(personToRemoveAsPersonModel.Name); if (personsFatherAsPersonModel.Children.Count == 0) { personsFatherAsPersonModel.Children = null; } db.Store(personsFatherAsPersonModel); } if (personToRemoveAsPersonModel.Mother != null && personToRemoveAsPersonModel.Mother != String.Empty) { var personsMother = db.QueryByExample(new PersonModel(personToRemoveAsPersonModel.Mother)).Next(); var personsMotherAsPersonModel = personsMother as PersonModel; personsMotherAsPersonModel.Children.Remove(personToRemoveAsPersonModel.Name); if (personsMotherAsPersonModel.Children.Count == 0) { personsMotherAsPersonModel.Children = null; } db.Store(personsMotherAsPersonModel); } db.Delete(personToRemove); db.Commit(); db.Close(); NotifyOfPropertyChange(() => AllPeopleInDatabase); } else if (result == MessageBoxResult.No) { return; } } }
//Display all computer (contain status) public static void DisplayAllComputers(IObjectContainer db) { IObjectSet result = db.QueryByExample(typeof(Computer)); UserManagement.ListResult(result); }
public static void RetrieveCollections(IObjectContainer db) { var result = db.QueryByExample(new ArrayList()); ListResult(result); }
private void Init() { nameBox.Text = _user.Name; birthDayBox.Text = _user.BirthDay; surnameBox.Text = _user.Surname; phoneBox.Text = _user.Phone; cityComboBox.SelectedIndex = cityComboBox.FindStringExact(_user.City); addressBox.Text = _user.Addres; if (_user.Gender == "Male") { maleButton.Select(); } else { femaleButton.Select(); } IEnumerable <Project> projects = from Project p in _db select p; _lastProjectId = projects.Any() ? projects.Last().Id : 0; IEnumerable <Task> tasks = from Task t in _db select t; _lastTaskId = tasks.Any() ? tasks.Last().Id : 0; UpdateProjectsGrid(); IObjectSet result = _db.QueryByExample(new Person()); employees.DataSource = result; showTaskEmployeesList.Items.Add("All"); employeesComboBox.Items.Add("All"); //showTasksProjectList.Items.Add("All"); foreach (Person person in result) { employeeList.Items.Add(person); if (!person.IsAdmin) { employeesComboBox.Items.Add(person); newTaskAssignEmp.Items.Add(person); showTaskEmployeesList.Items.Add(person); normalUsersList.Items.Add(person); } else { adminsList.Items.Add(person); } } for (int i = 2016; i > 1950; i--) { yearsComboBox.Items.Add(i); } if (employeesComboBox.Items.Count > 0) { employeesComboBox.SelectedIndex = 0; } UpdateShowTasksView(); UpdateAnalyzeView(); }
public static void RetrieveArrays(IObjectContainer db) { IObjectSet result = db.QueryByExample((Array) new double[] { 0.6, 0.4 }); ListResult(result); }
private void RemoveLinhaUnica(DataGridView datagrid, DataGridViewCellEventArgs e) { // argumentos: Datagrid a ser manipulado e Eventos da célula (retirada do evento cell content click) try { string msg = ""; /* * if (tbcMenuHistorico.SelectedIndex != 2) * { * for (int i = 0; i < 4; i++) //4 colunas p/datagrid * { * if (i == 3) * { * msg += datagrid.Rows[e.RowIndex].Cells[i].Value.ToString(); * continue; * } * msg += datagrid.Rows[e.RowIndex].Cells[i].Value.ToString() + delimitadorInicial; * } * msg += delimitadorFinal; * } */ ///Aqui foi o que deu certo no histórico do RSA, só adaptar pra outras cifras ///Não sei qual delimitador utilizaram, mas acho melhor usar um só, o malakoi do hebraico lá for (int i = 0; i < 4; i++) //4 colunas p/datagrid { msg += datagrid.Rows[e.RowIndex].Cells[i].Value.ToString() + delimitadorFinal; } //busca no banco string msgBanco = ""; banco.Close(); banco = Db4oFactory.OpenFile(caminhoBanco); IObjectSet resultado = banco.QueryByExample(usuario); string actualTab = tbcMenuHistorico.SelectedTab.Text; switch (actualTab) { case "AES": if (resultado.HasNext()) { Usuario tmp = (Usuario)resultado.Next(); msgBanco = tmp.historicoAES; msgBanco = msgBanco.Replace(msg, ""); tmp.historicoAES = msgBanco; banco.Store(tmp); } break; case "AES Arquivos": if (resultado.HasNext()) { Usuario tmp = (Usuario)resultado.Next(); msgBanco = tmp.historicoAESArquivo; msgBanco = msgBanco.Replace(msg, ""); tmp.historicoAESArquivo = msgBanco; banco.Store(tmp); } break; case "RSA": if (resultado.HasNext()) { Usuario tmp = (Usuario)resultado.Next(); msgBanco = tmp.historicoRSA; msgBanco = msgBanco.Replace(msg, ""); tmp.historicoRSA = msgBanco; banco.Store(tmp); } break; case "Esteganografia": if (resultado.HasNext()) { Usuario tmp = (Usuario)resultado.Next(); msgBanco = tmp.historicoEsteganografia; msgBanco = msgBanco.Replace(msg, ""); tmp.historicoEsteganografia = msgBanco; banco.Store(tmp); } break; case "Código Morse": if (resultado.HasNext()) { Usuario tmp = (Usuario)resultado.Next(); msgBanco = tmp.historicoMorse; msgBanco = msgBanco.Replace(msg, ""); tmp.historicoMorse = msgBanco; banco.Store(tmp); } break; case "Cifra de Cesar": if (resultado.HasNext()) { msg = ""; for (int i = 0; i < 5; i++) { msg += datagrid.Rows[e.RowIndex].Cells[i].Value.ToString() + delimitadorFinal; } Usuario tmp = (Usuario)resultado.Next(); msgBanco = tmp.historicoCesar; msgBanco = msgBanco.Replace(msg, ""); tmp.historicoCesar = msgBanco; banco.Store(tmp); } break; default: break; } banco.Close(); } catch (Exception) { return; } }
public void cadastrarPedido(SolicitacaoMateriais objSolicitacao) { //Atualiza a solicitação no db SolicitacaoMateriaisDAO objSolicitacaoDAO = FactoryDAO.criarSolicitacaoMateriaisDAO(); if (objSolicitacaoDAO.atualizarSolicitacao(objSolicitacao)) { SolicitacaoMateriais objSolicitacaoProt = FactoryClasses.criarSolicitacaoMateriais(); objSolicitacaoProt.Codigo = objSolicitacao.Codigo; db = ServidorSingleton.obterServidor().OpenClient(); IObjectSet leitor = db.QueryByExample(objSolicitacaoProt); if (leitor.HasNext()) { objSolicitacaoProt = null; objSolicitacaoProt = (SolicitacaoMateriais)leitor.Next(); } leitor = null; Collection <Pedido> objPedidoColecao = new Collection <Pedido>(); foreach (Materiais material in objSolicitacaoProt.Materiais) { Pedido objPedido = FactoryClasses.criarPedido(); objPedido.SolicitacaoMateriais = objSolicitacaoProt; Collection <Materiais> objMateriaisColecao = new Collection <Materiais>(); objMateriaisColecao.Add(material); objPedido.Materiais = objMateriaisColecao; objPedido.Codigo = obtemNovoId(); db = ServidorSingleton.obterServidor().OpenClient(); db.Store(objPedido); db.Commit(); } //Le os pedidos Pedido objPedidoProt = FactoryClasses.criarPedido(); objPedidoProt.SolicitacaoMateriais = objSolicitacaoProt; db = ServidorSingleton.obterServidor().OpenClient(); IObjectSet leitorPedidoCache = db.QueryByExample(objPedidoProt); int codFornecedor = 0; int contador = 0; int codPedido = 0; while (leitorPedidoCache.HasNext()) { Pedido objPedidoLer = (Pedido)leitorPedidoCache.Next(); if (contador == 0) { codFornecedor = objPedidoLer.Materiais[0].Fornecedor.Codigo; } else { if (codFornecedor == objPedidoLer.Materiais[0].Fornecedor.Codigo) { //Retira os itens deste pedido e coloca no anterior Collection <Materiais> objMateriaisColecaoTmp = new Collection <Materiais>(); foreach (Materiais item in objPedidoLer.Materiais) { objMateriaisColecaoTmp.Add(item); } //exclui o pedido atual db.Delete(objPedidoLer); //Carrega o anterior em cache Pedido p = FactoryClasses.criarPedido(); p.Codigo = codPedido; IObjectSet leitorPedido2 = db.QueryByExample(p); if (leitorPedido2.HasNext()) { p = null; p = (Pedido)leitorPedido2.Next(); //Atualiza o pedido anterior com os dados do pedido que foi apagado foreach (Materiais item in p.Materiais) { objMateriaisColecaoTmp.Add(item); } p.Materiais = objMateriaisColecaoTmp; db.Store(p); db.Commit(); } leitorPedido2 = null; } } codFornecedor = objPedidoLer.Materiais[0].Fornecedor.Codigo; codPedido = objPedidoLer.Codigo; contador++; } leitorPedidoCache = null; db.Close(); db.Dispose(); } }
public IObjectSet QueryByExample(object template) { return(session.QueryByExample(template)); }
private void btnEsteganografar_Click(object sender, EventArgs e) { if (validarCampos() && validarNomeArquivo()) { nome = txtNomeArquivo.Text; if (nome.Contains(" ")) { nome = nome.Replace(' ', '_'); } try { if (File.Exists(@"C:\iCrypto\Zipado.rar")) { File.Delete(@"C:\iCrypto\Zipado.rar"); } if (!Directory.Exists(@"C:\iCrypto\Esteganografia")) { Directory.CreateDirectory(@"C:\iCrypto\Esteganografia"); } else { Directory.Delete(@"C:\iCrypto\Esteganografia", true); Directory.CreateDirectory(@"C:\iCrypto\Esteganografia"); } File.Copy(txtFileHide.Text, @"C:\iCrypto\Esteganografia\ArquivoEsteganografado" + extensaoHide, true); ZipFile.CreateFromDirectory(@"C:\iCrypto\Esteganografia", @"C:\iCrypto\Zipado.rar"); gerado = '"' + txtSalvarArquivo.Text + @"\" + '"' + nome + extensao + '"'; ProcessStartInfo infos = new ProcessStartInfo(); infos.FileName = "cmd.exe"; infos.UseShellExecute = true; infos.CreateNoWindow = true; infos.WindowStyle = ProcessWindowStyle.Hidden; infos.Arguments = "/C copy /b " + '"' + txtArquivoOriginal.Text + '"' + "+" + '"' + @"C:\iCrypto\Zipado.rar" + '"' + " " + gerado; Process processo = new Process(); processo.StartInfo = infos; processo.Start(); gerado = txtSalvarArquivo.Text + @"\" + "" + nome + "" + extensao; mensagem = "Foi criado um novo arquivo esteganografado no seguinte diretório:" + "\n" + "\n" + gerado; MessageBox.ShowMessageBoxOK("correct", mensagem, "Processo concluído!", DarkTheme); timerAntiBug.Start(); FileInfo novoArquivo = new FileInfo(gerado); txtDiretorioFinal.Text = gerado; arquivo[0] = novoArquivo.Name; nomeArqFinal = novoArquivo.Name; arquivo[1] = novoArquivo.Length.ToString() + " bytes"; arquivo[2] = novoArquivo.Extension; dgvArquivoFinal.Rows.Clear(); if (cboxAnexar.Checked) { fileAnexo[0] = arquivo[0]; fileAnexo[1] = arquivo[1]; fileAnexo[2] = arquivo[2]; fileAnexo[3] = gerado; dgvAnexos.Rows.Add(fileAnexo); anexos.Add(gerado); } dgvArquivoFinal.Rows.Insert(0, arquivo); Usuario usuarioPesquisa = new Usuario(); usuarioPesquisa.nome = usuario.nome; IObjectSet pesquisarUsuario = banco.QueryByExample(usuarioPesquisa); if (pesquisarUsuario.HasNext()) { usuario = (Usuario)pesquisarUsuario.Next(); if (String.IsNullOrEmpty(usuario.historicoEsteganografia)) { usuario.historicoEsteganografia = nomeArqOriginal + "ק" + nomeArqOculto + "ק" + nomeArqFinal + "ק" + DateTime.Now.ToString("dd /MM/yyyy") + "ק"; } else { usuario.historicoEsteganografia += nomeArqOriginal + "ק" + nomeArqOculto + "ק" + nomeArqFinal + "ק" + DateTime.Now.ToString("dd /MM/yyyy") + "ק"; } banco.Store(usuario); } File.Delete(@"C:\iCrypto\Zipado.rar"); Directory.Delete(@"C:\iCrypto\Esteganografia", true); } catch (Exception erro) { MessageBox.ShowMessageBoxOK("error", erro.Message, "Ocorreu um erro inesperado", DarkTheme); } } }
public Boolean excluirFilme(clsFilme objFilme) { db = ServidorSingleton.obterServidor().OpenClient(); try { IObjectSet leitor = db.QueryByExample(objFilme); if (leitor.HasNext()) { db.Delete((clsFilme)leitor.Next()); db.Commit(); return true; } else { return false; } } catch { db.Rollback(); return false; } finally { db.Close(); db.Dispose(); } }
public static void UpdatePilotSeparateSessionsImprovedPart2(IObjectContainer db) { IObjectSet result = db.QueryByExample(new Car("Ferrari")); ListResult(result); }
public Boolean temStatusEmFilme(clsStatus objStatus) { bool temfilme; try { db = ServidorSingleton.obterServidor().OpenClient(); clsFilme objFilme = new clsFilme(); objFilme.Status = objStatus; IObjectSet leitor = db.QueryByExample(objFilme); if (leitor.HasNext()) { temfilme = true; } else { temfilme = false; } leitor = null; } catch (Exception ex) { throw new Exception("Erro verificando possibilidade de exclusão do status:" + ex.ToString()); } finally { db.Close(); db.Dispose(); } return temfilme; }
public static void RetrieveAllPilots(IObjectContainer db) { IObjectSet result = db.QueryByExample(typeof(Pilot)); ListResult(result); }
public void cadastrarFilme(clsFilme objFilme) { objFilme.Codigo = obtemNovoId(); db = ServidorSingleton.obterServidor().OpenClient(); try { //Coloca o genero em cache para não ser inserido novamente IObjectSet leitorGenero = db.QueryByExample(objFilme.Genero); if (leitorGenero.HasNext()) { objFilme.Genero = (clsGenero)leitorGenero.Next(); } leitorGenero = null; //Coloca o status em cache para não ser inserido novamente IObjectSet leitorStatus = db.QueryByExample(objFilme.Status); if (leitorStatus.HasNext()) { objFilme.Status = (clsStatus)leitorStatus.Next(); } leitorStatus = null; //Grava o filme db.Store(objFilme); db.Commit(); } catch (Exception) { db.Rollback(); throw new Exception("Erro cadastrando o filme :" + ex.ToString()); } finally { db.Close(); db.Dispose(); } }
static void Main(string[] args) { //UpisiNoveUBazu(); #region Jednostavni upiti #region QBE Console.WriteLine("Obavljam QBE za pilote"); IObjectSet rezultatQBE = dataBase.QueryByExample(typeof(Pilot)); ListResult(rezultatQBE); Console.WriteLine(); #endregion #region NQ Console.WriteLine("Dohvacam po imenu"); string ime = Console.ReadLine(); //Dohvacanje svih pilota koji imaju ime ucitano iz konzole IList<Pilot> rezultatNQ = dataBase.Query<Pilot>(delegate(Pilot pilot) { return pilot.Ime == ime; }); foreach (Pilot p in rezultatNQ) { Console.WriteLine("{0} {1} {2} {3} {4}", p.Ime, p.Prezime, p.Sifra, p.Momcad.Naziv, p.Vrsta); } Console.WriteLine(); #endregion #region SODA Console.WriteLine("SODA upit"); string prviSodaString = Console.ReadLine(); string drugiSodaStrnig = Console.ReadLine(); IQuery query = dataBase.Query(); query.Constrain(typeof(Pilot)); query.Descend("_ime").Constrain(prviSodaString).Or(query.Descend("_ime").Constrain(drugiSodaStrnig)); IObjectSet rezultatSodaUpita = query.Execute(); ListResult(rezultatSodaUpita); Console.WriteLine(); #endregion #region LINQ Console.WriteLine("LINQ upit"); string linqString = Console.ReadLine(); IEnumerable<Pilot> rezultatLINQUpita = from Pilot p in dataBase where p.Ime == linqString select p; ListResult(rezultatLINQUpita Console.WriteLine(); #endregion #endregion #region (malo)Slozeniji upiti #region QBE //Dohvacamo pilota preko drzave Drzava drzavaSlozenijiQBE = new Drzava(); drzavaSlozenijiQBE.Naziv = "Hrvatska"; Pilot pilotSlozenijiQBE = new Pilot(); pilotSlozenijiQBE.Drzava = drzavaSlozenijiQBE; Console.WriteLine("Slozeniji QBE\nTrazimo sve vozace iz Hrvatske\n"); IObjectSet rezultatSlozenijegQBE = dataBase.QueryByExample(pilotSlozenijiQBE); ListResult(rezultatSlozenijegQBE); Console.WriteLine(); #endregion #region NQ Drzava drzavaSlozenijiNQ = new Drzava(); drzavaSlozenijiQBE.Naziv = "Hrvatska"; //Pilot pilotSlozenijiNQ = new Pilot(); //pilotSlozenijiNQ.Drzava = drzavaSlozenijiNQ; IList<Drzava> rezultatDrzavaSlozenijiNQ = dataBase.Query<Drzava>(delegate(Drzava drzava) { return drzava.Naziv == "Hrvatska"; }); //ako postoji drzava imena Hrvatska onda trazi pilote iz te drzave if(rezultatDrzavaSlozenijiNQ.Count > 0) { Console.WriteLine("Slozeniji NQ\nTrazimo vozace iz Hrvatske\n"); IList<Pilot> rezultatSlozenijegNQ = dataBase.Query<Pilot>(delegate(Pilot pilot) { return pilot.Drzava.Naziv == rezultatDrzavaSlozenijiNQ[0].Naziv; }); ListResult(rezultatSlozenijegNQ); Console.WriteLine(); } #endregion #region SODA //Definiramo upit za dohvacanje drzave //Ovo je vec malo teze kemijanje. Ovakvo nesto nece sigurno biti ;) //Isto se radi i u LINQ upitima. //Buduci da ne znam kako se preko samog naziva drzave dokopati pilota isao sam za svaku //pronadenu drzavu traziti onaj element koji ju sadrzi IQuery slozenijiSODAUpitDrzava = dataBase.Query(); slozenijiSODAUpitDrzava.Constrain(typeof(Drzava)); slozenijiSODAUpitDrzava.Descend("_naziv").Constrain("Hrvatska"); IObjectSet rezultatDrzavaSlozenijiSODA = slozenijiSODAUpitDrzava.Execute(); //Ako smo pronasli drzavu dohvacamo pilote iz te drzave if (rezultatDrzavaSlozenijiSODA.Count > 0) { Console.WriteLine("Slozeniji SODA\nTrazimo vozace iz Hrvatske \n"); for (int i = 0; i < rezultatDrzavaSlozenijiSODA.Count; i++) { IQuery slozenijiSODAUpitPilot = dataBase.Query(); slozenijiSODAUpitPilot.Constrain(typeof(Pilot)); slozenijiSODAUpitPilot.Descend("_drzava").Constrain(rezultatDrzavaSlozenijiSODA[i]); IObjectSet rezultatPilotSlozenijiSODA = slozenijiSODAUpitPilot.Execute(); ListResult(rezultatPilotSlozenijiSODA); } } #endregion #region LINQ Console.WriteLine("LINQ upit"); IEnumerable<Drzava> rezultatDrzavaSlozenijeLINQ = from Drzava d in dataBase where d.Naziv == "Hrvatska" select d; foreach (Drzava drzavaUSlozenijemLINQ in rezultatDrzavaSlozenijeLINQ) { IEnumerable<Pilot> rezultatLINQUpita = from Pilot p in dataBase where p.Drzava == drzavaUSlozenijemLINQ select p; ListResult(rezultatLINQUpita); } Console.WriteLine(); #endregion #endregion }