public void MyRFID_Taged(object sender, RFIDTagEventArgs args) { lbxLoaneditems.Items.Clear(); lbxIDscan.Items.Clear(); lbxIDscan.Items.Add($"RFID Taged! ID: {args.Tag}"); tag = args.Tag.ToString(); double balance = dh.GetBalance(args.Tag); if (balance > -1) { lbBalance.Text = balance.ToString() + "€"; } else { lbBalance.Text = "0€"; } List <List <string> > inf = dh.Items(args.Tag); int i = 0; if (!inf.Any()) { } else { foreach (var g in inf) { lbxLoaneditems.Items.Add($"Item: {g[0]} with Price of {g[1]}€ from Stand: {g[2]} is STILL LOANED"); i++; } } }
private void Rfid_Tag(object sender, RFIDTagEventArgs e) { string rfidNr = e.Tag; try { tempCustomer = dh.GetCustomer(rfidNr); if (orderedProducts.Capacity != 0) { if (tempCustomer.CustomerBalance >= this.CalculateTotalBill()) { btnProceedOrder.Enabled = true; } else { MessageBox.Show("Balance not enough!"); } } else { MessageBox.Show("No order found!"); } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } }
private void Rfid_Tag(object sender, RFIDTagEventArgs e) { string rfidNr = e.Tag; try { c = d.Customer(rfidNr); if (loan.Capacity != 0) { if (c.CustomerBalance >= this.CalculateTotal()) { borrow.Enabled = true; } else { MessageBox.Show("Balance not enough!"); } } else { MessageBox.Show("No order found!"); } } catch (Exception ex) { MessageBox.Show("Error: " + ex.Message); } }
private void Reader_Tag(object sender, RFIDTagEventArgs e) { String sqlStatement = "SELECT * FROM customer;"; MySqlCommand sqlCommand = new MySqlCommand(sqlStatement, dbConnection); var list = new List <string>(); dbConnection.Open(); MySqlDataReader articlesReader = sqlCommand.ExecuteReader(); while (articlesReader.Read()) { var id = articlesReader[0].ToString(); var name = articlesReader[1].ToString(); var balance = articlesReader[6].ToString(); var number = articlesReader[7].ToString(); list.Add(id); list.Add(name); list.Add(balance); list.Add(number); } if (e.Tag == "2800b82096") { lblStatus.Text = "Approved"; lblStatus.ForeColor = Color.Green; cardHolderId.Text = list[0]; lblCardNr.Text = list[3]; lblBalance.Text = list[2]; lblCardHld.Text = list[1]; button5.Enabled = true; button5.BackColor = Color.Orange; } dbConnection.Close(); }
//Setting the RFID to the new Visitor public void SetRfidToUser(object sender, RFIDTagEventArgs args) { rfidCode = args.Tag; myRfid.Close(); var dh = new Datahelper(); lblRfidSt.Text = dh.GetUserFirstNameWithRfid(rfidCode); //Setting the visitors id dh.userId = UserIdForSettingRfid; //Giving the rfid chip to the visitor var status = dh.GiveRfid(rfidCode); lbCheckStatus.Text = status; lblRfidSt.Text = ""; if (status == "There is already a user with that RFID" || status == "Error Assigning RFID" || status == "Error!") { lbCheckStatus.ForeColor = Color.Red; CheckedIn = "yes"; } else { lbCheckStatus.ForeColor = Color.Green; lbRegisterStatus.Text = ""; CheckedIn = "no"; } }
private void RFID_Reader(object sender, RFIDTagEventArgs e) { try { //retrieveData(); //foreach (Staff a in tempLst) //{ // if (e.Tag == a.RFIDNO.Replace(" ", string.Empty)) // { // textBox3.Text = e.Tag.Replace(" ",string.Empty); // break; // } // else // { // MessageBox.Show("NOT FOUND"); // textBox3.Clear(); // break; // } //} textBox3.Text = e.Tag; } catch (Exception E) { } finally { myRFID.Close(); } }
private void Rfid_Tag(object sender, RFIDTagEventArgs e) { string rfid = e.Tag; if (tempCustomer != null) { try { tempCustomer.AssignRfid(rfid); dh.InsertCustomerRfidTable(tempCustomer.Id, tempCustomer.Rfid); ShowInfo(tempCustomer); MessageBox.Show("Successful update"); } catch (Exception e1) { MessageBox.Show(e1.Message + " RFID not assigned!"); listBoxInfo.Items.Clear(); tempCustomer = null; rfid = null; } } else { MessageBox.Show("No visitor selected"); } }
private void AssignRFID(object sender, RFIDTagEventArgs e) { if (phidget.TagNr != null) {// the scanned object has a tag code. RFIDTagNr = phidget.TagNr; } }
public void ReadTagID(object sender, RFIDTagEventArgs e) { //lblCopiedID.Text = e.Tag; this.tag = e.Tag; lbxIDscan.Items.Clear(); lbxIDscan.Items.Add("Scanned ID: " + e.Tag); }
private void Rfid_Tag(object sender, RFIDTagEventArgs e) { string rfidNr = e.Tag; Customer c = null; try { c = dh.GetCustomer(rfidNr); } catch (Exception e1) { MessageBox.Show(e1.Message); } if (c != null) { if (c.Reservation == true) { if (c.CheckedStatusCamp == 0) { listBoxInfo.Items.Add("Welcome, " + c.FirstName + " " + c.LastName + " !"); listBoxInfo.Items.Add("Your SpotID is: " + c.SpotId); label1.Text = "We wish you a plesant stay!"; } else { label1.Visible = false; listBoxInfo.Items.Add("Goodbye, " + c.FirstName + " " + c.LastName + " !"); } try { dh.UpdateCustomertable(); } catch (Exception e2) { MessageBox.Show(e2.Message); } } else { label1.Text = "No reservation found!"; } } }
private void RFID_CheckOut(object sender, RFIDTagEventArgs e) { if (e.Tag != "") { textBox2.Text = e.Tag; } myRFID.Close(); }
public void ReadTagID(object sender, RFIDTagEventArgs e) { this.tag = e.Tag; if (dh.CheckReservationSelect(e.Tag) == true) { lbxIDscan.Items.Clear(); lbxIDscan.Items.Add("Checked in Visitor: " + e.Tag); dh.AddLogCheckedIn(e.Tag); if (dh.CheckedinCheckoutSelect(e.Tag) == "No") { int catchnr2 = dh.Checkin(e.Tag); if (catchnr2 > 0) { lbxIDscan.Items.Clear(); lbxIDscan.Items.Add("Checked In Visitor: " + e.Tag); dh.AddLogCheckedIn(e.Tag); // lblCheckincheckout.Text = "Checked in Visitor: " + e.Tag; } else { // lblCheckincheckout.Text = "Check in failed"; lbxIDscan.Items.Add("Checked In Failed" /*+ e.Tag*/); } } else if (dh.CheckedinCheckoutSelect(e.Tag) == "Yes") { int catchnr2 = dh.Checkout(e.Tag); if (catchnr2 > 0) { lbxIDscan.Items.Clear(); lbxIDscan.Items.Add("Checked Out Visitor: " + e.Tag); dh.AddLogCheckedOut(e.Tag); // lblCheckincheckout.Text = "Checked out Visitor: " + e.Tag; } else { // lblCheckincheckout.Text = "Checkout failed"; lbxIDscan.Items.Add("Checked Out Failed" /*+ e.Tag*/); } } } else { lbxIDscan.Items.Clear(); lbxIDscan.Items.Add("Visitor: " + e.Tag + " has no reservation, please make one"); groupBox2.Visible = true; List <string> spots; spots = dh.NonReservedSelect(); lbxAvailablecampingspots.Items.Clear(); foreach (string s in spots) { lbxAvailablecampingspots.Items.Add(s); } lbxAvailablecampingspots.SelectedIndex = 0; } }
public void ReadTagUserReturn(object sender, RFIDTagEventArgs e) { // if (db.SelectUserId(e.Tag) > 0) //{ int userId = db.SelectUserId(e.Tag); // double balance = db.SelectBalance(userId); // Console.WriteLine("** " + loanId); // Console.WriteLine("********** hiiiiiiiiiiiiiiiiiiiiiii" + db.Price); // Console.WriteLine("Hello " + db.SelectUserId(e.Tag)); //Console.WriteLine("Hello3 " + e.Tag); //Console.WriteLine("Hello2 " + db.CheckIfBorrowed(e.Tag)); int test = 0; foreach (Item i in items) { if (db.SelectUserId(e.Tag) >= 1 && db.CheckIfBorrowed(i.P_rfid) > 0) { lbInfo.Items.Insert(0, "UserRfid: " + e.Tag + " Returned: " + i.Name); //Console.WriteLine("*** " + userId+"*"+ shopId+ "*"+p.P_rfid); db.ReturnItems(i.P_rfid); test = 1; } // lblTag.Text = ""; //lblItemName.Text = ""; // lblPrice.Text = ""; } if (test == 1) { MessageBox.Show("Items Returned successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); btnReturn.Text = "RETURN ITEMS"; myRFIDReader.Tag -= new RFIDTagEventHandler(ReadTagUserReturn); myRFIDReader.Tag += new RFIDTagEventHandler(ReadTagNewID); lblTotalPrice.Text = "0"; items.Clear(); lbItems.Items.Clear(); } else if (btnReturn.Text == "RETURN ITEMS") { MessageBox.Show("This item is out of stock!"); btnReturn.Text = "RETURN ITEMS"; myRFIDReader.Tag -= new RFIDTagEventHandler(ReadTagUserReturn); myRFIDReader.Tag += new RFIDTagEventHandler(ReadTagNewID); } else { MessageBox.Show("This item is already rented!"); btnReturn.Text = "RETURN ITEMS"; myRFIDReader.Tag -= new RFIDTagEventHandler(ReadTagUserReturn); myRFIDReader.Tag += new RFIDTagEventHandler(ReadTagNewID);; } }
private void ProcessThisTag(object sender, RFIDTagEventArgs e) { try { tbID.Text = e.Tag; } catch (PhidgetException pe) { MessageBox.Show(pe.Message); } }
private void ShowInfoOnTagDetected(object sender, RFIDTagEventArgs e) { try { RFIDcode = e.Tag; } catch (PhidgetException pe) { MessageBox.Show(pe.Message); } }
public void ReadTagNewID(object sender, RFIDTagEventArgs e) { if (btnSell.Text == "RENT ITEMS") { db.ItemPrice(e.Tag); lblPrice.Text = db.Price.ToString(); lblProduct.Text = db.Name.ToString(); rfidItem = e.Tag; loanId = db.SelectLoanId(e.Tag); } }
private void AssignARFID(object sender, RFIDTagEventArgs e) { if (phidget.TagNr != null) {// the scanned object has a tag code. RFIDTagNr = phidget.TagNr; lbEventID.Text = RFIDTagNr; balance = Equipment.GettTotalBalance(RFIDTagNr); lbCurrentBalance.Text = balance.ToString(); } }
private void ShowInfoOnTagDetected(object sender, RFIDTagEventArgs e) { try { tbTicketNo.Text = e.Tag; textBox1.Text = e.Tag; } catch (PhidgetException pe) { MessageBox.Show(pe.Message); } }
//private BorrowedEquipment CheckForitemid() //{ // int id = Convert.ToInt16(textBox1.Text); // return equip.GetAVisitor(id); // get the participant from the database. //} private void AssignRFID(object sender, RFIDTagEventArgs e) { if (phidget.TagNr != null) {// the scanned object has a tag code. RFIDTagNr = phidget.TagNr; Status(); } else { lbRFIDStatus.Text = "Scan an RFID object."; } }
private void Reader_Tag(object sender, RFIDTagEventArgs e) { if (e.Tag == "28007bcb0f") { lblStatus.Text = "Approved"; lblStatus.ForeColor = Color.Green; button1.Enabled = false; button2.Enabled = false; button3.Enabled = false; button4.Enabled = false; } //MessageBox.Show("dsd"); }
public void ReadTagUser(object sender, RFIDTagEventArgs e) { if (db.SelectUserId(e.Tag) > 0) { int userId = db.SelectUserId(e.Tag); double balance = db.SelectBalance(userId); // Console.WriteLine("** " + loanId); // Console.WriteLine("********** hiiiiiiiiiiiiiiiiiiiiiii" + db.Price); if (balance >= db.Price) { // lblTag.Text = e.Tag; // Console.WriteLine("********** " + balance); balance = balance - totalPrice; //Console.WriteLine("********** " + balance); foreach (Item p in items) { //db.ProductQty(p.P_rfid); lbInfo.Items.Insert(0, "UserRfid: " + e.Tag + " " + p.Name + " Price: " + p.Price); //Console.WriteLine("*** " + userId+"*"+ shopId+ "*"+p.P_rfid); db.InsertTransction(userId, loanId, p.P_rfid); db.InsertUpTransction(userId, loanId, p.P_rfid, p.Price); db.Paying(userId, balance); } MessageBox.Show("Products Rented successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); // lblTag.Text = ""; //lblItemName.Text = ""; // lblPrice.Text = ""; btnSell.Text = "RENT ITEMS"; myRFIDReader.Tag -= new RFIDTagEventHandler(ReadTagUser); myRFIDReader.Tag += new RFIDTagEventHandler(ReadTagNewID); lblTotalPrice.Text = "0"; items.Clear(); lbItems.Items.Clear(); } else { MessageBox.Show("Buyer don't have enough credits!"); } } else if (btnSell.Text == "RENT ITEMS") { MessageBox.Show("This item is out of stock!"); } else { MessageBox.Show("This ticket does not exist!"); } }
private void RFID_Reader(object sender, RFIDTagEventArgs e) { if (e.Tag != "") { // Participant s; string sql1 = "select * from participant where RFIDNo = '" + e.Tag + "'"; string[,] querryResult = DBConnection.ExecuteQuery1(1, sql1, 4); if (querryResult != null) { string sql2 = "select * from eventaccount where AccountNo = '" + Convert.ToInt32(querryResult[0, 1]) + "'"; string[,] querryResult2 = DBConnection.ExecuteQuery1(1, sql2, 8); if (querryResult2 != null) { string sql3 = "select * from visitor where VisitorNo = '" + Convert.ToInt32(querryResult2[0, 7]) + "'"; string[,] querryResult3 = DBConnection.ExecuteQuery1(1, sql3, 10); if (querryResult3 != null) { tbxRegisteredId.Text = e.Tag + ""; tbxRegisteredName.Text = Convert.ToString(querryResult3[0, 3]) + " " + Convert.ToString(querryResult3[0, 4]); tbPhone.Text = Convert.ToString(querryResult3[0, 7]); tbxRegisteredAccNo.Text = Convert.ToString(querryResult[0, 1]); myRFID.Close(); } } else { MessageBox.Show("Wrong RFID"); } } else { MessageBox.Show("Cannot find!"); } //staff1 = myEvent.findStaffByRFID(e.Tag); //if (staff1 != null) //{ // this.Visible = false; // myRFID.Close(); //} //else //{ // MessageBox.Show("Wrong RIFD!"); //} } myRFID.Close(); }
public void ReadTagUser(object sender, RFIDTagEventArgs e) { if (db.SelectUserId(e.Tag) > 0) { int userId = db.SelectUserId(e.Tag); double balance = db.SelectBalance(userId); if (balance >= db.Price) { // lblTag.Text = e.Tag; // Console.WriteLine("********** " + balance); balance = balance - totalPrice; //Console.WriteLine("********** " + balance); foreach (Product p in products) { db.ProductQty(p.P_rfid); //Console.WriteLine("********** " + db.Qty); int qty = db.Qty - p.Qty; //Console.WriteLine("********** " + qty); lbInfo.Items.Insert(0, "BuyerRfid: " + e.Tag + " " + p.Name + " Price: " + p.Price + " Quantity: " + p.Qty); db.InsertTransction(userId, p.Qty, shopId, p.P_rfid, p.Price * p.Qty); // Console.WriteLine("****** " + p.Qty + " " + qty + " " + shopId + " " + rfidProduct); db.Paying(userId, balance); db.UpdateQty(p.P_rfid, qty); } MessageBox.Show("Products sold successfully!", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information); // lblTag.Text = ""; //lblItemName.Text = ""; // lblPrice.Text = ""; btnSell.Text = "SELL ITEMS"; myRFIDReader.Tag -= new RFIDTagEventHandler(ReadTagUser); myRFIDReader.Tag += new RFIDTagEventHandler(ReadTagNewID); lblTotalPrice.Text = "0"; products.Clear(); lbSellList.Items.Clear(); } else { MessageBox.Show("Buyer don't have enough credits!"); } } else if (btnSell.Text == "SELL ITEMS") { MessageBox.Show("This item is out of stock!"); } else { MessageBox.Show("This ticket does not exist!"); } }
private void AssignRFID(object sender, RFIDTagEventArgs e) { if (phidget.TagNr != null) { RFIDTagNr = phidget.TagNr; lbEventID.Text = RFIDTagNr; balnce = items.GetPresentBalance(RFIDTagNr); lbCurrentBalance.Text = balnce.ToString(); dataGridVisitor.Rows.Clear(); orders.Clear(); Totalprice(); } }
private void AssignRFID(object sender, RFIDTagEventArgs e) { if (phidget.TagNr != null) {// the scanned object has a tag code. RFIDTagNr = phidget.TagNr; id = Equipmentdata.GetVistorFromDataBase(id, RFIDTagNr); // MessageBox.Show("Your Event is "+id.ToString()+" \n please enter into the textbox"); textBox1.Text = id.ToString(); Status(); } else { lbRFIDStatus.Text = "Scan an RFID."; } }
private void rfid_Tag(object sender, RFIDTagEventArgs e) { RFID rf = (RFID)sender; rf.Channel = 2; rf.Open(); // SendEmail(); label2.Text = "Amount sent: " + amountSent; dig.BeginSetState(true, TurnOn, null); this.BackColor = Color.Green; Process.Start("chrome", "http://www.google.dk"); dig.BeginSetState(false, TurnOff, null); // this.BackColor = Color.Gray; }
public void ReadTagNewID(object sender, RFIDTagEventArgs e) { if (btnSell.Text == "SELL ITEMS") { db.ProductNamePrice(e.Tag); lblPrice.Text = db.Price.ToString(); lblProduct.Text = db.Name.ToString(); rfidProduct = e.Tag; } if (btnSell.Text == "SELL ITEMS" && lblProduct.Text != "not exist" && lblProduct.Text != "Name of product") { rfidProduct = e.Tag; shopId = db.SelectShopId(e.Tag); // Console.WriteLine("****** " + shopId); } }
//Only displaying the chip public void CheckUserRfid(object sender, RFIDTagEventArgs args) { rfidCode = args.Tag; var dh = new Datahelper(); var userName = dh.GetUserFirstNameWithRfid(rfidCode); if (userName != "") { lblRfidSt.Text = userName; } else { lblRfidSt.Text = rfidCode; } myRfid.Close(); }
public void CheckUserRfid(object sender, RFIDTagEventArgs args) { rfid_Code = args.Tag; Mysql dh = new Mysql(); string userName = dh.GetUserNameWithRfid(rfid_Code); if (userName != "") { lbVisitorName.Text = userName; } else { lbVisitorName.Text = rfid_Code; } rfid.Close(); }
private void Rfid_Tag(object sender, RFIDTagEventArgs e) { string rfidNr = e.Tag; Customer c = null; try { c = dh.GetCustomer(rfidNr); } catch (Exception e1) { MessageBox.Show(e1.Message); } if (c != null) { if (c.CheckedStatusEvent == 0) { lbChecked.Text = "Welcome, " + c.FirstName + " " + c.LastName + " !"; try { dh.UpdateCustomertable(); dh.InsertCustomerHistory(); } catch (Exception e2) { MessageBox.Show("Error updating database: " + e2.Message); } } else { if (c.LoanedProductStatus == 0) { lbChecked.Text = "Goodbye, " + c.FirstName + " " + c.LastName + " !"; try { dh.UpdateCustomertable(); dh.InsertCustomerHistory(); } catch (Exception e2) { MessageBox.Show("Error updating database: " + e2.Message); } } else { lbChecked.ForeColor = Color.Red; lbChecked.Text = "Please return the loaned products first!"; } } } }