test-booking-sqlite/Reservation.h at master · HackoDev/test-booking-sqlite · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
#pragma once
#include <ctime>
#include "BaseSQLiteModel.h"
#include "Country.h"
#include "Hotel.h"
#include "User.h"
#include "Room.h"
#include "City.h"

class Reservation :
	public BaseSQLiteModel
{
private:
	// db fields
	int city_id;
	int user_id;
	int room_id;
	std::string start_date;
	std::string end_date;
	float price;
	std::string note;
public:
	Reservation();
	~Reservation();

	// getters
	float get_price();
	std::string get_note();
	std::string get_start_date();
	std::string get_end_date();
	int get_country_id();
	int get_city_id();
	City* get_city();
	Country* get_country();
	Room* get_room();
	Hotel* get_hotel();

	// setters
	void set_price(float value);
	void set_note(std::string value);
	void set_start_date(std::string value);
	void set_start_date(time_t value);
	void set_end_date(std::string value);
	void set_end_date(time_t value);
	void set_user(User* value);
	void set_city(int value);
	void set_city(City* value);
	void set_room(int value);
	void set_room(Room* value);
	// managers
	static Reservation* create(int user_id, int room_id, std::string start_date, std::string end_date, std::string note);
	static std::string get_table_name();
	static Reservation* get_by_id(int);
	static Reservation* choice(std::vector<std::string>);
	static void show_by_user(User*);
	static void check_free_by_date(std::string);
	void prepare_params();
	void load_from_stmt(sqlite3_stmt*);
	static std::vector<std::string> db_sorted_fields;
};