private void LvMasterData_ItemClick(object sender, AdapterView.ItemClickEventArgs e) { int position = 0; foreach (ListViewRow.LvRow_MasterMenu a in listMasterMenu) { if (position == e.Position) { //listOrder.Add(new ClassOrderTransaction(a.id, a.kategori, a.namaMenu, a.hargaBeli, a.hargaJual, 1)); Control.Class_Outstanding data = new Control.Class_Outstanding() { idMenu = a.id.ToString(), kategori = a.kategori, namaMenu = a.namaMenu, hargaBeli = a.hargaBeli, hargaJual = a.hargaJual, }; mod_masterMenu.insertTable(data); jmlItemTransaction++; successDialogPopUp(a.namaMenu); break; } else { position++; } } }
public bool insertTable(Control.Class_Outstanding data) { try { using(var connection = new SQLiteConnection(System.IO.Path.Combine(folder,"POS.db"))) { connection.Insert(data); return true; } } catch(Exception ex) { throw new Exception(ex.Message); } }