public PopUpDataAppointment() { InitializeComponent(); datePick.SelectedDate = DateTime.Today; DataDokter(); koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); koneksi.Dispose(); }
public PopUpDataAppointment(string IdAppointment) { InitializeComponent(); isEdit = true; DataDokter(); this.Title = "Ubah Data Appointment"; btnSimpan.Content = "Update"; IDAppoinment = IdAppointment; koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); FetchEditData(); koneksi.Dispose(); }
void ShowDataTabel() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); dgTerapi.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_terapi", null).DefaultView; ((DataGridTextColumn)dgTerapi.Columns[0]).Binding = new Binding("id_terapi"); //((DataGridTextColumn)dgUsers.Columns[1]).Binding = new Binding("id_karyawan"); ((DataGridTextColumn)dgTerapi.Columns[2]).Binding = new Binding("nama_terapi"); ((DataGridTextColumn)dgTerapi.Columns[3]).Binding = new Binding("jenis_terapi"); ((DataGridTextColumn)dgTerapi.Columns[3]).Binding.StringFormat = "{0} %"; ((DataGridTextColumn)dgTerapi.Columns[4]).Binding = new Binding("biaya_terapi"); ((DataGridTextColumn)dgTerapi.Columns[4]).Binding.StringFormat = "{0:C2}"; ((DataGridTextColumn)dgTerapi.Columns[5]).Binding = new Binding("keterangan_terapi"); //@Bahar : Harus ditutup !!! koneksi.Dispose(); }
void ShowDataTabel() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); dgTerapi.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_terapi", null).DefaultView; ((DataGridTextColumn)dgTerapi.Columns[0]).Binding = new Binding("id_terapi"); //((DataGridTextColumn)dgUsers.Columns[1]).Binding = new Binding("id_karyawan"); ((DataGridTextColumn)dgTerapi.Columns[2]).Binding = new Binding("nama_terapi"); ((DataGridTextColumn)dgTerapi.Columns[3]).Binding = new Binding("jenis_terapi"); ((DataGridTextColumn)dgTerapi.Columns[3]).Binding.StringFormat = "{0} %"; ((DataGridTextColumn)dgTerapi.Columns[4]).Binding = new Binding("biaya_terapi"); ((DataGridTextColumn)dgTerapi.Columns[4]).Binding.StringFormat = "{0:C2}"; ((DataGridTextColumn)dgTerapi.Columns[5]).Binding = new Binding("keterangan_terapi"); //@Bahar : Harus ditutup !!! koneksi.Dispose(); }
private void Status_Click(object sender, RoutedEventArgs e) { var button = (FrameworkElement)sender; var row = (DataGridRow)button.Tag; ((CheckBox)sender).IsChecked = !((CheckBox)sender).IsChecked; //MessageBox.Show(((CheckBox)sender).IsChecked.ToString()); MessageBoxResult result = MessageBox.Show("Ubah Status Appointment?", "Konfirmasi", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); //Update Status database ((CheckBox)sender).IsChecked = !((CheckBox)sender).IsChecked; bool statusbool = (bool)((CheckBox)sender).IsChecked; int status; if (statusbool) { status = 1; } else { status = 0; } ParameterData[] parameter = new ParameterData[] { new ParameterData("status_appo", status) }; koneksi.UpdateRow(SettingHelper.database, "tbl_appointment", "id_appo=" + GetIndexKaryawan(row), 0, parameter); koneksi.Commit(true); //AddItemCallback(); koneksi.Dispose(); MessageBox.Show("Data status appointment berhasil diubah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); //Warna(); //MessageBox.Show(GetIndexKaryawan(row)); } }
void ShowDataTabelFilter(string tahun, string bulan) { rekapObats.Clear(); try{ dgRekapData.ItemsSource = null; DataTable CmbxData = new DataTable(); koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); CmbxData = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_obat RIGHT JOIN mydentist.tbl_rekapobat ON mydentist.tbl_rekapobat.namaobat_rekapobat=mydentist.tbl_obat.nama_obat WHERE MONTH(mydentist.tbl_rekapobat.tanggal_rekapobat) = " + (cmbBulan.SelectedIndex + 1) + " AND YEAR(mydentist.tbl_rekapobat.tanggal_rekapobat) =" + tahun, null); DataTable CmbxDataPerawat = new DataTable(); for (int i = 0; i < CmbxData.Rows.Count; i++) { DateTime dt = DateTime.Parse(CmbxData.Rows[i]["tanggal_rekapobat"].ToString()); string format = "dd MMMM yyyy"; rekapObats.Add(new RekapObat { Tanggal = dt.ToString(format), NamaPasien = CmbxData.Rows[i]["namapasien_rekapobat"].ToString(), NamaObat = CmbxData.Rows[i]["namaobat_rekapobat"].ToString(), Jenis = "Obat", QTY = (int)CmbxData.Rows[i]["qty_rekapobat"], Tarif = (double)CmbxData.Rows[i]["total_rekapobat"] }); } dgRekapData.ItemsSource = rekapObats; koneksi.Dispose(); } catch (Exception ex) { //Warna(); dgRekapData.ItemsSource = null; //dgAppo.Items.Refresh(); koneksi.Dispose(); } //Warna(); }
void DataDokter() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); CmbxData = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_karyawan WHERE mydentist.tbl_karyawan.jenis_karyawan = 'Dokter'", null); //cmbNamaDokter.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_karyawan WHERE mydentist.tbl_karyawan.jenis_karyawan = 'Dokter'", null).DefaultView; //cmbNamaDokter.DisplayMemberPath = "nama_karyawan"; //cmbNamaDokter.DataContext = "nama_karyawan"; //cmbNamaDokter..valu = "nama_karyawan"; List <string> studentList = new List <string>(); for (int i = 0; i < CmbxData.Rows.Count; i++) { cmbNamaDokter.Items.Add(CmbxData.Rows[i]["nama_karyawan"].ToString()); } koneksi.Dispose(); }
void ShowPerawat() { try { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); dgPerawat.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_karyawan WHERE mydentist.tbl_karyawan.jenis_karyawan = 'Perawat'", null).DefaultView; ((DataGridTextColumn)dgPerawat.Columns[0]).Binding = new Binding("id_karyawan"); //((DataGridTextColumn)dgUsers.Columns[1]).Binding = new Binding("id_karyawan"); ((DataGridTextColumn)dgPerawat.Columns[1]).Binding = new Binding("nama_karyawan"); //((DataGridCheckBoxColumn)dgPerawat.Columns[3]).Binding = new Binding("jenis_karyawan"); // Harus ditutup !!! koneksi.Dispose(); } catch (Exception e) { } }
private void btnHapus_Click(object sender, RoutedEventArgs e) { var button = (FrameworkElement)sender; var row = (DataGridRow)button.Tag; if (dgPasien.SelectedCells.Count > 0) { MessageBoxResult result = MessageBox.Show("Hapus Data Pasien?", "Konfirmasi", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); koneksi.SendQuery("DELETE FROM mydentist.tbl_pasien WHERE mydentist.tbl_pasien.id_pasien = " + GetIndexpasien(row), null); koneksi.Commit(true); ShowDataTabel(); koneksi.Dispose(); } } }
void SimpanNew() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); param = new ParameterData[] { new ParameterData("norm_pasien", txtNoRM.Text), new ParameterData("nama_pasien", txtNama.Text), new ParameterData("alamat_pasien", txtAlamat.Text), new ParameterData("telp_pasien", txtTelp.Text), new ParameterData("keterangan_pasien", txtKeterangan.Text) }; koneksi.InsertRow(SettingHelper.database, "tbl_pasien", true, param); //@Bahar : Penting ketika melakukan fungsi InsertRow, kalau tidak dicommit data gk akan masuk ke database koneksi.Commit(true); //@Bahar : melaksanakan fungsi delegate AddItemCallback(); koneksi.Dispose(); this.Close(); MessageBox.Show("Data pasien berhasil ditambah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); }
void EditUpdate() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); param = new ParameterData[] { new ParameterData("id_pasien", IDPasien), new ParameterData("jam_appo", dJam), new ParameterData("tanggal_appo", datePick.SelectedDate), new ParameterData("norm_appo", txtNoRm.Text), new ParameterData("namapasien_appo", txtNamaPasien.Text), new ParameterData("namadokter_appo", cmbNamaDokter.SelectedItem), new ParameterData("status_appo", status), new ParameterData("keterangan_appo", txtKeterangan.Text) }; koneksi.UpdateRow(SettingHelper.database, "tbl_appointment", "id_appo =" + IDAppoinment, 0, param); koneksi.Commit(true); AddItemCallback(); koneksi.Dispose(); this.Close(); MessageBox.Show("Data appointment berhasil diubah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); }
void SimpanNew() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); //@Bahar : ParameterData dalam bentuk Array (Menyesuakian Database) param = new ParameterData[] { new ParameterData("nama_terapi", txtNama.Text), new ParameterData("jenis_terapi", txtJenis.Text), new ParameterData("biaya_terapi", biayaAngka), new ParameterData("keterangan_terapi", txtKeterangan.Text) }; koneksi.InsertRow(SettingHelper.database, "tbl_terapi", true, param); //@Bahar : Penting ketika melakukan fungsi InsertRow, kalau tidak dicommit data gk akan masuk ke database koneksi.Commit(true); //@Bahar : melaksanakan fungsi delegate AddItemCallback(); koneksi.Dispose(); this.Close(); MessageBox.Show("Data terapi berhasil ditambah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); }
private void txtPencarian_TextChanged(object sender, TextChangedEventArgs e) { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); dgPasien.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_pasien WHERE " + "mydentist.tbl_pasien.norm_pasien LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_pasien.nama_pasien LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_pasien.alamat_pasien LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_pasien.telp_pasien LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_pasien.keterangan_pasien LIKE '%" + txtPencarian.Text + "%'", null).DefaultView; ((DataGridTextColumn)dgPasien.Columns[0]).Binding = new Binding("id_pasien"); //((DataGridTextColumn)dgUsers.Columns[1]).Binding = new Binding("id_pasien"); ((DataGridTextColumn)dgPasien.Columns[2]).Binding = new Binding("norm_pasien"); ((DataGridTextColumn)dgPasien.Columns[3]).Binding = new Binding("nama_pasien"); ((DataGridTextColumn)dgPasien.Columns[4]).Binding = new Binding("alamat_pasien"); ((DataGridTextColumn)dgPasien.Columns[5]).Binding = new Binding("telp_pasien"); ((DataGridTextColumn)dgPasien.Columns[6]).Binding = new Binding("keterangan_pasien"); //@Bahar : Harus ditutup !!! koneksi.Dispose(); }
private void btnHapus_Click(object sender, RoutedEventArgs e) { var button = (FrameworkElement)sender; var row = (DataGridRow)button.Tag; if (dgTerapi.SelectedCells.Count > 0) { MessageBoxResult result = MessageBox.Show("Hapus Data Terapi?", "Konfirmasi", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); koneksi.SendQuery("DELETE FROM mydentist.tbl_terapi WHERE mydentist.tbl_terapi.id_terapi = " + GetIndexpasien(row), null); koneksi.Commit(true); ShowDataTabel(); koneksi.Dispose(); } } }
private void txtPencarian_TextChanged(object sender, TextChangedEventArgs e) { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); dgTerapi.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_terapi WHERE " + "mydentist.tbl_terapi.nama_terapi LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_terapi.jenis_terapi LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_terapi.biaya_terapi LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_terapi.keterangan_terapi LIKE '%" + txtPencarian.Text + "%'", null).DefaultView; ((DataGridTextColumn)dgTerapi.Columns[0]).Binding = new Binding("id_terapi"); //((DataGridTextColumn)dgUsers.Columns[1]).Binding = new Binding("id_karyawan"); ((DataGridTextColumn)dgTerapi.Columns[2]).Binding = new Binding("nama_terapi"); ((DataGridTextColumn)dgTerapi.Columns[3]).Binding = new Binding("jenis_terapi"); ((DataGridTextColumn)dgTerapi.Columns[3]).Binding.StringFormat = "{0} %"; ((DataGridTextColumn)dgTerapi.Columns[4]).Binding = new Binding("biaya_terapi"); ((DataGridTextColumn)dgTerapi.Columns[4]).Binding.StringFormat = "{0:C2}"; ((DataGridTextColumn)dgTerapi.Columns[5]).Binding = new Binding("keterangan_terapi"); //@Bahar : Harus ditutup !!! koneksi.Dispose(); }
void FetchEditData() { try { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); DataTable Datatable = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_obat WHERE mydentist.tbl_obat.id_obat =" + txtID.Text, null); foreach (DataRow row in Datatable.Rows) { //MessageBox.Show(row["nama_karyawan"].ToString()); txtNama.Text = row["nama_obat"].ToString(); cmbJenis.SelectedItem = row["jenis_obat"].ToString(); txtHargaBeli.Text = row["hargabeli_obat"].ToString(); txtHargaJual.Text = row["hargajual_obat"].ToString(); txtStok.Text = row["stok_obat"].ToString(); txtKeterangan.Text = row["keterangan_obat"].ToString(); } koneksi.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
void SimpanNew() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); param = new ParameterData[] { new ParameterData("nama_obat", txtNama.Text), new ParameterData("jenis_obat", cmbJenis.SelectedItem), new ParameterData("hargabeli_obat", biayaBeliAngka), new ParameterData("hargajual_obat", biayaJualAngka), new ParameterData("stok_obat", txtStok.Text), new ParameterData("keterangan_obat", txtKeterangan.Text) }; koneksi.InsertRow(SettingHelper.database, "tbl_obat", true, param); //@Bahar : Penting ketika melakukan fungsi InsertRow, kalau tidak dicommit data gk akan masuk ke database koneksi.Commit(true); //@Bahar : melaksanakan fungsi delegate AddItemCallback(); koneksi.Dispose(); this.Close(); MessageBox.Show("Data obat berhasil ditambah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); }
void FetchEditData() { Thread.CurrentThread.CurrentCulture = new CultureInfo("id-ID"); koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); DataTable Datatable = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_appointment WHERE mydentist.tbl_appointment.id_appo = " + IDAppoinment, null); foreach (DataRow row in Datatable.Rows) { //MessageBox.Show(row["nama_karyawan"].ToString()); IDPasien = row["id_pasien"].ToString(); DateTime t = DateTime.Parse(row["jam_appo"].ToString()); txtJam.Text = string.Format("{0:HH:mm}", t); status = row["status_appo"].ToString(); datePick.Text = row["tanggal_appo"].ToString(); txtNoRm.Text = row["norm_appo"].ToString(); txtNamaPasien.Text = row["namapasien_appo"].ToString(); cmbNamaDokter.SelectedValue = row["namadokter_appo"].ToString(); //txtAlamat.Text = row["alamat_karyawan"].ToString(); //txtTelp.Text = row["telp_karyawan"].ToString(); txtKeterangan.Text = row["keterangan_appo"].ToString(); } }
void FetchEditData() { try { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); DataTable Datatable = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_obat WHERE mydentist.tbl_obat.id_obat =" + txtID.Text, null); foreach (DataRow row in Datatable.Rows) { //MessageBox.Show(row["nama_karyawan"].ToString()); txtNama.Text = row["nama_obat"].ToString(); cmbJenis.SelectedItem = row["jenis_obat"].ToString(); txtHargaBeli.Text = row["hargabeli_obat"].ToString(); txtHargaJual.Text = row["hargajual_obat"].ToString(); txtStok.Text = row["stok_obat"].ToString(); txtKeterangan.Text = row["keterangan_obat"].ToString(); } koneksi.Dispose(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
void EditUpdate() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); param = new ParameterData[] { new ParameterData("nama_obat", txtNama.Text), new ParameterData("jenis_obat", cmbJenis.SelectedItem), new ParameterData("hargabeli_obat", biayaBeliAngka), new ParameterData("hargajual_obat", biayaJualAngka), new ParameterData("stok_obat", txtStok.Text), new ParameterData("keterangan_obat", txtKeterangan.Text)}; koneksi.UpdateRow(SettingHelper.database, "tbl_obat", "id_obat=" + txtID.Text, 0, param); koneksi.Commit(true); AddItemCallback(); koneksi.Dispose(); this.Close(); MessageBox.Show("Data obat berhasil diubah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); }
//public virtual void Show(){ //ShowDataTabel(); //} public void ShowDataTabel() { try { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); dgAppo.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_appointment WHERE mydentist.tbl_appointment.tanggal_appo = CURDATE() AND mydentist.tbl_appointment.status_appo = 0 ORDER BY CAST(mydentist.tbl_appointment.tanggal_appo as datetime),CAST(mydentist.tbl_appointment.jam_appo as time) ASC", null).DefaultView; ((DataGridTextColumn)dgAppo.Columns[0]).Binding = new Binding("id_appo"); //((DataGridTextColumn)dgAppo.Columns[1]).Binding = new Binding("id_pasien"); ((DataGridTextColumn)dgAppo.Columns[2]).Binding = new Binding("tanggal_appo"); ((DataGridTextColumn)dgAppo.Columns[2]).Binding.StringFormat = "{0:dd MMMM yyyy}"; ((DataGridTextColumn)dgAppo.Columns[3]).Binding = new Binding("jam_appo"); ((DataGridTextColumn)dgAppo.Columns[3]).Binding.StringFormat = @"hh\:mm"; ((DataGridTextColumn)dgAppo.Columns[4]).Binding = new Binding("norm_appo"); ((DataGridTextColumn)dgAppo.Columns[5]).Binding = new Binding("namapasien_appo"); ((DataGridTextColumn)dgAppo.Columns[6]).Binding = new Binding("namadokter_appo"); //((DataGridCheckBoxColumn)dgAppo.Columns[7]).Binding = new Binding("status_appo") { Converter = new ItemCodeToBoolConverter() }; ((DataGridTextColumn)dgAppo.Columns[7]).Binding = new Binding("keterangan_appo"); //@Bahar : Harus ditutup !!! koneksi.Dispose(); //MessageBox.Show(); } catch (Exception e) { dgAppo.ItemsSource = null; //dgAppo.Items.Refresh(); koneksi.Dispose(); //MessageBox.Show(e.Message); } }
void SimpanNew() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); //@Bahar : ParameterData dalam bentuk Array (Menyesuakian Database) param = new ParameterData[] { new ParameterData("nama_karyawan", txtNama.Text), new ParameterData("jenis_karyawan", cmbJenis.SelectedItem), new ParameterData("alamat_karyawan", txtAlamat.Text), new ParameterData("telp_karyawan", txtTelp.Text), new ParameterData("tglmasuk_karyawan", datePick.SelectedDate), new ParameterData("keterangan_karyawan", txtKeterangan.Text)}; koneksi.InsertRow(SettingHelper.database, "tbl_karyawan", true, param); //@Bahar : Penting ketika melakukan fungsi InsertRow, kalau tidak dicommit data gk akan masuk ke database koneksi.Commit(true); //@Bahar : melaksanakan fungsi delegate AddItemCallback(); koneksi.Dispose(); this.Close(); MessageBox.Show("Data karyawan berhasil ditambah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); //@Bahar : Penting, habis melakukan koneksi harus ditutup koneksi.Dispose() !! //Jika tidak ditutup akan bertabrakan dengan koneksi lain yang aktif, alhasil Not Respond }
void DataDokter() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); DataTable CmbxData = new DataTable(); CmbxData = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_karyawan WHERE mydentist.tbl_karyawan.jenis_karyawan = 'Dokter'", null); //cmbNamaDokter.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_karyawan WHERE mydentist.tbl_karyawan.jenis_karyawan = 'Dokter'", null).DefaultView; //cmbNamaDokter.DisplayMemberPath = "nama_karyawan"; //cmbNamaDokter.DataContext = "nama_karyawan"; //cmbNamaDokter..valu = "nama_karyawan"; List<string> studentList = new List<string>(); for (int i = 0; i < CmbxData.Rows.Count; i++) { cmbNamaDokter.Items.Add(CmbxData.Rows[i]["nama_karyawan"].ToString()); } koneksi.Dispose(); }
void SimpanNew() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); //DataRowView drv = (DataRowView)cmbNamaDokter.SelectedItem; //String valueOfItem = drv["nama_karyawan"].ToString(); //@Bahar : ParameterData dalam bentuk Array (Menyesuakian Database) param = new ParameterData[] { new ParameterData("id_pasien", IDPasien), new ParameterData("jam_appo", dJam), new ParameterData("tanggal_appo", datePick.SelectedDate), new ParameterData("norm_appo", txtNoRm.Text), new ParameterData("namapasien_appo", txtNamaPasien.Text), new ParameterData("namadokter_appo", cmbNamaDokter.SelectedItem), new ParameterData("status_appo", 0), new ParameterData("keterangan_appo", txtKeterangan.Text)}; koneksi.InsertRow(SettingHelper.database, "tbl_appointment", true, param); //@Bahar : Penting ketika melakukan fungsi InsertRow, kalau tidak dicommit data gk akan masuk ke database koneksi.Commit(true); //@Bahar : melaksanakan fungsi delegate AddItemCallback(); koneksi.Dispose(); this.Close(); MessageBox.Show("Data appointment berhasil ditambah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); //@Bahar : Penting, habis melakukan koneksi harus ditutup koneksi.Dispose() !! //Jika tidak ditutup akan bertabrakan dengan koneksi lain yang aktif, alhasil Not Respond }
void FetchEditData() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); DataTable Datatable = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_karyawan WHERE mydentist.tbl_karyawan.id_karyawan = " + txtID.Text, null); foreach (DataRow row in Datatable.Rows) { //MessageBox.Show(row["nama_karyawan"].ToString()); txtNama.Text = row["nama_karyawan"].ToString(); cmbJenis.SelectedItem = row["jenis_karyawan"].ToString(); txtAlamat.Text = row["alamat_karyawan"].ToString(); txtTelp.Text = row["telp_karyawan"].ToString(); datePick.Text = row["tglmasuk_karyawan"].ToString(); txtKeterangan.Text = row["keterangan_karyawan"].ToString(); } koneksi.Dispose(); }
void SimpanNew() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); param = new ParameterData[] { new ParameterData("nama_obat", txtNama.Text), new ParameterData("jenis_obat", cmbJenis.SelectedItem), new ParameterData("hargabeli_obat", biayaBeliAngka), new ParameterData("hargajual_obat", biayaJualAngka), new ParameterData("stok_obat", txtStok.Text), new ParameterData("keterangan_obat", txtKeterangan.Text)}; koneksi.InsertRow(SettingHelper.database, "tbl_obat", true, param); //@Bahar : Penting ketika melakukan fungsi InsertRow, kalau tidak dicommit data gk akan masuk ke database koneksi.Commit(true); //@Bahar : melaksanakan fungsi delegate AddItemCallback(); koneksi.Dispose(); this.Close(); MessageBox.Show("Data obat berhasil ditambah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); }
private void dgTerapi_CurrentCellChanged(object sender, EventArgs e) { if (v != null) { v.EndEdit(); string StandartMasuk1 = "06:30:00"; DateTime s1 = DateTime.Parse(StandartMasuk1); string StandartMasuk2 = "4:30:00"; DateTime s2 = DateTime.Parse(StandartMasuk2); string Msk1 = (string)v[4].ToString(); DateTime m1 = DateTime.Parse(Msk1); string Plg1 = (string)v[5].ToString(); DateTime p1 = DateTime.Parse(Plg1); string Msk2 = (string)v[6].ToString(); DateTime m2 = DateTime.Parse(Msk2); string Plg2 = (string)v[7].ToString(); DateTime p2 = DateTime.Parse(Plg2); double TotalP1_M1 = (p1.TimeOfDay - m1.TimeOfDay).TotalHours; double TotalP2_M2 = (p2.TimeOfDay - m2.TimeOfDay).TotalHours; double total = 0; double jumlah = TotalP1_M1 + TotalP2_M2; TimeSpan LT; // = TimeSpan.FromHours(total); TimeSpan OT; // = TimeSpan.FromHours(total); TimeSpan RumusJumlah = TimeSpan.FromHours(jumlah); //MessageBox.Show((TotalP2_M2).ToString()); if (TotalP2_M2 == 0) { total = ((s1.TimeOfDay.TotalHours - TotalP1_M1)); } if (TotalP1_M1 == 0) { total = ((s2.TimeOfDay.TotalHours - TotalP2_M2)); } if (TotalP2_M2 != 0 && TotalP1_M1 != 0) { total = ((s1.TimeOfDay.TotalHours - TotalP1_M1) + (s2.TimeOfDay.TotalHours - TotalP2_M2)); } if (total >= 0) { LT = TimeSpan.FromHours(total); OT = TimeSpan.Zero; } else { OT = TimeSpan.FromHours(total); LT = TimeSpan.Zero; } //MessageBox.Show((string)v[4].ToString()); koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); param = new ParameterData[] { new ParameterData("masuk1_presensi", TimeSpan.ParseExact((string)v[4].ToString(), "c", null)), new ParameterData("pulang1_presensi", TimeSpan.ParseExact((string)v[5].ToString(), "c", null)), new ParameterData("masuk2_presensi", TimeSpan.ParseExact((string)v[6].ToString(), "c", null)), new ParameterData("pulang2_presensi", TimeSpan.ParseExact((string)v[7].ToString(), "c", null)), new ParameterData("ot_presensi", OT), new ParameterData("lt_presensi", LT), new ParameterData("jumlah_presensi", RumusJumlah) }; koneksi.UpdateRow(SettingHelper.database, "tbl_presensi", "id_presensi=" + (string)v[0].ToString(), 0, param); koneksi.Commit(true); ShowDataTabel(); /* * double TotalJumlah = 0; * DateTime d = new DateTime(); * for (int x = 0; x < dgTerapi.Items.Count; x++) * { * * var rows = (DataGridRow)dgTerapi.ItemContainerGenerator.ContainerFromIndex(x); * * DataRowView vx = (DataRowView)dgTerapi.Items[x]; * DateTime t = DateTime.Parse((string)vx[10].ToString()); * * //d = d + t.TimeOfDay; * * TotalJumlah += (d.TimeOfDay + t.TimeOfDay).TotalHours; * } * * totalJumlah.Text = TimeSpan.FromHours(TotalJumlah).ToString(); */ //MessageBox.Show("Data karyawan berhasil diubah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); koneksi.Dispose(); v = null; } }
private void txtPencarian_TextChanged(object sender, TextChangedEventArgs e) { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); dgPasien.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_pasien WHERE " + "mydentist.tbl_pasien.norm_pasien LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_pasien.nama_pasien LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_pasien.alamat_pasien LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_pasien.telp_pasien LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_pasien.keterangan_pasien LIKE '%" + txtPencarian.Text + "%'", null).DefaultView; ((DataGridTextColumn)dgPasien.Columns[0]).Binding = new Binding("id_pasien"); //((DataGridTextColumn)dgUsers.Columns[1]).Binding = new Binding("id_pasien"); ((DataGridTextColumn)dgPasien.Columns[2]).Binding = new Binding("norm_pasien"); ((DataGridTextColumn)dgPasien.Columns[3]).Binding = new Binding("nama_pasien"); ((DataGridTextColumn)dgPasien.Columns[4]).Binding = new Binding("alamat_pasien"); ((DataGridTextColumn)dgPasien.Columns[5]).Binding = new Binding("telp_pasien"); ((DataGridTextColumn)dgPasien.Columns[6]).Binding = new Binding("keterangan_pasien"); //@Bahar : Harus ditutup !!! koneksi.Dispose(); }
void ShowDataTabelFilter(string tahun, string bulan, string namakaryawan) { try { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); dgTerapi.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_presensi WHERE MONTH(mydentist.tbl_presensi.tanggal_presensi) = " + (cmbBulan.SelectedIndex + 1) + " AND YEAR(mydentist.tbl_presensi.tanggal_presensi) =" + cmbTahun.SelectedItem.ToString() + " AND mydentist.tbl_presensi.nama_presensi='" + (cmbKaryawan.SelectedItem).ToString() + "' ORDER BY id_presensi DESC", null).DefaultView; //dgTerapi.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_appointment WHERE MONTH(mydentist.tbl_appointment.tanggal_appo) = " + (cmbBulan.SelectedIndex + 1) + " AND YEAR(mydentist.tbl_appointment.tanggal_appo) =" + cmbTahun.SelectedItem.ToString() + " ORDER BY CAST(mydentist.tbl_appointment.tanggal_appo as datetime),CAST(mydentist.tbl_appointment.jam_appo as time) ASC", null).DefaultView; string format = "hh:mm"; ((DataGridTextColumn)dgTerapi.Columns[0]).Binding = new Binding("id_presensi"); //((DataGridTextColumn)dgUsers.Columns[1]).Binding = new Binding("id_pasien"); ((DataGridTextColumn)dgTerapi.Columns[1]).Binding = new Binding("tanggal_presensi"); ((DataGridTextColumn)dgTerapi.Columns[1]).Binding.StringFormat = "{0:dd}"; ((DataGridTextColumn)dgTerapi.Columns[2]).Binding = new Binding("tanggal_presensi"); ((DataGridTextColumn)dgTerapi.Columns[2]).Binding.StringFormat = "{0:dddd}"; ((DataGridTextColumn)dgTerapi.Columns[3]).Binding = new Binding("nama_presensi"); ((DataGridTextColumn)dgTerapi.Columns[4]).Binding = new Binding("masuk1_presensi"); ((DataGridTextColumn)dgTerapi.Columns[4]).Binding.StringFormat = @"hh\:mm"; ((DataGridTextColumn)dgTerapi.Columns[5]).Binding = new Binding("pulang1_presensi"); ((DataGridTextColumn)dgTerapi.Columns[5]).Binding.StringFormat = @"hh\:mm"; ((DataGridTextColumn)dgTerapi.Columns[6]).Binding = new Binding("masuk2_presensi"); ((DataGridTextColumn)dgTerapi.Columns[6]).Binding.StringFormat = @"hh\:mm"; ((DataGridTextColumn)dgTerapi.Columns[7]).Binding = new Binding("pulang2_presensi"); ((DataGridTextColumn)dgTerapi.Columns[7]).Binding.StringFormat = @"hh\:mm"; ((DataGridTextColumn)dgTerapi.Columns[8]).Binding = new Binding("ot_presensi"); ((DataGridTextColumn)dgTerapi.Columns[8]).Binding.StringFormat = @"hh\:mm"; ((DataGridTextColumn)dgTerapi.Columns[9]).Binding = new Binding("lt_presensi"); ((DataGridTextColumn)dgTerapi.Columns[9]).Binding.StringFormat = @"hh\:mm"; ((DataGridTextColumn)dgTerapi.Columns[10]).Binding = new Binding("jumlah_presensi"); ((DataGridTextColumn)dgTerapi.Columns[10]).Binding.StringFormat = @"hh\:mm"; // Harus ditutup !!! /* * double TotalJumlah = 0; * DateTime d = new DateTime(); * for (int x = 0; x < dgTerapi.Items.Count; x++) * { * * var rows = (DataGridRow)dgTerapi.ItemContainerGenerator.ContainerFromIndex(x); * * DataRowView v = (DataRowView)dgTerapi.Items[x]; * DateTime t = DateTime.Parse((string)v[10].ToString()); * * TotalJumlah = (d.Add(t.TimeOfDay).TimeOfDay).TotalHours; * } * * * totalJumlah.Text = TimeSpan.FromHours(TotalJumlah).ToString(); */ //double TotalP1_M1 = (p1.TimeOfDay - m1.TimeOfDay).TotalHours; koneksi.Dispose(); } catch (Exception e) { //Warna(); MessageBox.Show(e.Message); dgTerapi.ItemsSource = null; //dgAppo.Items.Refresh(); koneksi.Dispose(); } //Warna(); }
void EditUpdate() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); param = new ParameterData[] { new ParameterData("id_pasien", IDPasien), new ParameterData("jam_appo", dJam), new ParameterData("tanggal_appo", datePick.SelectedDate), new ParameterData("norm_appo", txtNoRm.Text), new ParameterData("namapasien_appo", txtNamaPasien.Text), new ParameterData("namadokter_appo", cmbNamaDokter.SelectedItem), new ParameterData("status_appo", status), new ParameterData("keterangan_appo", txtKeterangan.Text)}; koneksi.UpdateRow(SettingHelper.database, "tbl_appointment", "id_appo =" + IDAppoinment, 0, param); koneksi.Commit(true); AddItemCallback(); koneksi.Dispose(); this.Close(); MessageBox.Show("Data appointment berhasil diubah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); }
void FetchEditData() { Thread.CurrentThread.CurrentCulture = new CultureInfo("id-ID"); koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); DataTable Datatable = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_appointment WHERE mydentist.tbl_appointment.id_appo = " + IDAppoinment, null); foreach (DataRow row in Datatable.Rows) { //MessageBox.Show(row["nama_karyawan"].ToString()); IDPasien = row["id_pasien"].ToString(); DateTime t = DateTime.Parse(row["jam_appo"].ToString()); txtJam.Text = string.Format("{0:HH:mm}", t); status = row["status_appo"].ToString(); datePick.Text = row["tanggal_appo"].ToString(); txtNoRm.Text = row["norm_appo"].ToString(); txtNamaPasien.Text = row["namapasien_appo"].ToString(); cmbNamaDokter.SelectedValue = row["namadokter_appo"].ToString(); //txtAlamat.Text = row["alamat_karyawan"].ToString(); //txtTelp.Text = row["telp_karyawan"].ToString(); txtKeterangan.Text = row["keterangan_appo"].ToString(); } }
void CheckReminder() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); DataTable CmbxDataTanggal = new DataTable(); CmbxDataTanggal = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_appointment ORDER BY id_appo", null); if (CmbxDataTanggal.Rows.Count != 0) { for(int x=0;x<CmbxDataTanggal.Rows.Count ;x++){ if (DateTime.Parse(CmbxDataTanggal.Rows[x]["tanggal_appo"].ToString()) == DateTime.Now.Date && CmbxDataTanggal.Rows[x]["status_appo"].ToString() != "1") { if (!this.taskbarNotifier.Activate()) { this.taskbarNotifier.StayOpenMilliseconds = 5000; this.taskbarNotifier.Show(); this.taskbarNotifier.Notify(); using (var soundPlayer = new SoundPlayer(@"c:\Windows\Media\chimes.wav")) { soundPlayer.Play(); // can also use soundPlayer.PlaySync() } this.taskbarNotifier.ShowDataTabel(); } } } } koneksi.Dispose(); }
private void txtPencarian_TextChanged(object sender, TextChangedEventArgs e) { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); dgTerapi.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_terapi WHERE " + "mydentist.tbl_terapi.nama_terapi LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_terapi.jenis_terapi LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_terapi.biaya_terapi LIKE '%" + txtPencarian.Text + "%' OR " + "mydentist.tbl_terapi.keterangan_terapi LIKE '%" + txtPencarian.Text + "%'", null).DefaultView; ((DataGridTextColumn)dgTerapi.Columns[0]).Binding = new Binding("id_terapi"); //((DataGridTextColumn)dgUsers.Columns[1]).Binding = new Binding("id_karyawan"); ((DataGridTextColumn)dgTerapi.Columns[2]).Binding = new Binding("nama_terapi"); ((DataGridTextColumn)dgTerapi.Columns[3]).Binding = new Binding("jenis_terapi"); ((DataGridTextColumn)dgTerapi.Columns[3]).Binding.StringFormat = "{0} %"; ((DataGridTextColumn)dgTerapi.Columns[4]).Binding = new Binding("biaya_terapi"); ((DataGridTextColumn)dgTerapi.Columns[4]).Binding.StringFormat = "{0:C2}"; ((DataGridTextColumn)dgTerapi.Columns[5]).Binding = new Binding("keterangan_terapi"); //@Bahar : Harus ditutup !!! koneksi.Dispose(); }
void EditUpdate() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); param = new ParameterData[] { new ParameterData("nama_karyawan", txtNama.Text), new ParameterData("jenis_karyawan", cmbJenis.SelectedItem), new ParameterData("alamat_karyawan", txtAlamat.Text), new ParameterData("telp_karyawan", txtTelp.Text), new ParameterData("tglmasuk_karyawan", datePick.SelectedDate), new ParameterData("keterangan_karyawan", txtKeterangan.Text)}; koneksi.UpdateRow(SettingHelper.database, "tbl_karyawan", "id_karyawan=" + txtID.Text, 0, param); koneksi.Commit(true); AddItemCallback(); koneksi.Dispose(); this.Close(); MessageBox.Show("Data karyawan berhasil diubah", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information); }
void ShowDataTabel() { koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); dgPasien.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_pasien", null).DefaultView; ((DataGridTextColumn)dgPasien.Columns[0]).Binding = new Binding("id_pasien"); //((DataGridTextColumn)dgUsers.Columns[1]).Binding = new Binding("id_pasien"); ((DataGridTextColumn)dgPasien.Columns[2]).Binding = new Binding("norm_pasien"); ((DataGridTextColumn)dgPasien.Columns[3]).Binding = new Binding("nama_pasien"); ((DataGridTextColumn)dgPasien.Columns[4]).Binding = new Binding("alamat_pasien"); ((DataGridTextColumn)dgPasien.Columns[5]).Binding = new Binding("telp_pasien"); ((DataGridTextColumn)dgPasien.Columns[6]).Binding = new Binding("keterangan_pasien"); //@Bahar : Harus ditutup !!! koneksi.Dispose(); }
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); } }
private void txtPencarian_TextChanged(object sender, TextChangedEventArgs e) { rekapTerapi.Clear(); try { dgRekapTerapi.ItemsSource = null; DataTable CmbxData = new DataTable(); koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); CmbxData = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_terapi RIGHT JOIN mydentist.tbl_rekapterapi ON mydentist.tbl_terapi.nama_terapi=mydentist.tbl_rekapterapi.namaterapi_rekapterapi WHERE (MONTH(mydentist.tbl_rekapterapi.tanggal_rekapterapi) = " + (cmbBulan.SelectedIndex + 1) + " AND YEAR(mydentist.tbl_rekapterapi.tanggal_rekapterapi) =" + cmbTahun.SelectedItem.ToString() + ") AND (mydentist.tbl_rekapterapi.namaterapi_rekapterapi LIKE '%" + txtPencarian.Text + "%')", null); DataTable CmbxDataPerawat = new DataTable(); int kj = 0; for (int i = 0; i < CmbxData.Rows.Count; i++) { kj++; double rumusTotal1Diskon = (double)CmbxData.Rows[i]["biaya_terapi"] - (((double)CmbxData.Rows[i]["diskon_rekapterapi"] / 100) * (double)CmbxData.Rows[i]["biaya_terapi"]); double rumusTotal1Card = rumusTotal1Diskon + (((double)CmbxData.Rows[i]["card_rekapterapi"] / 100) * rumusTotal1Diskon); double rumusBiayaBahan = (double)CmbxData.Rows[i]["biaya_terapi"] * ((double)CmbxData.Rows[i]["jenis_terapi"] / 100); double totalAll = rumusTotal1Card; double MYHasilDkter = (totalAll - rumusBiayaBahan) / 2; string listperawat = string.Empty; CmbxDataPerawat = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_rekapperawat WHERE mydentist.tbl_rekapperawat.nokwt_rekapperawat = " + CmbxData.Rows[i]["nokwt_rekapterapi"].ToString(), null); for (int x = 0; x < CmbxDataPerawat.Rows.Count; x++) { listperawat += CmbxDataPerawat.Rows[x]["nama_perawat"].ToString() + ", "; } DateTime dt = DateTime.Parse(CmbxData.Rows[i]["tanggal_rekapterapi"].ToString()); string format = "dd MMMM yyyy"; rekapTerapi.Add(new RekapTerapi { KJ = kj, NoKWT = CmbxData.Rows[i]["nokwt_rekapterapi"].ToString(), Tanggal = dt.ToString(format), NoRM = CmbxData.Rows[i]["nokwt_rekapterapi"].ToString(), NamaPasien = CmbxData.Rows[i]["namapasien_rekapterapi"].ToString(), NamaTerapi = CmbxData.Rows[i]["namaterapi_rekapterapi"].ToString(), Jenis = (double)CmbxData.Rows[i]["jenis_terapi"], Biaya = (double)CmbxData.Rows[i]["biaya_terapi"], Diskon = (double)CmbxData.Rows[i]["diskon_rekapterapi"], Card = (double)CmbxData.Rows[i]["card_rekapterapi"], Total = totalAll, NamaDokter = CmbxData.Rows[i]["namadokter_rekapterapi"].ToString(), Keterangan = "", NamaPerawat = listperawat, BiayaBahan = rumusBiayaBahan, MY = MYHasilDkter, HasilDokter = MYHasilDkter }); } dgRekapTerapi.ItemsSource = rekapTerapi; koneksi.Dispose(); } catch (Exception ex) { //Warna(); dgRekapTerapi.ItemsSource = null; //dgAppo.Items.Refresh(); koneksi.Dispose(); } //Warna(); }
private void dgObat_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e) { //Cek Stock Obat try{ koneksi = new cds_MYSQLKonektor(new cds_KoneksiString(SettingHelper.host, SettingHelper.user, SettingHelper.pass, SettingHelper.port), true, System.Data.IsolationLevel.Serializable); // var rows = (DataGridRow)dgObat.ItemContainerGenerator.ContainerFromIndex(dgObat.SelectedIndex); //DataObat v = (DataObat)dgObat.Items[rows.GetIndex()]; DataObat v = ((DataObat)(dgObat.SelectedItem)); int select = dgObat.SelectedIndex; CmbxData = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_obat WHERE mydentist.tbl_obat.id_obat =" + v.ID, null); if (v.QTY > (int)CmbxData.Rows[0]["stok_obat"]) { myDataItems.Remove(v); dgObat.ItemsSource = null; myDataItems.Add(new DataObat { ID = (int)CmbxData.Rows[0]["id_obat"], QTY = tempStokEdit, NamaObat = CmbxData.Rows[0]["nama_obat"].ToString(), Biaya = (int)CmbxData.Rows[0]["hargajual_obat"] }); dgObat.ItemsSource = myDataItems; dgObat.UpdateLayout(); MessageBox.Show("Maaf, stock tidak mencukupi"); int TotalObat = 0; dgObat.UpdateLayout(); for (int x = 0; x < dgObat.Items.Count; x++) { //var row = (DataGridRow)dgObat.ItemContainerGenerator.ContainerFromIndex(x); //DataRowView v = (DataRowView)dgObat.Items[row.GetIndex()]; DataGridCell cell = DataGridHelper.GetCell(dgObat, x, 5); TextBlock tb = cell.Content as TextBlock; ///Console.WriteLine(cell); /// //MessageBox.Show(cell.ToString()); string value = tb.Text.Replace("Rp", "").Replace(".", "").Replace(",00", ""); TotalObat += int.Parse(value); } dgObat.UpdateLayout(); tempStokEdit = 0; txtTotalObat.Text = TotalObat.ToString(); } else { int TotalObat = 0; dgObat.UpdateLayout(); for (int x = 0; x < dgObat.Items.Count; x++) { //var row = (DataGridRow)dgObat.ItemContainerGenerator.ContainerFromIndex(x); //DataRowView v = (DataRowView)dgObat.Items[row.GetIndex()]; DataGridCell cell = DataGridHelper.GetCell(dgObat, x, 5); TextBlock tb = cell.Content as TextBlock; ///Console.WriteLine(cell); /// //MessageBox.Show(cell.ToString()); string value = tb.Text.Replace("Rp", "").Replace(".", "").Replace(",00", ""); TotalObat += int.Parse(value); } txtTotalObat.Text = TotalObat.ToString(); } } catch (Exception ex) { } }