/// <summary> /// this method is used to execute the copy command, by calling each of the appropriate methods to add not only the queries, but also the data to the second table /// </summary> /// <param name="database"> /// the name of the first database /// </param> /// <param name="database2"> /// the name of the second database /// </param> /// <param name="connNumber"> /// the connection number of the first database /// </param> /// <param name="connNumber2"> /// the connection number of the second database /// </param> /// <param name="queryStep"> /// the action we want to take every query action /// </param> /// <param name="justStructure"> /// a boolean dictating if the user just wants to copy the structure for now (incase they want to add any fields to the database before copying the data) /// </param> /// <returns> /// the asyncronous task, so it does not lock the UI /// </returns> public static void ExecuteCopy(string database, string database2, int connNumber, int connNumber2, Action <string> queryStep, Boolean justStructure) { //using the opened connection... using (DbConnection conn = SQLConnectionHandler.GetOpenedConnection(connNumber2)) { //using the opened transaction... using (DbTransaction sqlTran = conn.BeginTransaction()) { try { //run the queries before, after, and copy the data SQLQueryHandler.RunBeforeQueries(connNumber2, conn, sqlTran, queryStep); if (!justStructure) { SQLDataHandler.CopyData(database, database2, connNumber, connNumber2, conn, sqlTran, queryStep); } SQLQueryHandler.RunAfterQueries(connNumber2, conn, sqlTran, queryStep); //commit the changes sqlTran.Commit(); } catch (Exception) { // rollback the transaction on error sqlTran.Rollback(); throw; } } } }
public SearchUser() { InitializeComponent(); searchUser = this; sqlHandler = new SQLDataHandler(); RefreshUI(); }
public AddBadge() { InitializeComponent(); txtScanID.Focus(); sqlHandler = new SQLDataHandler(); _timer = new DispatcherTimer(); _timer.Interval = new TimeSpan(0, 0, 1); _timer.Tick += new EventHandler(Timer_Tick); btnCheckIn.Visibility = Visibility.Hidden; }
public SearchUser() { InitializeComponent(); searchUser = this; sqlHandler = new SQLDataHandler(); dispatcherTimer.Tick += new EventHandler(dispatcherTimer_Tick); dispatcherTimer.Interval = new TimeSpan(0, 0, 15); RefreshUI(); }
public RedeemPage() { InitializeComponent(); sqlHandler = new SQLDataHandler(); _timer = new DispatcherTimer(); _timer.Interval = new TimeSpan(0, 0, 1); _timer.Tick += new EventHandler(Timer_Tick); txtScanner = txtTicketID; txtTicketID.Focus(); btnManualRedeem.Visibility = Visibility.Hidden; }
public LoginWindow() { InitializeComponent(); loginManager = new SQLDataHandler(); }
public RedeemPage() { InitializeComponent(); sqlHandler = new SQLDataHandler(); }
public RegistrationPage() { InitializeComponent(); sqlHandler = new SQLDataHandler(); }
public RegistrationPage() { InitializeComponent(); sqlHandler = new SQLDataHandler(); btnRegister.Focus(); }
public LoginWindow() { InitializeComponent(); loginManager = new SQLDataHandler(); txtUserName.Focus(); }
public RafflePage() { InitializeComponent(); sqlHandler = new SQLDataHandler(); }