private void appbarDelete_Click(object sender, EventArgs e)
{
if (userSelected == null)
{
MessageBox.Show(Resource.EliminarNoSelected);
}
else
{
if (MessageBox.Show(Resource.EliminarMessageBoxText + " " + userSelected.Nombre, Resource.EliminarCaptionText, MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
try
{
using (ContextoDatos ctx = new ContextoDatos())
{
var user = ctx.Users.Where(x => x.Id == userSelected.Id).FirstOrDefault();
var userData = ctx.Datas.Where(x => x.IdUsuario == userSelected.Id);
ctx.GetTable<DataUser>().DeleteAllOnSubmit(userData);
ctx.GetTable<User>().DeleteOnSubmit(user);
ctx.SubmitChanges();
loadUsers();
}
}
catch (DbException x)
{
MessageBox.Show("An error has occurred!, we worked to resolved this problem");
}
}
}
}
private void appbarSave_Click(object sender, EventArgs e)
{
var items = (List<Usuario>)listBox1.ItemsSource;
var selectedItem = items != null ? items.Where(x => x.Selected).FirstOrDefault() : null;
if ((String.IsNullOrEmpty(textBox1.Text) || String.IsNullOrWhiteSpace(textBox1.Text)) && selectedItem == null)
MessageBox.Show(Resource.CompleteInformacion);
else
{
String Nombre = "";
String Id = "";
if (selectedItem != null)
Nombre = selectedItem.Nombre;
else
Nombre = textBox1.Text;
try
{
if (selectedItem == null)
{
//ContextoDatos.DeleteDB();
ContextoDatos.CrearDBSiNoExiste();
User user = new User()
{
Nombre = textBox1.Text
};
DataUser datauser = new DataUser()
{
Altura = App.IsMetric ? Conversion.ConverDouble(dataAltura) : Conversion.ToCentimetros(Conversion.ConverDouble(dataAltura.Split('.').First()),
Conversion.ConverDouble(dataAltura.Split('.').Last())),
Edad = Convert.ToInt32(dataEdad),
Fecha =Convert.ToDateTime(datePicker1.Value),
Genero = dataGenero,
Indice = Conversion.ConverDouble(dataIndice),
//Peso = App.IsMetric ? Convert.ToDouble(dataPeso) : Conversion.ToKilogramos(Convert.ToDouble(dataPeso)),
Peso = App.IsMetric ? Convert.ToDouble(dataPeso) : Conversion.ToKilogramos(Convert.ToDouble(dataPeso)),
User = user
};
using (ContextoDatos ctx = new ContextoDatos())
{
ctx.GetTable<User>().InsertOnSubmit(user);
ctx.GetTable<DataUser>().InsertOnSubmit(datauser);
ctx.SubmitChanges();
Id = user.Id.ToString();
}
}
else
{
DataUser datauser = new DataUser();
datauser.Altura = App.IsMetric ? Conversion.ConverDouble(dataAltura) : Conversion.ToCentimetros(Conversion.ConverDouble(dataAltura.Split('.').First()),
Conversion.ConverDouble(dataAltura.Split('.').Last()));
datauser.Edad = Convert.ToInt32(dataEdad);
datauser.Fecha = Convert.ToDateTime(datePicker1.Value);
datauser.Genero = dataGenero;
datauser.Indice = Conversion.ConverDouble(dataIndice);
// datauser.Peso = App.IsMetric ? Convert.ToDouble(dataPeso) : Conversion.ToKilogramos(Convert.ToDouble(dataPeso));
//datauser.Peso = App.IsMetric ? Convert.ToDouble(dataPeso.Replace(",",".")): Conversion.ToKilogramos(Convert.ToDouble(dataPeso.Replace(",",".")));
datauser.Peso = App.IsMetric? Convert.ToDouble(dataPeso.Replace(System.Globalization.CultureInfo.InvariantCulture.NumberFormat.CurrencyDecimalSeparator.ToString(), ".")):Conversion.ToKilogramos(Convert.ToDouble(dataPeso));
using (ContextoDatos ctx = new ContextoDatos())
{
datauser.User = ctx.Users.Where(x => x.Id == selectedItem.Id).SingleOrDefault();
ctx.GetTable<DataUser>().InsertOnSubmit(datauser);
ctx.SubmitChanges();
Id = selectedItem.Id.ToString();
}
}
(App.Current as App).CurrentUser = null;
MessageBox.Show(Resource.DataSaved);
NavigationService.Navigate(new Uri("/DataUsers.xaml?Id=" + Id, UriKind.Relative));
//loadUsers();
}
catch (DbException x)
{
MessageBox.Show("Error al insertar: " + x.Message);
}
}
}
