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);
}
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 <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);
}