//запись данных в файл
//запись в базу данных
private void Button_Click(object sender, RoutedEventArgs e)
{
//работа с Excel
//save.XLWb = save.XApp.Workbooks.Open(save.FileName);
//save.Worksheet = save.XLWb.Sheets[1];
//save.NumLastRow = save.Worksheet.Cells[save.Worksheet.Rows.Count, "C"].End[Excel.XlDirection.xlUp].Row;
//save.NumLastRow++;
//save.Worksheet.Cells[save.NumLastRow, "A"] = TBSite.Text;
//save.Worksheet.Cells[save.NumLastRow, "B"] = TBLogin.Text;
//save.Worksheet.Cells[save.NumLastRow, "C"] = PBPass.Password;
//MessageBox.Show("Save data!");
//save.XLWb.Close(true);
// для удаления из базы данных DataBaseWorker.QueryWithoutResponse("DELETE FROM [DBPass] WHERE id=1");
DataBaseWorker.Conection();
string site = TBSite.Text;
string log = TBLogin.Text;
string pas = PBPass.Password;
if (site != "Write Source" && log != "Write Login" && log != "")
{
string sqlExpression = String.Format("INSERT INTO DBPass(LoginSite,Login,Password) VALUES ('{0}', '{1}','{2}')", site, log, pas);
DataBaseWorker.QueryWithoutResponse(sqlExpression);
DataBaseWorker.CloseConection();
TBSite.Text = "Write Source";
TBLogin.Text = "Write Login";
PBPass.Clear();
}
else
{
MessageBox.Show("Specify data to write", "Attantion", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
// открыть найденый адрес в браузере
private void StartBroweser(object sender, RoutedEventArgs e)
{
if (TBSite.Text != "www." && TBSite.Text != null && TBSite.Text != "Write Source")
{
Process.Start(TBSite.Text);
TBSite.Text = "Write Source";
TBLogin.Text = "Write Login";
SearchSite.Text = "What to find?";
PBPass.Clear();
}
else
{
MessageBox.Show("Site address is not specified", "Attantion", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
//очистка TextBox
private void TBSite_GotFocus(object sender, RoutedEventArgs e)
{
TextBox textBox = sender as TextBox;
if (textBox.Text == "Write Source")
{
textBox.Clear();
textBox.Text = "www.";
SearchSite.Text = "What to find?";
}
if (textBox.Text == "Write Login")
{
textBox.Clear();
}
if (textBox.Text == "What to find?")
{
textBox.Clear();
textBox.Text = "www.";
TBSite.Text = "Write Source";
TBLogin.Text = "Write Login";
PBPass.Clear();
}
}
