protected void btnSave_Click(object sender, EventArgs e)
{
//do insert or update
using (comp2007Entities db = new comp2007Entities())
{
Room objC = new Room();
if (!String.IsNullOrEmpty(Request.QueryString["RoomID"]))
{
Int32 RoomID = Convert.ToInt32(Request.QueryString["RoomID"]);
objC = (from r in db.Rooms
where r.RoomID == RoomID
select r).FirstOrDefault();
}
Booking objD = new Booking();
//populate the booking entry from the input form and room info
objD.RoomID = objC.RoomID;
objD.LastName = txtLastName.Text;
objD.FirstName = txtFirstName.Text;
objD.DaysStaying = Convert.ToInt32(txtDaysStaying.Text);
objD.BookDate = DateTime.Today;
//Decimal TotalCost = objC.CostPerDay * objD.DaysStaying;
//add
db.Bookings.Add(objD);
//save and redirect
db.SaveChanges();
Response.Redirect("bookings.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
//do insert or update
using (comp2007Entities db = new comp2007Entities())
{
Room objC = new Room();
if (!String.IsNullOrEmpty(Request.QueryString["RoomID"]))
{
Int32 RoomID = Convert.ToInt32(Request.QueryString["RoomID"]);
objC = (from r in db.Rooms
where r.RoomID == RoomID
select r).FirstOrDefault();
}
//populate the room from the input form
objC.Size = ddlRoomSize.Text;
objC.CostPerDay = Convert.ToDecimal(txtCostPerDay.Text);
objC.Availability = "y";
if (String.IsNullOrEmpty(Request.QueryString["RoomID"]))
{
//add
db.Rooms.Add(objC);
}
//save and redirect
db.SaveChanges();
Response.Redirect("rooms.aspx");
}
}
protected void CheckIn()
{
//populate the existing room for editing
using (comp2007Entities db = new comp2007Entities())
{
Room objC = new Room();
if (!String.IsNullOrEmpty(Request.QueryString["RoomID"]))
{
Int32 RoomID = Convert.ToInt32(Request.QueryString["RoomID"]);
objC = (from r in db.Rooms
where r.RoomID == RoomID
select r).FirstOrDefault();
}
//populate the room from the input form
objC.Size = objC.Size;
objC.CostPerDay = objC.CostPerDay;
objC.Availability = objC.Availability;
//set availability to no
if (objC.Availability == "y")
{
objC.Availability = "n";
if (String.IsNullOrEmpty(Request.QueryString["RoomID"]))
{
//add
db.Rooms.Add(objC);
}
//save
db.SaveChanges();
}
//room not currently available
else
{
//redirect
Response.Redirect("rooms.aspx");
}
}
}
