public static PivotItem getPivot(TB_CONTA account)
        {
            double size = 230;
            PivotItem temp = new PivotItem { Header = account.CTA_NOME };
            Grid grid = new Grid();
            StackPanel panel = new StackPanel();
            ListBox transBox = new ListBox();

            Button accVal = new Button() { Content = "$999.99", Height = 128, Width = size * 2 };
            Button credit = new Button() { Content = "+", Height = size, Width = size };
            Button debit = new Button() { Content = "-", Height = size, Width = size };
            StackPanel bts = new StackPanel() { Orientation = Orientation.Horizontal };

            List<String> source = new List<String>();
            source.Add("Item 1");
            source.Add("Item 2");
            source.Add("Item 3");
            source.Add("Item 4");
            source.Add("Item 5");
            source.Add("Item 6");
            source.Add("Item 12");
            source.Add("Item 13");
            source.Add("Item 14");
            source.Add("Item 15");
            source.Add("Item 16");
            source.Add("Item 17");
            source.Add("Item 18");
            source.Add("Item 19");
            source.Add("Item 20");

            ListBox box = new ListBox();
            box.ItemsSource = source;
            box.Height = 200;

            bts.Children.Add(credit);
            bts.Children.Add(debit);

            panel.Children.Add(accVal);
            panel.Children.Add(bts);
            panel.Children.Add(box);

            temp.Content = panel;
            return temp;
        } 
        public void SampleData()
        {
            string connection = App.Connection;
            using (var ctx = new ControleDeGastosDataContext(App.Connection))
            {
                TB_TIPO_CONTA novoTipoConta = new TB_TIPO_CONTA()
                {
                    TPC_NOME = "Banco",
                    TPC_FLAG_ATIVA = true
                };
                ctx.TB_TIPO_CONTAs.InsertOnSubmit(novoTipoConta);

                novoTipoConta = new TB_TIPO_CONTA()
                {
                    TPC_NOME = "Investimento",
                    TPC_FLAG_ATIVA = true
                };
                ctx.TB_TIPO_CONTAs.InsertOnSubmit(novoTipoConta);

                novoTipoConta = new TB_TIPO_CONTA()
                {
                    TPC_NOME = "Dinheiro",
                    TPC_FLAG_ATIVA = true
                };
                ctx.TB_TIPO_CONTAs.InsertOnSubmit(novoTipoConta);

                ctx.SubmitChanges();

                TB_MOEDA novaMoeda = new TB_MOEDA()
                {
                    MOE_NOME = "Real Brasil",
                    MOE_SIGLA = "R$",
                    MOE_COTACAO = 0,
                    MOE_PADRAO = true,
                    MOE_FLAG_ATIVA = true
                };
                ctx.TB_MOEDAs.InsertOnSubmit(novaMoeda);

                novaMoeda = new TB_MOEDA()
                {
                    MOE_NOME = "Dólar",
                    MOE_SIGLA = "$",
                    MOE_COTACAO = 0,
                    MOE_PADRAO = false,
                    MOE_FLAG_ATIVA = true
                };
                ctx.TB_MOEDAs.InsertOnSubmit(novaMoeda);

                ctx.SubmitChanges();

                TB_BENEFICIARIO novoBeneficiario = new TB_BENEFICIARIO()
                {
                    BNF_NOME = "Wagner Sommer",
                    BNF_OBSERVACAO = "Pai",
                    BNF_FLAG_ATIVA = true
                };
                ctx.TB_BENEFICIARIOs.InsertOnSubmit(novoBeneficiario);

                novoBeneficiario = new TB_BENEFICIARIO()
                {
                    BNF_NOME = "Margarete Sommer",
                    BNF_OBSERVACAO = "Mãe",
                    BNF_FLAG_ATIVA = true
                };
                ctx.TB_BENEFICIARIOs.InsertOnSubmit(novoBeneficiario);

                ctx.SubmitChanges();

                TB_CONTA novaConta = new TB_CONTA()
                {
                    CTA_NOME = "Pessoa Fisica",
                    TPC_ID = 1,
                    CTA_DT_INICIO = System.DateTime.Today,
                    CTA_DT_FIM = Convert.ToDateTime(System.DateTime.MaxValue.ToString()),
                    CTA_VALOR_INICIAL = 0,
                    MOE_ID = 1,
                    CTA_ENCERRADA = false,
                    CTA_FLAG_ATIVA = true
                };
                ctx.TB_CONTAS.InsertOnSubmit(novaConta);

                novaConta = new TB_CONTA()
                {
                    CTA_NOME = "Pessoa Juridica",
                    TPC_ID = 1,
                    CTA_DT_INICIO = System.DateTime.Today,
                    CTA_DT_FIM = Convert.ToDateTime(System.DateTime.MaxValue.ToString()),
                    CTA_VALOR_INICIAL = 0,
                    MOE_ID = 1,
                    CTA_ENCERRADA = false,
                    CTA_FLAG_ATIVA = true
                };
                ctx.TB_CONTAS.InsertOnSubmit(novaConta);

                novaConta = new TB_CONTA()
                {
                    CTA_NOME = "Acoes",
                    TPC_ID = 2,
                    CTA_DT_INICIO = System.DateTime.Today,
                    CTA_DT_FIM = Convert.ToDateTime(System.DateTime.MaxValue.ToString()),
                    CTA_VALOR_INICIAL = 0,
                    MOE_ID = 1,
                    CTA_ENCERRADA = false,
                    CTA_FLAG_ATIVA = true
                };
                ctx.TB_CONTAS.InsertOnSubmit(novaConta);

                ctx.SubmitChanges();

                TB_CATEGORIA novaCategoria = new TB_CATEGORIA()
                {
                    CAT_NOME = "Automovel",
                    CAT_PAI_ID = 1,
                    CAT_TIPO = "1",
                    CAT_FLAG_ATIVA = true,
                    CAT_OBSERVACAO = ""
                };
                ctx.TB_CATEGORIAs.InsertOnSubmit(novaCategoria);

                ctx.SubmitChanges();

                TB_ORCAMENTO novoOrcamento = new TB_ORCAMENTO()
                {
                    ORC_NOME = "Carro",
                    ORC_TIPO = 1,
                    MOE_ID = 1,
                    CAT_ID = 1,
                    ORC_VALOR = 100,
                    ORC_FLAG_ATIVA = true,
                    ORC_OBSERVACAO = "Mensal",
                    ORC_SUBCATEGORIA = false
                };
                ctx.TB_ORCAMENTOs.InsertOnSubmit(novoOrcamento);

                novoOrcamento = new TB_ORCAMENTO()
                {
                    ORC_NOME = "Casa",
                    ORC_TIPO = 2,
                    MOE_ID = 1,
                    CAT_ID = 1,
                    ORC_VALOR = 500,
                    ORC_FLAG_ATIVA = true,
                    ORC_OBSERVACAO = "Trimestral",
                    ORC_SUBCATEGORIA = false
                };
                ctx.TB_ORCAMENTOs.InsertOnSubmit(novoOrcamento);

                ctx.SubmitChanges();


            }
        }
 public void deleteAccount(TB_CONTA account)
 {
     using (var ctx = new ControleDeGastosDataContext(App.Connection))
     {
         // find a city to delete
         IQueryable<TB_CONTA> accountQuery = from c in ctx.TB_CONTAS where c.CTA_NOME == account.CTA_NOME select c;
         TB_CONTA accountToDelete = accountQuery.FirstOrDefault();
         // delete city from the context
         ctx.TB_CONTAS.DeleteOnSubmit(accountToDelete);
         // save changes to the database
         ctx.SubmitChanges();
     }
 }
        void makePivot(TB_CONTA account)
        {
            if (account.CTA_FLAG_ATIVA == true)
            {

                PivotItem newPivot = new PivotItem()
                {
                    Header = account.CTA_NOME
                };

                //O pivot prescisa de um container para adicionar elements
                Grid pivotContent = new Grid()
                {
                    HorizontalAlignment = HorizontalAlignment.Left,
                    VerticalAlignment = VerticalAlignment.Top,
                    Height = 572,
                    Width = 432
                };

                Button amount = new Button()
                {
                    Content = account.CTA_VALOR_INICIAL,
                    HorizontalAlignment = HorizontalAlignment.Left,
                    VerticalAlignment = VerticalAlignment.Top,
                    Width = 416,
                    Height = 82,
                    Margin = new Thickness(8, 0, 0, 0),
                };
                amount.Tap += new EventHandler<System.Windows.Input.GestureEventArgs>(onTap_Top);

                Button credit = new Button()
                {
                    Content = "+",
                    HorizontalAlignment = HorizontalAlignment.Left,
                    VerticalAlignment = VerticalAlignment.Top,
                    Width = 214,
                    Height = 98,
                    Margin = new Thickness(8, 86, 0, 0)
                };
                credit.Tap += new EventHandler<System.Windows.Input.GestureEventArgs>(onTapCredit);


                Button debit = new Button()
                {
                    Content = "-",
                    HorizontalAlignment = HorizontalAlignment.Left,
                    VerticalAlignment = VerticalAlignment.Top,
                    Width = 214,
                    Height = 98,
                    Margin = new Thickness(210, 86, 0, 0)

                };

                //As Transacoes prescisam de um container
                StackPanel transactionHolder = new StackPanel()
                {
                    Margin = new Thickness(10)
                };

                //Faz com que o container das transacoes possa
                //ser scrollable (rolado)... xD
                //Esse meu portugues ta uma merda! =P
                ScrollViewer transScroller = new ScrollViewer()
                {
                    Content = transactionHolder, //adiciona o container das trasacoes no scrollViewer
                    Margin = new Thickness(21, 199, 20, 113),
                    BorderBrush = new SolidColorBrush(Colors.White),
                    BorderThickness = new Thickness(1)
                };


                for (int i = 20; i > 0; i--)
                {
                    TextBlock t1 = new TextBlock() { Text = "Bough " + i };
                    t1.Padding = new Thickness(10);
                    transactionHolder.Children.Add(t1);
                }

                pivotContent.Children.Add(amount);
                pivotContent.Children.Add(credit);
                pivotContent.Children.Add(debit);
                pivotContent.Children.Add(transScroller);

                newPivot.Content = pivotContent;
                newPivot.Name = account.CTA_ID.ToString();
                pivotAccounts.Items.Add(newPivot);
            }
        }
 partial void DeleteTB_CONTA(TB_CONTA instance);
 partial void UpdateTB_CONTA(TB_CONTA instance);
 partial void InsertTB_CONTA(TB_CONTA instance);
		private void detach_TB_CONTAs(TB_CONTA entity)
		{
			this.SendPropertyChanging();
			entity.TB_TIPO_CONTA = null;
		}
		private void attach_TB_CONTAs(TB_CONTA entity)
		{
			this.SendPropertyChanging();
			entity.TB_MOEDA = this;
		}