public void InsertChildTableData(int bookingId, int pax, string roomno, string paymentmethod, DateTime chekindate, string packageid, int totpax, int roomcatid)
{
BALBooking blsr = new BALBooking();
DALBooking dlsr = new DALBooking();
BALBooking booking = dlsr.GetBookingDetails(bookingId);
DataTable dt = bindRoomRates(chekindate, packageid, totpax);
DataView dv = new DataView(dt);
dv = new DataView(dt, "roomcategoryid='" + roomcatid + "'", "roomcategoryid", DataViewRowState.CurrentRows);
DataTable dt1 = dv.ToTable();
if (booking != null)
{
//DataTable GridRoomPaxDetail = SessionServices.RetrieveSession<DataTable>("BookedRooms");
int LoopInsertStatus = 0;
try
{
blsr._iBookingId = bookingId;
blsr._iAccomId = booking._iAccomId;
blsr._dtStartDate = booking._dtStartDate;
blsr._dtEndDate = booking._dtEndDate;
blsr._iPaxStaying = pax;
if (dt1.Rows[0]["RmType"].ToString() == "Twin")
{
blsr._bConvertTo_Double_Twin = dt1.Rows[0]["RmType"].ToString() == "Twin" ? true : false;
//string strContent = dt1.Rows[0]["Price Per Person on Twin Sharing inclusive of taxes"].ToString().Replace("INR", string.Empty);
blsr._Amt = Convert.ToDecimal(dt1.Rows[0]["Price Per Person on Twin Sharing inclusive of taxes"].ToString().Replace("INR", string.Empty)) * Convert.ToDecimal(totpax);
}
else if (dt1.Rows[0]["RmType"].ToString() == "Double")
{
blsr._bConvertTo_Double_Twin = dt1.Rows[0]["RmType"].ToString() == "Double" ? true : false;
}
blsr._cRoomStatus = "B";
blsr._sRoomNo = roomno;
blsr.action = "AddPriceDetailsToo";
string BookingPayId = paymentmethod.Trim().Substring(0, 2) + DateTime.Now.ToString("MMddhhmmssfff");
blsr.PaymentId = BookingPayId;
//blsr._Amt = Convert.ToDecimal(GridRoomPaxDetail.Rows[LoopCounter]["Price"].ToString());
int GetQueryResponse = dlsr.AddRoomBookingDetails(blsr);
if (GetQueryResponse > 0)
{
LoopInsertStatus++;
}
}
catch (Exception e)
{
throw;
}
}
}
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 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
{
}
}
