private void UpdateDay(PersonTreningDaySet obj)//super metodka która trigeruje się za każdym razem jak jest zmiana na dacie { SelectedDay = (PersonTreningDaySet)obj; using (Models.WorkOut2Container contex = new Models.WorkOut2Container()) { firstIdOfImage = (from c in contex.PersonPhotoSetSet where c.PersonTreningDaySetId == SelectedDay.Id select c.Id).FirstOrDefault(); howManyImage = (from c in contex.PersonPhotoSetSet where c.PersonTreningDaySetId == SelectedDay.Id select c.Id).Count(); _howManyImage = howManyImage; _firstIdOfImage = firstIdOfImage; } Values = new ObservableCollection <ExtendedPersonTraninDaySet>();//wreszcie sukces ;) if (SelectedDay.PersonPhotoSet.FirstOrDefault() != null) { Photo = SelectedDay.PersonPhotoSet.FirstOrDefault().Photo; ConvertetPhoto = this.LoadImage(Photo); tmp = new ExtendedPersonTraninDaySet(SelectedDay.Date, SelectedDay.Diet, SelectedDay.PersonSetId, SelectedDay.Weight, SelectedDay.Exercises, SelectedDay.Supplementation, ConvertetPhoto); Values.Add(tmp); } tmp = new ExtendedPersonTraninDaySet(SelectedDay.Date, SelectedDay.Diet, SelectedDay.PersonSetId, SelectedDay.Weight, SelectedDay.Exercises, SelectedDay.Supplementation, null); Values.Add(tmp); using (Models.WorkOut2Container contex = new Models.WorkOut2Container()) { var listForGraf = (from c in contex.PersonNoTreningDaySetSet where c.PersonSetId == SelectedPerson.Id select c); var listForGraf1 = (from c in contex.PersonTreningDaySetSet where c.PersonSetId == SelectedPerson.Id select c); Dictionary <string, double?> dictionary = new Dictionary <string, double?>(); foreach (var graf in listForGraf) { DateTime temp = (DateTime)graf.Date; dictionary.Add(temp.ToShortDateString(), graf.Weight); } foreach (var graf in listForGraf1) { DateTime temp = (DateTime)graf.Date; dictionary.Add(temp.ToShortDateString(), graf.Weight); } var items = from pair in dictionary orderby pair.Key ascending select pair; foreach (var graf in items) { GrafData.Add(new KeyValuePair <string, double?>(graf.Key, graf.Value)); } } }
private void Execute() { DayToAdd = new PersonTreningDaySet(SelectedDate, Diete, SelectedPerson.Id, Wage, WorkOut, Suplementation); using (WorkOut2Container contex = new Models.WorkOut2Container()) { try { contex.PersonTreningDaySetSet.Add(DayToAdd); contex.SaveChanges(); MessageBox.Show("Workout was added if you want add to this workout picture press add picture!"); } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.InnerException.Message); } } }