private void PrintOrderEdit(string edit_id, string job_id) { OrderEditReport report = new OrderEditReport(); try { foreach (DataRow r in kitchen_printers_dt.Rows) { OrderEditDataSet ds = generateOrderEditDataSet(edit_id, r["Category"].ToString()); if (ds.OrderEditDetails.Rows.Count > 0) { report.SetDataSource(ds); report.PrintOptions.PrinterName = r["Printer"].ToString(); report.PrintToPrinter(1, false, 0, 0); } } MySqlFunctions.SqlNonQuery("update print_jobs set executed_at = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' " + "where id = '" + job_id + "'", Program.GlobalConn); } catch (Exception ex) { MySqlFunctions.SqlNonQuery("update print_jobs set executed_at = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "', " + " error = '" + MySql.Data.MySqlClient.MySqlHelper.EscapeString(ex.Message) + "' " + "where id = '" + job_id + "'", Program.GlobalConn); } finally { report.Dispose(); } }
private void PrintOrderForKitchens(string order_id, string job_id, string title = "New Order") { NewOrderReport report = new NewOrderReport(); try { report.DataDefinition.FormulaFields["ReportTitle"].Text = "'" + title + "'"; foreach (DataRow r in kitchen_printers_dt.Rows) { NewOrderDataSet ds = generateNewOrderDataSet(order_id, r["Category"].ToString()); if (ds.OrderDetail.Rows.Count > 0) { report.SetDataSource(ds); report.PrintOptions.PrinterName = r["Printer"].ToString(); report.PrintToPrinter(1, false, 0, 0); } } MySqlFunctions.SqlNonQuery("update print_jobs set executed_at = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' " + "where id = '" + job_id + "'", Program.GlobalConn); } catch (Exception ex) { MySqlFunctions.SqlNonQuery("update print_jobs set executed_at = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "', " + " error = '" + MySql.Data.MySqlClient.MySqlHelper.EscapeString(ex.Message) + "' " + "where id = '" + job_id + "'", Program.GlobalConn); } finally { report.Dispose(); } }
private void PrintOrderCancellation(string order_id, string job_id) { OrderCancellation report = new OrderCancellation(); try { report.DataDefinition.FormulaFields["order_id"].Text = "'" + order_id + "'"; foreach (DataRow r in kitchen_printers_dt.Rows) { report.PrintOptions.PrinterName = r["Printer"].ToString(); report.PrintToPrinter(1, false, 0, 0); } MySqlFunctions.SqlNonQuery("update print_jobs set executed_at = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' " + "where id = '" + job_id + "'", Program.GlobalConn); } catch (Exception ex) { MySqlFunctions.SqlNonQuery("update print_jobs set executed_at = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "', " + " error = '" + MySql.Data.MySqlClient.MySqlHelper.EscapeString(ex.Message) + "' " + "where id = '" + job_id + "'", Program.GlobalConn); } finally { report.Dispose(); } }
private OrderEditDataSet generateOrderEditDataSet(string edit_id, string category) { OrderEditDataSet ds = new OrderEditDataSet(); DataTable edit = MySqlFunctions.GetTable( "select tos_edits.id, tos_edits.to_id as order_id, " + "tables.portion, tables.name as table_name from tos_edits " + "left join tables on tables.id = tos_edits.new_table_id " + "where tos_edits.id = '" + edit_id + "'", Program.GlobalConn); string detail_query = "select tos_edits_details.to_edit_id as edit_id, " + "tos_edits_details.edit_type, items.category, " + "items.code as code, items.name as item_name, tos_edits_details.qty " + "from tos_edits_details " + "join items on items.id = tos_edits_details.item_id" + " where tos_edits_details.to_edit_id = '" + edit_id + "'"; if (category != "") { detail_query += " and items.category = '" + category + "' "; } DataTable detail = MySqlFunctions.GetTable(detail_query, Program.GlobalConn); foreach (DataRow r in edit.Rows) { ds.OrderEdit.AddOrderEditRow( r["id"].ToString(), r["order_id"].ToString(), r["portion"].ToString(), r["table_name"].ToString() ); } foreach (DataRow r in detail.Rows) { ds.OrderEditDetails.AddOrderEditDetailsRow( (OrderEditDataSet.OrderEditRow)ds.OrderEdit.Rows[0], r["edit_type"].ToString(), r["category"].ToString(), r["code"].ToString(), r["item_name"].ToString(), r["qty"].ToString() ); } return(ds); }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { string path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location); string pos_printers = path + @"/pos_printers.dat"; string kitchen_printers = path + @"/kitchen_printers.dat"; pos_printers_dt = Program.loadDTfromFile(pos_printers); kitchen_printers_dt = Program.loadDTfromFile(kitchen_printers); if (pos_printers_dt == null || kitchen_printers_dt == null) { throw new Exception("Unable to open printers files."); } DataTable dt_print_jobs = MySqlFunctions.GetTable("SELECT * FROM print_jobs where executed_at is null;", Program.GlobalConn); foreach (DataRow r in dt_print_jobs.Rows) { if (r["print_type"].ToString() == "New Order") { PrintOrderForKitchens(r["entity_id"].ToString(), r["id"].ToString(), "New Order"); } else if (r["print_type"].ToString() == "Reprint for Kitchens") { PrintOrderForKitchens(r["entity_id"].ToString(), r["id"].ToString(), "Reprint"); } else if (r["print_type"].ToString() == "Edit Order") { PrintOrderEdit(r["entity_id"].ToString(), r["id"].ToString()); } else if (r["print_type"].ToString() == "Customer Print") { PrintOrder(r["entity_id"].ToString(), r["id"].ToString(), false); } else if (r["print_type"].ToString() == "Order Cancelled") { PrintOrderCancellation(r["entity_id"].ToString(), r["id"].ToString()); } else if (r["print_type"].ToString() == "Invoice Print") { PrintOrder(r["entity_id"].ToString(), r["id"].ToString(), true); } } }
private void openConnection() { ConfigurationManager.RefreshSection("appSettings"); try { string server = ConfigurationManager.AppSettings.Get("server"); string port = ConfigurationManager.AppSettings.Get("port"); string username = ConfigurationManager.AppSettings.Get("user"); string password = ConfigurationManager.AppSettings.Get("password"); password = password != "" ? StringCipher.Decrypt(password, "abc") : ""; string database = ConfigurationManager.AppSettings.Get("database"); Program.GlobalConn = MySqlFunctions.OpenSqlConnection(server, database, username, password, port); } catch (Exception ex) { MessageBox.Show("Error Occurred: " + ex.ToString()); } }
private NewOrderDataSet generateNewOrderDataSet(string order_id, string category = "") { NewOrderDataSet ds = new NewOrderDataSet(); DataTable order = MySqlFunctions.GetTable( "select tos.id, order_types.name as order_type, tos.order_datetime, " + "tables.portion, tables.name as table_name, tos.deliver_to_name, tos.deliver_to_phone, " + "tos.deliver_to_address, tos.received_through, tos.order_amount_ex_st as ex_st, " + "tos.sales_tax as st, tos.order_amount_inc_st as inc_st, " + "tos.cover, tos.discount, tos.order_amount_before_discount as before_discount " + "from tos " + "join order_types on order_types.id = tos.order_type_id " + "left join tables on tables.id = tos.table_id " + "where tos.id = " + order_id + "; ", Program.GlobalConn); string detail_query = "select tos_details.to_id as order_id, items.category, items.code as item_code , items.name as item_name, " + "tos_details.qty, tos_details.rate, tos_details.amount, tos_details.item_notes " + "from tos_details " + "join items on items.id = tos_details.item_id " + " where tos_details.to_id = " + order_id; string closingAccountsQuery = @"SELECT id, NAME, sales_tax_rate FROM closing_accounts WHERE show_on_print_for_customer = TRUE;"; if (category != "") { detail_query += " and items.category = '" + category + "' "; } DataTable detail = MySqlFunctions.GetTable(detail_query, Program.GlobalConn); DataTable closingAccounts = MySqlFunctions.GetTable(closingAccountsQuery, Program.GlobalConn); decimal discount = 0; decimal before_discount = 0; foreach (DataRow r in order.Rows) { decimal cover = r["cover"].ToString() == "" ? decimal.Parse("0") : decimal.Parse(r["cover"].ToString()); discount = r["discount"].ToString() == "" ? decimal.Parse("0") : decimal.Parse(r["discount"].ToString()); before_discount = r["before_discount"].ToString() == "" ? decimal.Parse("0") : decimal.Parse(r["before_discount"].ToString()); ds.Order.AddOrderRow( r["id"].ToString(), r["order_type"].ToString(), (System.DateTime)r["order_datetime"], r["portion"].ToString(), r["table_name"].ToString(), r["deliver_to_name"].ToString(), r["deliver_to_phone"].ToString(), r["deliver_to_address"].ToString(), r["received_through"].ToString(), (decimal)r["ex_st"], (decimal)r["st"], (decimal)r["inc_st"], cover, discount, before_discount ); } decimal after_discount = before_discount - discount; foreach (DataRow r in closingAccounts.Rows) { //NAME, sales_tax_rate int id = 0; string name = r["name"].ToString(); decimal salesTaxRate = Convert.ToDecimal(r["sales_tax_rate"]); decimal salesTaxAmount = Math.Round(after_discount * salesTaxRate / 100); decimal totalAmount = Math.Round(after_discount + salesTaxAmount); ds.TaxDetail.AddTaxDetailRow( id, name, salesTaxRate, salesTaxAmount, totalAmount ); } foreach (DataRow r in detail.Rows) { ds.OrderDetail.AddOrderDetailRow( (NewOrderDataSet.OrderRow)ds.Order.Rows[0], r["category"].ToString(), r["item_code"].ToString(), r["item_name"].ToString(), (decimal)r["qty"], (decimal)r["rate"], (decimal)r["amount"], r["item_notes"].ToString() ); } return(ds); }
private void PrintOrder(string order_id, string job_id, bool printInvoice) { PrintForCustomer report = new PrintForCustomer(); try { NewOrderDataSet ds = generateNewOrderDataSet(order_id); if (printInvoice) { string invoice_id = ""; DataTable inv_dt = null; inv_dt = MySqlFunctions.GetTable("select id from invoices where order_id = '" + ds.Order.Rows[0]["id"].ToString() + "' limit 1", Program.GlobalConn); if (inv_dt != null && inv_dt.Rows.Count > 0) { invoice_id = "Invoice:" + inv_dt.Rows[0]["id"].ToString(); } inv_dt = MySqlFunctions.GetTable("select id from ent_bills where order_id = '" + ds.Order.Rows[0]["id"].ToString() + "' limit 1", Program.GlobalConn); if (inv_dt != null && inv_dt.Rows.Count > 0) { invoice_id = "Ent Bill:" + inv_dt.Rows[0]["id"].ToString(); } if (invoice_id != "") { //report.DataDefinition.FormulaFields["invoice_id"].Text = "'" + invoice_id + "'"; } } report.SetDataSource(ds); DataTable restaurant_infoDT = MySqlFunctions.GetTable("select " + "(select `value` from settings where slug = 'restaurant_name') as 'name', " + "(select `value` from settings where slug = 'restaurant_address') as 'address', " + "(select `value` from settings where slug = 'restaurant_ntn') as 'ntn', " + "(select `value` from settings where slug = 'restaurant_stn') as 'stn'; ", Program.GlobalConn); if (restaurant_infoDT != null && restaurant_infoDT.Rows.Count > 0) { DataRow r = restaurant_infoDT.Rows[0]; //report.DataDefinition.FormulaFields["restaurant_name"].Text = "'" + r["name"].ToString() + "'"; //report.DataDefinition.FormulaFields["restaurant_address"].Text = "'" + r["address"].ToString() + "'"; //report.DataDefinition.FormulaFields["ntn"].Text = "'" + r["ntn"].ToString() + "'"; //report.DataDefinition.FormulaFields["stn"].Text = "'" + r["stn"].ToString() + "'"; } var path = System.IO.Path.GetDirectoryName(Application.ExecutablePath); var rtb = new RichTextBox(); rtb.LoadFile(path + "/header.txt"); var headerLines = rtb.Text.Split('\n'); for (int i = 0; i < headerLines.Length && i < 5; i++) { report.DataDefinition.FormulaFields["header_line" + i.ToString()].Text = "'" + headerLines[i] + "'"; } rtb.LoadFile(path + "/footer.txt"); var footerLines = rtb.Text.Split('\n'); for (int i = 0; i < footerLines.Length && i < 5; i++) { report.DataDefinition.FormulaFields["footer_line" + i.ToString()].Text = "'" + footerLines[i] + "'"; } foreach (DataRow r in pos_printers_dt.Rows) { report.PrintOptions.PrinterName = r["Printer"].ToString(); report.PrintToPrinter(1, false, 0, 0); } MySqlFunctions.SqlNonQuery("update print_jobs set executed_at = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' " + "where id = '" + job_id + "'", Program.GlobalConn); } catch (Exception ex) { MySqlFunctions.SqlNonQuery("update print_jobs set executed_at = '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "', " + " error = '" + MySql.Data.MySqlClient.MySqlHelper.EscapeString(ex.Message) + "' " + "where id = '" + job_id + "'", Program.GlobalConn); } finally { report.Dispose(); } }