public void calcamt(DataTable dts) { try { for (int j = 0; j < dts.Rows.Count; j++) { string[] arr = dts.Rows[j]["Total"].ToString().Split(' '); TotalPaybleAmt = TotalPaybleAmt + Convert.ToInt32(arr[1]);; } hdnfTotalPaybleAmt.Value = TotalPaybleAmt.ToString(); txtPaidAmt.Text = Math.Round(((25 * TotalPaybleAmt) / 100)).ToString("N2"); Bookingdt = SessionServices.RetrieveSession <DataTable>("Bookingdt"); lbltotAmt.Text = Bookingdt.Rows[0]["Currency"].ToString() + " " + TotalPaybleAmt.ToString(); lblCurrency.Text = Bookingdt.Rows[0]["Currency"].ToString().ToString() + " "; txtPaidAmt.Text = Math.Round(((25 * TotalPaybleAmt) / 100)).ToString("#.##"); hftxtpaidamt.Value = Convert.ToDouble(txtPaidAmt.Text).ToString("N2").Replace(",", ""); lblBalanceAmt.Text = Bookingdt.Rows[0]["Currency"].ToString().ToString() + " " + Math.Round((TotalPaybleAmt - Convert.ToDouble(txtPaidAmt.Text))).ToString(); // lbltotAmt.Text = dtGetBookedRooms.Rows[0]["Currency"].ToString() + " " + TotalPaybleAmt.ToString(); } catch { } }
protected void btnCustLogin_Click(object sender, EventArgs e) { try { blcus.Email = txtCustMailId.Text.Trim(); blcus.Password = txtCustPass.Text.Trim(); blcus.action = "LoginCust"; DataTable dtCustomer = dlcus.checkDuplicateemail(blcus); if (dtCustomer != null) { if (dtCustomer.Rows.Count > 0) { Session["CustMailId"] = txtCustMailId.Text.Trim(); ViewState["Pass"] = txtCustPass.Text.Trim(); lblBillingAddress.Text = dtCustomer.Rows[0]["BillingAddress"].ToString(); lblAgentName.Text = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()) + " " + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()); lbPaymentMethod.Text = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["PaymentMethod"].ToString()); hdnfPhoneNumber.Value = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Telephone"].ToString()); Session["CustId"] = dtCustomer.Rows[0]["CustId"].ToString(); Session["CustomerCode"] = dtCustomer.Rows[0]["CustId"].ToString(); Session.Add("CustomerMailId", DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Email"].ToString())); Session.Add("CustPassword", DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Password"].ToString())); DataTable dtrpax = SessionServices.RetrieveSession <DataTable>("Bookingdt"); string BookRef = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()) + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()) + "X" + Convert.ToDouble(dtrpax.Compute("SUM(Pax)", string.Empty)).ToString() + "-" + "Self"; ViewState["BookRef"] = BookRef; lbPaymentMethod.Text = "N/A"; pnlFullDetails.Visible = true; panelwithoutCreditAgent.Visible = true; pnlBookButton.Visible = true; customerLogin.Visible = false; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Password or Email Id incorrect')", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Password or Email Id incorrect')", true); } //Bookingdt = Session["Bookingdt"] as DataTable; // preparetables(Bookingdt); } catch { } }
protected void Page_Load(object sender, EventArgs e) { Bookingdt = SessionServices.RetrieveSession <DataTable>("Bookingdt"); gdvSelectedRooms.DataSource = Bookingdt; gdvSelectedRooms.DataBind(); lblArrvDate.Text = Session["Chkin"].ToString(); lblDepartDate.Text = Session["chkout"].ToString();; lblacm.Text = lblAccomName.Text = Session["AccomName"].ToString(); CalcAmount(); getbalance(); }
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; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["UserCode"] != null || Session["CustomerCode"] != null) { if (Session["UserCode"] != null) { BookRef.Style.Remove("display"); ReqBookRef.Enabled = true; } else { BookRef.Style.Add("display", "None"); ReqBookRef.Enabled = false; } lnkLogout.Visible = true; } else { BookRef.Style.Add("display", "None"); ReqBookRef.Enabled = false; lnkLogout.Visible = false; } this.pnlLogin.Visible = false; this.pnlFullDetails.Visible = false; pnlBookButton.Visible = false; panelwithoutCreditAgent.Visible = false; Bookingdt = new DataTable(); Bookingdt = SessionServices.RetrieveSession <DataTable>("Bookingdt"); bookingmealdt = new DataTable(); bookingmealdt = SessionServices.RetrieveSession <DataTable>("BookinMealdt"); gdvSelectedRooms.DataSource = Bookingdt; gdvSelectedRooms.DataBind(); //lblChkin.Text = Session["Chkin"].ToString(); //lblChkout.Text = Session["chkout"].ToString(); calcamt(Bookingdt); LoadCountries(); pnlCustReg.Visible = false; customerLogin.Visible = false; } Bookingdt = SessionServices.RetrieveSession <DataTable>("Bookingdt"); preparetables(Bookingdt); }
public void calcamt(DataTable dts) { try { for (int j = 0; j < dts.Rows.Count; j++) { string[] arr = dts.Rows[j]["Total"].ToString().Split(' '); TotalPaybleAmt = TotalPaybleAmt + Convert.ToInt32(arr[1]);; } hdnfTotalPaybleAmt.Value = TotalPaybleAmt.ToString(); Bookingdt = SessionServices.RetrieveSession <DataTable>("Bookingdt"); lbltotAmt.Text = Bookingdt.Rows[0]["Currency"].ToString() + " " + TotalPaybleAmt.ToString(); lblCurrency.Text = Bookingdt.Rows[0]["Currency"].ToString().ToString() + " "; DateTime checkInDate = Convert.ToDateTime(Session["Chkin"]); double paidAmt = 0; if (checkInDate.AddDays(-30) < System.DateTime.Now) { //txtPaidAmt.Text = Math.Round(((25 * TotalPaybleAmt) / 100)).ToString("N2"); txtPaidAmt.Text = Math.Round(((100 * TotalPaybleAmt) / 100)).ToString("#.##"); paidAmt = Math.Round(((100 * TotalPaybleAmt) / 100)); } else { //txtPaidAmt.Text = Math.Round(((25 * TotalPaybleAmt) / 100)).ToString("N2"); txtPaidAmt.Text = Math.Round(((25 * TotalPaybleAmt) / 100)).ToString("#.##") + " (25 % of total)"; paidAmt = Math.Round(((25 * TotalPaybleAmt) / 100)); } hftxtpaidamt.Value = paidAmt.ToString("N2").Replace(",", ""); double balanceAmt = Math.Round((TotalPaybleAmt - paidAmt)); if (balanceAmt > 0) { lblBalanceAmt.Text = Bookingdt.Rows[0]["Currency"].ToString().ToString() + " " + balanceAmt.ToString() + " (75% of total) to be paid prior to " + checkInDate.AddDays(-30).ToString("MMM-dd-yyyy"); } else { lblBalanceAmt.Text = Bookingdt.Rows[0]["Currency"].ToString().ToString() + " " + balanceAmt.ToString(); } // lbltotAmt.Text = dtGetBookedRooms.Rows[0]["Currency"].ToString() + " " + TotalPaybleAmt.ToString(); } catch { } }
private void InsertParentTableData() { try { if (Session["UserCode"] != null) { blsr._iAgentId = Convert.ToInt32(Session["UserCode"].ToString()); } else { blsr._iAgentId = Convert.ToInt32(Session["CustId"].ToString()); } blsr.action = "GetDepartureDetails"; blsr._iBookingId = 0; blsr.PackageId = Session["PackageId"].ToString(); dtGetReturnedData = dlsr.GetDepartureDetails(blsr); blsr._sBookingRef = Session["BookingRef"].ToString(); blsr._dtStartDate = Convert.ToDateTime(dtGetReturnedData.Rows[0]["CheckInDate"]); blsr._dtEndDate = Convert.ToDateTime(dtGetReturnedData.Rows[0]["CheckOutDate"]); blsr._iAccomTypeId = Convert.ToInt32(dtGetReturnedData.Rows[0]["AccomTypeId"]); blsr._iAccomId = Convert.ToInt32(dtGetReturnedData.Rows[0]["AccomId"]); blsr._iNights = Convert.ToInt32(dtGetReturnedData.Rows[0]["NoOfNights"]); DataTable dtRoomBookingDetails = SessionServices.RetrieveSession <DataTable>("BookedRooms"); blsr._iPersons = Convert.ToInt32(dtRoomBookingDetails.Compute("SUM(Pax)", string.Empty)); blsr._BookingStatusId = 1; blsr._SeriesId = 0; blsr._proposedBooking = false; blsr._chartered = false; Session.Add("tblBookingBAL", blsr); int iBRC = dlsr.GetBookingReferenceCount(blsr); if (iBRC > 0) { System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertBox", "alert('The Booking Reference mentioned by you is not unique. Please enter a different reference number.');", true); return; } int GetQueryResponse = dlsr.AddParentBookingDetail(blsr); } catch { } }
protected void gdvSelectedRooms_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { try { retdt = SessionServices.RetrieveSession <DataTable>("RoomInfo"); Label roomcatid = (Label)e.Row.FindControl("lblRoomCatId"); DataView dv = new DataView(retdt); dv.RowFilter = "RoomCategoryId='" + roomcatid.Text + "' "; e.Row.Cells[7].Text = dv.ToTable().Rows[0]["TaxPct"].ToString(); e.Row.Cells[8].Text = ((Convert.ToDouble(e.Row.Cells[7].Text) * Convert.ToDouble(e.Row.Cells[6].Text)) / 100).ToString(); } catch { } } }
private int InsertRoomBookingTableData(int bookingId, string bookingPaymentId) { try { BALBooking blsr = new BALBooking(); DALBooking dlsr = new DALBooking(); DataTable dtbkdetails = SessionServices.RetrieveSession <DataTable>("Bookingdt"); BALBooking booking = dlsr.GetBookingDetails(bookingId); Session["maxBookId"] = bookingId; blsr._iBookingId = bookingId; blsr._iAccomId = booking._iAccomId; blsr.PaymentId = bookingPaymentId; //int LoopInsertStatus = 0; for (int LoopCounter = 0; LoopCounter < dtbkdetails.Rows.Count; LoopCounter++) { blsr._dtStartDate = booking._dtStartDate; blsr._dtEndDate = booking._dtEndDate; blsr._iPaxStaying = booking._iPaxStaying; blsr._bConvertTo_Double_Twin = Convert.ToBoolean(dtbkdetails.Rows[LoopCounter]["ConvDouble"].ToString()); blsr._cRoomStatus = "B"; blsr._sRoomNo = dtbkdetails.Rows[LoopCounter][7].ToString(); blsr._PaidAmount = Convert.ToDouble(Session["Paid"]); blsr.action = "AddPriceDetailsToo"; string[] arr = dtbkdetails.Rows[LoopCounter]["Total"].ToString().Split(' '); blsr._Amt = Convert.ToDecimal(arr[1]); int GetQueryResponse = dlsr.AddRoomBookingDetails(blsr); } return(1); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('" + ex.Message.ToString() + "')", true); throw ex; } }
private int InsertBookingTableData(int acmid, int acmtpid, int agid, string bkref, DateTime cin, DateTime cout, DataTable vsdetails) { try { dtbkdetails = SessionServices.RetrieveSession <DataTable>("Bookingdt"); blsr._sBookingRef = bkref; blsr._dtStartDate = cin; blsr._dtEndDate = cout; 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; int GetQueryResponse = dlsr.AddParentBookingDetail(blsr); if (GetQueryResponse > 0) { return(1); } else { return(0); } } catch (Exception ex) { return(0); } }
private void LoadBookedRoomDetails() { dtGetBookedRooms = SessionServices.RetrieveSession<DataTable>("BookedRooms"); DataTable dtgroupedData = new DataTable(); dtgroupedData.Columns.Add("categoryName"); dtgroupedData.Columns.Add("Pax"); dtgroupedData.Columns.Add("Price"); DataTable dtUniqueCategories = dtGetBookedRooms.DefaultView.ToTable(true, "categoryName"); #region Adding distict Room categories foreach (DataRow dr1 in dtUniqueCategories.Rows) { string categoryName = dr1["categoryName"].ToString(); DataRow dr2 = dtgroupedData.NewRow(); dr2["categoryName"] = categoryName; dtgroupedData.Rows.Add(dr2); } #endregion #region calculating values foreach (DataRow dr1 in dtgroupedData.Rows) { string category = dr1["categoryName"].ToString(); DataView dv; dv = new DataView(dtGetBookedRooms, "categoryName='" + category + "'", "categoryName", DataViewRowState.CurrentRows); DataTable dtFiltered = dv.ToTable(); int packs = 0; decimal price = 0; foreach (DataRow dr3 in dtFiltered.Rows) { packs = packs + Convert.ToInt32(dr3["Pax"].ToString()); price = price + Convert.ToDecimal(dr3["Price"].ToString()); } dr1["Pax"] = packs.ToString(); dr1["Price"] = price.ToString(); } dtGetBookedRooms = dtgroupedData; #endregion }
private int InsertRoomBookingTableData(DataTable dtbooking, DateTime cin, DateTime cout, int acmid) { try { dtbkdetails = SessionServices.RetrieveSession <DataTable>("Bookingdt"); blsr._iAccomId = acmid; blsr.action = "getMaxBookId"; DataTable dtmaxId = dlsr.GetMaxBookingId(blsr); int MaxBookingId = Convert.ToInt32(dtmaxId.Rows[0].ItemArray[0].ToString()); lbBookingNo.Text = dtmaxId.Rows[0].ItemArray[0].ToString(); // BookedId = MaxBookingId; blsr._iBookingId = MaxBookingId; Session["maxBookId"] = MaxBookingId; int LoopInsertStatus = 0; for (int LoopCounter = 0; LoopCounter < dtbkdetails.Rows.Count; LoopCounter++) { blsr._dtStartDate = cin; blsr._dtEndDate = cout; blsr._iPaxStaying = Convert.ToInt32(dtbooking.Rows[LoopCounter][3].ToString()); blsr._bConvertTo_Double_Twin = Convert.ToBoolean(dtbkdetails.Rows[LoopCounter]["ConvDouble"].ToString()); blsr._cRoomStatus = "B"; blsr._sRoomNo = dtbkdetails.Rows[LoopCounter][7].ToString(); blsr._PaidAmount = Convert.ToDouble(Session["Paid"]); blsr.action = "AddPriceDetailsToo"; string[] arr = dtbkdetails.Rows[LoopCounter]["Total"].ToString().Split(' '); blsr._Amt = Convert.ToDecimal(arr[1]); blsr.PaymentId = Session["BookingPayId"].ToString(); int GetQueryResponse = dlsr.AddRoomBookingDetails(blsr); if (GetQueryResponse > 0) { LoopInsertStatus++; } else { } } DataTable Bookingdt = SessionServices.RetrieveSession <DataTable>("Bookingdt"); //Response.Write(Bookingdt.Rows[0]["Total1"].ToString()); //gdvSelectedRooms.DataSource = Bookingdt; //gdvSelectedRooms.DataBind(); //gdvSelectedRooms.FooterRow.Cells[1].Text = "Total </br> Service Tax @ 4.50% </br> <b> Grand Total </b> "; //gdvSelectedRooms.FooterRow.Cells[3].Text = Math.Round(Convert.ToDouble(Bookingdt.Compute("SUM(Total1)", "[Total1] > 0"))).ToString("#.##") + "</br> " + Math.Round((4.5 * (Convert.ToInt32(Bookingdt.Compute("SUM(Total1)", "[Total1] > 0")) / 100))).ToString("#.##") + " </br> " + Math.Round((Convert.ToDouble(Bookingdt.Compute("SUM(Total1)", "[Total1] > 0")) + (4.5 * (Convert.ToInt32(Bookingdt.Compute("SUM(Total1)", "[Total1] > 0")) / 100)))).ToString("#.##"); //Response.Write("def"); //lbPax.Text = Convert.ToInt32(Bookingdt.Compute("SUM(Pax)", "[Pax] > 0")).ToString(); ; //lblTotAMt.Text = Math.Round((Convert.ToDouble(Bookingdt.Compute("SUM(Total1)", "[Total1] > 0")) + (4.5 * (Convert.ToInt32(Bookingdt.Compute("SUM(Total1)", "[Total1] > 0")) / 100)))).ToString("#.##"); //lblBalance.Text = Math.Round((Convert.ToDouble(lblTotAMt.Text) - Convert.ToDouble(lblTotPaid.Text))).ToString("#.##"); //lbBalanceDueIn.Text = Convert.ToDateTime(lblArrvDate.Text).AddDays(-90).ToString("d MMMM, yyyy"); //hfBookingId.Value = MaxBookingId.ToString(); //lblArrvDate.Text = Session["Chkin"].ToString(); //lblDepartDate.Text = Session["chkout"].ToString(); ; //lblacm.Text = "Accomodation Name: " + Session["AccomName"].ToString(); if (LoopInsertStatus == dtbooking.Rows.Count) { return(1); } else { return(0); } } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('" + ex.Message.ToString() + "')", true); return(0); } }
public string CRCCode(String ClearString, String key, string TRANSACTIONSTATUS, string APTRANSACTIONID, string MESSAGE, string TRANSACTIONID, string AMOUNT) { try { Crc32 crc32 = new Crc32(); String hash = String.Empty; byte[] mybytes = Encoding.UTF8.GetBytes(ClearString); foreach (byte b in crc32.ComputeHash(mybytes)) { hash += b.ToString("x2"); } UInt32 Output = UInt32.Parse(hash, System.Globalization.NumberStyles.HexNumber); UInt32 Output1 = UInt32.Parse(key); if (Output1 == Output) { if (Session["Hotel"] != null) { lblTotPaid.Text = Convert.ToDouble(AMOUNT).ToString("#.##"); GenrateBill1(TRANSACTIONID); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ReservationConnectionString"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("insert into tblTransactionDetails values('" + hfBookingId.Value + "', '" + TRANSACTIONID + "','" + APTRANSACTIONID + "' , '" + Convert.ToDecimal(AMOUNT) + "','" + TRANSACTIONSTATUS + "','" + System.DateTime.Now + "')", con); int QueryResponse = cmd.ExecuteNonQuery(); con.Close(); if (QueryResponse > 0) { // lbBookingNo.Text = TRANSACTIONID.ToString(); //FiilPackage(); } } else { lblTotPaid.Text = Convert.ToDouble(AMOUNT).ToString("#.##");; GenrateBill(TRANSACTIONID); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ReservationConnectionString"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("insert into tblTransactionDetails values('" + hfBookingId.Value + "', '" + TRANSACTIONID + "','" + APTRANSACTIONID + "' , '" + Convert.ToDecimal(AMOUNT) + "','" + TRANSACTIONSTATUS + "','" + System.DateTime.Now + "')", con); int QueryResponse = cmd.ExecuteNonQuery(); con.Close(); if (QueryResponse > 0) { // lbBookingNo.Text = TRANSACTIONID.ToString(); FiilPackage(); } DataTable GridRoomPaxDetail = SessionServices.RetrieveSession <DataTable>("BookedRooms"); gdvCruiseRooms.FooterRow.Cells[1].Text = "Total </br> Service Tax @ 4.50% </br> <b> Grand Total </b>"; gdvCruiseRooms.FooterRow.Cells[3].Text = Math.Round(Convert.ToDouble(GridRoomPaxDetail.Compute("SUM(Price)", string.Empty))).ToString("#.##") + "</br> " + Math.Round((4.5 * (Convert.ToInt32(GridRoomPaxDetail.Compute("SUM(Price)", string.Empty)) / 100))).ToString("#.##") + " </br> " + Math.Round((Convert.ToDouble(GridRoomPaxDetail.Compute("SUM(Price)", string.Empty)) + (4.5 * (Convert.ToInt32(GridRoomPaxDetail.Compute("SUM(Price)", string.Empty)) / 100)))).ToString("#.##"); lblTotAMt.Text = Math.Round((Convert.ToDouble(GridRoomPaxDetail.Compute("SUM(Price)", string.Empty)) + (4.5 * (Convert.ToInt32(GridRoomPaxDetail.Compute("SUM(Price)", string.Empty)) / 100)))).ToString("#.##"); lblBalance.Text = Math.Round((Convert.ToDouble(lblTotAMt.Text) - Convert.ToDouble(lblTotPaid.Text))).ToString("#.##"); lbBalanceDueIn.Text = Convert.ToDateTime(lblArrvDate.Text).AddDays(-90).ToString("d MMMM, yyyy"); //gdvCruiseRooms.FooterRow.Cells[1].Text = "Total </br> Service Tax @ 4.50%"; //gdvCruiseRooms.FooterRow.Cells[3].Text = Convert.ToDouble(GridRoomPaxDetail.Compute("SUM(Price)", string.Empty)).ToString(); //lblTotAMt.Text = (Convert.ToDouble(GridRoomPaxDetail.Compute("SUM(Price)", string.Empty)) + (4.5 * (Convert.ToInt32(GridRoomPaxDetail.Compute("SUM(Price)", string.Empty)) / 100))).ToString(); //lblBalance.Text = (Convert.ToDouble(lblTotAMt.Text) - Convert.ToDouble(lblTotPaid.Text)).ToString(); Session["BookedRooms"] = null; Session["PackageId"] = null; Session["BookingRef"] = null; } lbRuppeeinwords.Text = GF.NumbersToWords(Convert.ToInt32(lblTotAMt.Text)); } else { Response.Write("Secure Hash mismatch."); } return(hash); } catch { return(null); } }
private void InsertChildTableData() { #region Fetching Departure Details blsr.action = "GetDepartureDetails"; blsr.PackageId = Session["PackageId"].ToString(); dtGetReturnedData = dlsr.GetDepartureDetails(blsr); blsr._iAccomId = Convert.ToInt32(dtGetReturnedData.Rows[0]["AccomId"]); #endregion blsr.action = "getMaxBookId"; DataTable dtmaxId = dlsr.GetMaxBookingId(blsr); if (dtGetReturnedData != null) { int MaxBookingId = Convert.ToInt32(dtmaxId.Rows[0].ItemArray[0].ToString()); lbBookingNo.Text = dtmaxId.Rows[0].ItemArray[0].ToString(); BookedId = MaxBookingId; blsr._iBookingId = MaxBookingId; DataTable GridRoomPaxDetail = SessionServices.RetrieveSession <DataTable>("BookedRooms"); gdvCruiseRooms.DataSource = GridRoomPaxDetail; gdvCruiseRooms.DataBind(); lblacm.Text = "M V Mahabaahu"; lblVessel.Text = "Vessel: "; lbPax.Text = Convert.ToInt32(GridRoomPaxDetail.Compute("SUM(Pax)", string.Empty)).ToString(); // lblTotoAmt.Text = Convert.ToInt32(GridRoomPaxDetail.Compute("SUM(Price)", string.Empty)).ToString(); lblDepartDate.Text = Convert.ToDateTime(dtGetReturnedData.Rows[0]["CheckOutDate"]).ToString("d MMMM, yyyy"); lblArrvDate.Text = Convert.ToDateTime(dtGetReturnedData.Rows[0]["CheckInDate"]).ToString("d MMMM, yyyy"); int LoopInsertStatus = 0; try { for (int LoopCounter = 0; LoopCounter < GridRoomPaxDetail.Rows.Count; LoopCounter++) { blsr._dtStartDate = Convert.ToDateTime(dtGetReturnedData.Rows[0]["CheckInDate"]); blsr._dtEndDate = Convert.ToDateTime(dtGetReturnedData.Rows[0]["CheckOutDate"]); blsr._iPaxStaying = Convert.ToInt32(GridRoomPaxDetail.Rows[LoopCounter]["Pax"].ToString()); blsr._bConvertTo_Double_Twin = GridRoomPaxDetail.Rows[LoopCounter]["Convertable"].ToString() == "1" ? true : false; blsr._cRoomStatus = "B"; blsr._sRoomNo = GridRoomPaxDetail.Rows[LoopCounter]["RoomNumber"].ToString(); blsr.action = "AddPriceDetailsToo"; blsr._Amt = Convert.ToDecimal(GridRoomPaxDetail.Rows[LoopCounter]["Price"].ToString()); blsr.PaymentId = Session["BookingPayId"].ToString(); blsr._PaidAmount = Convert.ToDouble(Session["Paid"]); int GetQueryResponse = dlsr.AddRoomBookingDetails(blsr); if (GetQueryResponse > 0) { LoopInsertStatus++; } else { //do nothing } } hfBookingId.Value = MaxBookingId.ToString(); } catch { } } else { } }
private int GetPax() { DataTable dtrpax = SessionServices.RetrieveSession <DataTable>("Bookingdt"); return(Convert.ToInt16(dtrpax.Compute("SUM(Pax)", string.Empty))); }
private void loadall() { if (Session["UserCode"] != null) { try { blagentpayment._Action = "MailValidate"; if (Session["AgentMailId"] != null && Session["Password"] != null) { blagentpayment._EmailId = Session["AgentMailId"].ToString(); blagentpayment._Password = Session["Password"].ToString(); DataTable dtAgent = dlagentpayment.BindControls(blagentpayment); if (dtAgent.Rows.Count > 0) { lblAgentName.Text = Session["UserName"].ToString(); lblBillingAddress.Text = dtAgent.Rows[0]["BillingAddress"].ToString(); lbPaymentMethod.Text = dtAgent.Rows[0]["PaymentMethod"].ToString(); hdnfPhoneNumber.Value = dtAgent.Rows[0]["Phone"].ToString(); hdnfCreditLimit.Value = dtAgent.Rows[0]["CreditLimit"].ToString(); bool oncredit = Convert.ToBoolean(dtAgent.Rows[0]["ChkCredit"].ToString()); pnlFullDetails.Visible = true; if (oncredit) { panelwithoutCreditAgent.Visible = false; panelwithoutCreditAgent.Visible = true; } else { panelwithoutCreditAgent.Visible = true; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Agent Payment Details Not found')", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('It seems you are not logged in')", true); } } catch (Exception sqe) { } } else if (Session["CustomerCode"] != null) { try { DataTable dtCustomer = new DataTable(); blcus.Email = Session["CustMailId"].ToString(); if (Session["guest"] != null) { blcus.action = "getforguest"; dtCustomer = dlcus.getforguest(blcus); } else { blcus.Password = Session["userpass"].ToString(); Session["CustPassword"] = Session["userpass"].ToString(); blcus.action = "LoginCust"; dtCustomer = dlcus.checkDuplicateemail(blcus); } if (dtCustomer != null && dtCustomer.Rows.Count > 0) { Session["CustomerMailId"] = Session["CustMailId"].ToString(); lblAgentName.Text = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()) + " " + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()); lblBillingAddress.Text = dlcus.GetBillingAddress(dtCustomer.Rows[0]); lbPaymentMethod.Text = dtCustomer.Rows[0]["PaymentMethod"].ToString(); hdnfPhoneNumber.Value = dtCustomer.Rows[0]["Telephone"].ToString(); Session["CustId"] = dtCustomer.Rows[0]["CustId"].ToString(); DataTable dtrpax = SessionServices.RetrieveSession <DataTable>("BookedRooms"); string BookRef = dtCustomer.Rows[0]["FirstName"].ToString() + dtCustomer.Rows[0]["LastName"].ToString() + "X" + Convert.ToDouble(dtrpax.Compute("SUM(Pax)", string.Empty)).ToString() + "-" + "Direct Client"; ViewState["BookRef"] = BookRef; lbPaymentMethod.Text = "Online"; pnlFullDetails.Visible = true; panelwithoutCreditAgent.Visible = true; } else { } } catch (Exception ex) { throw ex; } } }
protected void btnPayProceed_Click(object sender, EventArgs e) { try { Session["Hotel"] = 1; if (btnPayProceed.Text == "Proceed For Payment") { if (Session["UserCode"] != null) { //[email protected] [1:48:55 PM] Augurs Technologies Pvt. Ltd.: 12345 DataTable dtrpax = SessionServices.RetrieveSession <DataTable>("Bookingdt"); string BookRef = txtBookRef.Text + "X" + Convert.ToDouble(dtrpax.Compute("SUM(Pax)", string.Empty)).ToString(); Session.Add("BookingRef", BookRef); Session["Paid"] = Convert.ToDouble(txtPaidAmt.Text.Trim() == "" ? "0" : txtPaidAmt.Text.Trim()); blagentpayment._Action = "MailValidate"; blagentpayment._EmailId = Session["AgentMailId"].ToString(); blagentpayment._Password = Session["Password"].ToString(); DataTable dtAgent = dlagentpayment.BindControls(blagentpayment); if (dtAgent.Rows.Count > 0) { string BookingPayId = lbPaymentMethod.Text.Trim().Substring(0, 2) + DateTime.Now.ToString("MMddhhmmssfff"); string Email = Session["AgentMailId"].ToString(); string PhoneNumber = hdnfPhoneNumber.Value.Trim().ToString(); string FirstName = DataSecurityManager.Decrypt(dtAgent.Rows[0]["FirstName"].ToString()); string LastName = DataSecurityManager.Decrypt(dtAgent.Rows[0]["LastName"].ToString()); string PaidAmt = hftxtpaidamt.Value.Trim().ToString(); string PaymentId = BookingPayId.ToString(); string BillingAddress = lblBillingAddress.Text.Trim().ToString(); Session["BookingPayId"] = txtBookRef.Text.Trim();// BookingPayId; Session["Address"] = BillingAddress; Session["InvName"] = FirstName; Session["SubInvName"] = FirstName; //Response.Redirect("PaymentGatewayResponse.aspx?BookingPayId=" + PaymentId + "&EmailId=" + Email.ToString() + "&PhoneNumber=" + PhoneNumber.ToString() + "&FirstName=" + FirstName.ToString() + "&LastName=" + LastName.ToString() + "&PaidAmt=" + PaidAmt.ToString() + "&BillingAddress=" + BillingAddress.ToString()); //http://adventureresortscruises.in/Cruise/booking/sendtoairpay.aspx?BookedId=0&PackName=7N8D+Downstream+Cruise&NoOfNights=7&CheckinDate=12%2f4%2f2016&PackId=Pack4 Response.Redirect("~/Cruise/booking/sendtoairpay.aspx?BookingPayId=" + PaymentId + "&EmailId=" + Email.ToString() + "&PhoneNumber=" + PhoneNumber.ToString() + "&FirstName=" + FirstName.ToString() + "&LastName=" + LastName.ToString() + "&PaidAmt=" + PaidAmt.ToString() + "&BillingAddress=" + BillingAddress.ToString()); //ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('not registered!!!')", true); } } else { Session.Add("BookingRef", ViewState["BookRef"].ToString()); blcus.Email = Session["CustomerMailId"].ToString(); blcus.Password = Session["CustPassword"].ToString(); blcus.action = "LoginCust"; DataTable dtCustomer = dlcus.checkDuplicateemail(blcus); Session["Paid"] = Convert.ToDouble(txtPaidAmt.Text.Trim() == "" ? "0" : txtPaidAmt.Text.Trim()); if (dtCustomer.Rows.Count > 0) { Random rnd = new Random(); string BookingPayId = rnd.Next(10000, 20000).ToString() + DateTime.Now.ToString("MMddhhmmssfff"); Session["BookingPayId"] = BookingPayId; string Email = Session["CustomerMailId"].ToString(); string PhoneNumber = hdnfPhoneNumber.Value.Trim().ToString(); string FirstName = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()); string LastName = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()); string PaidAmt = hftxtpaidamt.Value.Trim().ToString(); string PaymentId = BookingPayId.ToString(); string BillingAddress = lblBillingAddress.Text.Trim().ToString(); Session["Address"] = BillingAddress; Session["InvName"] = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Title"].ToString()) + " " + LastName; Session["SubInvName"] = LastName + ", " + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Title"].ToString()) + " " + FirstName; Response.Redirect("~/Cruise/booking/sendtoairpay.aspx?BookingPayId=" + PaymentId + "&EmailId=" + Email.ToString() + "&PhoneNumber=" + PhoneNumber.ToString() + "&FirstName=" + FirstName.ToString() + "&LastName=" + LastName.ToString() + "&PaidAmt=" + PaidAmt.ToString() + "&BillingAddress=" + BillingAddress.ToString()); //http://localhost:1897/ResortManager/Cruise/booking/SummerisedDetails.aspx?BookedId=0&PackName=Ganges+Exclusive&NoOfNights=5&CheckinDate=5%2f1%2f2016 //ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('not registered!!!')", true); } } } else { if (Convert.ToDecimal(txtPaidAmt.Text) <= Convert.ToDecimal(hdnfCreditLimit.Value)) { string BookingPayId = lbPaymentMethod.Text.Trim().Substring(0, 2) + DateTime.Now.ToString("MMddhhmmssfff"); Session["BookingPayId"] = BookingPayId; Session.Add("BookingRef", txtBookRef.Text.Trim().ToString()); Session["Paid"] = Convert.ToDouble(hftxtpaidamt.Value.Trim() == "" ? "0" : hftxtpaidamt.Value.Trim().ToString()); Session["InvName"] = Session["UserName"].ToString(); Session["Address"] = null; Response.Redirect("PaymentGatewayResponse.aspx"); } else { lblPaymentErr.Text = "Payment Amount Exceeding Credit Limit"; } } } catch { } }
protected void Page_Load(object sender, EventArgs e) { try { //txtChkin.Attributes.Add("onchange", "return fillEndDate('" + txtChkin.ClientID + "','" + txtChkOut.ClientID + "');"); if (!IsPostBack) { if (Session["UserCode"] != null) { LinkButton1.Visible = true; } else { LinkButton1.Visible = false; } if (SessionServices.RetrieveSession <DataTable>("Bookingdt") == null) { Session["AcId"] = Request.QueryString["AccomId"]; Session["Agid"] = Request.QueryString["AId"]; Session["Hpax"] = Request.QueryString["pax"]; Session["AccomTypeId"] = Request.QueryString["AccomTypeId"]; Session["HCheckin"] = Request.QueryString["Checkin"]; Session["HCheckout"] = Request.QueryString["Checkout"]; Session["HNoofrooms"] = Request.QueryString["Noofrooms"]; } Int32.TryParse(Session["AcId"].ToString(), out iAccomId); Int32.TryParse(Session["Agid"].ToString(), out iagentid); Int32.TryParse(Session["Hpax"].ToString(), out Totpax); Int32.TryParse(Session["AccomTypeId"].ToString(), out iaccomtypeid); DateTime.TryParse(Session["HCheckin"].ToString(), out chkin); DateTime.TryParse(Session["HCheckout"].ToString().ToString(), out chkout); Int32.TryParse(Session["HNoofrooms"].ToString().ToString(), out noofrooms); DataTable bookingDt = SessionServices.RetrieveSession <DataTable>("Bookingdt"); if (bookingDt != null) { ViewState["VsRoomDetails"] = bookingDt; gdvSelectedRooms.DataSource = bookingDt; gdvSelectedRooms.DataBind(); CalculateRoomRates(); } if (gdvSelectedRooms.Rows.Count > 0) { DivRmRate.Style.Remove("display"); } else { DivRmRate.Style.Add("display", "None"); } this.bindRoomRates(iAccomId, Totpax, iagentid, chkin, chkout, noofrooms, 6); this.bindServiceRates(iAccomId); this.bindMealPlans(iAccomId, iagentid, Totpax); adddatestoddl(Convert.ToDateTime(Session["HCheckin"].ToString().ToString()), Convert.ToDateTime(Session["HCheckout"].ToString().ToString())); // DivRmRate.Style.Add("display", "None"); } } catch { } }
private void LoadBookedRoomDetails() { try { dtGetBookedRooms = SessionServices.RetrieveSession <DataTable>("BookedRooms"); DataTable dtgroupedData = new DataTable(); dtgroupedData.Columns.Add("categoryName"); dtgroupedData.Columns.Add("Pax"); dtgroupedData.Columns.Add("Price"); dtgroupedData.Columns.Add("Currency"); DataTable dtUniqueCategories = dtGetBookedRooms.DefaultView.ToTable(true, "categoryName"); #region Adding distict Room categories foreach (DataRow dr1 in dtUniqueCategories.Rows) { string categoryName = dr1["categoryName"].ToString(); DataRow dr2 = dtgroupedData.NewRow(); dr2["categoryName"] = categoryName; dtgroupedData.Rows.Add(dr2); } #endregion #region calculating values decimal TotalPaybleAmt = 0; double gettax1 = 0; foreach (DataRow dr1 in dtgroupedData.Rows) { string category = dr1["categoryName"].ToString(); DataView dv; dv = new DataView(dtGetBookedRooms, "categoryName='" + category + "'", "categoryName", DataViewRowState.CurrentRows); DataTable dtFiltered = dv.ToTable(); int packs = 0; decimal price = 0; decimal discountamount = 0; foreach (DataRow dr3 in dtFiltered.Rows) { packs = packs + Convert.ToInt32(dr3["Pax"].ToString()); price = price + Convert.ToDecimal(dr3["Totalprice"].ToString().Replace(",", "")); } dr1["Pax"] = packs.ToString(); dr1["Price"] = price.ToString(); dr1["Currency"] = dv.ToTable().Rows[0]["Currency"].ToString(); double discount = 0; if (Session["getdiscountvalue"] != null) { try { discount = Convert.ToDouble(Session["getdiscountvalue"].ToString()); } catch { } } lblDiscountper.Text = Session["getdiscountvalue"].ToString() + "%"; TotalPaybleAmt = TotalPaybleAmt + Convert.ToDecimal(price); try { gettax1 = Convert.ToDouble(Session["gettax"].ToString().Split('R')[1]); } catch { gettax1 = Convert.ToDouble(Session["gettax"].ToString()); } } double total = 0; double gettax = 0; double getalltotal = 0; double totyadiscount = 0; double grosstotal = 0; double taxableamt = 0; for (int i = 0; i < dtGetBookedRooms.Rows.Count; i++) { taxableamt = taxableamt + Convert.ToDouble(dtGetBookedRooms.Rows[i]["taxablepamt"].ToString()); gettax = gettax + (Convert.ToDouble(dtGetBookedRooms.Rows[i]["Tax1"].ToString())); total = Convert.ToDouble(total) + (Convert.ToDouble(dtGetBookedRooms.Rows[i]["pricewithouttax"].ToString().Replace(",", "")) * Convert.ToDouble(dtGetBookedRooms.Rows[i]["Pax"].ToString())); getalltotal = Convert.ToDouble(getalltotal) + (Convert.ToDouble(dtGetBookedRooms.Rows[i]["CRPrice"].ToString().Split('R')[1].ToString().Replace(",", ""))); totyadiscount = Convert.ToDouble(totyadiscount) + (Convert.ToDouble(dtGetBookedRooms.Rows[i]["Discountprice"].ToString().Replace(",", ""))); grosstotal = Convert.ToDouble(grosstotal) + (Convert.ToDouble(dtGetBookedRooms.Rows[i]["Totalprice"].ToString().Replace(",", ""))); } Session["getcruisetax"] = "INR" + ((Convert.ToDouble(dtGetBookedRooms.Rows[0]["pricewithouttax"].ToString()) * gettax1) / 100).ToString("##,0"); lblTax.Text = "INR " + Convert.ToDouble(gettax.ToString()).ToString("##,0"); Session["getcruiseinvoice"] = "INR " + Math.Round(gettax).ToString(); lbltaxin.Text = "INR " + taxableamt.ToString("##,0"); if (lblDiscountper.Text != "0%") { lblDiscount.Text = dtGetBookedRooms.Rows[0]["Currency"].ToString() + " " + totyadiscount.ToString("##,0"); } else { getdiscount.Visible = false; } lblalltotal.Text = dtGetBookedRooms.Rows[0]["Currency"].ToString() + " " + getalltotal.ToString("##,0"); lbltotAmt.Text = dtGetBookedRooms.Rows[0]["Currency"].ToString() + " " + total.ToString("##,0"); lblGross.Text = dtGetBookedRooms.Rows[0]["Currency"].ToString() + " " + Convert.ToDouble(grosstotal.ToString()).ToString("##,0"); lblCurrency.Text = dtGetBookedRooms.Rows[0]["Currency"].ToString() + " "; if (Session["advanceamount"].ToString() == "") { txtPaidAmt.Text = Convert.ToDouble(Math.Round(((100 * TotalPaybleAmt) / 100)).ToString("#.##")).ToString("##,0"); lbl25.Text = ""; lblBalancedate.Text = "N/A"; trbalancedate.Visible = false; } else { txtPaidAmt.Text = Convert.ToDouble(Math.Round(((25 * TotalPaybleAmt) / 100)).ToString("#.##")).ToString("##,0"); if (Session["Getcheckindate"] != null) { lblBalancedate.Text = "(75% of total) to be paid prior to " + Convert.ToDateTime(Session["Getcheckindate"].ToString()).AddDays(-90).ToString("dddd, MMMM d, yyyy"); } lbl25.Text = "(25% of Total)"; Session["get25"] = 1; Session["getPaid"] = txtPaidAmt.Text; } lblBalanceAmt.Text = dtGetBookedRooms.Rows[0]["Currency"].ToString() + " " + Convert.ToDouble(Math.Round((TotalPaybleAmt - Convert.ToDecimal(txtPaidAmt.Text))).ToString()).ToString("##,0"); if (lblBalanceAmt.Text == "INR 0") { trbalanceamount.Visible = false; } Session["getbalanceSummerlizede"] = Math.Round((TotalPaybleAmt - Convert.ToDecimal(txtPaidAmt.Text))).ToString(); dtGetBookedRooms = dtgroupedData; #endregion } catch (Exception ex) { } }
protected void btnSmbt_Click(object sender, EventArgs e) { if (Session["UserCode"] != null) { // pnlLogin.Visible = true; try { customerLogin.Visible = false; if (Session["AgentMailId"] != null && Session["Password"] != null) { blagentpayment._Action = "MailValidate"; blagentpayment._EmailId = Session["AgentMailId"].ToString(); blagentpayment._Password = Session["Password"].ToString(); DataTable dtAgent = dlagentpayment.BindControls(blagentpayment); if (dtAgent.Rows.Count > 0) { lblAgentName.Text = Session["UserName"].ToString(); lblBillingAddress.Text = dtAgent.Rows[0]["BillingAddress"].ToString(); lbPaymentMethod.Text = dtAgent.Rows[0]["PaymentMethod"].ToString(); hdnfPhoneNumber.Value = dtAgent.Rows[0]["Phone"].ToString(); hdnfCreditLimit.Value = dtAgent.Rows[0]["CreditLimit"].ToString(); bool oncredit = Convert.ToBoolean(dtAgent.Rows[0]["ChkCredit"].ToString()); pnlFullDetails.Visible = true; pnlBookButton.Visible = true; if (oncredit) { panelwithoutCreditAgent.Visible = false; btnPayProceed.Text = "Book"; } else { panelwithoutCreditAgent.Visible = true; btnPayProceed.Text = "Proceed For Payment"; } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('Agent Payment Details Not found')", true); } } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "Showstatus", "javascript:alert('It seems you are not logged in')", true); } } catch (Exception sqe) { } } else if (Session["CustomerCode"] != null) { try { blcus.Email = Session["CustomerMailId"].ToString();; blcus.Password = Session["CustPassword"].ToString(); blcus.action = "LoginCust"; DataTable dtCustomer = dlcus.checkDuplicateemail(blcus); if (dtCustomer != null) { Session["CustMailId"] = Session["CustomerMailId"].ToString(); ViewState["Pass"] = txtCustPass.Text.Trim(); lblBillingAddress.Text = dlcus.GetBillingAddress(dtCustomer.Rows[0]); lblAgentName.Text = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()) + " " + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()); lbPaymentMethod.Text = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["PaymentMethod"].ToString()); hdnfPhoneNumber.Value = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["Telephone"].ToString()); Session["CustId"] = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["CustId"].ToString()); DataTable dtrpax = SessionServices.RetrieveSession <DataTable>("Bookingdt"); string BookRef = DataSecurityManager.Decrypt(dtCustomer.Rows[0]["FirstName"].ToString()) + DataSecurityManager.Decrypt(dtCustomer.Rows[0]["LastName"].ToString()) + "X" + Convert.ToDouble(dtrpax.Compute("SUM(Pax)", string.Empty)).ToString() + "-" + "Self"; ViewState["BookRef"] = BookRef; lbPaymentMethod.Text = "N/A"; pnlFullDetails.Visible = true; panelwithoutCreditAgent.Visible = true; pnlBookButton.Visible = true; customerLogin.Visible = false; } Bookingdt = SessionServices.RetrieveSession <DataTable>("Bookingdt"); // preparetables(Bookingdt); } catch { } } else { pnlLogin.Visible = false; customerLogin.Visible = true; } //Bookingdt = Session["Bookingdt"] as DataTable; //preparetables(Bookingdt); }