protected void ButtonSaveBooking_Click(object sender, EventArgs e)
{
#region SetGuests with variabler (OUT COMMENTE)
//string fisteName = TextBoxFistName.Text;
//string lastName = TextBoxLastName.Text;
//string adderss = "JVej no. 8";
//string mail = TextBoxMail.Text;
//int telefonNo = Convert.ToInt32(TextBoxPhoneNo.Text);
//int zipCode = 4800;
//HotelManager.SetGuests(fisteName, lastName, adderss, mail, telefonNo, zipCode);
#endregion
DateTime ArrivalDate = DateTime.Parse(TextBoxArrivalDate.Text);
DateTime levingDate = DateTime.Parse(TextBoxLevingDate.Text);
int usrRoomChoose = int.Parse(TextBoxRoompicking.Text);
#region SetBooking
DalManager.SetBookings(ArrivalDate, levingDate, int.Parse(TextBoxGuestsId.Text), usrRoomChoose); // manglier noget til vælge brugene
#endregion
#region TotalAmount
TotalAmount totalAmount = new TotalAmount();
LabelPrice.Text = totalAmount.Percentage(ArrivalDate, levingDate, usrRoomChoose).ToString();
#endregion
}
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 = "";
int CheckNo = 0;
foreach (Booking item in bookings)
{
contentsFromRoomUse = contentsFromRoomUse + "Room.RoomNo <> " + item.RoomNo;
CheckNo++;
if (bookings.Count > CheckNo)
{
contentsFromRoomUse = contentsFromRoomUse + " and ";
}
}
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';", 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())
{
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 <Guests> GetGuestsID()
{
return(DalManager.GetGuestsID());
}
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));
}
