public static List <Room> GetRooms(string ServiceYesOrNo, string service, DateTime usrADate, DateTime usrLDate)
{
List <Room> rooms = new List <Room>();
List <Booking> bookings = DalManager.GetRoomInUse(ServiceYesOrNo, usrADate, usrLDate);
string contentsFromRoomUse = "";
foreach (Booking item in bookings)
{
contentsFromRoomUse = contentsFromRoomUse + "Room.RoomNo <> " + item.RoomNo;
}
using (SqlConnection connection = new SqlConnection(DBconnection.connect("LandLystDB")))
{
SqlCommand cmd;
connection.Open();
if (ServiceYesOrNo == "ja")
{
cmd = new SqlCommand($@"
select dbo.RoomServices.RoomNo, dbo.Room.Price from dbo.Room
join dbo.RoomServices
on dbo.Room.RoomNo = dbo.RoomServices.RoomNo
where dbo.RoomServices.SerName = '{service}' and dbo.Room.Cleaned = 'true' and {contentsFromRoomUse};", connection);
}
else
{
cmd = new SqlCommand($@"
select RoomNo, Price from dbo.Room
where dbo.Room.Cleaned = 'true' and {contentsFromRoomUse};", connection);
}
SqlDataReader dataReader = cmd.ExecuteReader();
while (dataReader.Read())
{
// RoomNo, Price
int roomNo = (int)dataReader["RoomNo"];
int price = (int)dataReader["Price"];
Room room = new Room()
{
RoomNo = roomNo, Price = price
};
rooms.Add(room);
}
}
return(rooms);
}
public static void SetBookings(DateTime checkIn, DateTime checkOut, int guestsId, int roomNo)
{
DalManager.SetBookings(checkIn, checkOut, guestsId, roomNo);
}
public static void SetGuests(string foreName, string lastName, string address, string email, int telephoneNo, int zipCode)
{
DalManager.SetGuests(foreName, lastName, address, email, telephoneNo, zipCode);
}
public static List <TotalAmount> GetServicePrice(int roomNo)
{
return(DalManager.GetServicesPrice(roomNo));
}
public static List <Room> GetRooms(string ServiceYesOrNo, string service, DateTime usrADate, DateTime usrLDate)
{
return(DalManager.GetRooms(ServiceYesOrNo, service, usrADate, usrLDate));
}
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();
}