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