private void t_gd_insert_buttonClick(object sender, EventArgs e)
{
FormFunctions fFunc = new FormFunctions(user_id_lbl.Text, user_hash_lbl.Text);
ConnectToMySQL dbc = new ConnectToMySQL(user_id_lbl.Text, user_hash_lbl.Text);
// adding fieldnames -->
fldNames.Clear();
fldNames.AddRange(new string[] { "job_number", "cust_name", "DATE_FORMAT(timestamp, '%Y-%m-%d')", "card_name", "Retailer", "card_denom", "order_qty", "concat(card_thickness, ' ', card_material)", "req_date", "cust_po_number", "card_size", "ProjectedDueDate", "sales_vars.user_id", "lamination", "ActualDueDate", "graphics_vars_gang_id", "PinCover", "Personalization_job", "CardRatio", "Other_Barcode", "MinPrintQty", "MagStripe", "Encode" });
// -->
// fetching data -->
string query = "SELECT " + string.Join(", ", fldNames.ToArray());
query += " FROM sales_vars ";
query += " JOIN graphics_vars_job ON sales_vars_id = sales_vars.id ";
query += " WHERE graphics_vars_job.job_number = " + ((Button)sender).Tag.ToString();
DataSet ds = new DataSet();
ds = dbc.SelectMyDA(query);
//-->
// adding labels -->
fldNames.Clear();
fldNames.AddRange(new string[] {"JobID", "Customer Name", "PODate", "Card Name", "Retailer", "Denomination", "Order Qty", "Core Material", "Customer Due Date", "PO", "Type Of Card", "Projected Due Date", "Sales", "Lamination", "Actual Due Date", "GangID", "Pin Cover", "Personalization Job", "Card Ratio", "Other", "Min Print Qty", "Mag Stripe", "Encode" });
// -->
fFunc.createXML_job("Personalization Detail Sheet", fldNames, ds);
}
