private void Row_DoubleClick(object sender, RoutedEventArgs e) { var o = this.data1.SelectedItem; try { BasesDados bd = (BasesDados)data1.SelectedItem; if (bd.StampBaseDados.Trim() != "") { PainelCentro.id_bd = bd.StampBaseDados; PainelCentro.Escolhe_Painel(8, false); } } catch { } }
public void EditBD() { var o = this.data1.SelectedItem; BasesDados b2 = null; try { b2 = (BasesDados)data1.SelectedItem; PainelCentro.id_bd = b2.StampBaseDados; PainelCentro.Escolhe_Painel(8, false); } catch { System.Windows.Forms.MessageBox.Show("Tem que seleccionar uma base de dados para editar!", "Aviso!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Warning); } }
public bool Delete_BasedeDados(string id) { bool done = false; try { BDKnowLedge bd = new BDKnowLedge(); BasesDados database = bd.BasesDados.Single(u => u.StampBaseDados == id); bd.BasesDados.Remove(database); bd.SaveChanges(); done = true; } catch { done = false; } return(done); }
public void DeleteBD() { var o = this.data1.SelectedItem; BasesDados b2 = null; try { b2 = (BasesDados)data1.SelectedItem; System.Windows.Forms.DialogResult result = System.Windows.Forms.MessageBox.Show("Tem a certeza que pretende eliminar a base de dados? ", "Pergunta!", System.Windows.Forms.MessageBoxButtons.YesNo, System.Windows.Forms.MessageBoxIcon.Question); switch (result) { case System.Windows.Forms.DialogResult.Yes: bool done = database.Delete_BasedeDados(b2.StampBaseDados); string warning = ""; if (done == true) { warning = "A base de dados foi removida com sucesso!"; } else { warning = "Falha ao remover a base de dados!"; } System.Windows.Forms.MessageBox.Show(warning, "Aviso!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Warning); data1.ItemsSource = database.GetBasesDeDados(); break; default: break; } } catch { System.Windows.Forms.MessageBox.Show("Tem que seleccionar uma base de dados para eliminar!", "Aviso!", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Warning); } }
private void Import_Click_1(object sender, RoutedEventArgs e) { string id = basesDados.IDBDByName(combo_BD.SelectedItem.ToString()); BasesDados bd = basesDados.getBDDetails(id); importarDados = new ViewModels.ImportDados(); Classes.DataControl dataControl = new Classes.DataControl(); string pass = dataControl.DecryptStringAES(bd.Password, "BigLevel"); bool conn = importarDados.ConstroiConnString(bd.Servername, bd.Initialcatalog, bd.UserID, pass); if (conn == false) { } else { teste = bd.Initialcatalog; bool done = false; Thread t = new Thread(new ThreadStart(Work)); t.Start(); Thread t2 = new Thread(new ThreadStart(Work2)); t2.Start(); } }
public bool UpdateBasedeDados(string id, List <string> ls) { BDKnowLedge bd = new BDKnowLedge(); bool done = true; BasesDados database = bd.BasesDados.Single(u => u.StampBaseDados == id); Classes.DataControl dataControl = new Classes.DataControl(); DateTime dt = dataControl.GeraDataHora(); int i = 0; try { foreach (string res in ls) { switch (i) { case 0: database.StampBaseDados = database.StampBaseDados; break; case 1: database.StampProjeto = res; break; case 2: database.Servername = res; break; case 3: database.UserID = res; break; case 4: string pass = dataControl.EncryptStringAES(res, "BigLevel"); database.Password = pass; break; case 5: database.Initialcatalog = res; break; case 6: if (res == "1") { database.Encrypt = true; } else { database.Encrypt = false; } break; case 7: if (res == "1") { database.Trustservercertificate = true; } else { database.Trustservercertificate = false; } break; case 8: database.Ousrinis = database.Ousrinis; break; case 9: database.Ousrdata = database.Ousrdata; break; case 10: database.Ousrhora = database.Ousrhora; break; case 11: database.Usrinis = Global.idUser; break; case 12: database.Usrdata = dt; break; case 13: database.Usrhora = dataControl.GeraHora(dt); break; } i++; } bd.SaveChanges(); } catch { done = false; } return(done); }