} //makes the btnAssign and tbTagValue visible
private void FillTextBoxInfo(int ticketId)
{
string name = connection.GetVisitorName(ticketId);
int visitorId = connection.GetVisitorIdFromTicketId(ticketId);
int campspotId = 0;
tbVisitorTicketId.Text = tbQrValue.Text;
string rfidValue = connection.VisitorHasRfidAssigned(ticketId);
if (connection.IsCamper(ticketId))
{
//hasCampspot = "Yes";
campspotId = connection.GetCampspotIdFromTicketId(ticketId);
}
else
//hasCampspot = "No";
if (rfidValue == "")
{
tbRfidAlreadyAssigned.Text = "Not assigned";
}
else
{
tbRfidAlreadyAssigned.Text = rfidValue;
}
byte[] pic = connection.getVisitorPicture(visitorId);
MemoryStream strm = new MemoryStream();
if (pic != null)
{
strm.Write(pic, 0, pic.Length);
strm.Position = 0;
System.Drawing.Image img = System.Drawing.Image.FromStream(strm);
BitmapImage bi = new BitmapImage();
bi.BeginInit();
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
ms.Seek(0, SeekOrigin.Begin);
bi.StreamSource = ms;
bi.EndInit();
pbPicture.Source = bi;
}
else
{
BitmapImage image = new BitmapImage(new Uri("img/no-profile.jpg", UriKind.Relative));
pbPicture.Source = image;
}
tbVisitorName.Text = name;
tbVisitorId.Text = visitorId.ToString();
//tbVisitorHasCamp.Text = hasCampspot;
tbVisitorCampspot.Text = campspotId.ToString();
}//fills the textboxes that give visitor information when the QR is scanned
