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