private void checkinResNumCB_SelectedIndexChanged(object sender, EventArgs e)
{
var selectedRow = (checkinResNumCB.SelectedItem as DataRowView);
string resRoomType = selectedRow["room_type_name"].ToString().Trim();
checkinTotalAmountTB.Text = selectedRow["total_amount"].ToString().Trim();
Checkin checkin = new Checkin();
checkinRoomNumCB.DataSource = checkin.RoomsComboBox(resRoomType);
checkinRoomNumCB.DisplayMember = "room_ID";
checkinRoomNumCB.SelectedItem = null;
checkinRoomNumCB.SelectedText = "Select Room Number";
string tempResColumnValue; //Temporary variable to store values of the "reservation_ID" column of the DataGridView
foreach (DataGridViewRow row in checkinDGV.Rows)
{
tempResColumnValue = row.Cells[1].Value.ToString();
if (checkinResNumCB.SelectedIndex == checkinResNumCB.FindStringExact(tempResColumnValue))
{
checkinTotalAmountTB.Text = "0";
checkinAmountPaidTB.Text = "0";
MessageBox.Show("Sorry! This person has already checked-in. Please select another one!");
checkinResNumCB.SelectedText = null;
}
}
}
private void CheckinControl_Load(object sender, EventArgs e)
{
checkinResNumCB.SelectedValue = null;
checkinResNumCB.DisplayMember = "reservation_ID";
Checkin checkin = new Checkin();
checkinResNumCB.DataSource = checkin.ReservationsComboBox();
checkinResNumCB.SelectedText = "Select Reservation Number";
ReloadData();
ResetForm();
checkinDGV.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
private void checkinB_Click(object sender, EventArgs e)
{
if (checkinResNumCB.Text == "Select Reservation Number" || checkinRoomNumCB.Text == "Select Room Number" || checkinTotalAmountTB.Text == "0" || checkinAmountPaidTB.Text == "0" || checkinResNumCB.Text == "")
{
MessageBox.Show("Please enter the missing detail to make a checkin!", "Message", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
Checkin checkin = new Checkin();
checkin.ReservationId = int.Parse(checkinResNumCB.Text);
checkin.RoomId = int.Parse(checkinRoomNumCB.Text);
checkin.CheckinDate = DateTime.Parse(checkinDTP.Text);
checkin.TotalAmount = int.Parse(checkinTotalAmountTB.Text);
checkin.AmountPaid = int.Parse(checkinAmountPaidTB.Text);
checkin.Insert(checkin.RoomId);
checkin.CloseConnection();
ResetForm();
ReloadData();
}
}
private void ReloadData()
{
Checkin checkin = new Checkin();
checkinDGV.DataSource = checkin.ListAll();
}
