public void Salvar(object sender, EventArgs eventArgs)
{
//String _Content = String.Format("Categoria: {0},Despesa: {1},Receita: {2},Valor: {3},Data: {4}",
// ListPickerSub.SelectedItems, rDespesa.IsChecked.Value, rReceita.IsChecked.Value, xValor.Text, xData.Value);
//MessageBox.Show(_Content);
using (var ctx = new FinancasDataContext(conn))
{
var cat = new Categoria();
cat = ListPickerSub.SelectedItem as Categoria;
CultureInfo newCulture = new CultureInfo("pt-BR");
newCulture.NumberFormat.CurrencyDecimalSeparator = ".";
newCulture.NumberFormat.CurrencyGroupSeparator = ",";
newCulture.NumberFormat.NumberDecimalSeparator = ".";
newCulture.NumberFormat.NumberGroupSeparator = ",";
var cadastro = new Cadastro
{
Descricao = xDescricao.Text,
CategoriaId = cat.Id,
// Valor = xValor.Text.ToString(),
Preco = xValor.Text.ToString(),
Data = xData.Value,
TipoCategoria = (rReceita.IsChecked.Value) ? 1 : 2,
Parcelas = parcela.Text != "" ? Convert.ToInt32(parcela.Text) : 0
};
ctx.Cadastros.InsertOnSubmit(cadastro);
ctx.SubmitChanges();
}
MessageBox.Show("Registro salvo com sucesso!");
NavigationService.Navigate(
new Uri("/Pages/MainPage.xaml", UriKind.Relative));
}
public void Salvar(object sender, EventArgs eventArgs)
{
using (var ctx = new FinancasDataContext(conn))
{
var categoria = new Categoria
{
Nome = xCategoria.Text,
};
ctx.Categorias.InsertOnSubmit(categoria);
ctx.SubmitChanges();
}
var m = MessageBox.Show("Registro salvo com sucesso! Deseja cadastrar mais uma categoria ?", "File Save", MessageBoxButton.OKCancel);
if (m == MessageBoxResult.OK)
{
Focus();
}
else if (m == MessageBoxResult.Cancel)
{
NavigationService.GoBack();
}
{
}
}
public IList<Categoria> GetCategorias()
{
using (var ctx = new FinancasDataContext(conn))
{
IList<Categoria> lista = null;
IQueryable<Categoria> query = ctx.Categorias.OrderBy(categoria => Name);
lista = query.ToList();
return lista;
}
}
public Dictionary<string, string> GetDespesa()
{
using (var ctx = new FinancasDataContext(conn))
{
Dictionary<string, string> lista = new Dictionary<string, string>();
var data = DateTime.Now.ToString().Substring(0, 11);
IQueryable<Cadastro> query = ctx.Cadastros.Where(x => x.TipoCategoria == 1 && Convert.ToDateTime(x.Data.ToString().Substring(0, 11)) == Convert.ToDateTime(data))
.OrderBy(cadastro => Name);
if (query.Count() > 0)
{
foreach (var item in query.ToList())
{
lista.Add(item.Descricao, item.Preco);
}
}
return lista;
}
}
/// <summary>
/// Constructor for the Application object.
/// </summary>
public App()
{
CultureInfo newCulture = new CultureInfo("pt-BR");
//change format of DatePicker to you own format
newCulture.DateTimeFormat.ShortDatePattern = "d/MMM/yyyy";
Thread.CurrentThread.CurrentCulture = newCulture;
Thread.CurrentThread.CurrentUICulture = newCulture;
// 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 FinancasDataContext(conn))
{
IList<Categoria> categorias = new List<Categoria>();
if (!ctx.DatabaseExists())
{
//ctx.DeleteDatabase();
ctx.CreateDatabase();
categorias.Add(new Categoria { Nome = "Café" });
categorias.Add(new Categoria { Nome = "Almoço" });
categorias.Add(new Categoria { Nome = "Lanche" });
categorias.Add(new Categoria { Nome = "Janta" });
categorias.Add(new Categoria { Nome = "Transporte" });
categorias.Add(new Categoria { Nome = "Mercado" });
categorias.Add(new Categoria { Nome = "Combustivel" });
foreach (var categoria in categorias)
{
ctx.Categorias.InsertOnSubmit(categoria);
ctx.SubmitChanges();
}
}
}
}
}
