public IList<TB_BENEFICIARIO> GetBeneficiaries()
{
IList<TB_BENEFICIARIO> list = null;
using (var ctx = new ControleDeGastosDataContext(App.Connection))
{
IQueryable<TB_BENEFICIARIO> query = ctx.TB_BENEFICIARIOs;
list = query.ToList();
}
return list;
}
public IList<TB_ORCAMENTO> GetBudgets()
{
IList<TB_ORCAMENTO> list = null;
using (var ctx = new ControleDeGastosDataContext(App.Connection))
{
IQueryable<TB_ORCAMENTO> query = ctx.TB_ORCAMENTOs;
list = query.ToList();
}
return list;
}
/*
public IList<TB_TIPO_CONTA> GetAccountType()
{
IList<TB_TIPO_CONTA> list = null;
using (var ctx = new ControleDeGastosDataContext(App.Connection))
{
IQueryable<TB_TIPO_CONTA> query = ctx.TB_TIPO_CONTAS;
list = query.ToList();
}
return list;
}
*/
public IList<TB_CATEGORIA> GetCategories()
{
IList<TB_CATEGORIA> list = null;
using (var ctx = new ControleDeGastosDataContext(App.Connection))
{
IQueryable<TB_CATEGORIA> query = ctx.TB_CATEGORIAs;
list = query.ToList();
}
return list;
}
public IList<TB_MOEDA> GetCurrencys()
{
IList<TB_MOEDA> list = null;
using (var ctx = new ControleDeGastosDataContext(App.Connection))
{
IQueryable<TB_MOEDA> query = ctx.TB_MOEDAs;
list = query.ToList();
}
return list;
}
public IList<TB_CONTA> GetAccount()
{
IList<TB_CONTA> list = null;
using (var ctx = new ControleDeGastosDataContext(App.Connection))
{
IQueryable<TB_CONTA> query = ctx.TB_CONTAS;
list = query.ToList();
}
return list;
}
/// <summary>
/// Constructor for the Application object.
/// </summary>
public App()
{
// Global handler for uncaught exceptions.
UnhandledException += Application_UnhandledException;
// Standard Silverlight initialization
InitializeComponent();
// Phone-specific initialization
InitializePhoneApplication();
// Show graphics profiling information while debugging.
if (System.Diagnostics.Debugger.IsAttached)
{
// Display the current frame rate counters
Application.Current.Host.Settings.EnableFrameRateCounter = true;
// Show the areas of the app that are being redrawn in each frame.
//Application.Current.Host.Settings.EnableRedrawRegions = true;
// Enable non-production analysis visualization mode,
// which shows areas of a page that are handed off to GPU with a colored overlay.
//Application.Current.Host.Settings.EnableCacheVisualization = true;
// Disable the application idle detection by setting the UserIdleDetectionMode property of the
// application's PhoneApplicationService object to Disabled.
// Caution:- Use this under debug mode only. Application that disables user idle detection will continue to run
// and consume battery power when the user is not using the phone.
PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
}
using (var ctx = new ControleDeGastosDataContext(connection))
{
if (!ctx.DatabaseExists())
{
ctx.CreateDatabase();
SampleData();
}
};
}
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 IList<TB_MOVIMENTACAO> GetTransaction()
{
IList<TB_MOVIMENTACAO> list = null;
using (var ctx = new ControleDeGastosDataContext(App.Connection))
{
IQueryable<TB_MOVIMENTACAO> query = ctx.TB_MOVIMENTACAOs;
list = query.ToList();
}
return list;
}
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();
}
}