private void setRefr() { connectDB conn = new connectDB("ticketSys", "root", "localhost", ""); ticketSystemGrid.ItemsSource = conn.Select().DefaultView; //timeBlock.Text = getTime().ToString("yyyy-dd-MM - H:mm:ss"); //Hiden already }
private void LoadAll() { connectDB conn = new connectDB("ticketSys", "root", "localhost", ""); ticketSystemGrid.ItemsSource = conn.Select().DefaultView; Timer t = new System.Timers.Timer(); t.Interval = 60000; //60s t.Elapsed += refr; t.AutoReset = true; t.Enabled = true; }
private void openEvent_Click(object sender, RoutedEventArgs e) { try { connectDB conn = new connectDB("ticketSys", "root", "localhost", ""); DataRowView drv = ticketSystemGrid.SelectedItem as DataRowView; conn.Update(Convert.ToInt32(drv["ID"].ToString()), true); ticketSystemGrid.ItemsSource = conn.Select().DefaultView; } catch (Exception xe) { MessageBox.Show(xe.Message); } }
private void refreshView_Click(object sender, RoutedEventArgs e) { connectDB conn = new connectDB("ticketSys", "root", "localhost", ""); ticketSystemGrid.ItemsSource = conn.Select().DefaultView; }