private void loadMeta()
{
List <string> items = MySQLServer.get_orders_information();
orders.Text += String.Format("<tr><th>User</th><th>Film title</th><th>Date and time</th><th>Places</th><th>Cost</th><th>Status</th></tr>");
for (int i = 0; i < items.Count / 7; ++i)
{
string id = items[i * 7 + 0];
string user = items[i * 7 + 1];
string film = items[i * 7 + 2];
string date = items[i * 7 + 3];
string status = items[i * 7 + 4];
string cost = items[i * 7 + 5];
string places = items[i * 7 + 6];
if (status == "pending confirmation")
{
orders.Text += String.Format("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{5}</td><td class=\"flex\"><input class=\"sub-button\" onClick=\"approve(this)\" id=\"a{4}\" type = \"submit\" value=\"Accept\"/><input class=\"dec-button\" onClick=\"approve(this)\" id=\"d{4}\" type = \"submit\" value=\"Decline\"/></td></tr>", user, film, date, places, id, cost);
}
else
{
orders.Text += String.Format("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{5}</td><td class=\"flex\">{4}</td></tr>", user, film, date, places, status, cost);
}
}
orders.Text = "<table cellspacing=\"0\">" + orders.Text + "</table>";
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/pdf";
context.Response.AddHeader("content-disposition", "inline; filename=ticket.pdf");
List <string> items = MySQLServer.get_orders_information(int.Parse(context.Request["id"]));
if (items.Count == 0 ||
items[1] != context.Request.Cookies["login"].Value.ToUpper() ||
items[4] != "confirmed")
{
context.Response.Redirect("~/Account/Profile");
}
QRCodeEncoder encoder = new QRCodeEncoder();
Bitmap QRImage = encoder.Encode(SignGenerator.GetSign(items[0] + items[1]));
Document doc = new Document(iTextSharp.text.PageSize.A4, 40, 40, 42, 35);
PdfWriter writer = PdfWriter.GetInstance(doc, context.Response.OutputStream);
doc.Open();
doc.Add(new Paragraph("User: "******"Film: " + items[2]));
doc.Add(new Paragraph("Date: " + items[3].Split(' ')[0]));
doc.Add(new Paragraph("Time: " + items[3].Split(' ')[1]));
doc.Add(new Paragraph("\n"));
doc.Add(new Paragraph("Cost: " + items[5]));
doc.Add(new Paragraph("\n"));
doc.Add(new Paragraph("Places: " + items[6]));
doc.Add(new Paragraph("\n"));
iTextSharp.text.Image i = iTextSharp.text.Image.GetInstance(QRImage, ImageFormat.Jpeg);
doc.Add(i);
doc.Close();
}
private void loadMeta()
{
List <string> items = MySQLServer.get_orders_information(name);
orders.Text += String.Format("<tr><th>Film title</th><th>Date and time</th><th>Places</th><th>Cost</th><th>Status</th><th>Get PDF</th></tr>");
for (int i = 0; i < items.Count / 7; ++i)
{
string id = items[i * 7 + 0];
string user = items[i * 7 + 1];
string film = items[i * 7 + 2];
string date = items[i * 7 + 3];
string status = items[i * 7 + 4];
string cost = items[i * 7 + 5];
string places = items[i * 7 + 6];
string PDF = "<a runat=\"server\" class = \"pdf\" href=\"Ticket.ashx?id=" + id + "\">Download</a>";
if (status != "confirmed")
{
PDF = "";
}
orders.Text += String.Format("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{4}</td><td class=\"flex\">{3}</td><td>{5}<td></tr>", film, date, places, status, cost, PDF);
}
orders.Text = "<table cellspacing=\"0\">" + orders.Text + "</table>";
}