public static List <TotalAmount> GetServicesPrice(int roomNumber)
{
List <TotalAmount> amounts = new List <TotalAmount>();
using (SqlConnection connection = new SqlConnection(DBconnection.connect("LandLystDB")))
{
connection.Open();
SqlCommand cmd = new SqlCommand($@"
select HotelServices.Price from HotelServices
join RoomServices
on dbo.RoomServices.SerName = dbo.HotelServices.ServiceName
where dbo.RoomServices.RoomNo = {roomNumber};", connection);
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
int servicePrice = (int)dataReader["Price"];
TotalAmount totalAmount = new TotalAmount()
{
ServicePrice = servicePrice
};
amounts.Add(totalAmount);
}
}
return(amounts);
}
public static List <TotalAmount> GetRoomPrice(int roomNumber)
{
List <TotalAmount> amounts = new List <TotalAmount>();
using (SqlConnection connection = new SqlConnection(DBconnection.connect("LandLystDB")))
{
connection.Open();
SqlCommand cmd = new SqlCommand($@"select Room.Price from Room
where RoomNo = {roomNumber}", connection);
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
int roomPrice = (int)dataReader["Price"];
TotalAmount totalAmount = new TotalAmount()
{
RoomPrice = roomPrice
};
amounts.Add(totalAmount);
}
}
return(amounts);
}
static void Main(string[] args)
{
Console.WriteLine("// START");
Console.WriteLine("Hvad er din forenavn");
string fisteName = Console.ReadLine();
Console.WriteLine("Hvad er din efternavn");
string lastName = Console.ReadLine();
Console.WriteLine("Hvad er din Addrese");
string adderss = Console.ReadLine();
Console.WriteLine("Hvad er din e-mail");
string mail = Console.ReadLine();
Console.WriteLine("Hvad er din telefonNo");
int telefonNo = int.Parse(Console.ReadLine());
Console.WriteLine("Hvad er din postnr");
int zipCode = int.Parse(Console.ReadLine());
HotelManager.SetGuests(fisteName, lastName, adderss, mail, telefonNo, zipCode);
Console.WriteLine("vil du have en særlid service : ja|nej");
string usrServiceYesOrNo = Console.ReadLine();
string usrService = "";
if (usrServiceYesOrNo == "ja")
{
Console.WriteLine("hvilken service vil du have: ");
usrService = Console.ReadLine();
}
Console.WriteLine("hvilken dato for ankomst :");
DateTime usrADate = DateTime.Parse(Console.ReadLine());
Console.WriteLine("hvilken hjem dato :");
DateTime usrLDate = DateTime.Parse(Console.ReadLine());
Console.WriteLine("hvilken kunde numer :");
int usrCustomerNo = Int32.Parse(Console.ReadLine());
List <Room> rooms = HotelManager.GetRooms(usrServiceYesOrNo, usrService, usrADate, usrLDate);
Console.WriteLine("Room No | Price");
foreach (Room item in rooms)
{
Console.WriteLine(" " + item.RoomNo + " " + item.Price);
}
Console.WriteLine("hvilken vælget værlse :");
int usrRoomNo = Int32.Parse(Console.ReadLine());
DalManager.SetBookings(usrADate, usrLDate, usrCustomerNo, usrRoomNo);
Console.WriteLine("den samlet pris er : ");
TotalAmount totalAmount = new TotalAmount();
Console.WriteLine(totalAmount.Percentage(usrADate, usrLDate, usrRoomNo));
Console.WriteLine("// S**T");
Console.ReadKey();
}
