public void InsertSalesReceipt(SalesReceiptDTO salesReceipt) { try { SalesReceiptDAO.Instance.InsertSalesReceipt(salesReceipt); } catch (MySqlException ex) { throw new BUSException(ex.Message); } }
public MySqlDataReader InsertSalesReceipt(SalesReceiptDTO salesReceipt) { try { // query string query = string.Format("insert into SALESRECEIPT values('{0}', (select CustomerID from CUSTOMER where CustomerID='{1}'),'{2}',(select StaffID from Staff where StaffID='{3}'))", salesReceipt.ID, salesReceipt.CustomerID, string.Format("{0}-{1}-{2}", salesReceipt.DateCosted.Year, salesReceipt.DateCosted.Month, salesReceipt.DateCosted.Day), salesReceipt.StaffID); // excute query MySqlDataReader reader = MySqlConnectionDAO.Instance.ExcuteQuery(query); return(reader); } finally { } }
private void buttonInHoaDon_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(textBoxTenNhanVien.Text)) { MessageBox.Show("Xin hãy nhập mã nhân viên", "!!!!", MessageBoxButton.OK, MessageBoxImage.Warning); return; } string maKhachHang = textBoxMaKhachHang.Text; if (string.IsNullOrEmpty(textBoxTenKhachHang.Text)) { if (MessageBox.Show("Bạn chưa nhập hoặc chưa nhập đúng mã khách hàng, bạn có chắc chắn muốn in hóa đơn không?", "!!!!", MessageBoxButton.YesNo, MessageBoxImage.Warning, MessageBoxResult.No) == MessageBoxResult.No) { maKhachHang = "0000"; return; } } try { //Insert sales receipt SalesReceiptDTO salesReceipt = new SalesReceiptDTO(SalesReceiptBUS.Instance.GetNewSalesReceiptID(), datePicker.SelectedDate.Value, maKhachHang, textBoxMaNhanVien.Text); SalesReceiptBUS.Instance.InsertSalesReceipt(salesReceipt); //Insert sales detail ObservableCollection <DishInfo> table = MainWindow.Instance.UCOrder.GetCurrentTable(); for (int i = 0; i < table.Count; i++) { SalesReceiptDetailDTO salesDetail = new SalesReceiptDetailDTO(SalesDetailBUS.Instance.GetNewSalesDetailID(), salesReceipt.ID, table[i].ID, table[i].Quantity); SalesDetailBUS.Instance.InsertSalesDetail(salesDetail); } //Clear items MainWindow.Instance.UCOrder.ClearCurrentTable(); ClearCustomerInfo(); MessageBox.Show("In hóa đơn thành công", "Thành công", MessageBoxButton.OK, MessageBoxImage.Information); // create pdf file. try { // Create the print dialog object and set options PrintDialog pDialog = new PrintDialog(); pDialog.PageRangeSelection = PageRangeSelection.AllPages; pDialog.UserPageRangeEnabled = true; Nullable <bool> dialog = pDialog.ShowDialog(); // Display the dialog. This returns true if the user presses the Print button. if (dialog == true) { decimal tongTien = 0; UserControlBill userBill = new UserControlBill(); for (int i = 0; i < listDishes.Count(); i++) { tongTien += listDishes.ElementAt(i).Price; TextBlock txbSTT = new TextBlock { Text = (i + 1).ToString(), TextAlignment = TextAlignment.Center, Margin = new Thickness(0, 0, 0, marginBot) }; userBill.stackSTT.Children.Add(txbSTT); TextBlock txbTenMonAn = new TextBlock { Text = listDishes.ElementAt <DishInfo>(i).DishName, TextAlignment = TextAlignment.Center, Margin = new Thickness(0, 0, 0, marginBot) }; userBill.stackMonAn.Children.Add(txbTenMonAn); TextBlock txbSoLuong = new TextBlock { Text = listDishes.ElementAt <DishInfo>(i).Quantity.ToString(), TextAlignment = TextAlignment.Center, Margin = new Thickness(0, 0, 0, marginBot) }; userBill.stackSoLuong.Children.Add(txbSoLuong); TextBlock txbDonGia = new TextBlock { Text = listDishes.ElementAt <DishInfo>(i).UnitPrice.ToString(), TextAlignment = TextAlignment.Center, Margin = new Thickness(0, 0, 0, marginBot) }; userBill.stackDonGia.Children.Add(txbDonGia); TextBlock txbThanhTien = new TextBlock { Text = listDishes.ElementAt <DishInfo>(i).Price.ToString(), TextAlignment = TextAlignment.Center, Margin = new Thickness(0, 0, 0, marginBot) }; userBill.stackThanhTien.Children.Add(txbThanhTien); } userBill.txbTongTien.Text = tongTien.ToString("C0").Replace("$", "") + " VND"; userBill.txbThuNgan.Text = $"Thu ngân: {textBoxTenNhanVien.Text}"; userBill.txbKhachHang.Text = $"Khách hàng: {textBoxTenKhachHang.Text}"; userBill.txbBan.Text = $"Bàn: {tableNumber}"; userBill.txbTime.Text = $"Thời gian: {DateTime.Now.ToLongTimeString()}"; pDialog.PrintVisual(userBill.customerBill, "Test print job"); } } catch (Exception exception) { MessageBox.Show(exception.ToString(), "!!!", MessageBoxButton.OK, MessageBoxImage.Error); } } catch (BUSException ex) { MessageBox.Show(ex.ToString(), "!!!", MessageBoxButton.OK, MessageBoxImage.Error); } }