private void LoadGroupsGrid()
        {
            var groups = GroupAndPermissionModel.GetGroupsPermission();

            List <Group> list      = new List <Group>();
            string       GroupName = "";

            foreach (var group in groups)
            {
                if (GroupName != group.GroupName)
                {
                    Group groupData = new Group();

                    GroupName = group.GroupName;
                    int GroupId = group.GroupId;


                    string Permissions = string.Join("  ,  ", groups.Where(x => x.GroupName.Equals(GroupName))
                                                     .Select(x => x.PermissionName).ToList());
                    groupData.GroupName      = GroupName;
                    groupData.PermissionName = Permissions;
                    groupData.GroupId        = GroupId;
                    list.Add(groupData);
                }
            }

            GroupsGrid.ItemsSource = list;
        }
        private void DropDownLoad()
        {
            var data = GroupAndPermissionModel.GetGroups();

            GroupsDrop.ItemsSource   = data;
            GroupsDrop.SelectedValue = data.Select(x => x.GroupId).First();
            GroupsDrop.SelectedValue = null;
        }
        private void CreateGroup_Click(object sender, RoutedEventArgs e)
        {
            List <int> list = new List <int>();
            string     Name = groupName.Text;


            list.Add(((bool)Billing.IsChecked) ? 1 : 0);
            list.Add(((bool)Inventory.IsChecked) ? 2 : 0);
            list.Add(((bool)Reports.IsChecked) ? 3 : 0);
            list.Add(((bool)Users.IsChecked) ? 4 : 0);

            string message = GroupAndPermissionModel.InsertProduct(Id, Name, list);

            Reset();

            MessageBox.Show(message);
            LoadGroupsGrid();
        }