protected void Page_Load(object sender, EventArgs e)
{
/*Retriving values from session variables*/
int FareDlx = Convert.ToInt32(Session["FareDlx"].ToString());
int FareExe = Convert.ToInt32(Session["FareExe"].ToString());
int DlxRooms = Convert.ToInt32(Session["DlxRooms"].ToString());
int ExeRooms = Convert.ToInt32(Session["ExeRooms"].ToString());
int FPD1 = Convert.ToInt32(Session["FPD1"].ToString());
int FPD2 = Convert.ToInt32(Session["FPD2"].ToString());
decimal Tax1 = Convert.ToDecimal(Session["TaxDlx"].ToString());
decimal Tax2 = Convert.ToDecimal(Session["TaxExe"].ToString());
string HID = Session["HotelId"].ToString();
/*Calculating fare,taxamount,nd total amount*/
DateTime CID = Convert.ToDateTime(Session["ArrivalDate"].ToString());
DateTime COD = Convert.ToDateTime(Session["DepartDate"].ToString());
int NoOfDays = (COD - CID).Days;
int DlxFare = FPD1 * DlxRooms * NoOfDays;
int ExeFare = FPD2 * ExeRooms * NoOfDays;
int Amount = DlxFare + ExeFare;
decimal TaxAmount = Tax1 + Tax2;
decimal TotalAmount = Convert.ToDecimal(Amount) + TaxAmount;
lblAmount.Text = Convert.ToString(Amount);
lblTaxAmount.Text = Convert.ToString(TaxAmount);
lblTotalAmount.Text = Convert.ToString(TotalAmount);
/*creating object of data base layer*/
HotelDataBaseLayer hobj = new HotelDataBaseLayer();
/*calling function CheckDiscount to check if discount is available or not*/
decimal Discount = hobj.CheckDiscount(HID, DlxRooms, ExeRooms);
double DiscountAmount = Convert.ToDouble(Discount) * 100;
if (IsPostBack == false)
{
if (Discount == 0)
{
Response.Write("<script>alert('Sorry!!! No discount available')</script>");
lblDiscount.Text = Convert.ToString(DiscountAmount);
}
else
{
lblDiscount.Text = Convert.ToString(DiscountAmount);
}
}
Double AmtPaid = Convert.ToDouble(TotalAmount) - Convert.ToDouble(Discount * TotalAmount);
lblPaidAmount.Text = Convert.ToString(AmtPaid);
}
protected void Page_Load(object sender, EventArgs e)
{
/*Retrieving Session variables in labels*/
lblHotelName.Text = Session["HotelName"].ToString();
lblCID.Text = Session["ArrivalDate"].ToString();
lblCOD.Text = Session["DepartDate"].ToString();
lblDLX.Text = Session["DlxRooms"].ToString();
lblEXE.Text = Session["ExeRooms"].ToString();
lblNOR1.Text = Session["DlxRooms"].ToString();
lblNOR2.Text = Session["ExeRooms"].ToString();
string HotelName = Session["HotelName"].ToString();
string HotelId = Session["HotelId"].ToString();
/*creating object of databaselayer*/
HotelDataBaseLayer Hobj = new HotelDataBaseLayer();
DataSet ds = Hobj.HotelDetails(HotelId);
/*Retriving values from dataset into labels*/
lblFPD1.Text = ds.Tables[0].Rows[0][0].ToString();
lblFPD2.Text = ds.Tables[0].Rows[0][1].ToString();
/*Calculating check in date nd check out date difference*/
int NoOfDays = (Convert.ToDateTime(lblCOD.Text) - Convert.ToDateTime(lblCID.Text)).Days;
int DlxFare = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString()) * Convert.ToInt32(Session["DlxRooms"].ToString()) * NoOfDays;
int ExeFare = Convert.ToInt32(ds.Tables[0].Rows[0][1].ToString()) * Convert.ToInt32(Session["ExeRooms"].ToString()) * NoOfDays;
lblFare1.Text = Convert.ToString(DlxFare);
lblFare2.Text = Convert.ToString(ExeFare);
/*calculating tax*/
double TaxDlx = Convert.ToDouble(DlxFare) * Convert.ToDouble(ds.Tables[0].Rows[0][2].ToString());
lblTax1.Text = Convert.ToString(TaxDlx);
double TaxExe = Convert.ToDouble(ExeFare) * Convert.ToDouble(ds.Tables[0].Rows[0][2].ToString());
lblTax2.Text = Convert.ToString(TaxExe);
/*calculating total amount*/
double TotalAmtDlx = TaxDlx + DlxFare;
double TotalAmtExe = TaxExe + ExeFare;
/*Retriving values from variables into labels*/
lblAmount1.Text = Convert.ToString(TotalAmtDlx);
lblAmount2.Text = Convert.ToString(TotalAmtExe);
lblGTotal.Text = Convert.ToString(TotalAmtDlx + TotalAmtExe);
}
protected void btnPayment_Click(object sender, EventArgs e)
{
Session["Amount"] = lblAmount.Text;
Session["TaxAmount"] = lblTaxAmount.Text;
Session["TotalAmount"] = lblTotalAmount.Text;
Session["DiscountAmount"] = lblDiscount.Text;
/*Retriving values from session variables*/
int CustId = Convert.ToInt32(Session["CustId"].ToString());
DateTime BookingDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
int Dlxrooms = Convert.ToInt32(Session["DlxRooms"].ToString());
int Exerooms = Convert.ToInt32(Session["ExeRooms"].ToString());
DateTime ArrivalDate = Convert.ToDateTime(Session["ArrivalDate"].ToString());
DateTime DepartDate = Convert.ToDateTime(Session["DepartDate"].ToString());
string HID = Session["HotelId"].ToString();
/*creating object of data base layer*/
HotelDataBaseLayer hobj1 = new HotelDataBaseLayer();
/*calling function GetNextBookingCode to genetare booking id*/
int BookingId = hobj1.GetNextBookingCode();
/*calling function BookHotel to book hotel*/
int status = hobj1.BookHotel(CustId, BookingDate, Dlxrooms, Exerooms, ArrivalDate, DepartDate, HID);
double Amount = Convert.ToDouble(lblAmount.Text);
double TaxAmount = Convert.ToDouble(lblTaxAmount.Text);
double TotalAmount = Convert.ToDouble(lblTotalAmount.Text);
int discountFlag = 0;
if (lblDiscount.Text != "0")
{
discountFlag = 1;
}
/*calling function InsertPayment to insert values in table tbl_hotel_payment_group12*/
hobj1.InsertPayment(BookingId, TotalAmount, TaxAmount, discountFlag);
if (status == 1)
{
Response.Write("<script>alert('SuccessFull Booking and Payment!!!Your Booking Id is:" + BookingId + "') </script>");
Response.Write("<script>alert('Thank You') </script>");
Server.Transfer("Welcome.aspx");
}
}
protected void dgvDisplayDetails_SelectedIndexChanged(object sender, EventArgs e)
{
/*creating object of databaselayer*/
HotelDataBaseLayer hobj = new HotelDataBaseLayer();
/*declaring variables*/
string HotelName = dgvDisplayDetails.SelectedRow.Cells[0].Text.ToString();
string Location = dgvDisplayDetails.SelectedRow.Cells[1].Text.ToString();
string HotelID = hobj.GetHotelID(HotelName, Location);
int DeluxeRooms = Convert.ToInt32(lblDelRooms.Text);
int EXERooms = Convert.ToInt32(lblExeRooms.Text);
DateTime CheckInDate = Convert.ToDateTime(lblArrivalDate.Text);
DateTime CheckOutDate = Convert.ToDateTime(lblDeptDate.Text);
/*using DataBaseLayerObject,calling Function ChechRoomStatus*/
int status = hobj.ChechRoomStatus(HotelID, DeluxeRooms, EXERooms, CheckInDate, CheckOutDate);
if (status == 0)
{
Response.Write("<script>alert('No Rooms available')</script>");
}
else
{
Response.Write("<script>alert('Rooms Available')</script>");
HotelDataBaseLayer hobj1 = new HotelDataBaseLayer();
Session["HotelId"] = HotelID;
Session["HotelName"] = dgvDisplayDetails.SelectedRow.Cells[0].Text.ToString();
/*Moving to next page ReviewHotelDetails.aspx*/
Server.Transfer("ReviewHotelDetails.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
CompareValidator1.ValueToCompare = DateTime.Now.ToShortDateString();
/*Creating object of DataBase Layer*/
HotelDataBaseLayer hobj = new HotelDataBaseLayer();
DataTable dt = new DataTable();
/*calling Function city to fill drop down list ddlCity*/
dt = hobj.City();
ddlCity.DataSource = dt;
ddlCity.DataValueField = "CityCode";
ddlCity.DataTextField = "CityName";
/*calling Function customer to fill drop down list ddlCustId*/
DataTable dt1 = new DataTable();
dt1 = hobj.Customer();
ddlCustID.DataSource = dt1;
ddlCustID.DataValueField = "Customerid";
ddlCustID.DataTextField = "Customerid";
Page.DataBind();
}
