private void btnUpdate_Click(object sender, RoutedEventArgs e)
        {
            if (txtCrewName.Text.Trim() == "")
            {
                MessageBox.Show("Crew name was required!", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
                return;
            }

            if (txtCrewName.Text.Trim() != Crew.CrewName)
            {
                if (Db.Context.Crews.ToList().FirstOrDefault(t => t.CrewName == txtCrewName.Text) != null)
                {
                    MessageBox.Show("This crew name was used", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
                    return;
                }
            }

            if (txtNumberOfMembers.Text.Trim() == "")
            {
                MessageBox.Show("Number of member was required", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
                return;
            }

            try
            {
                var number = int.Parse(txtNumberOfMembers.Text.Trim());
                if (number < Crew.CrewMembers.Count())
                {
                    MessageBox.Show("The number of member must be greater than or equal to the current membes", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
                    return;
                }
            }
            catch (Exception)
            {
                MessageBox.Show("Number of members must be integer", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
                return;
            }

            Crew.CrewName        = txtCrewName.Text.Trim();
            Crew.NumberOfMembers = int.Parse(txtNumberOfMembers.Text.Trim());
            Crew.Office          = cbOffice.SelectedItem as Office;

            Db.Context.SaveChanges();
            ManageWindow.LoadCrews();
            MessageBox.Show("Edit crew successful", "Message", MessageBoxButton.OK, MessageBoxImage.Information);

            this.Close();
        }
        private void btnSave_Click(object sender, RoutedEventArgs e)
        {
            if (txtCrewName.Text.Trim() == "")
            {
                MessageBox.Show("Crew name was required!", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
                return;
            }

            if (Db.Context.Crews.ToList().FirstOrDefault(t => t.CrewName == txtCrewName.Text) != null)
            {
                MessageBox.Show("This crew name was used", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
                return;
            }

            if (txtNumberOfMembers.Text.Trim() == "")
            {
                MessageBox.Show("Number of member was required", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
                return;
            }

            try
            {
                int.Parse(txtNumberOfMembers.Text.Trim());
            }
            catch (Exception)
            {
                MessageBox.Show("Number of members must be integer", "Message", MessageBoxButton.OK, MessageBoxImage.Error);
                return;
            }

            Crew crew = new Crew()
            {
                CrewName        = txtCrewName.Text.Trim(),
                NumberOfMembers = int.Parse(txtNumberOfMembers.Text.Trim()),
                Office          = cbOffice.SelectedItem as Office
            };

            Db.Context.Crews.Add(crew);
            Db.Context.SaveChanges();
            ManageWindow.LoadCrews();
            MessageBox.Show("Add crew successful", "Message", MessageBoxButton.OK, MessageBoxImage.Information);

            this.Close();
        }