public static bool InitializeJoinRequests()
{
if (!DatabaseInitialized)
{
return(false);
}
MySqlDataManipulator manipulator = new MySqlDataManipulator();
if (!manipulator.Connect(TestingConstants.ConnectionString))
{
return(false);
}
using (manipulator) {
if (manipulator.GetJoinRequests(1).Count == 0)
{
if (!manipulator.AddJoinRequest(TestingJoinRequest.ValidRequest1.CompanyId, TestingJoinRequest.ValidRequest1.UserId))
{
Console.WriteLine(manipulator.LastException.Message);
return(false);
}
}
if (manipulator.GetJoinRequests(2).Count == 0)
{
if (!manipulator.AddJoinRequest(TestingJoinRequest.ValidRequest2.CompanyId, TestingJoinRequest.ValidRequest2.UserId))
{
Console.WriteLine(manipulator.LastException.Message);
return(false);
}
}
}
return(true);
}
/// <summary>
/// GET request format located in the Web Api Enumeration v2
/// under the tab Company/Requests, starting row 23
/// </summary>
/// <param name="ctx">HttpListenerContext to respond to</param>
private void HandleGetRequest(HttpListenerContext ctx, CompanyRequestsGetRequest entry)
{
try
{
MySqlDataManipulator connection = new MySqlDataManipulator();
using (connection)
{
bool res = connection.Connect(MySqlDataManipulator.GlobalConfiguration.GetConnectionString());
if (!res)
{
WriteBodyResponse(ctx, 500, "Unexpected Server Error", "Connection to database failed");
return;
}
#region User Validation
OverallUser mappedUser = connection.GetUserById(entry.UserId);
if (mappedUser == null)
{
WriteBodyResponse(ctx, 404, "Not Found", "User was not found on on the server");
return;
}
if (!UserVerificationUtil.LoginTokenValid(mappedUser, entry.LoginToken))
{
WriteBodyResponse(ctx, 401, "Not Authorized", "Login token was incorrect.");
return;
}
if (!UserVerificationUtil.AuthTokenValid(mappedUser, entry.AuthToken))
{
WriteBodyResponse(ctx, 401, "Not Authorized", "Auth token was ezpired or incorrect");
return;
}
if ((mappedUser.AccessLevel & AccessLevelMasks.AdminMask) == 0)
{
WriteBodyResponse(ctx, 401, "Not Authorized", "User was not an administrative user");
return;
}
#endregion
#region Action Handling
var requests = connection.GetJoinRequests(mappedUser.Company);
JsonListStringConstructor returnConstructor = new JsonListStringConstructor();
requests.ForEach(req => returnConstructor.AddElement(WriteJoinRequestToOutput(req, connection)));
WriteBodyResponse(ctx, 200, "OK", returnConstructor.ToString());
#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);
}
}