private void btnSimpan_Click(object sender, EventArgs e) { var dt = new yakkumdbTableAdapters.fa_rx_tindakanTableAdapter(); for (int i = 0; i < dgvTindakan.RowCount - 1; i++) { // if (dgvTindakan.Rows[i].Cells[1].Value.Equals(null)) if (dgvTindakan.Rows[i].Cells[1].Value != null) { dt.DeleteTindakan(_koderx); dt.InsertQuery( _koderx, dgvTindakan.Rows[i].Cells[1].Value.ToString() ); } else { } } var dh = new yakkumdbTableAdapters.resep_waitingTableAdapter(); dh.UpdateQuery(_koderx); MessageBox.Show("Data Berhasil di Simpan"); this.Controls.Clear(); }
private void populateItems() { flpNotif.Controls.Clear(); var ds = new yakkumdbTableAdapters.resep_waitingTableAdapter(); ds.Fill(yakkumdb.resep_waiting, lblKklinik.Text); DataTable dt = ds.GetData(lblKklinik.Text); foreach (DataRow r in dt.Rows) { var uc = new CardResep { Tag = r["vc_nid"].ToString() + r["vc_kode_rx"].ToString(), NoRM = r["vc_no_rm"].ToString(), Nama = r["vc_nama_Peserta"].ToString(), NoResep = r["vc_kode_rx"].ToString(), namaklinik = r["vc_kode_poli_bpjs"].ToString(), Dokter = r["dokter"].ToString(), SEP = r["vc_no_sep"].ToString(), kdokter = r["vc_nid"].ToString() }; if (flpNotif.Controls.Count < 0) { flpNotif.Controls.Clear(); } else { flpNotif.Controls.Add(uc); uc.Click += uc_MouseCliked; } } }
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(); }