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