private void btn_cari_Click(object sender, EventArgs e) { var db = Model.Database.Instance; var query = txt_cari.Text; var category = cb_jenis.SelectedItem.ToString(); IEnumerable <Model.Distributor> result; if (category == "Kode") { //kalau ini pakai Like bisa ko ndre? jadi kode like query result = db.Query2 <Model.Distributor>().Where(db.Column("Kode") == query).Execute(); } else if (category == "Nama") { //kalau ini pakai Like bisa ko ndre? jadi kode like query result = db.Query2 <Model.Distributor>().Where(db.Column("Nama") == query).Execute(); } else { MessageBox.Show("Tidak dapat menemukan distributor."); return; } distributor = result.FirstOrDefault(); if (distributor != null) { txt_kode.DataBindings.Clear(); txt_kode.DataBindings.Clear(); txt_nama.DataBindings.Clear(); txt_alamat.DataBindings.Clear(); txt_kota.DataBindings.Clear(); txt_telp.DataBindings.Clear(); cmb_bank.DataBindings.Clear(); txt_norek.DataBindings.Clear(); txt_email.DataBindings.Clear(); txt_kode.DataBindings.Add("Text", distributor, "Kode"); txt_nama.DataBindings.Add("Text", distributor, "Nama"); txt_alamat.DataBindings.Add("Text", distributor, "Alamat"); txt_kota.DataBindings.Add("Text", distributor, "Kota"); txt_telp.DataBindings.Add("Text", distributor, "Telp"); cmb_bank.DataBindings.Add("Text", distributor, "Bank"); txt_norek.DataBindings.Add("Text", distributor, "Norek"); txt_email.DataBindings.Add("Text", distributor, "Email"); } else { txt_kode.DataBindings.Clear(); txt_kode.DataBindings.Clear(); txt_nama.DataBindings.Clear(); txt_alamat.DataBindings.Clear(); txt_kota.DataBindings.Clear(); txt_telp.DataBindings.Clear(); cmb_bank.DataBindings.Clear(); txt_norek.DataBindings.Clear(); txt_email.DataBindings.Clear(); } }
public tambah(Controller controller, Model.Distributor distributor = null) { this.controller = controller; InitializeComponent(); if (distributor != null) { model = distributor; } else { model = new Model.Distributor(); } txt_kode.DataBindings.Add("Text", model, "Kode"); txt_nama.DataBindings.Add("Text", model, "Nama"); txt_alamat.DataBindings.Add("Text", model, "Alamat"); txt_kota.DataBindings.Add("Text", model, "Kota"); txt_telp.DataBindings.Add("Text", model, "Telp"); cmb_bank.DataBindings.Add("Text", model, "Bank"); txt_norek.DataBindings.Add("Text", model, "Norek"); txt_email.DataBindings.Add("Text", model, "Email"); }