void limpaTabelas() { DBCadPedido sqlCadPedido = new DBCadPedido("delivery_db"); DBCadPedidoItem sqlCadPedidoItem = new DBCadPedidoItem("delivery_db"); DBCadCarrinho sqlCadCarrinho = new DBCadCarrinho("delivery_db"); DBCadCarrinhoItem sqlCadCarrinhoItem = new DBCadCarrinhoItem("delivery_db"); sqlCadPedido.DeleteRecord(); sqlCadPedidoItem.DeleteRecord("delete from PEDIDO_ITEM"); sqlCadCarrinho.DeleteRecord(); sqlCadCarrinhoItem.DeleteRecord("delete from CARRINHO_ITEM"); }
protected override void OnCreate(Bundle bundle) { base.OnCreate(bundle); SetContentView(Resource.Layout.frmCarrinho); if (MainActivity.iCodEmpresa > 0) { sqldb_carrinho = new DBCadCarrinho("delivery_db"); sqldb_carrinho_item = new DBCadCarrinhoItem("delivery_db"); sqldb_pedido = new DBCadPedido("delivery_db"); sqldb_pedido_item = new DBCadPedidoItem("delivery_db"); lwCarrinho = FindViewById <ListView> (Resource.Id.lwCarrinho); ImageButton btAnt = FindViewById <ImageButton> (Resource.Id.btAnt); ImageButton btCarrinho = FindViewById <ImageButton> (Resource.Id.imgBtCarrinho); ImageButton imgBtMenu = FindViewById <ImageButton> (Resource.Id.imgBtMenu); ImageButton btInseriPedido = FindViewById <ImageButton> (Resource.Id.btInseriPedido); ImageButton btSubTotal = FindViewById <ImageButton> (Resource.Id.btSubTotal); txtSubTotal = FindViewById <TextView> (Resource.Id.txtSTotal); carrinho = carregaCarrinho(); lwCarrinho.Adapter = new adapter_carrinho(this, carrinho); lwCarrinho.ItemClick += OnListItemClick; btAnt.Click += new EventHandler(btAnt_Click); imgBtMenu.Click += new EventHandler(btMenu_Click); btInseriPedido.Click += new EventHandler(btInseriPedido_Click); btSubTotal.Click += new EventHandler(btSubTotal_Click); } else { Finish(); StartActivity(typeof(MainActivity)); } }