private void btnHapus_Click(object sender, RoutedEventArgs e) { MessageBoxResult result = MessageBox.Show("Yakin menghapus item ini?", "Konfirmasi", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { var button = (FrameworkElement)sender; var row = (DataGridRow)button.Tag; dgTerapi.Items.RemoveAt(row.GetIndex()); double TotalTerapi = 0; dgTerapi.UpdateLayout(); for (int x = 0; x < dgTerapi.Items.Count; x++) { var rows = (DataGridRow)dgTerapi.ItemContainerGenerator.ContainerFromIndex(x); DataTerapi v = (DataTerapi)dgTerapi.Items[rows.GetIndex()]; //DataGridCell cell = DataGridHelper.GetCell(dgTerapi, x, 3); //Console.WriteLine(v.Row.ItemArray[0]); TotalTerapi += v.Biaya; //Console.WriteLine(v.Biaya); } txtTotalTerapi.Text = TotalTerapi.ToString(); decimal TotalGrand = totalTerapi + totalObat; //txtGrandTotal.Text = TotalGrand.ToString(); txtGrandTotal.Text = HitungGrandTotal(Convert.ToDouble(TotalGrand), double.Parse(txtDiskon.Text), double.Parse(txtCard.Text)).ToString(); } }
private void AddItemCallbackAmbilDataTerapi(string persen, string nama, double biaya) { /* * DataTable dt = new DataTable(); * dt.Columns.Add("NamaTerapi"); * dt.Columns.Add("Biaya"); * DataRow newRow = dt.NewRow(); * * newRow["NamaTerapi"] = nama; * newRow["Biaya"] = biaya; * //dt.Rows.Add(newRow); * dt.ImportRow(newRow); * dgTerapi.ItemsSource = dt.DefaultView; * */ double TotalTerapi = 0; dgTerapi.Items.Add(new DataTerapi { NamaTerapi = nama, Biaya = biaya }); dgTerapi.UpdateLayout(); for (int x = 0; x < dgTerapi.Items.Count; x++) { var row = (DataGridRow)dgTerapi.ItemContainerGenerator.ContainerFromIndex(x); DataTerapi v = (DataTerapi)dgTerapi.Items[row.GetIndex()]; //DataGridCell cell = DataGridHelper.GetCell(dgTerapi, x, 3); //Console.WriteLine(v.Row.ItemArray[0]); TotalTerapi += v.Biaya; //Console.WriteLine(v.Biaya); } txtTotalTerapi.Text = TotalTerapi.ToString(); }
private void btn_tambah_Click(object sender, RoutedEventArgs e) { try { if (txtKWT.Text != string.Empty && txtNamaPasien.Text != string.Empty && cmbNamaDokter.SelectedIndex != -1) { if (dgTerapi.Items.Count > 0 || dgObat.Items.Count > 0) { string invoice_order = UnixTimeNow().ToString(); string grandTotal = txtGrandTotal.Text.Replace("Rp", "").Replace(".", "").Replace(",", ""); string totalObat = txtTotalObat.Text.Replace("Rp", "").Replace(".", "").Replace(",", ""); string totalRekap = txtTotalTerapi.Text.Replace("Rp", "").Replace(".", "").Replace(",", ""); koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); //Terapi for (int x = 0; x < dgTerapi.Items.Count; x++) { var row = (DataGridRow)dgTerapi.ItemContainerGenerator.ContainerFromIndex(x); DataTerapi v = (DataTerapi)dgTerapi.Items[row.GetIndex()]; // ParameterData dalam bentuk Array (Menyesuakian Database) param = new ParameterData[] { new ParameterData("invoice_rekapterapi", invoice_order), new ParameterData("tanggal_rekapterapi", datePick.SelectedDate), new ParameterData("nokwt_rekapterapi", txtKWT.Text), new ParameterData("namaterapi_rekapterapi", v.NamaTerapi), new ParameterData("namapasien_rekapterapi", txtNamaPasien.Text), new ParameterData("namadokter_rekapterapi", cmbNamaDokter.Text), new ParameterData("qty_rekapterapi", 1), new ParameterData("card_rekapterapi", txtCard.Text), new ParameterData("diskon_rekapterapi", txtDiskon.Text), new ParameterData("total_rekapterapi", totalRekap), new ParameterData("grandtotal_rekapterapi", grandTotal) }; koneksi.InsertRow(SettingHelper.database, "tbl_rekapterapi", true, param); // Penting ketika melakukan fungsi InsertRow, kalau tidak dicommit data gk akan masuk ke database koneksi.Commit(true); // melaksanakan fungsi delegate } for (int x = 0; x < dgObat.Items.Count; x++) { var row = (DataGridRow)dgObat.ItemContainerGenerator.ContainerFromIndex(x); DataObat v = (DataObat)dgObat.Items[row.GetIndex()]; // ParameterData dalam bentuk Array (Menyesuakian Database) param = new ParameterData[] { new ParameterData("invoice_rekapobat", invoice_order), new ParameterData("tanggal_rekapobat", datePick.SelectedDate), new ParameterData("nokwt_rekapobat", txtKWT.Text), new ParameterData("namapasien_rekapobat", txtNamaPasien.Text), new ParameterData("namadokter_rekapobat", cmbNamaDokter.Text), new ParameterData("namaobat_rekapobat", v.NamaObat), new ParameterData("qty_rekapobat", v.QTY), new ParameterData("card_rekapobat", txtCard.Text), new ParameterData("diskon_rekapobat", txtCard.Text), new ParameterData("total_rekapobat", totalObat), new ParameterData("grandtotal_rekapobat", grandTotal) }; koneksi.InsertRow(SettingHelper.database, "tbl_rekapobat", true, param); // Penting ketika melakukan fungsi InsertRow, kalau tidak dicommit data gk akan masuk ke database koneksi.Commit(true); //pengurangan stok DataTable Datatable = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_obat WHERE mydentist.tbl_obat.id_obat =" + v.ID, null); int stokakhir = 0; foreach (DataRow rows in Datatable.Rows) { stokakhir = (int)rows["stok_obat"] - v.QTY; MessageBox.Show(stokakhir.ToString()); try { //koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); ParameterData[] para = new ParameterData[] { new ParameterData("stok_obat", stokakhir) }; koneksi.UpdateRow(SettingHelper.database, "tbl_obat", "id_obat=" + v.ID, 1, para); koneksi.Commit(true); }catch (Exception ex) { //MessageBox.Show(ex.Message); } } } for (int i = 0; i < dgPerawat.Items.Count; i++) { DataGridRow rows = (DataGridRow)dgPerawat.ItemContainerGenerator.ContainerFromIndex(i); CheckBox checkBox = FindChild <CheckBox>(rows, "chkSelectAll"); //checkBox.IsChecked = ((CheckBox)sender).IsChecked; if (checkBox != null && checkBox.IsChecked == true) { DataRowView v = (DataRowView)dgPerawat.Items[rows.GetIndex()]; //koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); // ParameterData dalam bentuk Array (Menyesuakian Database) param = new ParameterData[] { new ParameterData("nama_perawat", (string)v[1].ToString()), new ParameterData("id_perawat", (string)v[0].ToString()), new ParameterData("tanggal_rekapperawat", datePick.SelectedDate), new ParameterData("invoice_rekapperawat", invoice_order), new ParameterData("nokwt_rekapperawat", txtKWT.Text) }; koneksi.InsertRow(SettingHelper.database, "tbl_rekapperawat", true, param); // Penting ketika melakukan fungsi InsertRow, kalau tidak dicommit data gk akan masuk ke database koneksi.Commit(true); // koneksi.Dispose(); } } koneksi.Dispose(); MessageBox.Show("Data transaki berhasil disimpan", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); ClearAll(); } else { MessageBox.Show("Mohon data field diisi !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Error); } } else { MessageBox.Show("Mohon data field diisi !", "Informasi", MessageBoxButton.OK, MessageBoxImage.Error); } }catch (Exception ex) { MessageBox.Show(ex.Message); } }