private void SetDataGrid(object selectedvalue)
        {
            //set up the ui of the data grid, hide unwanted information, style the border
            Style headerStyle           = new Style();
            DataGridColumnHeader header = new DataGridColumnHeader();

            headerStyle.TargetType = header.GetType();

            headerStyle.Setters.Add(new Setter {
                Property = Control.BackgroundProperty, Value = Brushes.DarkGreen
            });
            headerStyle.Setters.Add(new Setter {
                Property = Control.ForegroundProperty, Value = Brushes.White
            });
            headerStyle.Setters.Add(new Setter {
                Property = Control.FontWeightProperty, Value = FontWeights.Bold
            });
            headerStyle.Setters.Add(new Setter {
                Property = Control.BorderThicknessProperty, Value = new Thickness(0.5)
            });
            headerStyle.Setters.Add(new Setter {
                Property = Control.BorderBrushProperty, Value = Brushes.White
            });
            headerStyle.Setters.Add(new Setter {
                Property = Control.HorizontalContentAlignmentProperty, Value = HorizontalAlignment.Center
            });

            this.grdData.RowBackground            = Brushes.White;
            this.grdData.AlternatingRowBackground = Brushes.LightGreen;

            switch (selectedvalue)
            {
            case "Customer":
                grdData.Columns[0].Visibility   = Visibility.Hidden;
                grdData.Columns[1].Visibility   = Visibility.Hidden;
                grdData.Columns[2].Visibility   = Visibility.Hidden;
                grdData.Columns[3].Visibility   = Visibility.Hidden;
                grdData.Columns[4].Visibility   = Visibility.Hidden;
                grdData.Columns[5].Visibility   = Visibility.Hidden;
                grdData.Columns[6].Visibility   = Visibility.Hidden;
                grdData.Columns[7].HeaderStyle  = headerStyle;
                grdData.Columns[8].HeaderStyle  = headerStyle;
                grdData.Columns[9].Header       = "Property Size";
                grdData.Columns[9].Width        = Width * 0.25;
                grdData.Columns[9].HeaderStyle  = headerStyle;
                grdData.Columns[10].Visibility  = Visibility.Hidden;
                grdData.Columns[11].Header      = "Name";
                grdData.Columns[11].Width       = Width * 0.25;
                grdData.Columns[11].HeaderStyle = headerStyle;
                grdData.Columns[12].Header      = "Address";
                grdData.Columns[12].Width       = Width * 0.25;
                grdData.Columns[12].HeaderStyle = headerStyle;
                break;

            case "Employee":
                grdData.Columns[0].Visibility   = Visibility.Hidden;
                grdData.Columns[1].Visibility   = Visibility.Hidden;
                grdData.Columns[2].Visibility   = Visibility.Hidden;
                grdData.Columns[3].Visibility   = Visibility.Hidden;
                grdData.Columns[4].Visibility   = Visibility.Hidden;
                grdData.Columns[5].Visibility   = Visibility.Hidden;
                grdData.Columns[6].Visibility   = Visibility.Hidden;
                grdData.Columns[9].Visibility   = Visibility.Hidden;
                grdData.Columns[1].HeaderStyle  = headerStyle;
                grdData.Columns[2].HeaderStyle  = headerStyle;
                grdData.Columns[7].HeaderStyle  = headerStyle;
                grdData.Columns[7].Width        = Width * 0.3;
                grdData.Columns[8].HeaderStyle  = headerStyle;
                grdData.Columns[10].HeaderStyle = headerStyle;
                grdData.Columns[10].Header      = "Name";
                grdData.Columns[10].Width       = Width * 0.3;
                grdData.Columns[11].HeaderStyle = headerStyle;
                grdData.Columns[11].Header      = "Address";
                grdData.Columns[11].Width       = Width * 0.3;
                break;

            case "Appointment":
                grdData.Columns[0].Visibility   = Visibility.Hidden;
                grdData.Columns[1].Visibility   = Visibility.Hidden;
                grdData.Columns[2].Visibility   = Visibility.Hidden;
                grdData.Columns[3].Header       = "Start Date";
                grdData.Columns[3].HeaderStyle  = headerStyle;
                grdData.Columns[4].Header       = "End Date";
                grdData.Columns[4].HeaderStyle  = headerStyle;
                grdData.Columns[5].Visibility   = Visibility.Hidden;
                grdData.Columns[6].HeaderStyle  = headerStyle;
                grdData.Columns[7].Header       = "Service";
                grdData.Columns[7].HeaderStyle  = headerStyle;
                grdData.Columns[8].Header       = "Rate";
                grdData.Columns[8].HeaderStyle  = headerStyle;
                grdData.Columns[9].Header       = "Length";
                grdData.Columns[9].HeaderStyle  = headerStyle;
                grdData.Columns[10].Visibility  = Visibility.Hidden;
                grdData.Columns[11].Visibility  = Visibility.Hidden;
                grdData.Columns[12].Visibility  = Visibility.Hidden;
                grdData.Columns[13].Visibility  = Visibility.Hidden;
                grdData.Columns[14].Visibility  = Visibility.Hidden;
                grdData.Columns[15].Visibility  = Visibility.Hidden;
                grdData.Columns[16].Visibility  = Visibility.Hidden;
                grdData.Columns[17].Visibility  = Visibility.Hidden;
                grdData.Columns[18].HeaderStyle = headerStyle;
                grdData.Columns[19].HeaderStyle = headerStyle;
                grdData.Columns[20].Header      = "Property Size";
                grdData.Columns[20].HeaderStyle = headerStyle;
                grdData.Columns[21].Header      = "Customer Name";
                grdData.Columns[21].HeaderStyle = headerStyle;
                grdData.Columns[22].Header      = "Employee Name";
                grdData.Columns[22].HeaderStyle = headerStyle;
                grdData.Columns[23].Header      = "Address";
                grdData.Columns[23].HeaderStyle = headerStyle;
                break;

            case "ServiceType":
                grdData.Columns[0].Visibility  = Visibility.Hidden;
                grdData.Columns[1].HeaderStyle = headerStyle;
                grdData.Columns[1].Width       = Width * 0.5;
                grdData.Columns[2].HeaderStyle = headerStyle;
                grdData.Columns[2].Header      = "Rate";
                grdData.Columns[2].Width       = Width * 0.5;
                break;

            case "Invoice":
                grdData.Columns[0].Visibility   = Visibility.Hidden;
                grdData.Columns[1].Visibility   = Visibility.Hidden;
                grdData.Columns[2].Visibility   = Visibility.Hidden;
                grdData.Columns[3].Visibility   = Visibility.Hidden;
                grdData.Columns[4].Visibility   = Visibility.Hidden;
                grdData.Columns[5].HeaderStyle  = headerStyle;
                grdData.Columns[5].Header       = "Customer Name";
                grdData.Columns[6].Visibility   = Visibility.Hidden;
                grdData.Columns[7].Visibility   = Visibility.Hidden;
                grdData.Columns[8].Visibility   = Visibility.Hidden;
                grdData.Columns[9].HeaderStyle  = headerStyle;
                grdData.Columns[9].Header       = "Address";
                grdData.Columns[10].HeaderStyle = headerStyle;
                grdData.Columns[10].Header      = "Email";
                grdData.Columns[11].HeaderStyle = headerStyle;
                grdData.Columns[11].Header      = "Date";
                grdData.Columns[12].HeaderStyle = headerStyle;
                grdData.Columns[12].Header      = "Service";
                grdData.Columns[13].HeaderStyle = headerStyle;
                grdData.Columns[13].Header      = "Property Size";
                grdData.Columns[14].HeaderStyle = headerStyle;
                grdData.Columns[14].Header      = "Rate";
                grdData.Columns[15].HeaderStyle = headerStyle;
                grdData.Columns[15].Header      = "Employee Name";
                grdData.Columns[16].HeaderStyle = headerStyle;
                grdData.Columns[16].Header      = "Status";
                grdData.Columns[17].HeaderStyle = headerStyle;
                grdData.Columns[17].Header      = "Total";
                break;

            case "User":
                grdData.Columns[0].Visibility  = Visibility.Hidden;
                grdData.Columns[1].Visibility  = Visibility.Hidden;
                grdData.Columns[2].Visibility  = Visibility.Hidden;
                grdData.Columns[3].HeaderStyle = headerStyle;
                grdData.Columns[3].Header      = "Username";
                grdData.Columns[3].Width       = Width * 0.5;
                grdData.Columns[4].Visibility  = Visibility.Hidden;
                grdData.Columns[5].Visibility  = Visibility.Hidden;
                grdData.Columns[6].Visibility  = Visibility.Hidden;
                grdData.Columns[7].HeaderStyle = headerStyle;
                grdData.Columns[7].Header      = "Name";
                grdData.Columns[7].Width       = Width * 0.5;
                break;
            }
        }