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