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 { } }