private JsonDictionaryStringConstructor WritePartsRequestToOutput(PartsRequest request, MySqlDataManipulator manipulator, int companyId)
{
JsonDictionaryStringConstructor ret = new JsonDictionaryStringConstructor();
var user = manipulator.GetUserById(request.UserId);
if (user == null)
{
ret.SetMapping("DisplayName", "defaultUser");
}
else
{
List <UserSettingsEntry> entries = JsonDataObjectUtil <List <UserSettingsEntry> > .ParseObject(user.Settings);
ret.SetMapping("DisplayName", entries.Where(entry => entry.Key.Equals(UserSettingsEntryKeys.DisplayName)).First().Value);
}
List <int> referencedParts = JsonDataObjectUtil <List <int> > .ParseObject(request.ReferencedParts);
JsonListStringConstructor partsConstructor = new JsonListStringConstructor();
foreach (int i in referencedParts)
{
var part = manipulator.GetPartCatalogueEntryById(companyId, i);
if (part == null)
{
continue;
}
partsConstructor.AddElement(part.PartId);
}
ret.SetMapping("ReferencedParts", partsConstructor);
ret.SetMapping("JobId", request.JobId);
ret.SetMapping("Id", request.Id);
return(ret);
}
private JsonDictionaryStringConstructor WritePartsListRequestToOutput(RequirementAdditionRequest request, MySqlDataManipulator connection, int companyId)
{
JsonDictionaryStringConstructor ret = new JsonDictionaryStringConstructor();
var user = connection.GetUserById(request.UserId);
if (user == null)
{
ret.SetMapping("DisplayName", "Unknown User");
}
else
{
List <UserSettingsEntry> userSettings = JsonDataObjectUtil <List <UserSettingsEntry> > .ParseObject(user.Settings);
ret.SetMapping("DisplayName", userSettings.Where(entry => entry.Key.Equals(UserSettingsEntryKeys.DisplayName)).First().Value);
}
var part = connection.GetPartCatalogueEntryById(companyId, int.Parse(request.RequestedAdditions));
if (part == null)
{
ret.SetMapping("RequestedAdditions", "Unknown Part");
}
else
{
ret.SetMapping("RequestedAdditions", part.PartId);
}
JsonListStringConstructor partsConstructor = new JsonListStringConstructor();
var job = connection.GetDataEntryById(companyId, request.ValidatedDataId);
if (job == null)
{
ret.SetMapping("JobId", "Unknown");
}
else
{
ret.SetMapping("JobId", job.JobId);
}
ret.SetMapping("Id", request.Id);
return(ret);
}
/// <summary>
/// PATCH request format located in the Web Api Enumeration v2
/// under the tab Company/Parts, starting row 28
/// </summary>
/// <param name="ctx">HttpListenerContext to respond to</param>
private void HandlePatchRequest(HttpListenerContext ctx)
{
try
{
#region Inpute Validation
if (!ctx.Request.HasEntityBody)
{
WriteBodyResponse(ctx, 400, "Bad Request", "No Body");
return;
}
string reqStr;
using (var reader = new StreamReader(ctx.Request.InputStream))
{
reqStr = reader.ReadToEnd();
}
CompanyPartsApiPatchRequest entry = JsonDataObjectUtil <CompanyPartsApiPatchRequest> .ParseObject(reqStr);
if (!ValidatePatchRequest(entry))
{
CompanyPartsApiDeleteRequest entry2 = JsonDataObjectUtil <CompanyPartsApiDeleteRequest> .ParseObject(reqStr);
if (entry2 != null)
{
HandleDeleteRequest(ctx, entry2);
return;
}
WriteBodyResponse(ctx, 400, "Bad Request", "Incorrect Format");
return;
}
#endregion
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.PartMask) == 0)
{
WriteBodyResponse(ctx, 401, "Not Autherized", "Not marked as a Parts User");
return;
}
#endregion
#region Edit Parts Entry
var partEntry = connection.GetPartCatalogueEntryById(mappedUser.Company, entry.PartEntryId);
if (partEntry == null)
{
WriteBodyResponse(ctx, 404, "Not Found", "Part entry with the given id was not found");
return;
}
switch (entry.FieldName)
{
case "Make":
partEntry.Make = entry.FieldValue;
break;
case "Model":
partEntry.Model = entry.FieldValue;
break;
case "Year":
partEntry.Year = int.Parse(entry.FieldValue);
break;
case "PartId":
partEntry.PartId = entry.FieldValue;
break;
case "PartName":
partEntry.PartName = entry.FieldValue;
break;
default:
WriteBodyResponse(ctx, 404, "Not Found", "The field specified was not found");
return;
}
if (!connection.UpdatePartEntry(mappedUser.Company, partEntry))
{
WriteBodyResponse(ctx, 500, "Internal Server Error", "Error occured while removing part entry: " + 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);
}
}
/// <summary>
/// DELETE request format located in the Web Api Enumeration v2
/// under the tab Company/Parts, starting row 51
/// </summary>
/// <param name="ctx">HttpListenerContext to respond to</param>
private void HandleDeleteRequest(HttpListenerContext ctx, CompanyPartsApiDeleteRequest req)
{
try
{
#region Input Validation
if (!ValidateDeleteRequest(req))
{
WriteBodyResponse(ctx, 400, "Bad Request", "Incorrect Format");
return;
}
#endregion
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(req.UserId);
if (mappedUser == null)
{
WriteBodyResponse(ctx, 404, "Not Found", "User was not found on on the server");
return;
}
if (!UserVerificationUtil.LoginTokenValid(mappedUser, req.LoginToken))
{
WriteBodyResponse(ctx, 401, "Not Authorized", "Login token was incorrect.");
return;
}
if (!UserVerificationUtil.AuthTokenValid(mappedUser, req.AuthToken))
{
WriteBodyResponse(ctx, 401, "Not Authorized", "Auth token was ezpired or incorrect");
return;
}
if ((mappedUser.AccessLevel & AccessLevelMasks.PartMask) == 0)
{
WriteBodyResponse(ctx, 401, "Not Autherized", "Not marked as a Parts User");
return;
}
#endregion
#region Delete Parts Request
if (connection.GetPartCatalogueEntryById(mappedUser.Company, req.PartEntryId) == null)
{
WriteBodyResponse(ctx, 404, "Not Found", "Part entry with the given id was not found");
return;
}
if (!connection.RemovePartCatalogueEntry(mappedUser.Company, req.PartEntryId))
{
WriteBodyResponse(ctx, 500, "Internal Server Error", "Error occured while removing part entry: " + 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);
}
}