void ShowDataTabelFilter(string tahun, string bulan)
{
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 MONTH(mydentist.tbl_appointment.tanggal_appo) = " + bulan + " AND YEAR(mydentist.tbl_appointment.tanggal_appo) =" + tahun + " 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)dgUsers.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[8]).Binding = new Binding("keterangan_appo");
//Warna();
//@Bahar : Harus ditutup !!!
koneksi.Dispose();
}
catch (Exception e)
{
//Warna();
dgAppo.ItemsSource = null;
//dgAppo.Items.Refresh();
koneksi.Dispose();
}
//Warna();
}
private void txtPencarian_TextChanged(object sender, TextChangedEventArgs e)
{
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) =" + cmbTahun.SelectedItem.ToString() + ") AND (mydentist.tbl_rekapobat.namapasien_rekapobat LIKE '%" + txtPencarian.Text + "%' OR mydentist.tbl_rekapobat.namaobat_rekapobat LIKE '%" + txtPencarian.Text + "%' )", 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();
if (txtPencarian.Text == string.Empty)
{
ShowData();
}
}
catch (Exception ex)
{
//Warna();
dgRekapData.ItemsSource = null;
//dgAppo.Items.Refresh();
koneksi.Dispose();
}
//Warna();
}
private void ShowData()
{
rekapObats.Clear();
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), 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();
}
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_presensi WHERE MONTH(mydentist.tbl_presensi.tanggal_presensi) = " + (cmbBulan.SelectedIndex + 1) + " AND YEAR(mydentist.tbl_presensi.tanggal_presensi) =" + cmbTahun.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";
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 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
}
private void btnSimpan_Click(object sender, RoutedEventArgs e)
{
try
{
dJam = DateTime.Parse(txtJam.Text);
try
{
if (!isEdit)
{
SimpanNew();
}
else
{
EditUpdate();
}
}
catch (Exception ex)
{
koneksi.Dispose();
//MessageBox.Show("Terjadi kesalahan!", "Informasi", MessageBoxButton.OK, MessageBoxImage.Error);
MessageBox.Show(ex.Message);
}
}
catch (Exception ex)
{
MessageBox.Show("Cek penulisan waktu! Contoh format 00:00", "Informasi", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
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);
dgObat.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_obat WHERE " +
"mydentist.tbl_obat.nama_obat LIKE '%" + txtPencarian.Text + "%' OR " +
"mydentist.tbl_obat.jenis_obat LIKE '%" + txtPencarian.Text + "%' OR " +
"mydentist.tbl_obat.hargabeli_obat LIKE '%" + txtPencarian.Text + "%' OR " +
"mydentist.tbl_obat.hargabeli_obat LIKE '%" + txtPencarian.Text + "%' OR " +
"mydentist.tbl_obat.stok_obat LIKE '%" + txtPencarian.Text + "%' OR " +
"mydentist.tbl_obat.keterangan_obat LIKE '%" + txtPencarian.Text + "%'", null).DefaultView;
((DataGridTextColumn)dgObat.Columns[0]).Binding = new Binding("id_obat");
//((DataGridTextColumn)dgUsers.Columns[1]).Binding = new Binding("id_pasien");
((DataGridTextColumn)dgObat.Columns[2]).Binding = new Binding("nama_obat");
((DataGridTextColumn)dgObat.Columns[3]).Binding = new Binding("jenis_obat");
((DataGridTextColumn)dgObat.Columns[4]).Binding = new Binding("hargabeli_obat");
((DataGridTextColumn)dgObat.Columns[4]).Binding.StringFormat = "{0:C2}";
((DataGridTextColumn)dgObat.Columns[5]).Binding = new Binding("hargajual_obat");
((DataGridTextColumn)dgObat.Columns[5]).Binding.StringFormat = "{0:C2}";
((DataGridTextColumn)dgObat.Columns[6]).Binding = new Binding("stok_obat");
((DataGridTextColumn)dgObat.Columns[7]).Binding = new Binding("keterangan_obat");
//@Bahar : Harus ditutup !!!
koneksi.Dispose();
}
/*
* SELECT Shippers.ShipperName,COUNT(Orders.OrderID) AS NumberOfOrders FROM Orders
* LEFT JOIN Shippers
* ON Orders.ShipperID=Shippers.ShipperID
* GROUP BY ShipperName;
*
* select * From tbl_terapi RIGHT JOIN tbl_rekapterapi ON tbl_terapi.nama_terapi=tbl_rekapterapi.namaterapi_rekapterapi WHERE tbl_rekapterapi.invoice_rekapterapi=1440416276
*/
/*
* SELECT * FROM mydentist.tbl_terapi RIGHT JOIN mydentist.tbl_rekapterapi ON mydentist.tbl_terapi.nama_terapi=mydentist.tbl_rekapterapi.namaterapi_rekapterapi JOIN mydentist.tbl_rekapperawat rp ON rp.nokwt_rekapperawat = mydentist.tbl_rekapterapi.nokwt_rekapterapi
*/
void ShowData()
{
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), null);
DataTable CmbxDataPerawat = new DataTable();
int kj = 0;
for (int i = 0; i < CmbxData.Rows.Count; i++)
{
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();
}
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);
dgAppo.ItemsSource = koneksi.GetDataTable("SELECT * FROM mydentist.tbl_appointment WHERE " +
"mydentist.tbl_appointment.norm_appo LIKE '%" + txtPencarian.Text + "%' OR " +
"mydentist.tbl_appointment.namapasien_appo LIKE '%" + txtPencarian.Text + "%' OR " +
"mydentist.tbl_appointment.namadokter_appo LIKE '%" + txtPencarian.Text + "%' OR " +
"mydentist.tbl_appointment.tanggal_appo LIKE '%" + txtPencarian.Text + "%' OR " +
"mydentist.tbl_appointment.keterangan_appo LIKE '%" + txtPencarian.Text + "%'", null).DefaultView;
((DataGridTextColumn)dgAppo.Columns[0]).Binding = new Binding("id_appo");
//((DataGridTextColumn)dgUsers.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[8]).Binding = new Binding("keterangan_appo");
//@Bahar : Harus ditutup !!!
koneksi.Dispose();
}
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()
{
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();
}
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 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_terapi WHERE mydentist.tbl_terapi.id_terapi = " + txtID.Text, null);
foreach (DataRow row in Datatable.Rows)
{
//MessageBox.Show(row["nama_karyawan"].ToString());
txtNama.Text = row["nama_terapi"].ToString();
txtJenis.Text = row["jenis_terapi"].ToString();
txtBiaya.Text = row["biaya_terapi"].ToString();
txtKeterangan.Text = row["keterangan_terapi"].ToString();
}
koneksi.Dispose();
}
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_pasien WHERE mydentist.tbl_pasien.id_pasien = " + txtID.Text, null);
foreach (DataRow row in Datatable.Rows)
{
//MessageBox.Show(row["nama_karyawan"].ToString());
txtNoRM.Text = row["norm_pasien"].ToString();
txtNama.Text = row["nama_pasien"].ToString();
txtAlamat.Text = row["alamat_pasien"].ToString();
txtTelp.Text = row["telp_pasien"].ToString();
txtKeterangan.Text = row["keterangan_pasien"].ToString();
}
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_presensi WHERE mydentist.tbl_presensi.nama_presensi LIKE '%" + txtPencarian.Text + "%' ORDER BY id_presensi DESC", 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:dddd}";
((DataGridTextColumn)dgTerapi.Columns[2]).Binding = new Binding("tanggal_presensi");
((DataGridTextColumn)dgTerapi.Columns[2]).Binding.StringFormat = "{0:MMMM yyyy}";
((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";
/*
* 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();
*/
koneksi.Dispose();
}
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();
}
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_terapi", txtNama.Text),
new ParameterData("jenis_terapi", txtJenis.Text),
new ParameterData("biaya_terapi", biayaAngka),
new ParameterData("keterangan_terapi", txtKeterangan.Text) };
koneksi.UpdateRow(SettingHelper.database, "tbl_terapi", "id_terapi=" + txtID.Text, 0, param);
koneksi.Commit(true);
AddItemCallback();
koneksi.Dispose();
this.Close();
MessageBox.Show("Data terapi berhasil diubah", "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("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);
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();
}
void GenerateAbsensi()
{
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_presensi ORDER BY id_presensi DESC LIMIT 1", null);
if (CmbxDataTanggal.Rows.Count == 0)
{
InsertGenerate();
}
else
if (DateTime.Parse(CmbxDataTanggal.Rows[0]["tanggal_presensi"].ToString()) != DateTime.Now.Date)
{
InsertGenerate();
}
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 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)
{
}
}
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 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 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();
}
}
}
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);
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 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 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 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()
{
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 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();
}
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);
//@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 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 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();
}
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 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);
}
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();
}