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