//TOMBOL PRINT AKAN MEMANGGIL KE METHOD INI, berguna untuk memanggil method print public void coba_print() { LinkApi link = new LinkApi(); try { PrintDialog printDialog = new PrintDialog(); PrintDocument printDocument = new PrintDocument(); printDialog.Document = printDocument; //add the document to the dialog box... printDocument.PrinterSettings.PrinterName = link.printer_name; //try_bi.Properties.Settings.Default.mPrinter;//seting nama printer printDocument.PrintPage += new PrintPageEventHandler(CreateReceipt); //add an event handler that will do the printing printDocument.Print(); } catch (Exception ex) { //MessageBox.Show("Your Printer Name Is Unavailable", "Error Message", MessageBoxButtons.OK, MessageBoxIcon.Error); //MessageBox.Show("Can't connect to the printer: " + try_bi.Properties.Settings.Default.mPrinter); MessageBox.Show("Can't connect to the printer #{" + link.printer_name /*try_bi.Properties.Settings.Default.mPrinter*/ + "}#" + ex.ToString()); var appLog = new System.Diagnostics.EventLog("Pos Biensi"); appLog.Source = "Printer"; appLog.WriteEntry(ex.Message); //MessageBox.Show(ex.ToString()); } }
//========================================================================= private void b_print_Click(object sender, EventArgs e) { ckon.con.Close(); LinkApi ls = new LinkApi(); if (ls.print_default == "1") { PrintThermal print = new PrintThermal(); print.get_trans_id(id_list); print.get_nm_store(); print.get_currency(); print.get_trans_header(); print.coba_print(); } else { NewFunctionPrinter print = new NewFunctionPrinter(); print.get_trans_id(id_list); print.get_nm_store(); print.get_currency(); print.get_trans_header(); print.coba_print(); } }
//============================================================================== //private void b_stockTake_Click(object sender, EventArgs e) //{ // //Jika POS tersebut bukan PC Master maka menu ini tidak bisa diakses // if (Properties.Settings.Default.MstrOrChld == "Child") // { // MessageBox.Show("This Menu Can Only Be Accessed By A Master PCss", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); // } // else // { // label3.Text = "Stock Take"; // UC_Stock_Take c = new UC_Stock_Take(this); // p_kanan.Controls.Clear(); // if (!p_kanan.Controls.Contains(UC_Stock_Take.Instance)) // { // p_kanan.Controls.Add(UC_Stock_Take.Instance); // UC_Stock_Take.Instance.Dock = DockStyle.Fill; // //UC_Stock_Take.Instance.from_form1(); // UC_Stock_Take.Instance.id_employee2 = id_employee; // UC_Stock_Take.Instance.nm_employee2 = nama_employee; // //UC_Stock_Take.Instance.retreive(sql); // UC_Stock_Take.Instance.BringToFront(); // } // else // { // //UC_Stock_Take.Instance.from_form1(); // UC_Stock_Take.Instance.id_employee2 = id_employee; // UC_Stock_Take.Instance.nm_employee2 = nama_employee; // //UC_Stock_Take.Instance.retreive(sql); // UC_Stock_Take.Instance.BringToFront(); // } // } //} //============================================================================== private void b_deliveryCust_Click(object sender, EventArgs e) { LinkApi link = new LinkApi(); API_DeliveryCustomer deliv_cust = new API_DeliveryCustomer(); //Jika POS tersebut bukan PC Master maka menu ini tidak bisa diakses if (Properties.Settings.Default.MstrOrChld == "Child") { MessageBox.Show("This Menu Can Only Be Accessed By A Master PCss", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { deliv_cust.getDeliveryCust(link.storeId).Wait(); label3.Text = "Delivery Customer"; p_kanan.Controls.Clear(); if (!p_kanan.Controls.Contains(UC_DeliveryCustomer.Instance)) { p_kanan.Controls.Add(UC_DeliveryCustomer.Instance); UC_DeliveryCustomer.Instance.Dock = DockStyle.Fill; UC_DeliveryCustomer.Instance.new_(); UC_DeliveryCustomer.Instance.holding(); UC_DeliveryCustomer.Instance.BringToFront(); } else { UC_DeliveryCustomer.Instance.new_(); UC_DeliveryCustomer.Instance.holding(); UC_DeliveryCustomer.Instance.BringToFront(); } } }
public SqlConnection sqlConMsg() { LinkApi xmlCon = new LinkApi(); String connectionString = ""; connectionString = "Data Source='" + xmlCon.host_db + "';Initial Catalog='" + xmlCon.msg_db + "';User ID='" + xmlCon.user_db + "';Password='******'"; SqlConnection sqlConMsg = new SqlConnection(connectionString); return(sqlConMsg); }
private void checkConnectionString() { LinkApi xmlCon = new LinkApi(); AppSetting setting = new AppSetting(); String exist_con = setting.GetConnectionString("BiensiPosDbDataContextConnectionString"); String new_con = string.Format("User Id={0};Password={1};Host={2};Database={3};Persist Security Info=True", xmlCon.user_db, xmlCon.pass_db, xmlCon.host_db, xmlCon.name_db); if (exist_con != new_con) { //save connection setting.SaveConnectionString("BiensiPosDbDataContextConnectionString", new_con); Application.Restart(); } }
//====================================================================== private void payment_Load(object sender, EventArgs e) { string command; LinkApi link = new LinkApi(); this.ActiveControl = textBox1; textBox1.Focus(); type = "Cash"; try { ckon.sqlCon().Open(); command = "SELECT * FROM store"; CRUD sql = new CRUD(); ckon.sqlDataRd = sql.ExecuteDataReader(command, ckon.sqlCon()); if (ckon.sqlDataRd.HasRows) { while (ckon.sqlDataRd.Read()) { store_code = ckon.sqlDataRd["CODE"].ToString(); store_name = ckon.sqlDataRd["NAME"].ToString(); store_add = ckon.sqlDataRd["ADDRESS"].ToString(); } } else { store_code = link.storeId; } } catch (Exception er) { MessageBox.Show(er.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (ckon.sqlDataRd != null) { ckon.sqlDataRd.Close(); } if (ckon.sqlCon().State == ConnectionState.Open) { ckon.sqlCon().Close(); } } }
//======AMBIL TOTAL DISCOUNT DARI TRANSAKSI HEADER SESUAI TERANSAKSI ID=== public void ambil_discount_subtotal() { CRUD sql = new CRUD(); LinkApi xmlCon = new LinkApi(); try { ckon.sqlCon().Open(); //String cmd = "SELECT * FROM [transaction] WHERE TRANSACTION_ID='" + id_transaksi3 + "'"; String cmd = "SELECT SUM(DISCOUNTAMOUNT) as DISCOUNT, SUM(SUBTOTAL) as SUBTOTAL FROM [Tmp]." + xmlCon.storeId + " WHERE TRANSACTION_ID='" + id_transaksi3 + "'"; ckon.sqlDataRd = sql.ExecuteDataReader(cmd, ckon.sqlCon()); if (ckon.sqlDataRd.HasRows) { while (ckon.sqlDataRd.Read()) { tot_diskon = Convert.ToInt32(ckon.sqlDataRd["DISCOUNT"]); tot_bel = Convert.ToInt32(ckon.sqlDataRd["SUBTOTAL"]); } } } catch (Exception e) { MessageBox.Show(e.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (ckon.sqlDataRd != null) { ckon.sqlDataRd.Close(); } if (ckon.sqlCon().State == ConnectionState.Open) { ckon.sqlCon().Close(); } } //ckon.cmd = new MySqlCommand(sql, ckon.con); //ckon.con.Open(); //ckon.myReader = ckon.cmd.ExecuteReader(); //while(ckon.myReader.Read()) //{ // tot_diskon = ckon.myReader.GetInt32("DISCOUNT"); //} //ckon.con.Close(); }
//================================================================================== //======================LIST HOLD TRANSACTION============================================ public void holding() { CRUD sql = new CRUD(); LinkApi link = new LinkApi(); dgv_Pending.Rows.Clear(); try { ckon.sqlCon().Open(); String cmd = "SELECT * FROM deliverycustomer a JOIN deliverycustomer_line b " + "ON a.DELIVERY_CUST_ID = b.DELIVERY_CUST_ID " + "WHERE STATUS = '0' AND STORE_FROM = '" + link.storeId + "'"; ckon.sqlDataRd = sql.ExecuteDataReader(cmd, ckon.sqlCon()); if (ckon.sqlDataRd.HasRows) { while (ckon.sqlDataRd.Read()) { id_trans = ckon.sqlDataRd["DELIVERY_CUST_ID"].ToString(); date = ckon.sqlDataRd["DATE"].ToString(); int dgRows = dgv_Pending.Rows.Add(); dgv_Pending.Rows[dgRows].Cells[0].Value = id_trans; dgv_Pending.Rows[dgRows].Cells[1].Value = date; } } } catch (Exception e) { MessageBox.Show(e.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { if (ckon.sqlDataRd != null) { ckon.sqlDataRd.Close(); } if (ckon.sqlCon().State == ConnectionState.Open) { ckon.sqlCon().Close(); } } }
//====================================================================== public void fungsi_cetak_struk() { LinkApi ls = new LinkApi(); if (ls.print_default == "1") { PrintThermal print = new PrintThermal(); print.get_trans_id(id_trans); print.get_nm_store(); print.get_currency(); print.get_trans_header(); print.coba_print(); } else { NewFunctionPrinter print = new NewFunctionPrinter(); print.get_trans_id(id_trans); print.get_nm_store(); print.get_currency(); print.get_trans_header(); print.coba_print(); } }
private void LinkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { LinkApi ls = new LinkApi(); string printer_name = ls.printer_name; MessageBox.Show("{System: '" + nm_printer.Text + "' #Entry: '" + printer_name + "'}"); if (printer_name != nm_printer.Text && printer_name != "") { MessageBox.Show("Masukkan nama printer dan klik save dibawah. Buka kembali aplikasi dan test print. {System: '" + nm_printer.Text + "' #Entry: '" + printer_name + "'}"); } else if (printer_name == "") { MessageBox.Show("Masukkan nama printer dan klik save dibawah. Buka kembali aplikasi dan test print. {System: '" + nm_printer.Text + "' #Entry: '" + printer_name + "'}"); } else { Cursor.Current = Cursors.WaitCursor; Coba_Print_Baru print = new Coba_Print_Baru(); print.coba_print(); Cursor.Current = Cursors.Default; } }