private void btnUpdate_Click(object sender, RoutedEventArgs e) { try { bool Checkerle = false; if (chkDongle.IsChecked.Value == true) { Checkerle = true; } con = new SqlDbConnect(); con.SqlQuery("UPDATE Licenses SET License='" + txtLicense.Text + "', Software='" + cmbSoft.Text + "', Version='" + txtVersion.Text + "', SType='" + cmbSType.Text + "', Dongle='" + Checkerle + "', PDate='" + dPick.Text + "', Customer='" + txtCustomer.Text + "', Seller='" + cmbSeller.Text + "', Notes='" + txtNotes.Text + "' WHERE ID ='" + txtID.Text + "'"); con.QueryEx(); DataTable dt = con.QueryEx(); dataGrid.ItemsSource = dt.DefaultView; string y = ""; y = theDate + "UPDATE Licenses SET License='" + txtLicense.Text + "', Software='" + cmbSoft.Text + "', Version='" + txtVersion.Text + "', SType='" + cmbSType.Text + "', Dongle='" + Checkerle + "', PDate='" + dPick.Text + "', Customer='" + txtCustomer.Text + "', Seller='" + cmbSeller.Text + "', Notes='" + txtNotes.Text + "' WHERE ID ='" + txtID.Text + "'"; System.Windows.MessageBox.Show("The data has been updated successfully", "Success", System.Windows.MessageBoxButton.OK, System.Windows.MessageBoxImage.Information); chkDongle.IsChecked = !chkDongle.IsChecked; if (y != "") { System.Windows.MessageBox.Show(y); } } catch (System.Exception excep) { System.Windows.MessageBox.Show(excep.Message, "Error", System.Windows.MessageBoxButton.OK, System.Windows.MessageBoxImage.Error); } }
public MainWindow() { InitializeComponent(); txtLicense.Text = ""; cmbSoft.Text = ""; txtVersion.Text = ""; cmbSType.Text = ""; txtCustomer.Text = ""; cmbSeller.Text = ""; txtNotes.Text = ""; try { con = new SqlDbConnect(); con.SqlQuery("SELECT * FROM LICENSES"); con.QueryEx(); DataTable dt = con.QueryEx(); dataGrid.ItemsSource = dt.DefaultView; } catch (Exception ex) { System.Windows.MessageBox.Show(ex.ToString(), "Error", System.Windows.MessageBoxButton.OK, System.Windows.MessageBoxImage.Error); } }
private void btnSearchDate_Click(object sender, EventArgs e) { con = new SqlDbConnect(); con.SqlQuery("SELECT ID, License, Software, Version, SType, Dongle, PDate, Customer, Seller, Notes From Licenses where PDate between'" + dPickStart.Text + "'and'" + dPickEnd.Text + "'"); con.QueryEx(); DataTable dt = con.QueryEx(); dataGrid.ItemsSource = dt.DefaultView; }
private void btnView_Click(object sender, RoutedEventArgs e) { try { con = new SqlDbConnect(); con.SqlQuery("SELECT * FROM Licenses"); con.QueryEx(); DataTable dt = con.QueryEx(); dataGrid.ItemsSource = dt.DefaultView; } catch (Exception ex) { System.Windows.MessageBox.Show(ex.ToString(), "Error", System.Windows.MessageBoxButton.OK, System.Windows.MessageBoxImage.Error); } }
private void btnSearch_Click(object sender, RoutedEventArgs e) { // if (cmbSBox.Text == "License") { con = new SqlDbConnect(); con.SqlQuery("SELECT ID, License, Software, Version, SType, Dongle, PDate, Customer, Seller, Notes From Licenses where License like '%" + txtSearch.Text + "%'"); con.QueryEx(); DataTable dt = con.QueryEx(); dataGrid.ItemsSource = dt.DefaultView; } if (cmbSearch.Text == "Software") { con = new SqlDbConnect(); con.SqlQuery("SELECT ID, License, Software, Version, SType, Dongle, PDate, Customer, Seller, Notes From Licenses where Software like '%" + txtSearch.Text + "%'"); con.QueryEx(); DataTable dt = con.QueryEx(); dataGrid.ItemsSource = dt.DefaultView; } if (cmbSearch.Text == "Version") { con = new SqlDbConnect(); con.SqlQuery("SELECT ID, License, Software, Version, SType, Dongle, PDate, Customer, Seller, Notes From Licenses where Version like '%" + txtSearch.Text + "%'"); con.QueryEx(); DataTable dt = con.QueryEx(); dataGrid.ItemsSource = dt.DefaultView; } if (cmbSearch.Text == "Software Type") { con = new SqlDbConnect(); con.SqlQuery("SELECT ID, License, Software, Version, SType, Dongle, PDate, Customer, Seller, Notes From Licenses where SType like '" + txtSearch.Text + "%'"); con.QueryEx(); DataTable dt = con.QueryEx(); dataGrid.ItemsSource = dt.DefaultView; } }
private void btnDelete_Click(object sender, EventArgs e) { try { con = new SqlDbConnect(); con.SqlQuery("Delete From Licenses where ID = " + txtID.Text); con.QueryEx(); System.Windows.MessageBox.Show("The data has been deleted successfully", "Success", System.Windows.MessageBoxButton.OK, System.Windows.MessageBoxImage.Information); } catch (System.Exception excep) { MessageBox.Show(excep.Message, "Error", System.Windows.MessageBoxButton.OK, System.Windows.MessageBoxImage.Error); } }