/// <summary> /// Function to create and add the user specified by the command to the database /// </summary> /// <param name="manipulator"><see cref="MySqlDataManipulator"/> used to add the user to the database</param> public override void PerformFunction(MySqlDataManipulator manipulator) { if (!manipulator.AddUser(Email, Password, SecurityQuestion, SecurityAnswer, AccessLevel, CompanyId)) { Console.WriteLine("Error while adding user..."); return; } Console.WriteLine("Successfully added user with email " + Email); }
public static void SetupTestSuite(TestContext ctx) { if (!TestingDatabaseCreationUtils.InitializeDatabaseSchema()) { throw new Exception("Failed to initialize database schema. See logged error"); } Manipulator = new MySqlDataManipulator(); bool res = Manipulator.Connect(TestingConstants.ConnectionString); Manipulator.AddUser("msn", "1234", "red", "blue"); }
/// <summary> /// Request for creating a base mechanic user account. Documention is found in the Web API Enumeration file /// in the /RepairJob/Requirements tab, starting at row 1 /// </summary> /// <param name="ctx">The HttpListenerContext to respond to</param> public void HandlePostRequest(HttpListenerContext ctx) { try { #region Input Validation if (!ctx.Request.HasEntityBody) { WriteBodyResponse(ctx, 400, "No Body", "Request lacked a body"); return; } UserCreationRequest req = JsonDataObjectUtil <UserCreationRequest> .ParseObject(ctx); if (req == null) { WriteBodyResponse(ctx, 400, "Incorrect Format", "Request was in the wrong format"); return; } if (!ValidateCreationResponse(req)) { WriteBodyResponse(ctx, 400, "Incorrect Format", "Not all fields of the request were filled"); return; } #endregion MySqlDataManipulator connection = new MySqlDataManipulator(); using (connection) { bool res = connection.Connect(MySqlDataManipulator.GlobalConfiguration.GetConnectionString()); if (!res) { WriteBodyResponse(ctx, 500, "Unexpected ServerError", "Connection to database failed"); return; } #region Action Handling var users = connection.GetUsersWhere(" Email = \"" + req.Email + "\""); if (users == null) { WriteBodyResponse(ctx, 500, "Unexpected Server Error", connection.LastException.Message); return; } if (users.Count > 0) { WriteBodyResponse(ctx, 409, "User Conflict", "User with email already exists"); return; } res = connection.AddUser(req.Email, req.Password, req.SecurityQuestion, req.SecurityAnswer); if (!res) { WriteBodyResponse(ctx, 500, "Unexpected ServerError", connection.LastException.Message); return; } WriteBodylessResponse(ctx, 200, "OK"); #endregion } } catch (HttpListenerException) { //HttpListeners dispose themselves when an exception occurs, so we can do no more. } catch (Exception e) { WriteBodyResponse(ctx, 500, "Internal Server Error", e.Message); } }
public static bool InitializeUsers() { if (!DatabaseInitialized) { return(false); } MySqlDataManipulator initializer = new MySqlDataManipulator(); using (initializer) { if (!initializer.Connect(TestingConstants.ConnectionString)) { Console.WriteLine("Encountered an error opening the global configuration connection"); Console.WriteLine(initializer.LastException.Message); return(false); } if (initializer.GetUsersWhere(string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser1.Email)).Count == 0) { if (!initializer.AddUser( TestingUserStorage.ValidUser1.Email, TestingUserStorage.ValidUser1.Password, TestingUserStorage.ValidUser1.SecurityQuestion, TestingUserStorage.ValidUser1.SecurityAnswer, TestingUserStorage.ValidUser1.AccessLevel ) ) { Console.WriteLine("Encountered an error adding the first valid user."); Console.WriteLine(initializer.LastException.Message); return(false); } } if (initializer.GetUsersWhere(string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser2.Email)).Count == 0) { if (!initializer.AddUser( TestingUserStorage.ValidUser2.Email, TestingUserStorage.ValidUser2.Password, TestingUserStorage.ValidUser2.SecurityQuestion, TestingUserStorage.ValidUser2.SecurityAnswer, TestingUserStorage.ValidUser2.AccessLevel ) ) { Console.WriteLine("Encountered an error adding the second valid user."); Console.WriteLine(initializer.LastException.Message); return(false); } } if (initializer.GetUsersWhere(string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser3.Email)).Count == 0) { if (!initializer.AddUser( TestingUserStorage.ValidUser3.Email, TestingUserStorage.ValidUser3.Password, TestingUserStorage.ValidUser3.SecurityQuestion, TestingUserStorage.ValidUser3.SecurityAnswer, TestingUserStorage.ValidUser3.AccessLevel ) ) { Console.WriteLine("Encountered an error adding the third valid user."); Console.WriteLine(initializer.LastException.Message); return(false); } } if (initializer.GetUsersWhere(string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser4.Email)).Count == 0) { if (!initializer.AddUser( TestingUserStorage.ValidUser4.Email, TestingUserStorage.ValidUser4.Password, TestingUserStorage.ValidUser4.SecurityQuestion, TestingUserStorage.ValidUser4.SecurityAnswer, TestingUserStorage.ValidUser4.AccessLevel ) ) { Console.WriteLine("Encountered an error adding the fourth valid user."); Console.WriteLine(initializer.LastException.Message); return(false); } } if (initializer.GetUsersWhere(string.Format("Email=\"{0}\"", TestingUserStorage.ValidUser5.Email)).Count == 0) { if (!initializer.AddUser( TestingUserStorage.ValidUser5.Email, TestingUserStorage.ValidUser5.Password, TestingUserStorage.ValidUser5.SecurityQuestion, TestingUserStorage.ValidUser5.SecurityAnswer, TestingUserStorage.ValidUser5.AccessLevel ) ) { Console.WriteLine("Encountered an error adding the fifth valid user."); Console.WriteLine(initializer.LastException.Message); return(false); } } return(true); } }