This project is an API built with Express.js to manage hall bookings and customer data. The API provides endpoints to create halls, add customer details, and retrieve filtered booking information.
\n","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"owner":"35084741","collectionId":"7151a5cb-d5c7-4cec-b82c-365fdb277b10","publishedId":"2sA3duGZ8A","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"FF6C37"},"publishDate":"2024-06-30T09:47:44.000Z"},"item":[{"name":"GetDetailsHall","id":"a99f89c8-1ea5-4048-b490-f899b997ccd3","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/HallDatils","description":"StartFragment
\nURL: /HallDetails
Method: GET
\nDescription: Retrieves the details of all halls
\nEndFragment
\n","urlObject":{"protocol":"https","path":["api","HallDatils"],"host":["hall-booking-nodejs-ddnn","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"3279e8a0-c193-4d3c-ab06-267ef6751c9e","name":"GetDetailsHall","originalRequest":{"method":"GET","header":[],"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/HallDatils"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sun, 30 Jun 2024 10:56:03 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"188"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"89bda0a40924a92b-MAA"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Encoding","value":"gzip"},{"key":"ETag","value":"W/\"256-SaTrsYaVTA9f62bT8rA0Z94zERU\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"rndr-id","value":"7674bcdf-b3e1-4114"},{"key":"x-powered-by","value":"Express"},{"key":"x-render-origin-server","value":"Render"},{"key":"Server","value":"cloudflare"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n \"data\": [\n {\n \"Hall_id\": 1,\n \"Hall_Name\": \"large\",\n \"H_AvaSeate\": 100,\n \"HoursPrice\": 800,\n \"amenites\": \"AC/Toilat/WIFI\",\n \"statusAva\": \"booked\"\n },\n {\n \"Hall_id\": 2,\n \"Hall_Name\": \"medium\",\n \"H_AvaSeate\": 50,\n \"HoursPrice\": 500,\n \"amenites\": \"AC/Toilat/WIFI\",\n \"statusAva\": \"booked\"\n },\n {\n \"Hall_id\": 3,\n \"Hall_Name\": \"small\",\n \"H_AvaSeate\": 20,\n \"HoursPrice\": 300,\n \"amenites\": \"AC/Toilat/WIFI\",\n \"statusAva\": \"booked\"\n },\n {\n \"Hall_id\": 4,\n \"Hall_Name\": \"medium\",\n \"H_AvaSeate\": 50,\n \"HoursPrice\": 500,\n \"amenites\": \"AC/Toilat/WIFI\",\n \"statusAva\": \"unbooked\"\n },\n {\n \"Hall_id\": 5,\n \"Hall_Name\": \"large\",\n \"H_AvaSeate\": 100,\n \"HoursPrice\": 800,\n \"amenites\": \"AC/Toilat/WIFI\",\n \"statusAva\": \"unbooked\"\n }\n ]\n}"}],"_postman_id":"a99f89c8-1ea5-4048-b490-f899b997ccd3"},{"name":"CreateHall","id":"c8553bbd-8573-4732-8d7f-6c946b3a6f9f","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"Hall_Name\": \"large\",\r\n \"H_AvaSeate\": 100,\r\n \"HoursPrice\": 800,\r\n \"amenites\": \"AC/Toilat/WIFI\",\r\n \"statusAva\": \"unbooked\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/createHall","description":"StartFragment
\nURL: /createHall
Method: POST
\nDescription: Creates a new hall.
\nEndFragment
\n","urlObject":{"protocol":"https","path":["api","createHall"],"host":["hall-booking-nodejs-ddnn","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"9d375501-794d-4f4b-b805-2387a9f7963e","name":"CreateHall","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"Hall_Name\": \"large\",\r\n \"H_AvaSeate\": 100,\r\n \"HoursPrice\": 800,\r\n \"amenites\": \"AC/Toilat/WIFI\",\r\n \"statusAva\": \"unbooked\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/createHall"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sun, 30 Jun 2024 10:56:09 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"159"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"89bda0cbccd8a92b-MAA"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Encoding","value":"gzip"},{"key":"ETag","value":"W/\"a4-DmVx3xZ26RrkonS8GDc5M3IOCfo\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"rndr-id","value":"98429fff-e856-426c"},{"key":"x-powered-by","value":"Express"},{"key":"x-render-origin-server","value":"Render"},{"key":"Server","value":"cloudflare"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n \"message\": \"Hall create Successfully\",\n \"data\": {\n \"Hall_id\": 6,\n \"Hall_Name\": \"large\",\n \"H_AvaSeate\": 100,\n \"HoursPrice\": 800,\n \"amenites\": \"AC/Toilat/WIFI\",\n \"statusAva\": \"unbooked\"\n }\n}"}],"_postman_id":"c8553bbd-8573-4732-8d7f-6c946b3a6f9f"},{"name":"CustomerData","id":"721acbd7-6bf2-4799-8a16-8a3b5776c659","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/CustomerDetails","description":"StartFragment
\nURL: /CustomerDetails
Method: GET
\nDescription: Retrieves the details of all customers.
\nEndFragment
\n","urlObject":{"protocol":"https","path":["api","CustomerDetails"],"host":["hall-booking-nodejs-ddnn","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"393b8c53-eb03-496a-b568-7b3f0ffa0f80","name":"CustomerData","originalRequest":{"method":"GET","header":[],"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/CustomerDetails"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sun, 30 Jun 2024 10:56:15 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"165"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"89bda0f13da2a92b-MAA"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Encoding","value":"gzip"},{"key":"ETag","value":"W/\"19f-/XZncM9H7d/7QNUo7iXNfKNSTvs\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"rndr-id","value":"56cfa7d9-5ae2-4684"},{"key":"x-powered-by","value":"Express"},{"key":"x-render-origin-server","value":"Render"},{"key":"Server","value":"cloudflare"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n \"data\": [\n {\n \"Cus_id\": 1,\n \"Cus_Name\": \"Rupen\",\n \"Data\": \"30/06/24\",\n \"Hall_id\": 1,\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\"\n },\n {\n \"Cus_id\": 2,\n \"Cus_Name\": \"Akash\",\n \"Data\": \"3/07/24\",\n \"Hall_id\": 2,\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\"\n },\n {\n \"Cus_id\": 3,\n \"Cus_Name\": \"giri\",\n \"Data\": \"10/08/24\",\n \"Hall_id\": 3,\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\"\n },\n {\n \"Cus_id\": 4,\n \"Cus_Name\": \"hari\",\n \"Data\": \"20/12/24\",\n \"Hall_id\": 2,\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\"\n }\n ]\n}"}],"_postman_id":"721acbd7-6bf2-4799-8a16-8a3b5776c659"},{"name":"AddCustomer","id":"4293c1bb-887f-45d5-9747-3790e0a2a66a","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"Cus_Name\": \"hari\",\r\n \"Data\": \"20/12/24\",\r\n \"S_Time\": \"10:00 AM\",\r\n \"E_Time\": \"10:00 PM\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/AddCustomer","description":"StartFragment
\nURL: /AddCustomer
Method: POST
\nDescription: Adds a new customer.
\nEndFragment
\n","urlObject":{"protocol":"https","path":["api","AddCustomer"],"host":["hall-booking-nodejs-ddnn","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"e9e4ad24-8388-4bac-8f36-2cff3463030e","name":"AddCustomer","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"Cus_Name\": \"hari\",\r\n \"Data\": \"20/12/24\",\r\n \"S_Time\": \"10:00 AM\",\r\n \"E_Time\": \"10:00 PM\"\r\n}","options":{"raw":{"language":"json"}}},"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/AddCustomer"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sun, 30 Jun 2024 10:56:21 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"141"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"89bda112f9e7a92b-MAA"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Encoding","value":"gzip"},{"key":"ETag","value":"W/\"93-h1oignccOAovwxy2nyzOxPW5Mjc\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"rndr-id","value":"2e421a68-c973-463a"},{"key":"x-powered-by","value":"Express"},{"key":"x-render-origin-server","value":"Render"},{"key":"Server","value":"cloudflare"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n \"message\": \"Customer Add Successfully\",\n \"data\": {\n \"Cus_id\": 5,\n \"Cus_Name\": \"hari\",\n \"Data\": \"20/12/24\",\n \"Hall_id\": 7,\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\"\n }\n}"}],"_postman_id":"4293c1bb-887f-45d5-9747-3790e0a2a66a"},{"name":"BookedHall","id":"421e0c82-08dd-4ccb-9182-f6b3b8ba4f8b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/filterBookedhall","description":"StartFragment
\nURL: /filterBookedhall
Method: GET
\nDescription: Retrieves details of booked halls along with customer details.
\nEndFragment
\n","urlObject":{"protocol":"https","path":["api","filterBookedhall"],"host":["hall-booking-nodejs-ddnn","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"b0d26dd2-4616-4e43-bf3e-0024d56f9680","name":"BookedHall","originalRequest":{"method":"GET","header":[],"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/filterBookedhall"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sun, 30 Jun 2024 10:56:26 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"191"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"89bda1347f0ea92b-MAA"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Encoding","value":"gzip"},{"key":"ETag","value":"W/\"17a-YpkAp7L9DHbzPgLpwqdqiLqrfV0\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"rndr-id","value":"553d88f6-54a3-41e8"},{"key":"x-powered-by","value":"Express"},{"key":"x-render-origin-server","value":"Render"},{"key":"Server","value":"cloudflare"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n \"message\": \"Fliter BookHall Details\",\n \"data\": [\n {\n \"Hall_id\": 1,\n \"Hall_Name\": \"large\",\n \"Cus_Name\": \"Rupen\",\n \"Data\": \"30/06/24\",\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\"\n },\n {\n \"Hall_id\": 2,\n \"Hall_Name\": \"medium\",\n \"Cus_Name\": \"Akash\",\n \"Data\": \"3/07/24\",\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\"\n },\n {\n \"Hall_id\": 3,\n \"Hall_Name\": \"small\",\n \"Cus_Name\": \"giri\",\n \"Data\": \"10/08/24\",\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\"\n }\n ]\n}"}],"_postman_id":"421e0c82-08dd-4ccb-9182-f6b3b8ba4f8b"},{"name":"Cus_hall_Booking","id":"212e29a2-46e8-4faf-a863-d40559f8d0ed","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/fliterCustomer","description":"StartFragment
\nURL: /fliterCustomer
Method: GET
\nDescription: Retrieves customer booking details for booked halls.
\nEndFragment
\n","urlObject":{"protocol":"https","path":["api","fliterCustomer"],"host":["hall-booking-nodejs-ddnn","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"cb71ba72-8b44-4c74-a1cc-e38e99b6d6e0","name":"Cus_hall_Booking","originalRequest":{"method":"GET","header":[],"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/fliterCustomer"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sun, 30 Jun 2024 10:56:33 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"189"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"89bda16288fea92b-MAA"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Encoding","value":"gzip"},{"key":"ETag","value":"W/\"163-DTxyiHnpsF3EcsKd4yDqla0FG5w\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"rndr-id","value":"a0dc2497-ce23-4e69"},{"key":"x-powered-by","value":"Express"},{"key":"x-render-origin-server","value":"Render"},{"key":"Server","value":"cloudflare"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n \"message\": \"Filter Customer Hall Booking Details\",\n \"data\": [\n {\n \"Cus_Name\": \"Rupen\",\n \"Hall_Name\": \"large\",\n \"Data\": \"30/06/24\",\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\"\n },\n {\n \"Cus_Name\": \"Akash\",\n \"Hall_Name\": \"medium\",\n \"Data\": \"3/07/24\",\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\"\n },\n {\n \"Cus_Name\": \"giri\",\n \"Hall_Name\": \"small\",\n \"Data\": \"10/08/24\",\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\"\n }\n ]\n}"}],"_postman_id":"212e29a2-46e8-4faf-a863-d40559f8d0ed"},{"name":"FilterCount","id":"004c72e1-4a2d-4c77-910e-cb6784f6cd13","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"GET","header":[],"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/Cus_many_Booked","description":"StartFragment
\nURL: /Cus_many_Booked
Method: GET
\nDescription: Retrieves how many times each hall is booked along with customer details.
\nEndFragment
\n","urlObject":{"protocol":"https","path":["api","Cus_many_Booked"],"host":["hall-booking-nodejs-ddnn","onrender","com"],"query":[],"variable":[]}},"response":[{"id":"48a4ff83-e576-42cc-af88-b1e5830ea56b","name":"FilterCount","originalRequest":{"method":"GET","header":[],"url":"https://hall-booking-nodejs-ddnn.onrender.com/api/Cus_many_Booked"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Date","value":"Sun, 30 Jun 2024 10:56:52 GMT"},{"key":"Content-Type","value":"application/json; charset=utf-8"},{"key":"Content-Length","value":"197"},{"key":"Connection","value":"keep-alive"},{"key":"CF-Ray","value":"89bda1d3db91a92b-MAA"},{"key":"CF-Cache-Status","value":"DYNAMIC"},{"key":"Access-Control-Allow-Origin","value":"*"},{"key":"Content-Encoding","value":"gzip"},{"key":"ETag","value":"W/\"1a5-pwXqQINdL5K1Ff7Yci2q5YlUy6M\""},{"key":"Vary","value":"Accept-Encoding"},{"key":"rndr-id","value":"2730072c-c887-4d27"},{"key":"x-powered-by","value":"Express"},{"key":"x-render-origin-server","value":"Render"},{"key":"Server","value":"cloudflare"},{"key":"alt-svc","value":"h3=\":443\"; ma=86400"}],"cookie":[],"responseTime":null,"body":"{\n \"message\": \"Filter\",\n \"data\": [\n {\n \"Cus_Name\": \"Rupen\",\n \"Hall_Name\": \"large\",\n \"Data\": \"30/06/24\",\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\",\n \"Cus_id\": 1,\n \"statusAva\": \"booked\"\n },\n {\n \"Cus_Name\": \"Akash\",\n \"Hall_Name\": \"medium\",\n \"Data\": \"3/07/24\",\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\",\n \"Cus_id\": 2,\n \"statusAva\": \"booked\"\n },\n {\n \"Cus_Name\": \"giri\",\n \"Hall_Name\": \"small\",\n \"Data\": \"10/08/24\",\n \"S_Time\": \"10:00 AM\",\n \"E_Time\": \"10:00 PM\",\n \"Cus_id\": 3,\n \"statusAva\": \"booked\"\n }\n ]\n}"}],"_postman_id":"004c72e1-4a2d-4c77-910e-cb6784f6cd13"}]}