public DetailReservationDTO ReservationDetail(string confirmationNumber)
{
List <ParmStruct> parms = new List <ParmStruct>();
parms.Add(new ParmStruct("@ConfirmationNumber", SqlDbType.NVarChar, 12, confirmationNumber, ParameterDirection.Input));
DataTable dt = db.GetData("spGetReservationDetail", parms);
DetailReservationDTO detailReservation = new DetailReservationDTO()
{
GuestName = dt.Rows[0][0].ToString(),
Address = dt.Rows[0][1].ToString(),
HomePhone = dt.Rows[0][2].ToString(),
CellPhone = dt.Rows[0][3].ToString(),
Email = dt.Rows[0][4].ToString(),
CheckInDate = (DateTime)dt.Rows[0][5],
CheckOutDate = (DateTime)dt.Rows[0][6],
RoomNumber = Convert.ToInt32(dt.Rows[0][7]),
RoomName = dt.Rows[0][8].ToString(),
NumOfAdults = Convert.ToInt32(dt.Rows[0][9]),
NumOfChildren = Convert.ToInt32(dt.Rows[0][10]),
BaseRate = Convert.ToDecimal(dt.Rows[0][11]),
DailyRate = Convert.ToDecimal(dt.Rows[0][12]),
TotalPrice = Convert.ToDecimal(dt.Rows[0][13]),
};
return(detailReservation);
}
private void dgvReservation_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex > -1 && dgvReservation.Columns[e.ColumnIndex].Name == "btnDetail")
{
if (e.RowIndex >= 0)
{
string confirmationNumber = dgvReservation.Rows[e.RowIndex].Cells[6].Value.ToString();
ReservationService service = new ReservationService();
DetailReservationDTO detailReservation = service.GetReservationDetail(confirmationNumber);
panel1.Visible = true;
string homePhone = detailReservation.HomePhone == string.Empty ? "" : $"/ {detailReservation.HomePhone}(Home Phone)";
string email = detailReservation.Email == string.Empty ? "Not provided" : detailReservation.Email;
lblGuestName.Text = detailReservation.GuestName;
lblGuestAddress.Text = detailReservation.Address;
lblPhone.Text = $"{detailReservation.CellPhone}(Cell Phone) {homePhone}";
lblEmail.Text = email;
lblCheckIn.Text = detailReservation.CheckInDate.ToShortDateString();
lblCheckOut.Text = detailReservation.CheckOutDate.ToShortDateString();
lblRoomNumber.Text = detailReservation.RoomNumber.ToString();
lblRoomName.Text = detailReservation.RoomName;
lblNumOfGuests.Text = $"{detailReservation.NumOfAdults} Adults, {detailReservation.NumOfChildren} Children";
lblBaseRate.Text = detailReservation.BaseRate.ToString("C");
lblDailyRate.Text = detailReservation.DailyRate.ToString("C");
lblTotalPrice.Text = detailReservation.TotalPrice.ToString("C");
lblConfirmationNumber.Text = confirmationNumber;
foreach (Control child in this.Controls)
{
if (child != panel1)
{
child.Enabled = false;
}
}
}
}
}
