/// <summary> /// GET request format located in the Web Api Enumeration v2 /// under the tab Company/Parts, starting row 72 /// </summary> /// <param name="ctx">HttpListenerContext to respond to</param> private void HandleGetRequest(HttpListenerContext ctx) { try { #region Input Validation if (!ctx.Request.HasEntityBody) { WriteBodyResponse(ctx, 400, "Bad Request", "No Body"); return; } CompanyPartsApiGetRequest entry = JsonDataObjectUtil <CompanyPartsApiGetRequest> .ParseObject(ctx); if (!ValidateGetRequest(entry)) { 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 Get Parts List List <PartCatalogueEntry> catelogue = connection.GetPartCatalogueEntries(mappedUser.Company); JsonListStringConstructor retConstructor = new JsonListStringConstructor(); catelogue.ForEach(part => retConstructor.AddElement(WritePartCatelogueEntryToOutput(part))); WriteBodyResponse(ctx, 200, "OK", retConstructor.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); } }
public static bool InitializePartCatelogueEntries() { if (!DatabaseInitialized) { return(false); } MySqlDataManipulator manipulator = new MySqlDataManipulator(); if (!manipulator.Connect(TestingConstants.ConnectionString)) { return(false); } using (manipulator) { if (manipulator.GetPartCatalogueEntries(1).Count == 0) { if (!manipulator.AddPartEntry( 1, new PartCatalogueEntry() { Make = TestingPartEntry.ValidPartEntry1.Make, Model = TestingPartEntry.ValidPartEntry1.Model, Year = TestingPartEntry.ValidPartEntry1.Year, PartId = TestingPartEntry.ValidPartEntry1.PartId, PartName = TestingPartEntry.ValidPartEntry1.PartName } )) { Console.WriteLine(manipulator.LastException.Message); return(false); } if (!manipulator.AddPartEntry( 1, new PartCatalogueEntry() { Make = TestingPartEntry.ValidPartEntry2.Make, Model = TestingPartEntry.ValidPartEntry2.Model, Year = TestingPartEntry.ValidPartEntry2.Year, PartId = TestingPartEntry.ValidPartEntry2.PartId, PartName = TestingPartEntry.ValidPartEntry2.PartName } )) { Console.WriteLine(manipulator.LastException.Message); return(false); } if (!manipulator.AddPartEntry( 1, new PartCatalogueEntry() { Make = TestingPartEntry.ValidPartEntry3.Make, Model = TestingPartEntry.ValidPartEntry3.Model, Year = TestingPartEntry.ValidPartEntry3.Year, PartId = TestingPartEntry.ValidPartEntry3.PartId, PartName = TestingPartEntry.ValidPartEntry3.PartName } )) { Console.WriteLine(manipulator.LastException.Message); return(false); } } } return(true); }