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;
}