private void btnHapusObat_Click(object sender, RoutedEventArgs e)
{
var button = (FrameworkElement)sender;
var row = (DataGridRow)button.Tag;
MessageBoxResult result = MessageBox.Show("Yakin menghapus item ini?", "Konfirmasi", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
DataObat v = ((DataObat)(dgObat.SelectedItem));
myDataItems.Remove(v);
dgObat.ItemsSource = null;
int TotalObat = 0;
dgObat.ItemsSource = myDataItems;
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();
decimal TotalGrand = totalTerapi + totalObat;
//txtGrandTotal.Text = TotalGrand.ToString();
txtGrandTotal.Text = HitungGrandTotal(Convert.ToDouble(TotalGrand), double.Parse(txtDiskon.Text), double.Parse(txtCard.Text)).ToString();
}
}
private void 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 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)
{
}
}
