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(); }