Beispiel #1
0
        public void create(gymnast gymnast)
        {
            using (var db = new DataContext())
            {
                bool dbexist = db.Database.Exists();
                if (dbexist == true)
                {
                    db.gymnast.Add(gymnast);

                    try
                    {
                        db.SaveChanges();
                    }
                    catch (Exception e)
                    {
                        Console.WriteLine(e);
                    }
                }
            }
        }
Beispiel #2
0
        public void update(gymnast gymnast)
        {
            using (var db = new DataContext())
            {
                bool dbexist = db.Database.Exists();
                if (dbexist == true)
                {
                    var query = from qGymnast in db.gymnast
                                where qGymnast.gymnast_id == gymnast.gymnast_id
                                select qGymnast;

                    foreach (gymnast eGymnast in query)
                    {
                        eGymnast.turnbondID = gymnast.turnbondID;
                        eGymnast.gender = gymnast.gender;
                        eGymnast.nationality = gymnast.nationality;
                        eGymnast.length = gymnast.length;
                        eGymnast.weight = gymnast.weight;
                        eGymnast.picture = gymnast.picture;
                        eGymnast.birthdate = gymnast.birthdate;
                        eGymnast.name = gymnast.name;
                        eGymnast.surname = gymnast.surname;
                        eGymnast.surname_prefix = gymnast.surname_prefix;
                        eGymnast.note = gymnast.note;
                    }

                    try
                    {
                        db.SaveChanges();
                    }
                    catch (Exception e)
                    {
                        Console.WriteLine(e);
                    }
                }
            }
        }
Beispiel #3
0
        public void NewGymnast(object commandParam)
        {
            selectedFilterItem = null;
            EditName = "";
            EditPrefix = "";
            EditSurname = "";
            EditFIGNumber = "";
            EditDateOfBirth = "";
            EditNationality = "";
            EditGender = "";
            EditLength = "";
            EditWeight = "";
            EditMemos = "";
            EditPicture = null;
            PictureCommandVisible = Visibility.Visible;
            EnableFilter = false;

            inEditingMode = true;
            creatingNewGymnast = true;
            OnPropertyChanged("Fullname");
            OnPropertyChanged("IsEditing");
            OnPropertyChanged("IsNotEditing");
            OnPropertyChanged("PictureAvailable");
            OnPropertyChanged("SelectedFilterItem");
            OnPropertyChanged("EditPictureAvailable");
        }
Beispiel #4
0
        public void SaveChanges(object commandParam)
        {
            decimal tmpLength;
            decimal tmpWeight;
            DateTime tmpDoB;
            String[] formats = { "yyyy/dd/MM", "yyyy/dd/M", "yyyy/d/MM", "yyyy/d/M", "dd/MM/yyyy", "dd/M/yyyy", "d/MM/yyyy", "d/M/yyyy" };

            gymnast gymnast = creatingNewGymnast ? new gymnast() : SelectedFilterItem;

            gymnast.name = EditName;
            gymnast.surname_prefix = EditPrefix;
            gymnast.surname = EditSurname;
            gymnast.turnbondID = long.Parse(EditFIGNumber);
            gymnast.birthdate = DateTime.TryParseExact(EditDateOfBirth, formats, CultureInfo.InvariantCulture, DateTimeStyles.None, out tmpDoB) ? tmpDoB : (DateTime?)null;
            gymnast.nationality = EditNationality;
            gymnast.gender = EditGender;
            gymnast.length = decimal.TryParse(EditLength.Replace(",", "."), out tmpLength) ? tmpLength : (decimal?)null;
            gymnast.weight = decimal.TryParse(EditWeight.Replace(",", "."), out tmpWeight) ? tmpWeight : (decimal?)null;
            gymnast.note = EditMemos;
            //gymnast.picture = EditPicture;
            if (EditPicture != null)
            {
                BitmapImage bImage = EditPicture as BitmapImage;
                byte[] data = null;

                //large picture
                JpegBitmapEncoder encoder = new JpegBitmapEncoder();
                encoder.Frames.Add(BitmapFrame.Create(bImage));
                using (MemoryStream ms = new MemoryStream())
                {
                    encoder.Save(ms);
                    data = ms.ToArray();
                    gymnast.picture = data;
                }

                //small picture
                bImage.DecodePixelHeight = 32;
                bImage.DecodePixelWidth = 32;
                encoder = new JpegBitmapEncoder();
                encoder.Frames.Add(BitmapFrame.Create(bImage));
                using (MemoryStream ms = new MemoryStream())
                {
                    encoder.Save(ms);
                    data = ms.ToArray();
                    gymnast.picture_small = data;
                }
            }

            if (creatingNewGymnast)
            { // Create a new Gymnast
                uModule.create(gymnast);

                selectedFilterItem = null;
                Name = "";
                Prefix = "";
                Surname = "";
                FIGNumber = "";
                DateOfBirth = "";
                Nationality = "";
                Gender = "";
                Length = "";
                Weight = "";
                Memos = "";
                Picture = null;
            }
            else
            { // update gymnast
                uModule.update(gymnast);
                SelectedFilterItem = gymnast; // re-setting selected filter. Should update appropriate fields.
            }

            CancelChanges(null); // returns to non editing mode
            EnableFilter = true;
            inEditingMode = false;

            gymnastList = uModule.getGymnastCollection();
            applyFilter();
            OnPropertyChanged("FilterList");
            OnPropertyChanged("Fullname");
            OnPropertyChanged("IsEditing");
            OnPropertyChanged("IsNotEditing");
            OnPropertyChanged("PictureAvailable");
            OnPropertyChanged("SelectedFilterItem");
            OnPropertyChanged("EditPictureAvailable");
        }
Beispiel #5
0
        public void DeleteGymnast(object commandParam)
        {
            if (!_app.IsLoggedIn)
            {
                _app.ShowLoginView();

            }
            if (_app.IsLoggedIn && SelectedFilterItem != null)
            {
                MessageBoxResult messageBoxResult = MessageBox.Show("Are you sure?", "Delete Confirmation", MessageBoxButton.YesNo);
                if (messageBoxResult == MessageBoxResult.Yes)
                {
                    uModule.delete(SelectedFilterItem.gymnast_id);

                    selectedFilterItem = null;
                    Name = "";
                    Prefix = "";
                    Surname = "";
                    FIGNumber = "";
                    DateOfBirth = "";
                    Nationality = "";
                    Gender = "";
                    Length = "";
                    Weight = "";
                    Memos = "";
                    Picture = null;
                    EnableFilter = true;
                    inEditingMode = false;

                    gymnastList = uModule.getGymnastCollection();
                    applyFilter();
                    OnPropertyChanged("FilterList");
                    OnPropertyChanged("Fullname");
                    OnPropertyChanged("IsEditing");
                    OnPropertyChanged("IsNotEditing");
                    OnPropertyChanged("PictureAvailable");
                    OnPropertyChanged("SelectedFilterItem");
                    OnPropertyChanged("EditPictureAvailable");
                }
            }
        }