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();
}
}
}
}
