private void dgvBMHP_CellClick(object sender, DataGridViewCellEventArgs e)
{
var rxd = new yakkumdbTableAdapters.bmhpTableAdapter();
if (e.RowIndex < 0)
{
return;
}
if (e.ColumnIndex == 4)
{
// Deleted event
var val2 = this.dgvBMHP[6, e.RowIndex].Value.ToString();
var val = this.dgvBMHP[5, e.RowIndex].Value.ToString();
rxd.DeleteQuery(val);
this.bmhpTableAdapter.Fill(this.yakkumdb.bmhp, val2);
this.dgvBMHP.Update();
this.dgvBMHP.Refresh();
// MessageBox.Show("Deleted! " + val);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtJumlah.Text == "" || cmbSatuan.SelectedIndex == 0)
{
MessageBox.Show("Masukan Jumlah Alat");
}
else
{
float _jumlahbmhp = (float)Convert.ToDouble(txtJumlah.Text);
bool valid = float.TryParse(txtJumlah.Text.ToString(), out _jumlahbmhp);
var bm = new yakkumdbTableAdapters.bmhpTableAdapter();
bm.InsertQuery(
_koderx,
"AL" + _koderx.Substring(2) + lblKodeObat.Text,
_nourut,
lblKodeObat.Text,
lblNama.Text,
Math.Round(_jumlahbmhp, 4),
cmbSatuan.Text,
_kdokter
);
this.DialogResult = DialogResult.OK;
this.Close();
}
}
private void txtcariBMHP_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
var dt = new yakkumdbTableAdapters.bmhpTableAdapter();
var nourut = (int)dt.ScalarNoUrut(_koderx) + 1;
JumlahBMHP jj = new JumlahBMHP(txtcariBMHP.Text, _koderx, _kdokter, nourut);
var result = jj.ShowDialog();
if (result == DialogResult.OK)
{
this.bmhpTableAdapter.Fill(yakkumdb.bmhp, _koderx);
dgvBMHP.Update();
dgvBMHP.Refresh();
}
}
}
private void InputBMHP_Load(object sender, EventArgs e)
{
//insert paket gigi
var dt = new yakkumdbTableAdapters.bmhpTableAdapter();
var dt2 = new yakkumdbTableAdapters.resep_waitingTableAdapter();
var statpaket = dt2.ScalarQueryStatPaket(_koderx);
var nourut = (int)dt.ScalarNoUrut(_koderx) + 1;
if (_kdokter.Substring(0, 2) == "12")
{
if (statpaket != "PAKET")
{
this.bmhpTableAdapter.InsertQueryPaketGigi(_koderx, nourut, _kdokter);
this.resep_waitingTableAdapter.UpdateQueryStatPaket(_koderx);
}
}
SqlDataReader dReader;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = rse.app.desk.rx.nurse.Properties.Settings.Default.yakkumdatabaseConnectionString;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText =
"Select [vc_namaobat],[vc_kodeobat] from [dbo].[view_rse_fa_obat]" +
"where [kodefornas] >= " + 3 + "and [vc_golongan] = '31'" +
"or [vc_kodeobat] = '002241'or [vc_kodeobat] = '002769'or [vc_kodeobat] = '002071'" +
" order by [vc_namaobat] asc";
conn.Open();
dReader = cmd.ExecuteReader();
if (dReader.HasRows == true)
{
while (dReader.Read())
{
namesCollection.Add(dReader["vc_namaobat"].ToString());
}
}
else
{
MessageBox.Show("Data not found");
}
dReader.Close();
conn.Close();
txtcariBMHP.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
txtcariBMHP.AutoCompleteSource = AutoCompleteSource.CustomSource;
txtcariBMHP.AutoCompleteCustomSource = namesCollection;
this.resep_waitingTableAdapter.FillByKoderesep(this.yakkumdb.resep_waiting, _koderx);
this.bmhpTableAdapter.Fill(this.yakkumdb.bmhp, _koderx);
dgvBMHP.Update();
dgvBMHP.Refresh();
this.fa_rx_tindakanTableAdapter.Fill(this.yakkumdb.fa_rx_tindakan, _koderx);
dgvTindakan.Update();
dgvTindakan.Refresh();
}
