public string getGuestId()
{
ThreeHotelEntities ct = new ThreeHotelEntities();
Guest guest = new Guest();
guest = (from x in ct.Guests
where x.GuestId.Contains("G")
orderby x.GuestId descending
select x).First();
string a = guest.GuestId;
string b = a.Substring(4, 1);
int d = Convert.ToInt32(b);
string e = Convert.ToString(d + 1);
string c = "";
if (d + 1 > 999)
c = "G" + e;
else if (d + 1 > 99)
c = "G0" + e;
else if (d + 1 > 9)
c = "G00" + e;
else
c = "G000" + e;
return c;
}
public Boolean checkMember(string username, string pwd)
{
Boolean status = false;
try
{
ThreeHotelEntities ct = new ThreeHotelEntities();
User guest = new User();
string ppwd = Encrypt(pwd);
var q = from x in ct.Users
where x.MembershipId == username && x.Password == ppwd
select x;
User u = q.First();
if (u == null)
status = false;
else
status = true;
return status;
}
catch
{
return status;
}
}
protected void btnContinue_Click(object sender, EventArgs e)
{
int refNo = Convert.ToInt16(txtReservationNo.Text);
string familyName = txtLastName.Text;
string guestId = null;
ThreeHotelEntities ctx = new ThreeHotelEntities();
Guest guest = ctx.Guests.Where(x=> x.FamilyName == familyName).FirstOrDefault();
if (guest != null)
{
guestId = guest.GuestId.Trim();
}
else
{
lblMsg.Text = "Invalid Booking Reference No or Family/Last Name";
}
Booking booking = ctx.Bookings.Where(x => x.BookingReferenceId == refNo && x.GuestId == guestId).FirstOrDefault();
if (booking != null && guestId != null)
{
Session["bookingRef"] = refNo;
Response.Redirect("RoomReservations-view.aspx");
}
if (booking == null)
{
lblMsg.Text = "Invalid Booking Reference No or Family/Last Name";
}
}
protected void btnCancelReservation_Click(object sender, EventArgs e)
{
if(ckCancel.Checked == true)
{
int bookingRef = Convert.ToInt32(Session["bookingRef"].ToString());
ThreeHotelEntities ctx = new ThreeHotelEntities();
//Booking booking = ctx.Bookings.Where(x => x.GuestId == id).FirstOrDefault();
Booking booking = ctx.Bookings.Where(x => x.BookingReferenceId == bookingRef).FirstOrDefault();
RoomBooked roomBooked = ctx.RoomBookeds.Where(r => r.BookingReferenceId == bookingRef).FirstOrDefault();
if (booking != null && roomBooked != null)
{
booking.Status = "Cancelled";
roomBooked.Status = "Cancelled";
ctx.SaveChanges();
lblMsg.Text = "Reservation successfully cancelled.";
}
else
{
lblMsg.Text = "Kindly select the check box if you wish to cancel your reservation.";
}
}
else
{
lblMsg.Text = "Kindly select the check box if you wish to cancel your reservation.";
}
}
public Guest getByMemberId(string id)
{
ThreeHotelEntities ct = new ThreeHotelEntities();
Guest guest = new Guest();
guest = (from x in ct.Guests
where x.GuestId == id
select x).First();
return guest;
}
protected void Page_Load(object sender, EventArgs e)
{
//ObjectDataSource1.FilterExpression = "Booking Reference = " + Session["bookingRef"].ToString();
if (Session["bookingRef"] != null)
{
int bookingRef = Convert.ToInt16(Session["bookingRef"].ToString());
//to populate the gridview
ThreeHotelEntities ctx = new ThreeHotelEntities();
List<PastTransaction> tl = ctx.PastTransactions.Where(x => x.Booking_Ref == bookingRef).ToList();
if (tl != null)
{
GridView1.DataSource = tl;
GridView1.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Id"] == null)
{
Response.Redirect("SignIn.aspx");
}
else
{
string id = Session["Id"].ToString();
lblMemberId.Text = id;
Guest guest = new Guest();
GuestController guestController = new GuestController();
guest = guestController.getByMemberId(id);
string points = Convert.ToString(guest.Points);
if (points == null)
{
points = "0";
}
lblPoints.Text = points;
string name = guest.Salutation + guest.FirstName + guest.FamilyName;
lblName.Text = name;
//to populate the gridview
ThreeHotelEntities ctx = new ThreeHotelEntities();
List<PastTransaction> tl = ctx.PastTransactions.Where(x => x.Member_No == id).ToList();
if (tl != null)
{
GridView1.DataSource = tl;
GridView1.DataBind();
}
else
{
lblPastTransaction.Text = "No reservations with the hotel has been made.";
}
}
}
public void MemberUpdate(string id, string salut, string familyName, string fName, string email, string address, string ph, string country)
{
ThreeHotelEntities ct = new ThreeHotelEntities();
Guest g = new Guest();
g = (from x in ct.Guests
where x.GuestId == id
select x).First();
g.Salutation = salut;
g.FamilyName = familyName;
g.FirstName = fName;
g.Email = email;
g.Address = address;
g.PhoneNo = ph;
g.Country = country;
ct.SaveChanges();
}
public string MemberSave(string salut, string familyName, string fName, string pwd, string email, string address, string ph, string country)
{
string id;
ThreeHotelEntities ct = new ThreeHotelEntities();
Guest g = new Guest();
User user = new User();
id = getMemberId();
g.GuestId = id;
g.Salutation = salut;
g.FamilyName = familyName;
g.FirstName = fName;
user.MembershipId = id;
user.Password = Encrypt(pwd);
g.Email = email;
g.Address = address;
g.PhoneNo = ph;
g.Country = country;
ct.Guests.Add(g);
ct.Users.Add(user);
ct.SaveChanges();
SendMail(fName, familyName, email, id);
return id;
}
public void MemberChangePwd(string id, string newpwd)
{
ThreeHotelEntities ct = new ThreeHotelEntities();
User g = new User();
g = (from x in ct.Users
where x.MembershipId == id
select x).First();
g.Password = Encrypt(newpwd);
ct.SaveChanges();
}
protected void btnCompleteReservation_Click(object sender, EventArgs e)
{
if (Session["Id"] != null)
{
member = true;
}
ThreeHotelEntities ctx = new ThreeHotelEntities();
char[] toTrim = { 'm', 'g', '0' };
string guestID = "";
//commit to database - Guest
//if non-member, create new guest by addding row to Guest table
if (!member)
{
Guest addGuest = new Guest();
var guest = (from x in ctx.Guests where x.GuestId.Contains("G") orderby x.GuestId descending select x).First();
if (guest != null)
{
int lastNo = Int32.Parse(guest.GuestId.TrimStart("GMgm0".ToCharArray()));
int nextNo = lastNo + 1;
guestID = "G" + nextNo.ToString().PadLeft(4, '0');
addGuest.GuestId = guestID;
}
if (ddlSalutation.SelectedValue != string.Empty)
{
addGuest.Salutation = ddlSalutation.SelectedValue;
}
if (txtFamilyName.Text != string.Empty)
addGuest.FamilyName = txtFamilyName.Text;
if (txtFirstName.Text != string.Empty)
addGuest.FirstName = txtFirstName.Text;
email = txtEmail.Text;
if (email != string.Empty)
addGuest.Email = email;
if (txtAddress.Text != string.Empty)
addGuest.Address = txtAddress.Text;
if (txtPhoneNo.Text != string.Empty)
addGuest.PhoneNo = txtPhoneNo.Text;
if (ddlCountry.SelectedValue != string.Empty)
addGuest.Country = ddlCountry.SelectedValue;
ctx.Guests.Add(addGuest);
ctx.SaveChanges();
}
//if member, add points earned to his account
if(member)
{
//MemberID session is saved when member signs in
guestID = Session["Id"].ToString();
var guest = ctx.Guests.Where(g => g.GuestId == guestID).FirstOrDefault();
if (guest != null)
{
int currentPoints = Convert.ToInt16(guest.Points);
int newPoints = currentPoints + pointsEarned;
guest.Points = newPoints;
ctx.SaveChanges();
}
}
//commit to database - Booking
Booking addBooking = new Booking();
if (Session["SpecialRateCode"] != string.Empty)
{
addBooking.SpecialRateCode = Session["SpecialRateCode"].ToString();
}
addBooking.CheckIn = Convert.ToDateTime(Session["CheckInDB"].ToString());
addBooking.CheckOut = Convert.ToDateTime(Session["CheckOutDB"].ToString());
addBooking.NoOfRooms = Convert.ToInt16(Session["RoomCount"].ToString());
addBooking.Tax = taxRate;
addBooking.ServiceCharge = serviceChargeRate;
if (member)
{
addBooking.PointsEarned = pointsEarned;
}
else
{
addBooking.PointsEarned = 0;
}
addBooking.GuestId = guestID;
if (txtCardNo.Text != string.Empty)
{
addBooking.CreditCardNo = Convert.ToInt64(txtCardNo.Text);
}
if (rbtnCardType.SelectedValue != string.Empty)
{
addBooking.CreditCardType = rbtnCardType.SelectedValue;
}
if (ddlMonth.SelectedValue != string.Empty && ddlYear.SelectedValue != string.Empty)
{
addBooking.CardExpiredDate = ddlMonth.SelectedValue + ddlYear.SelectedValue;
}
addBooking.TotalCost = totalCost;
ctx.Bookings.Add(addBooking);
ctx.SaveChanges();
//commit to database - RoomBooked
RoomBooked addRoomBooked = new RoomBooked();
var booking = (from x in ctx.Bookings orderby x.BookingReferenceId descending select x).First();
if (booking != null)
{
bookingRefId = Convert.ToInt32(booking.BookingReferenceId);
addRoomBooked.BookingReferenceId = bookingRefId;
}
addRoomBooked.RoomType = Session["RoomType"].ToString();
addRoomBooked.Rate = Convert.ToDouble(Session["Rate"].ToString());
ctx.RoomBookeds.Add(addRoomBooked);
ctx.SaveChanges();
if (txtEmail.Text != string.Empty)
{
Session["Email"] = txtEmail.Text;
}
Session["BookingRefID"] = bookingRefId;
Session["TotalCost"] = totalCost;
Session["Email"] = txtEmail.Text;
string mailadd = txtEmail.Text;
Session["CostNights"] = costNights;
Session["TaxSc"] = taxSC;
Session["NoOfNights"] = noOfNights;
if (txtFamilyName.Text != string.Empty)
{
Session["FamilyName"] = txtFamilyName.Text;
}
SendMail(bookingRefId, mailadd);
Response.Redirect("RoomReservations-confirmation.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if ((string)Session["CheckIn"] == string.Empty)
{
Response.Redirect("RoomReservations-input.aspx");
}
//populate search field
String[] RoomOptions = new[] { "1", "2", "3" };
foreach (string option in RoomOptions)
{
DropDownListRoomCount.Items.Add(new ListItem(option, option));
}
populateByRoom();
populateByAdult();
//set search field with previously chosen values
checkInDatePicker.Text = Session["CheckIn"].ToString();
checkOutDatePicker.Text = Session["CheckOut"].ToString();
DropDownListRoomCount.Text = Session["RoomCount"].ToString();
DropDownListAdult.Text = Session["AdultCount"].ToString();
DropDownListChildren.Text = Session["ChildrenCount"].ToString();
}
//Search database for available rooms
ThreeHotelEntities ctx = new ThreeHotelEntities();
var result = ctx.SearchOccupancy(Convert.ToDateTime(Session["CheckInDB"]), Convert.ToDateTime(Session["CheckOutDB"]));
int[] count = new int[8];
string[] roomType = new string[8] { "DCK", "DCT", "DSK", "DST", "HCK", "HCT", "HSK", "HST" };
foreach (var item in result)
{
switch (item.RoomType)
{
case "DCK":
count[0]++;
break;
case "DCT":
count[1]++;
break;
case "DSK":
count[2]++;
break;
case "DST":
count[3]++;
break;
case "HCK":
count[4]++;
break;
case "HCT":
count[5]++;
break;
case "HSK":
count[6]++;
break;
case "HST":
count[7]++;
break;
default:
break;
}
}
int[] roomQty = new int[8] { 20, 20, 20, 20, 20, 20, 20, 20 };
string[] availability = new string[8];
int unavailableCount = 0;
for (int i = 0; i < 8; i++)
{
if ((roomQty[i] - count[i]) >= Convert.ToInt16(Convert.ToString(Session["RoomCount"])))
{
availability[i] = "available";
}
else
{
unavailableCount++;
availability[i] = "unavailable";
}
}
if (unavailableCount == 8)
{
lblAllUnavailable.Text = "All rooms are unavailable for the chosen date range " + Session["CheckIn"] + " to " + Session["CheckOut"] + " .";
}
else
{
//Check DCK and DCT
if (availability[0] == "available" && availability[1] == "available")
{
rbtn_DCK.Enabled = true;
rbtn_DCT.Enabled = true;
rbtn_DCK.Checked = true;
}
else if (availability[0] == "unavailable" && availability[1] == "unavailable")
{
btnBook_DC.Enabled = false;
btnBook_DC.Text = "SOLD OUT!";
btnBook_DC.BorderStyle = BorderStyle.None;
btnBook_DC.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFFFFF");
btnBook_DC.BorderColor = System.Drawing.ColorTranslator.FromHtml("#FFFFFF");
btnBook_DC.ForeColor = System.Drawing.ColorTranslator.FromHtml("#000000");
}
else if (availability[0] == "available")
{
rbtn_DCK.Enabled = true;
rbtn_DCK.Checked = true;
}
else if (availability[1] == "available")
{
rbtn_DCT.Enabled = true;
rbtn_DCT.Checked = true;
}
//check DSK and DST
if (availability[2] == "available" && availability[3] == "available")
{
rbtn_DSK.Enabled = true;
rbtn_DST.Enabled = true;
rbtn_DSK.Checked = true;
}
else if (availability[2] == "unavailable" && availability[3] == "unavailable")
{
btnBook_DS.Enabled = false;
btnBook_DS.Text = "SOLD OUT!";
btnBook_DS.BorderStyle = BorderStyle.None;
btnBook_DS.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFFFFF");
btnBook_DS.BorderColor = System.Drawing.ColorTranslator.FromHtml("#FFFFFF");
btnBook_DS.ForeColor = System.Drawing.ColorTranslator.FromHtml("#000000");
}
else if (availability[2] == "available")
{
rbtn_DSK.Enabled = true;
rbtn_DSK.Checked = true;
}
else if (availability[3] == "available")
{
rbtn_DST.Enabled = true;
rbtn_DST.Checked = true;
}
//Check HCK and HCT
if (availability[4] == "available" && availability[5] == "available")
{
rbtn_HCK.Enabled = true;
rbtn_HCT.Enabled = true;
rbtn_HCK.Checked = true;
}
else if (availability[4] == "unavailable" && availability[5] == "unavailable")
{
btnBook_HC.Enabled = false;
btnBook_HC.Text = "SOLD OUT!";
btnBook_HC.BorderStyle = BorderStyle.None;
btnBook_HC.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFFFFF");
btnBook_HC.BorderColor = System.Drawing.ColorTranslator.FromHtml("#FFFFFF");
btnBook_HC.ForeColor = System.Drawing.ColorTranslator.FromHtml("#000000");
}
else if (availability[4] == "available")
{
rbtn_HCK.Enabled = true;
rbtn_HCK.Checked = true;
}
else if (availability[5] == "available")
{
rbtn_HCT.Enabled = true;
rbtn_HCT.Checked = true;
}
//check HSK and HST
if (availability[6] == "available" && availability[7] == "available")
{
rbtn_HSK.Enabled = true;
rbtn_HST.Enabled = true;
rbtn_HSK.Checked = true;
}
else if (availability[6] == "unavailable" && availability[7] == "unavailable")
{
btnBook_HS.Enabled = false;
btnBook_HS.Text = "SOLD OUT!";
btnBook_HS.BorderStyle = BorderStyle.None;
btnBook_HS.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFFFFF");
btnBook_HS.BorderColor = System.Drawing.ColorTranslator.FromHtml("#FFFFFF");
btnBook_HS.ForeColor = System.Drawing.ColorTranslator.FromHtml("#000000");
}
else if (availability[6] == "available")
{
rbtn_HSK.Enabled = true;
rbtn_HSK.Checked = true;
}
else if (availability[7] == "available")
{
rbtn_HST.Enabled = true;
rbtn_HST.Checked = true;
}
}
}