private void btnSelectGuest_Click(object sender, EventArgs e)
{
DataGridViewRow row = (DataGridViewRow)dgvGuests.Rows[dgvGuests.SelectedCells[0].RowIndex];
if (row.Cells[4].Value.ToString() == Globals.hotelCountry)
{
Guest guest = new NationalGuest();
guest.Id = int.Parse(row.Cells["guest_id"].Value.ToString());
guest.FirstName = row.Cells["First Name"].Value.ToString();
guest.LastName = row.Cells["Last Name"].Value.ToString();
guest.Email = row.Cells["Email"].Value.ToString();
this.Guest = guest;
}
else
{
Guest guest = new InternationalGuest();
guest.Id = int.Parse(row.Cells["guest_id"].Value.ToString());
guest.FirstName = row.Cells["First Name"].Value.ToString();
guest.LastName = row.Cells["Last Name"].Value.ToString();
guest.Email = row.Cells["Email"].Value.ToString();
this.Guest = guest;
}
this.Close();
var form = new CheckinFrm(this.ReservationId, this.Guest, this.ReservationApartmentId);
form.Show();
}
private void btnSelectGuest_Click(object sender, EventArgs e)
{
DataGridViewRow row = (DataGridViewRow)dgvGuests.Rows[dgvGuests.SelectedCells[0].RowIndex];
if (row.Cells[4].Value.ToString() == Globals.hotelCountry)
{
Guest guest = new NationalGuest();
guest.Id = int.Parse(row.Cells["guest_id"].Value.ToString());
guest.FirstName = row.Cells["Name"].Value.ToString();
guest.LastName = row.Cells["Last Name"].Value.ToString();
guest.Email = row.Cells["Email"].Value.ToString();
this.Guest = guest;
}
else
{
Guest guest = new InternationalGuest();
guest.Id = int.Parse(row.Cells[0].Value.ToString());
guest.FirstName = row.Cells["Name"].Value.ToString();
guest.LastName = row.Cells["Last Name"].Value.ToString();
guest.Email = row.Cells["Email"].Value.ToString();
this.Guest = guest;
}
MySqlConnection con = new MySqlConnection(Globals.connString);
using (MySqlCommand cmd = new MySqlCommand("INSERT INTO _reservation_guest(guest_id, reservation_id) " +
"VALUES(@guestId, @reservationId)", con))
{
cmd.Parameters.Add("@guestId", MySqlDbType.Int32).Value = this.Guest.Id;
cmd.Parameters.Add("@reservationId", MySqlDbType.Int32).Value = this.Reservation.Id;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
MessageBox.Show("Guest added to reservation");
this.Close();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
// Converting to enums
try
{
Countries nationality = (Countries)Enum.Parse(typeof(Countries), comboNationality.SelectedItem.ToString());
Countries issuingCountry = (Countries)Enum.Parse(typeof(Countries), comboIssuingCountry.SelectedItem.ToString());
Occupation occupation = (Occupation)Enum.Parse(typeof(Occupation), comboOccupation.SelectedItem.ToString());
DocumentType documentType = (DocumentType)Enum.Parse(typeof(DocumentType), comboDocumentType.SelectedItem.ToString());
IssuingBody issuingBody = (IssuingBody)Enum.Parse(typeof(IssuingBody), comboIssuingBody.SelectedItem.ToString());
string gender;
if (radioMale.Checked)
{
gender = "Male";
}
else
{
gender = "Female";
}
//Check whether it is a national or international guest
if (comboNationality.SelectedItem.ToString() == Globals.hotelCountry)
{
NationalGuest guest = new NationalGuest(
txtFirstName.Text,
txtLastName.Text,
txtEmail.Text,
occupation,
dtpBirth.Value,
nationality,
Convert.ToInt64(txtPhone.Text),
Convert.ToInt64(txtDocument.Text),
documentType,
issuingBody
);
MySqlConnection con = new MySqlConnection(Globals.connString);
con.Open();
try
{
MySqlCommand cmd = new MySqlCommand("SaveNewGuest", con);
cmd.Parameters.Add("_first_name", MySqlDbType.VarChar, 55).Value = guest.FirstName;
cmd.Parameters.Add("_last_name", MySqlDbType.VarChar, 55).Value = guest.LastName;
cmd.Parameters.Add("_email", MySqlDbType.VarChar, 60).Value = guest.Email;
cmd.Parameters.Add("_occupation", MySqlDbType.VarChar, 45).Value = guest.Occupation;
cmd.Parameters.Add("_birth_date", MySqlDbType.Date).Value = guest.Birthdate;
cmd.Parameters.Add("_nationality", MySqlDbType.VarChar, 60).Value = Globals.hotelCountry;
cmd.Parameters.Add("_gender", MySqlDbType.VarChar, 6).Value = gender;
cmd.Parameters.Add("_phone", MySqlDbType.VarChar, 50).Value = guest.Phone;
cmd.Parameters.Add("_document", MySqlDbType.VarChar, 50).Value = guest.Document;
cmd.Parameters.Add("_document_type", MySqlDbType.VarChar, 25).Value = guest.DocumentType;
cmd.Parameters.Add("_issuing_body", MySqlDbType.VarChar, 45).Value = guest.IssuingBody;
cmd.Parameters.Add("_issuing_country", MySqlDbType.VarChar, 60).Value = Globals.hotelCountry;
cmd.Parameters.Add("_is_international", MySqlDbType.Int16).Value = 0;
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
MessageBox.Show("Guest saved successfully!");
this.Close();
var form = new GuestListFrm();
form.Show();
}
catch (Exception ex)
{
throw ex;
}
con.Close();
}
else
{
InternationalGuest guest = new InternationalGuest(
txtFirstName.Text,
txtLastName.Text,
txtEmail.Text,
occupation,
dtpBirth.Value,
nationality,
Convert.ToInt64(txtPhone.Text),
txtDocument.Text,
issuingCountry
);
MySqlConnection con = new MySqlConnection(Globals.connString);
con.Open();
try
{
MySqlCommand cmd = new MySqlCommand("SaveNewGuest", con);
cmd.Parameters.Add("_first_name", MySqlDbType.VarChar, 55).Value = guest.FirstName;
cmd.Parameters.Add("_last_name", MySqlDbType.VarChar, 55).Value = guest.LastName;
cmd.Parameters.Add("_email", MySqlDbType.VarChar, 60).Value = guest.Email;
cmd.Parameters.Add("_occupation", MySqlDbType.VarChar, 45).Value = guest.Occupation;
cmd.Parameters.Add("_birth_date", MySqlDbType.Date).Value = guest.Birthdate;
cmd.Parameters.Add("_nationality", MySqlDbType.VarChar, 60).Value = guest.Nationality;
cmd.Parameters.Add("_gender", MySqlDbType.VarChar, 6).Value = gender;
cmd.Parameters.Add("_phone", MySqlDbType.VarChar, 50).Value = guest.Phone;
cmd.Parameters.Add("_document", MySqlDbType.VarChar, 50).Value = guest.Passport;
cmd.Parameters.Add("_document_type", MySqlDbType.VarChar, 25).Value = Globals.foreignDocument;
cmd.Parameters.Add("_issuing_body", MySqlDbType.VarChar, 45).Value = null;
cmd.Parameters.Add("_issuing_country", MySqlDbType.VarChar, 60).Value = issuingCountry;
cmd.Parameters.Add("_is_international", MySqlDbType.Int16).Value = 1;
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
MessageBox.Show("Guest saved successfully!");
this.Close();
var form = new GuestListFrm();
form.Show();
}
catch (Exception ex)
{
throw ex;
}
con.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}