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