Daily Rate Calculation for Room Pricing

Benjamin Vichel

Introduction

Hello! Thanks for reading my project!

The idea of this project is to calculate the value of the daily rate for a specific schadule's range. I use Mysql to store all the daily expenses prices.
If you find any bugs or have sugestions, please give me a feedback in my e-mail adress: benni.vichel@hotmail.com.
Thanks!

How it Works

The end customer will choose a start date and an end date in the program.
The program will fetch the values ​​on the specified date and return them to the customer's screen.

Sections

Section 1 (valores)

In this section, we have:
🛌 Casal (Double room)
🛌 Casal - Luxo (Luxury double room)
🛌 Solteiro (Single value)
🛌Triplo (Triple room)
🛌Quadruplo (Quadruple room)
🛌Quintuplo (Quintuple room)
We also have 2 columns: Diária (daily) and Total (total)
Diária (daily) is the daily rate. calculated by dividing the total daily rate by the number of days.
Total (total) is the total price.
The "single value" is not the value for a room with single bed, but it's the value the program uses to calculate the cost for the triple,quadruple and quintuple rooms.
Example:
In the image the double room value is R$ 420,00. Adding the "single value(solteiro)" with the "double room value(casal)" we get the "triple room value(triplo)".
double room (420,00)+ single value(100,00) = triple room (520,00).
We do exactly the same thing to quadruple and quintuple rooms.

Section 2 (Quarto customizado)

In section 1 we only have room prices for guests over 10 years old. To find out the value of, for example, a triple room with a couple and a child, we use section 2.
The base value in section 2 will always be the value of the double room.

Section 3 (Quarto customizado)

In section 3 the calculated number of daily rates will be shown
#CRUD
Edit your values using CRUD
Password: nathanota10

To Know

Microsoft Visual Stiudio Community 2019
version 16.11.33
Microsoft .NET Framework
Version 4.8.09037
WampServer-3.3.2
Like this project
1

Posted Apr 22, 2025

Calculated daily rates for room pricing using MySQL.

Likes

1

Views

0

Timeline

Mar 1, 2022 - Apr 30, 2022

BenTechPatternMVP API Development
BenTechPatternMVP API Development
Database Configuration Setup
Database Configuration Setup