///api/Values/5 nights 6 days MV Mahabaahu Upstream Cruise/2018-10-16/2018-10-21/4/rabiul/102,208/7/2/online/248 public string Get1(string pakackagename, DateTime chekindate, DateTime checkoutdate, int total, string refrence, string roomno, int accomid, int roomcatid, string paymentmethod, int agentid) { string value = ""; DataSet ds = new DataSet(); HttpContext httpContext = HttpContext.Current; string authHeader = httpContext.Request.Headers["Authorization"]; if (authHeader != null && authHeader.StartsWith("Basic")) { string encodedUsernamePassword = authHeader.Substring("Basic ".Length).Trim(); AgentMaster oAgentMaster = new AgentMaster(); AgentDTO[] oAgentData = oAgentMaster.GetApiAuth(agentid); string TokenNo = oAgentData[0].TokenNo.ToString(); if (TokenNo != "" && TokenNo == encodedUsernamePassword) { DataTable dt1 = dlsr.getpackaageid(pakackagename, chekindate); if (dt1 != null && dt1.Rows.Count > 0) { pakackageid = dt1.Rows[0]["PackageId"].ToString(); departureId = Convert.ToInt32(dt1.Rows[0]["Id"].ToString()); } DataTable dt = cab.bindroomddl(pakackageid, departureId); dv = new DataView(); string[] strArray = roomno.Split(','); //foreach (object obj in strArray) //{ // roomno = obj.ToString(); //} //var values = Request.GetQueryNameValuePairs() // .Where(kvp => kvp.Key == "roomno") // .Select(kvp => int.Parse(kvp.Value)) // .ToArray(); int n = cab.InsertParentTableData(pakackageid, chekindate, checkoutdate, total, refrence, agentid); foreach (var lockRoom in strArray) { roomno = lockRoom.ToString(); dv = new DataView(dt, "RoomNo='" + roomno + "'", "RoomNo", DataViewRowState.CurrentRows); DataTable dtcheck = dv.ToTable(); dv = new DataView(dtcheck, "BookedStatus='" + "Available" + "'", "BookedStatus", DataViewRowState.CurrentRows); if (dv.Count > 0) { //var values = Request.GetQueryNameValuePairs() // .Where(kvp => kvp.Key == "roomno") // .Select(kvp => int.Parse(kvp.Value)) // .ToArray(); //foreach (var lockRoom in strArray) //{ //roomno = lockRoom.ToString(); cab.InsertChildTableData(n, total, roomno, paymentmethod, chekindate, pakackageid, total, roomcatid); cab.LockTheBooking(roomno, accomid, roomcatid); blsr.action = "fetchbybookingId"; blsr._iBookingId = n; DataTable dtfetch = dlsr.fetchbybookingid(blsr); DataTable dtvalue = cab.loadbookingDetails(pakackagename, n, total, roomno, paymentmethod, chekindate, checkoutdate, pakackageid, total, roomcatid, Convert.ToInt32(dtfetch.Rows[0]["NoOFNights"].ToString())); //DataSet ds = new DataSet(); ds.Tables.Add(dtvalue); //value = ds.GetXml(); //// } //return value; } //else //{ // return "Room is already booked"; //} } } value = ds.GetXml(); // } if (value != "<NewDataSet />") { return(value); } else { return("Room is already booked"); } } else { return(value); } }
protected void Page_Load(object sender, EventArgs e) { // txtPassportNo.Text = "VDIzaDQ1aXMxMjRJNTRz"; //string PassportNo = DataSecurityManager.Decrypt(txtPassportNo.Text.ToString()); //string t = "VDIzaDQ1aXMxMjRJNTRz"; //string PassportNo = DataSecurityManager.Decrypt(t.ToString()); if (Session["CustName"] != null) { navlogin.Visible = false; lblUsername.Text = Session["CustName"].ToString(); } else { // Response.Redirect("http://test1.adventureresortscruises.in/Cruise/Booking/searchproperty1.aspx"); } TouristServices touristServices = null; //AddAttributes(); SessionServices.TouristDetails_BookingNo = BookingId; if (!IsPostBack) { if (Request.QueryString["bid"] != null) { BookingId = Convert.ToInt32(Request.QueryString["bid"]); } if (Request.QueryString["tno"] != null) { TouristNo = Convert.ToInt32(Request.QueryString["tno"]); } RefreshGrid(BookingId); if (Request.QueryString["bid"] != null) { BookingId = Convert.ToInt32(Request.QueryString["bid"]); } blsr._iBookingId = BookingId; blsr.action = "fetchbybookingId"; DataTable dt = dlsr.fetchbybookingid(blsr); if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { paxcount = paxcount + Convert.ToInt32(dt.Rows[i]["NoOfPersons"].ToString()); } Session["getpaxcount"] = paxcount; } FillNationality(); radEmpNo.Checked = true; if (Request.QueryString["op"] == "edit") { btnSubmit.Text = "Update"; if (touristServices == null) { touristServices = new TouristServices(); } BookingTouristDTO oBTData = touristServices.GetBookingTouristDetails(BookingId, TouristNo); if (oBTData != null) { FillTouristDetails(oBTData); } touristServices = null; oBTData = null; } else { //btnDelete.Visible = false; } //System.Web.UI.ScriptManager.GetCurrent(this).SetFocus(this.ddlSuffix); //Response.Redirect("http://test.adventureresortscruises.in/Cruise/Booking/NewRegister.aspx?bid=" + BookingId); } }