private void refresh()
{
using (MobileContext db = new MobileContext())
{
exerciseList.ItemsSource = db.Exercises.OrderBy(r => r.Name).ToList();
}
}
private void calendar_SelectedDatesChanged(CalendarView sender, CalendarViewSelectedDatesChangedEventArgs args)
{
if (calendar.SelectedDates == null)
{
return;
}
try
{
DateTime date = calendar.SelectedDates.First().Date;
if (dates.Contains(date))
{
using (MobileContext db = new MobileContext())
{
exercisesList = db.Exercises.ToList();
trainList = new ObservableCollection <Training>(db.Trainings.Where(r => r.Date.Date == date).Include(x => x.ex).ToList());
}
List.ItemsSource = trainList;
}
else
{
List.ItemsSource = null;
}
}
catch { }
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
using (MobileContext db = new MobileContext())
{
cmbTraining.ItemsSource = db.Exercises.OrderBy(r => r.Name).ToList();
cmbTraining.DisplayMemberPath = "Name";
cmbTraining.SelectedValuePath = "Id";
}
if (e.Parameter != null)
{
int id = (int)e.Parameter;
using (MobileContext db = new MobileContext())
{
tr = db.Trainings.FirstOrDefault(c => c.Id == id);
}
}
if (tr != null)
{
headerBlock.Text = "Редактирование подхода";
cmbTraining.SelectedValue = tr.ExerciseId;
tbWeight.Text = tr.Weight.ToString();
tbIteration.Text = tr.Iteration.ToString();
}
}
public history()
{
this.InitializeComponent();
using (MobileContext db = new MobileContext())
{
dates = db.Trainings.Select(x => x.Date).Distinct().ToList();
}
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
using (MobileContext db = new MobileContext())
{
exercisesList = db.Exercises.ToList();
list = new ObservableCollection <Training>(db.Trainings.Where(r => r.Date.Date == DateTime.Now.Date).Include(x => x.ex).ToList());
}
tList.ItemsSource = list;
}
private void Save_Click(object sender, RoutedEventArgs e)
{
Exercise _ex = cmbTraining.SelectedItem as Exercise;
if (_ex == null)
{
return;
}
bool isRecord = false;
using (MobileContext db = new MobileContext())
{
if (tr != null)
{
tr.ExerciseId = Int32.Parse(cmbTraining.SelectedValue.ToString());
tr.Weight = short.Parse(tbWeight.Text.ToString());
tr.Iteration = short.Parse(tbIteration.Text.ToString());
tr.ex = _ex;
db.Trainings.Update(tr);
db.SaveChanges();
}
else
{
Training tr = new Training
{
Date = DateTime.Now.Date,
Weight = Int16.Parse(tbWeight.Text.ToString()),
Iteration = Int16.Parse(tbIteration.Text.ToString()),
ExerciseId = Int32.Parse(cmbTraining.SelectedValue.ToString()),
ex = _ex
};
db.Exercises.Attach(_ex);
db.Trainings.Add(tr);
if ((tr.Weight > _ex.Weight) || (tr.Weight == _ex.Weight && tr.Iteration > _ex.Iteration))
{
_ex.Weight = tr.Weight;
_ex.Iteration = tr.Iteration;
isRecord = true;
}
db.SaveChanges();
}
}
if (isRecord)
{
Frame.Navigate(typeof(congratulations));
}
else
{
GoToMainPage();
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
if (e.Parameter != null)
{
int id = (int)e.Parameter;
using (MobileContext db = new MobileContext())
{
ex = db.Exercises.FirstOrDefault(c => c.Id == id);
}
}
if (ex != null)
{
headerBlock.Text = "Редактирование упражнения";
tbName.Text = ex.Name;
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
// получаем выделеный пункт меню
if (exerciseList.SelectedItem != null)
{
Exercise ex = exerciseList.SelectedItem as Exercise;
if (ex != null)
{
using (MobileContext db = new MobileContext())
{
db.Exercises.Remove(ex);
db.SaveChanges();
exerciseList.ItemsSource = db.Exercises.ToList();
}
}
}
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
// получаем выделеный пункт меню
if (tList.SelectedItem != null)
{
Training tr = tList.SelectedItem as Training;
if (tr != null)
{
using (MobileContext db = new MobileContext())
{
db.Trainings.Remove(tr);
db.SaveChanges();
exercisesList = db.Exercises.ToList();
list = new ObservableCollection <Training>(db.Trainings.Where(r => r.Date.Date == DateTime.Now.Date).Include(x => x.ex).ToList());
tList.ItemsSource = list;
}
}
}
}
private void Save_Click(object sender, RoutedEventArgs e)
{
using (MobileContext db = new MobileContext())
{
if (ex != null)
{
ex.Name = tbName.Text;
db.Exercises.Update(ex);
}
else
{
db.Exercises.Add(new Exercise {
Name = tbName.Text
});
}
db.SaveChanges();
}
GoToMainPage();
}