Example #1
0
        public static void InsertUser(string userName)
        {
            using (TransactionScope scope = new TransactionScope())
            {
                using (GroupsEntities context = new GroupsEntities())
                {
                    Group adminGroup = new Group {
                        GroupName = "Admins"
                    };
                    if (context.Groups.Count(x => x.GroupName == "Admins") == 0)
                    {
                        context.Groups.Add(adminGroup);
                        context.SaveChanges();
                        scope.Complete();
                    }
                    else
                    {
                        if (context.Users.Count(x => x.UserName == userName) > 0)
                        {
                            Console.WriteLine("User already exists.");
                            scope.Dispose();
                        }

                        Group currentgroup = context.Groups
                                             .Where(x => x.GroupName == "Adminss").First();

                        User newUser = new User()
                        {
                            UserName = userName,
                            GroupID  = currentgroup.GroupID
                        };

                        context.Users.Add(newUser);
                        context.SaveChanges();
                        scope.Complete();
                    }
                }
            }
        }
Example #2
0
        public static void InsertUser(string userName)
        {
            using (TransactionScope scope = new TransactionScope())
            {
                using (GroupsEntities context = new GroupsEntities())
                {
                    Group adminGroup = new Group { GroupName = "Admins" };
                    if (context.Groups.Count(x => x.GroupName == "Admins") == 0)
                    {
                        context.Groups.Add(adminGroup);
                        context.SaveChanges();
                        scope.Complete();
                    }
                    else
                    {
                        if (context.Users.Count(x => x.UserName == userName) > 0)
                        {
                            Console.WriteLine("User already exists.");
                            scope.Dispose();
                        }

                        Group currentgroup = context.Groups
                            .Where(x => x.GroupName == "Adminss").First();

                        User newUser = new User()
                        {
                            UserName = userName,
                            GroupID = currentgroup.GroupID
                        };

                        context.Users.Add(newUser);
                        context.SaveChanges();
                        scope.Complete();
                    }
                }
            }

        }