public POSui(int x) { //CONSTRUCTOR FOR HOLD InitializeComponent(); data.sum = 0; data.check = x; int holder; DBConnect initial = new DBConnect(); String query = "SELECT *,(product_qty*product_price)as sales FROM product GROUP BY product_name"; String trans = "INSERT INTO transactionlog(transactionDate) VALUES(NOW()); SELECT transactionID,transactionDate FROM transactionlog WHERE transactionDate=NOW();"; initial.getTransID(trans, out holder);//retrieves ID for foreign key assignment and deletion initial.getInv(copy, query); this.ActiveControl = IDfield; data.transID = holder; holdCust.Hide(); }
globals data = new globals(); //total price, transaction ID, and cashier ID put here public POSui() { InitializeComponent(); data.sum = 0; data.check = 0; int holder; DBConnect initial = new DBConnect(); String query = "SELECT *,(product_qty*product_price)as sales FROM product GROUP BY product_name"; String trans = "INSERT INTO transactionlog(transactionDate) VALUES(NOW()); SELECT transactionID,transactionDate FROM transactionlog WHERE transactionDate=NOW();"; initial.getTransID(trans, out holder);//retrieves transID for foreign key assignment and deletion initial.getInv(copy, query); this.ActiveControl = IDfield; data.transID = holder; AutoCompleteStringCollection col = new AutoCompleteStringCollection(); for (int i = copy.Count - 1; i >= 0; i--) { col.Add(copy[i].itemName); } itemNamefield.AutoCompleteCustomSource = col; }