private void saveObat(DataRow row, string no_pembelian)
{
SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConString"]);
SqlCommand cmd = new SqlCommand("sp_Transaksi_Beli_Obat", connection);
cmd.CommandType = CommandType.StoredProcedure;
string id_obat2 = Kenko.generateId("OB", "sp_Obat_GetLast");
cmd.Parameters.AddWithValue("no_pembelian", no_pembelian);
cmd.Parameters.AddWithValue("id_obat1", row["id_obat"].ToString());
cmd.Parameters.AddWithValue("id_obat2", id_obat2);
cmd.Parameters.AddWithValue("nama_obat", row["nama_obat"].ToString());
cmd.Parameters.AddWithValue("tgl_expired", row["tgl_exp"].ToString());
cmd.Parameters.AddWithValue("jumlah_beli", row["jumlah"].ToString());
cmd.Parameters.AddWithValue("harga_beli", row["harga_beli"].ToString());
cmd.Parameters.AddWithValue("harga_jual", row["harga_jual"].ToString());
cmd.Parameters.AddWithValue("total_harga", Kenko.getNumber(row["harga_total"].ToString()));
try
{
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Data gagal disimpan : " + ex.Message, "Gagal", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void btnBayar_Click(object sender, RoutedEventArgs e)
{
SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConString"]);
SqlCommand cmd = new SqlCommand("sp_Transaksi_Penjualan", connection);
cmd.CommandType = CommandType.StoredProcedure;
string id_user = Application.Current.Properties["id"].ToString();
string no_penjualan = Kenko.generateId("PJ", "sp_Transaksi_Penjualan_GetLast");
cmd.Parameters.AddWithValue("no_penjualan", no_penjualan);
cmd.Parameters.AddWithValue("tgl_beli", DateTime.Now);
cmd.Parameters.AddWithValue("total_harga", Convert.ToDouble(Kenko.getNumber(lblTotalPembayaran.Text)));
cmd.Parameters.AddWithValue("id_member", (txtPoin.IsEnabled == true) ? (object)txtIdMember.Text : DBNull.Value);
cmd.Parameters.AddWithValue("poin_terpakai", txtPoin.Text);
cmd.Parameters.AddWithValue("id_user", id_user);
try
{
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
foreach (DataRow row in dtPenjualan.Rows)
{
cmd = new SqlCommand("sp_Transaksi_Penjualan_Detail", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("no_penjualan", no_penjualan);
cmd.Parameters.AddWithValue("id_obat", row["id_obat"].ToString());
cmd.Parameters.AddWithValue("jumlah", row["jumlah"].ToString());
cmd.Parameters.AddWithValue("total_harga", Kenko.getNumber(row["harga"].ToString()));
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
MessageBox.Show("Data berhasil disimpan!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
AddPrintData(no_penjualan);
StrukPreview strukPreview = new StrukPreview(penjualans, detail_Penjualans);
strukPreview.Close();
NewTransaksi();
}
catch (Exception ex)
{
MessageBox.Show("Data gagal disimpan : " + ex.Message, "Gagal", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (cmbSupplier.SelectedIndex < 0)
{
MessageBox.Show("Silahkan pilih supplier terlebih dahulu", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information);
}
else if (dtKeranjang.Rows.Count <= 0)
{
MessageBox.Show("Silahkan isi keranjang pembelian.", "Informasi", MessageBoxButton.OK, MessageBoxImage.Information);
}
else
{
SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConString"]);
SqlCommand cmd = new SqlCommand("sp_Transaksi_Pembelian", connection);
cmd.CommandType = CommandType.StoredProcedure;
string no_pembelian = Kenko.generateId("PB", "sp_Transaksi_Pembelian_GetLast");
cmd.Parameters.AddWithValue("no_pembelian", no_pembelian);
cmd.Parameters.AddWithValue("total_harga", Kenko.getNumber(lblTotalPembayaran.Text));
cmd.Parameters.AddWithValue("id_supplier", cmbSupplier.SelectedValue);
cmd.Parameters.AddWithValue("id_user", 2);
try
{
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
catch (Exception ex)
{
MessageBox.Show("Data gagal disimpan : " + ex.Message, "Gagal", MessageBoxButton.OK, MessageBoxImage.Error);
}
foreach (DataRow row in dtKeranjang.Rows)
{
saveObat(row, no_pembelian);
}
MessageBox.Show("Data pembelian berhasil ditambahkan", "Berhasil", MessageBoxButton.OK, MessageBoxImage.Information);
NewTransaksi();
}
}
private void btnDaftar_Click(object sender, RoutedEventArgs e)
{
if (id_pasien.Text == "ID Pasien" || id_pasien.Text == "")
{
MessageBox.Show("Silahkan pilih pasien terlebih dahulu.", "Gagal", MessageBoxButton.OK, MessageBoxImage.Error);
}
else if (cmbDokter.SelectedIndex < 0)
{
MessageBox.Show("Silahkan pilih dokter terlebih dahulu.", "Gagal", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConString"]);
SqlCommand cmd = new SqlCommand("sp_Transaksi_Reservasi", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("no_reservasi", Kenko.generateId("RV", "sp_Transaksi_Reservasi_GetLast"));
cmd.Parameters.AddWithValue("id_dokter", cmbDokter.SelectedValue.ToString());
cmd.Parameters.AddWithValue("id_pasien", id_pasien.Text);
cmd.Parameters.AddWithValue("keterangan", txtKeluhan.Text);
try
{
connection.Open();
cmd.ExecuteNonQuery();
MessageBox.Show("Reservasi berhasil.", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
connection.Close();
ClearForm();
formReadOnly(false);
ClearDokter();
}
catch (Exception ex)
{
MessageBox.Show("Data gagal disimpan : " + ex.Message, "Gagal", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
private void btnBuatResep_Click(object sender, RoutedEventArgs e)
{
if (id_pasien == "" || id_pasien == "ID_Pasien")
{
MessageBox.Show("Pilih antrian terlebih dahulu.", "Gagal", MessageBoxButton.OK, MessageBoxImage.Error);
}
else if (dtResep.Rows.Count < 1)
{
MessageBox.Show("Silahkan tambahkan obat terlebih dahulu.", "Gagal", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConString"]);
SqlCommand cmd = new SqlCommand("sp_Transaksi_Resep", connection);
cmd.CommandType = CommandType.StoredProcedure;
string id_resep = Kenko.generateId("RS", "sp_Transaksi_Resep_GetLast");
string id_dokter = Application.Current.Properties["id"].ToString();
cmd.Parameters.AddWithValue("id_resep", id_resep);
cmd.Parameters.AddWithValue("id_pasien", id_pasien);
cmd.Parameters.AddWithValue("id_dokter", id_dokter);
try
{
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
foreach (DataRow row in dtResep.Rows)
{
cmd = new SqlCommand("sp_Transaksi_Resep_Detail", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("id_resep", id_resep);
cmd.Parameters.AddWithValue("id_obat", row["id_obat"].ToString());
cmd.Parameters.AddWithValue("jumlah", row["jumlah"].ToString());
cmd.Parameters.AddWithValue("keterangan", row["keterangan"].ToString());
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
}
cmd = new SqlCommand("sp_Transaksi_Reservasi_UpdateStatus", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("no_reservasi", id_reservasi);
connection.Open();
cmd.ExecuteNonQuery();
connection.Close();
ClearForm();
MessageBox.Show("Data berhasil disimpan!", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
}
catch (Exception ex)
{
MessageBox.Show("Data gagal disimpan : " + ex.Message, "Gagal", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
}
