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