//private int InsertBookingTableData() //{ // try // { // // blsr._sBookingRef = txtBookRef.Text.Trim().ToString(); // blsr._dtStartDate = Convert.ToDateTime(txtChkin.Text.Trim()); // blsr._dtEndDate = Convert.ToDateTime(txtChkOut.Text.Trim()); // Int32.TryParse(Session["AcId"].ToString(), out iAccomId); // Int32.TryParse(Session["AccomTypeId"].ToString(), out iaccomtypeid); // Int32.TryParse(Session["Agid"].ToString(), out iagentid); // blsr._iAccomTypeId = iaccomtypeid; // blsr._iAccomId = iAccomId; // blsr._iAgentId = iagentid; // //Convert.ToInt32(Session["UserCode"].ToString()); // blsr._iNights = Convert.ToInt32((Convert.ToDateTime(txtChkOut.Text.Trim()) - Convert.ToDateTime(txtChkin.Text.Trim())).TotalDays); // DataTable dtRoomBookingDetails = ViewState["VsRoomDetails"] as DataTable; // blsr._iPersons = Convert.ToInt32(dtRoomBookingDetails.Compute("SUM(Pax)", string.Empty)); // blsr._BookingStatusId = 1; // blsr._SeriesId = 0; // blsr._proposedBooking = false; // blsr._chartered = false; // int GetQueryResponse = dlsr.AddParentBookingDetail(blsr); // if (GetQueryResponse > 0) // return 1; // else // return 0; // } // catch // { // return 0; // } //} //private int InsertRoomBookingTableData() //{ // Int32.TryParse(Session["AcId"].ToString(), out iAccomId); // blsr._iAccomId = iAccomId; // blsr.action = "getMaxBookId"; // DataTable dtmaxId = dlsr.GetMaxBookingId(blsr); // int MaxBookingId = Convert.ToInt32(dtmaxId.Rows[0].ItemArray[0].ToString()); // // BookedId = MaxBookingId; // blsr._iBookingId = MaxBookingId; // int LoopInsertStatus = 0; // try // { // for (int LoopCounter = 0; LoopCounter < gdvSelectedRooms.Rows.Count; LoopCounter++) // { // blsr._dtStartDate = Convert.ToDateTime(txtChkin.Text.Trim()); // blsr._dtEndDate = Convert.ToDateTime(txtChkOut.Text.Trim()); // blsr._iPaxStaying = Convert.ToInt32(gdvSelectedRooms.Rows[LoopCounter].Cells[3].Text); // blsr._bConvertTo_Double_Twin = false; // blsr._cRoomStatus = "B"; // HiddenField hfnrm = (HiddenField)gdvSelectedRooms.Rows[LoopCounter].FindControl("hdnRmno"); // blsr._sRoomNo = hfnrm.Value.ToString(); // // blsr.action = "AddPriceDetailsToo"; // blsr._Amt = Convert.ToDecimal(gdvSelectedRooms.Rows[LoopCounter].Cells[4].Text); // int GetQueryResponse = dlsr.AddRoomBookingDetails(blsr); // if (GetQueryResponse > 0) // LoopInsertStatus++; // else // { // //do nothing // } // } // // insertbookingMealData(MaxBookingId); // if (LoopInsertStatus == gdvSelectedRooms.Rows.Count) // { // return 1; // } // else // return // 0; // } // catch // { // return 0; // } //} protected void Button2_Click(object sender, EventArgs e) { try { Session["HotelBokingUrl"] = Request.Url.ToString(); Int32.TryParse(Session["AcId"].ToString(), out iAccomId); Int32.TryParse(Session["AccomTypeId"].ToString(), out iaccomtypeid); DataTable fg = ViewState["VsRoomDetails"] as DataTable; SessionServices.SaveSession <DataTable>("Bookingdt", fg); Session["Chkin"] = Session["HCheckin"].ToString(); Session["chkout"] = Session["HCheckout"].ToString(); // Session["BookRef"] = txtBookRef.Text.Trim(); Session["AccomId"] = iAccomId; Session["iAccomtypeId"] = iaccomtypeid; Session["AId"] = Session["Agid"].ToString(); if (Session["RedUrl"] == null) { string redurl = "AfterBookingDetails.aspx?AccomName=" + Request.QueryString["AccomName"].ToString() + ""; Session["RedUrl"] = redurl; } Response.Redirect(Session["RedUrl"].ToString()); } catch { } }
private int InsertBookingTableData(int acmid, int acmtpid, int agid, string bkref, DateTime cin, DateTime cout) { try { BALBooking blsr = new BALBooking(); DALBooking dlsr = new DALBooking(); DataTable dtbkdetails = SessionServices.RetrieveSession <DataTable>("Bookingdt"); blsr._sBookingRef = bkref; blsr._dtStartDate = cin; blsr._dtEndDate = cout; if (Session["CustId"] != null && Session["UserCode"] == null) { blsr.CustomerId = Session["CustId"].ToString(); } else { blsr.CustomerId = "0"; } blsr._iAccomTypeId = acmtpid; blsr._iAccomId = acmid; blsr._iAgentId = agid; blsr._iNights = Convert.ToInt32((cout - cin).TotalDays); blsr._iPersons = Convert.ToInt32(dtbkdetails.Compute("SUM(Pax)", string.Empty)); blsr._BookingStatusId = 1; blsr._SeriesId = 0; blsr._proposedBooking = false; blsr._chartered = false; blsr._BookingStatusId = (int)BookingStatusTypes.BOOKED; blsr._proposedBooking = true; int bookingId = dlsr.AddParentBookingDetail(blsr); var bookingDetails = dlsr.GetBookingDetails(bookingId); if (bookingDetails != null) { blsr.BookingCode = bookingDetails.BookingCode; } blsr._iBookingId = bookingId; //Session["tblBookingBAL"] = blsr; SessionServices.SaveSession <BALBooking>("tblBookingBAL", blsr); return(bookingId); } catch (Exception ex) { throw ex; } }
private void bindRoomRates(int accmid, int Totpax, int agid, DateTime chkin, DateTime chkout, int norooms, int RtypeId) { try { if (Session["UserCode"] != null) { blht.action = "RoomRate"; } else { blht.action = "RoomRateCust"; } blht.Accomid = accmid; blht.TotPax = Totpax; blht.Reqnoofrooms = norooms; blht.checkin = chkin; blht.Checkout = chkout; blht.RoomTypeId = RtypeId; blht.agentid = agid; Returndt = dlht.GetHotelRates(blht); if (Returndt != null) { SessionServices.SaveSession <DataTable>("RoomInfo", Returndt); dv = new DataView(Returndt); // dv.RowFilter = "ActualRoomTypeId<>0"; if (dv.ToTable().Rows.Count > 0) { gdvHotelRoomRates.DataSource = dv; gdvHotelRoomRates.DataBind(); //avl.InnerHtml = "Available Rooms"; } else { //avl.InnerHtml = "No Rooms Available"; RemoveZeroes(); } ViewState["Rrate"] = Returndt; } } catch { } }