private static void Main()
{
using (UserRepositoryEntities dbContext = new UserRepositoryEntities())
{
DataAccess.Initialize(dbContext);
try
{
DataAccess.InsertNewUser("Admins", "salman", "s3cr3t", "Salman", "Khan");
}
catch (DbEntityValidationException ex)
{
foreach (var validationResult in ex.EntityValidationErrors)
{
foreach (var error in validationResult.ValidationErrors)
{
Console.WriteLine(error.ErrorMessage);
}
}
}
catch (DbUpdateException ex)
{
Console.WriteLine(ex.InnerException.InnerException.Message);
}
}
}
private static bool CreateUser(string name, string group)
{
User newUser = new User();
newUser.Name = name;
Group newGroup = new Group();
newGroup.Name = group;
bool success = false;
using (var contextDB = new UserRepositoryEntities())
{
using (TransactionScope trans = new TransactionScope())
{
try
{
if (contextDB.Groups.FirstOrDefault(x => x.Name == newGroup.Name) == null)
{
contextDB.Groups.Add(newGroup);
contextDB.SaveChanges();
}
var groupID = contextDB.Groups.First(x => x.Name == newGroup.Name);
newUser.GroupID = groupID.ID;
contextDB.Users.Add(newUser);
contextDB.SaveChanges();
trans.Complete();
success = true;
}
catch (Exception ex)
{
if (ex.GetType() != typeof(System.Data.UpdateException))
{
Console.WriteLine("An error occured. "
+ "The operation cannot be retried."
+ ex.Message);
}
}
}
}
return(success);
}
public static void Initialize(UserRepositoryEntities userRepositoryContext)
{
userRepository = userRepositoryContext;
}
public static void Initialize(UserRepositoryEntities userRepositoryContext)
{
userRepository = userRepositoryContext;
}
