protected void btnConfirmReservation_Click(object sender, EventArgs e)
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
Reservation res = db.Reservations.Single(p=> p.ReservationID == Convert.ToInt16(lblReservationNumber.Text));
res.ReservationStatus = 'C';
db.SubmitChanges();
}
protected void btnCancelReservation_Click(object sender, EventArgs e)
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
var deleteRows = from rs in db.ReservationDetails
where rs.ReservationID == Convert.ToInt16(lblReservationNumber.Text)
select rs;
db.ReservationDetails.DeleteAllOnSubmit(deleteRows);
db.SubmitChanges();
var deleteRes = from r in db.Reservations
where r.ReservationID == Convert.ToInt16(lblReservationNumber.Text)
select r;
db.Reservations.DeleteAllOnSubmit(deleteRes);
db.SubmitChanges();
}
protected void btnAddStatuses_Click(object sender, EventArgs e)
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
RoomStatus status = new RoomStatus();
status.RoomStatus1 = Convert.ToChar(txtStatus.Text);
status.RoomStatusDescription = txtDescription.Text;
db.RoomStatus.InsertOnSubmit(status);
db.SubmitChanges();
GridView1.DataBind();
}
protected void btnReadyforGuest_Click(object sender, EventArgs e)
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
var roo = db.Rooms.Single(r => r.RoomID == Convert.ToInt16(gvMaintenance.SelectedRow.Cells[0].Text));
roo.RoomStatus = 'A';
db.SubmitChanges();
gvMaintenance.DataBind();
check();
}
protected void gvCollections_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int collectionID = Convert.ToInt32(gvCollections.Rows[e.RowIndex].Cells[0].Text);
TextBox txtamount = (TextBox)(gvCollections.Rows[e.RowIndex].FindControl("Textbox1"));
decimal amount = Convert.ToDecimal(txtamount.Text);
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
Collection updateCollection = db.Collections.Single(c => c.CollectionsID == collectionID);
updateCollection.CollectionsAmountOwed = amount;
db.SubmitChanges();
gvCollections.DataBind();
}
//Adds the selected Ingredient to the selected menu item
protected void btnAddIngredientToMenuItem_Click(object sender, EventArgs e)
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
MenuItemIngredient mii = new MenuItemIngredient();
mii.IngredientID = Convert.ToInt16(ddlIngredients.SelectedValue);
mii.MenuItemID = Convert.ToInt16(ddlMenuItemIngredients.SelectedValue);
mii.MenuItemIngredientQty = Convert.ToDecimal(txtMenuItemIngredientQty.Text);
db.MenuItemIngredients.InsertOnSubmit(mii);
db.SubmitChanges();
lbMenuItems.DataBind();
lblIngredientInsert.Visible = false;
}
protected void btnAddBilling_Click(object sender, EventArgs e)
{
//Insert Values into discounts table using linq
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
BillingCategory addBilling = new BillingCategory();
addBilling.BillingCategoryDescription = txtDesciption.Text;
addBilling.BillingCategoryTaxable = cbTaxable.Checked;
db.BillingCategories.InsertOnSubmit(addBilling);
db.SubmitChanges();
gvBilling.DataBind();
}
protected void btnAddRoomType_Click(object sender, EventArgs e)
{
//USes an linq to sql to insert a guest into the guest table
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
HotelRoomType type = new HotelRoomType();
type.HotelID = Convert.ToInt16(ddlHotel.SelectedValue);
type.RoomType = txtRoomType.Text;
type.RoomTypeDescription = txtDescription.Text;
type.RoomTypeRackRate = Convert.ToDecimal(txtRackRate.Text);
db.HotelRoomTypes.InsertOnSubmit(type);
db.SubmitChanges();
gvRoomTpyes.DataBind();
}
protected void btnReadyforGuest_Click(object sender, EventArgs e)
{
lblHousekeeping.Text = "";
btnReadyforGuest.Visible = true;
btnNeedsMaintenance.Visible = true;
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
var roo = db.Rooms.Single(r => r.RoomID == Convert.ToInt16(gvHouseKeeping.SelectedRow.Cells[0].Text));
roo.RoomStatus = 'A';
db.SubmitChanges();
gvHouseKeeping.DataBind();
check();
}
protected void btnUpdatePin_Click(object sender, EventArgs e)
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
var pin = from p in db.aspnet_Memberships
where p.Pin == txtPin.Text
select new { p.Pin };
if (pin.Count() != 0 && pin.First().Pin != lblPin.Text)
{
Label_StatusMsg.Text = "This is not a valid pin";
}
else if(pin.Count() != 0 && pin.First().Pin == lblPin.Text)
{
Label_StatusMsg.Text = "This is your current pin";
}
else
{
Label_StatusMsg.Text = "Pin Changed";
var query = from p in db.aspnet_Memberships
join u in db.aspnet_Users
on p.UserId equals u.UserId
where u.UserName == Request.QueryString["user"]
select p;
foreach (var result in query)
{
result.Pin = txtPin.Text;
}
db.SubmitChanges();
var pinrefresh = from p in db.aspnet_Memberships
join u in db.aspnet_Users
on p.UserId equals u.UserId
where u.UserName == Request.QueryString["user"]
select new { p.Pin };
if (pinrefresh.Count() == 0)
{
lblPin.Text = "No Pin";
}
else
{
lblPin.Text = pin.First().Pin;
}
txtPin.Text = "";
}
}
protected void btnInsertDiscount_Click(object sender, EventArgs e)
{
//Insert Values into discounts table using linq
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
Discount addDiscount = new Discount();
addDiscount.DiscountDescription = txtDiscountDescription.Text;
addDiscount.DiscountExpiration = Convert.ToDateTime(txtDiscountExpiration.Text);
addDiscount.DiscountRules = txtDiscountRules.Text;
addDiscount.DiscountAmount = Convert.ToDecimal(txtDiscountAmount.Text);
if (cbIsPercentage.Checked)
{
addDiscount.IsPrecentage = true;
}
else
{
addDiscount.IsPrecentage = false;
}
db.Discounts.InsertOnSubmit(addDiscount);
db.SubmitChanges();
GridView1.DataBind();
}
protected void btnReserve_Click(object sender, EventArgs e)
{
if (gvRoomInfo.Rows.Count > 0)
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
Reservation res = new Reservation();
res.GuestID = reserving.GuestID;
res.ReservationDate = DateTime.Today;
res.ReservationStatus = 'U';
db.Reservations.InsertOnSubmit(res);
db.SubmitChanges();
LinkedList<RoomInfo> ri = (LinkedList<RoomInfo>)Session["RoomIDs"];
int i = 0;
foreach(RoomInfo r in ri)
{
ReservationDetail resDetail = new ReservationDetail();
gvRoomInfo.SelectRow(i);
resDetail.ReservationID = res.ReservationID;
resDetail.CheckinDate = Convert.ToDateTime(reserving.reserveDate);
resDetail.RoomID = Convert.ToInt16(r.RoomID);
resDetail.QuotedRate = Convert.ToByte(reserving.daysStaying) * Convert.ToDecimal(gvRoomInfo.SelectedRow.Cells[2].Text);
resDetail.ReservationStatus = 'A';
resDetail.Nights = Convert.ToByte(reserving.daysStaying);
DropDownList ddl = (DropDownList) gvRoomInfo.SelectedRow.Cells[3].FindControl("numAdults");
resDetail.NumberOfAdults = Convert.ToByte(ddl.SelectedValue);
ddl = (DropDownList)gvRoomInfo.SelectedRow.Cells[4].FindControl("numChild");
resDetail.NumberOfChildren = Convert.ToByte(ddl.SelectedValue);
resDetail.DiscountID = 1;
db.ReservationDetails.InsertOnSubmit(resDetail);
db.SubmitChanges();
i++;
}
lblFinalReservationNumber.Text = res.ReservationID.ToString();
db = new TreasureLandDataClassesDataContext();
var resing = from rv in db.Reservations
join rd in db.ReservationDetails
on rv.ReservationID equals rd.ReservationID
join ro in db.Rooms
on rd.RoomID equals ro.RoomID
join hrt in db.HotelRoomTypes
on ro.HotelRoomTypeID equals hrt.HotelRoomTypeID
where rv.ReservationID == Convert.ToInt16(lblFinalReservationNumber.Text)
select new { rd.ReservationDetailID, ro.RoomNumbers, rd.CheckinDate, hrt.RoomType };
gvReserved.DataSource = resing.ToList();
gvReserved.DataBind();
reserving.returnView = 4;
}
else
{
lblError.Text = "Please select a room before commting a reservation";
}
}
/// <summary>
/// Creates a purchase and saves it do the database
/// </summary>
protected void btnSubmitPurchase_Click(object sender, EventArgs e)
{
//insert drink purchase
if (ddlChooseItemForPurchase.SelectedIndex==0)
{
if (Session["drinklist"] != null)
{
drinkPurchase = (List<IngredientPurchaseHistory>)Session["drinklist"];
//create a database connection
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
IngredientPurchase addDrinkPurchase = new IngredientPurchase();
addDrinkPurchase.PurchaseDate= DateTime.Now;
db.IngredientPurchases.InsertOnSubmit(addDrinkPurchase);
db.SubmitChanges();
var pch = (from i in db.IngredientPurchases
select i.PurchaseID).Max();
foreach (var dp in drinkPurchase)
{
dp.PurchaseID = System.Convert.ToInt16(pch.ToString());
db.IngredientPurchaseHistories.InsertOnSubmit(dp);
db.SubmitChanges();
}
}
}
//enter food purchase
else
{
if (Session["ingredientlist"] != null)
{
purchase = (List<IngredientPurchaseHistory>)Session["ingredientlist"];
//create a database connection
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
//Create Ingredient Purchase
IngredientPurchase addIngredientPurchase = new IngredientPurchase();//create new purchase object
addIngredientPurchase.PurchaseDate = DateTime.Now;//get today
db.IngredientPurchases.InsertOnSubmit(addIngredientPurchase);
db.SubmitChanges();
//System.Diagnostics.Debug.WriteLine("");
//Query Recently added Purchase to get Purchase ID
var pch = (from i in db.IngredientPurchases
select i.PurchaseID).Max();//db.IngredientPurchases.Last(); //from p in db.IngredientPurchases select p.PurchaseDate//.Where(p => p. == purchaseTime )
//select p;
System.Diagnostics.Debug.WriteLine(pch.ToString());
//for each add to database
foreach (var ph in purchase)
{
ph.PurchaseID = System.Convert.ToInt16(pch.ToString());
db.IngredientPurchaseHistories.InsertOnSubmit(ph);
db.SubmitChanges();
}
Session["ingredientlist"] = null;
gvshowIngredientPurchases.DataSource = null;
gvshowIngredientPurchases.DataBind();
}
};
gvshowIngredientPurchases.DataSource = null;
gvshowIngredientPurchases.DataBind();
btnSubmitPurchase.Enabled = false;
btnManageCategories.Enabled = true;
btnManageMenuItems.Enabled = true;
btnEnterPurchase.Enabled = true;
btnIngredients.Enabled = true;
btnClear.Enabled = false;
}
protected void btnRemoveIngredient_Click(object sender, EventArgs e)
{
if (lbMenuItems.SelectedIndex>-1)
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
var deleteMenuItemIngredient =
from details in db.MenuItemIngredients
where details.MenuItemIngredientID == Convert.ToInt16(lbMenuItems.SelectedValue)
select details;
foreach (var detail in deleteMenuItemIngredient)
{
db.MenuItemIngredients.DeleteOnSubmit(detail);
}
db.SubmitChanges();
lbMenuItems.DataBind();
lblIngredientInsert.Visible = false;
}
}
/// <summary>
/// The item new item is added to the menu item table or the drink table based on
/// the selected category. The fields are then hidden.
/// </summary>
protected void btnAddSubmit_Click(object sender, EventArgs e)
{
//the item to be added is a drink
//gets the nonalcohol or alcohol tage from the drop down list
if (ddlChooseItem.SelectedIndex == 0)
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
TreasureLand.DBM.MenuItem d = new DBM.MenuItem();
d.MenuItemName = txtAddMenuItemName.Text;
d.MenuItemPrice = Convert.ToDecimal(txtAddPrice.Text);
d.IsCurrentItem = true;
d.FoodDrinkCategoryID = Convert.ToByte(ddlAddCategory.SelectedIndex + 1);
db.MenuItems.InsertOnSubmit(d);
db.SubmitChanges();
}
//the item to be added is a discount
else if (ddlChooseItem.SelectedItem.Text=="Discounts")
{
try
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
TreasureLand.DBM.MenuItem d = new DBM.MenuItem();
d.MenuItemName = txtAddMenuItemName.Text;
d.MenuItemPrice = Convert.ToDecimal(txtAddPrice.Text);
d.IsCurrentItem = true;
d.FoodDrinkCategoryID = Convert.ToByte(3);
db.MenuItems.InsertOnSubmit(d);
db.SubmitChanges();
}
catch (Exception)
{
throw;
}
}
else
{
//The item to be added is a menu item
//gets the value from the category drop down list and adds 4 to that value
//2 for drink categories, 1 for dicount category, and 1 since the first location is 0
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
TreasureLand.DBM.MenuItem mi = new TreasureLand.DBM.MenuItem();
mi.FoodDrinkCategoryID = Convert.ToSByte(ddlAddCategory.SelectedIndex + 4);
mi.MenuItemName = txtAddMenuItemName.Text;
mi.MenuItemPrice = Convert.ToDecimal(txtAddPrice.Text);
mi.IsCurrentItem = true;
db.MenuItems.InsertOnSubmit(mi);
db.SubmitChanges();
}
disableButtons(true);
gvMenuItems.DataBind();
ddlMenuItemIngredients.DataBind();
}
/// <summary>
/// creates a new category
/// checks to see if the category to be entered is already in the database
/// if it doesn't exist it is created and added to the database
/// </summary>
protected void btnAddNewCategory(object sender, EventArgs e)
{
//Hides the error message
lblCatAddError.Text = "";
//If input is blank
if (txtCategory.Text == "")
{
lblCatAddError.Text = "You have not entered a Category";
}
else
{
//Change View Over to ManageCategories View.
containerView.ActiveViewIndex = 1;
//populate grid
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
var ing = from fdc in db.FoodDrinkCategories.Where(fdc => fdc.FoodDrinkCategoryName == txtCategory.Text)
select fdc;
//checks to see if the item is in the database
if (ing.Any())
{
//If something exists, then don't add
//print error message
lblCatAddError.Text = "Category Is Already In the Hotel Restaurant";
//reset txtIngredient to " "
txtCategory.Text = "";
}
else
{
//else if something exists
//add record to database
//USes an linq to sql to insert a guest into the guest table
FoodDrinkCategory addfdc = new FoodDrinkCategory();
addfdc.FoodDrinkCategoryName = txtCategory.Text;
addfdc.FoodDrinkCategoryTypeID = "F";
db.FoodDrinkCategories.InsertOnSubmit(addfdc);
db.SubmitChanges();
}
//repopulate dropdownlist
ddlCategory.DataSource = getAllCategories();
ddlCategory.DataBind();
gvEditCategories.DataBind();
ddlAddGetCategory.DataBind();
txtCategory.Text = "";
}
}
protected void btnAddListItemIngredient_Click1(object sender, EventArgs e)
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
var ing = from fdc in db.Ingredients.Where(fdc => fdc.IngredientName == txtIngredient.Text)
select fdc;
//checks to see if the item is in the database
if (ing.Any())
{
//If something exists, then don't add
//print error message
lblIngredientInsert.Text = "Ingredient Is Already In the Hotel Restaurant";
lblIngredientInsert.Visible = true;
//reset txtIngredient to " "
txtCategory.Text = "";
}
else
{
//add ingredient to database
Ingredient addIngredient = new Ingredient();
addIngredient.IngredientName = txtIngredient.Text;
//addIngredient.IngredientDescription = txtIngredientComments.Text;
db.Ingredients.InsertOnSubmit(addIngredient);
db.SubmitChanges();
lblIngredientInsert.Text = "Insert Successful";
lblIngredientInsert.Visible = true;
ddlIngredients.DataBind();
txtIngredient.Text = "";
txtIngredientComments.Text = "";
//make text box invisible again.
//make text box
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnUpdate_Click(object sender, EventArgs e)
{
try
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
TreasureLand.DBM.Guest guest = new TreasureLand.DBM.Guest();
var query = from guests in db.Guests
where guests.GuestID == Convert.ToInt32(gvGuestFolio.SelectedRow.Cells[0].Text)
select guests;
foreach (var guests in query)
{
guests.GuestSalutation = txtSalutation.Text;
guests.GuestSurName = txtShowSurname.Text;
guests.GuestFirstName = txtShowFirstName.Text;
guests.GuestAddress = txtAddress.Text;
guests.GuestCity = txtCity.Text;
guests.GuestRegion = txtState.Text;
guests.GuestCountry = txtCountry.Text;
guests.GuestEmail = txtEmail.Text;
guests.GuestPhone = txtPhone.Text;
guests.GuestPostalCode = txtPostalCode.Text;
guests.GuestComments = txtComments.Text;
guests.GuestIDIssueCountry = txtIssueCountry.Text;
guests.GuestID = (short)Convert.ToInt32(gvGuestFolio.SelectedRow.Cells[0].Text);
guests.GuestIDNumber = txtGuestID.Text;
}
db.SubmitChanges();
updateGuestBoxes();
lblError.Text = "Updated successfully";
}
catch (Exception)
{
throw;
}
}
protected void btnNewGuest_Click(object sender, EventArgs e)
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
var gu = from g in db.Guests.Where(g => g.GuestFirstName == txtFirstName.Text && g.GuestSurName == txtSurName.Text && g.GuestPhone == txtPhone.Text)
select g;
gvGuest.DataSource = gu.ToList();
gvGuest.DataBind();
if (gvGuest.Rows.Count == 0)
{
//USes an linq to sql to insert a guest into the guest table
Guest addGuest = new Guest();
addGuest.GuestFirstName = txtFirstName.Text;
addGuest.GuestSurName = txtSurName.Text;
addGuest.GuestPhone = txtPhone.Text;
db.Guests.InsertOnSubmit(addGuest);
db.SubmitChanges();
lblResFirstName.Text = txtFirstName.Text;
lblResSurName.Text = txtSurName.Text;
lblResPhone.Text = txtPhone.Text;
reserving.GuestID = addGuest.GuestID;
reserving.view = 2;
btnNewGuest.CommandArgument = "2";
}
else
{
lblErrorInsertGuest.Text = "Guest already exists please select below or enter a new guest";
btnNewGuest.CommandArgument = "0";
reserving.view = 0;
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
if (gvUnconfirmedGuest.SelectedIndex == -1)
lblErrorMessage2.Text = "You must select a guest";
else
{
TreasureLandDataClassesDataContext db = new TreasureLandDataClassesDataContext();
Reservation res = db.Reservations.Single(r=> r.ReservationID == Convert.ToInt32(gvUnconfirmedGuest.SelectedRow.Cells[3].Text));
res.ReservationStatus = 'C';
db.SubmitChanges();
//switches to the next view
mvLocateGuest.ActiveViewIndex = 1;
//get the discount
ArrayList myArrList = new ArrayList();
myArrList = App_Code.GuestDB.getGuestInformation(Convert.ToInt32(gvUnconfirmedGuest.SelectedRow.Cells[3].Text));
//if there are no items in the arrayList then there is no discount
if (myArrList.Count != 0)
{
txtShowReservationNum.Text = myArrList[0].ToString();
txtShowRoomType.Text = myArrList[1].ToString();
txtShowRoomNum.Text = myArrList[2].ToString();
txtShowNumGuests.Text = (Convert.ToInt32(myArrList[3]) + Convert.ToInt32(myArrList[4])).ToString();
txtShowFirstName.Text = myArrList[5].ToString();
txtShowSurname.Text = myArrList[6].ToString();
txtShowPhone.Text = myArrList[7].ToString();
txtShowCheckOut.Text = string.Format("{0:dd/MM/yyyy}", (Convert.ToDateTime(myArrList[8]).AddDays(Convert.ToInt32(myArrList[9]))));
lblCustomerId.Text = App_Code.GuestDB.getGuestID(Convert.ToInt32(txtShowReservationNum.Text)).ToString();
lblReservationDetailID.Text = gvUnconfirmedGuest.SelectedRow.Cells[0].Text;
}
}
}
