public DataSet GetBookingsCruiseFH(cdtGetBookingsInput getBookingsInput) { try { if (bookingHandler == null) { bookingHandler = new BookingHandler(); } return(bookingHandler.GetBookingsCruiseFH(getBookingsInput)); } catch (Exception exp) { throw exp; } }
public List <ViewBookingDTO> GetBookingsFH(cdtGetBookingsInput getBookingsInput) { try { if (bookingHandler == null) { bookingHandler = new BookingHandler(); } return(bookingHandler.GetBookingsFH(getBookingsInput)); } catch (Exception exp) { throw exp; } }
private void RefreshGrid() { ds1 = new DataSet(); ENums.BookingStatusTypes bookingStatusType = ENums.BookingStatusTypes.NONE; ENums.BookingStatusTypes newBookingStatusType = ENums.BookingStatusTypes.NONE; BookingServices oBookingManager = new BookingServices(); List <ViewBookingDTO> oBookingData = null; DateTime checkInDate, checkOutDate; DateTime.TryParse(txtStartDate.Text, out checkInDate); DateTime.TryParse(txtEndDate.Text, out checkOutDate); bookingStatusType = GetBookingStatusType(ddlBookingStatusTypes.SelectedItem.Text); int AccomTypeId = 0; Int32.TryParse(ddlAccomType.SelectedValue.ToString(), out AccomTypeId); if (AccomTypeId <= 0) { AccomTypeId = 0; //To handle the -1 value of Choose option. } if (SessionServices.ViewBooking_BookingData == null) { newBookingStatusType = bookingStatusType; if (bookingStatusType == ENums.BookingStatusTypes.PROPOSED) { newBookingStatusType = ENums.BookingStatusTypes.BOOKED; } cdtGetBookingsInput getBookingsInput = new cdtGetBookingsInput(); getBookingsInput.AccomTypeId = AccomTypeId; getBookingsInput.FromDate = checkInDate; getBookingsInput.ToDate = checkOutDate; getBookingsInput.BookingStatusType = newBookingStatusType; getBookingsInput.BookingCode = txtBookingCode.Text.Trim(); getBookingsInput.AgentId = Convert.ToInt32(ddlAgent.SelectedValue.ToString()); ds1 = oBookingManager.GetBookingsCruiseFH(getBookingsInput); if (ds1 != null && ds1.Tables[0].Rows.Count > 0) { headings1.Style.Remove("display"); headings.Style.Remove("display"); } else { headings1.Style.Add("display", "none"); headings.Style.Add("display", "none"); } if (bookingStatusType == ENums.BookingStatusTypes.PROPOSED) { oBookingData = oBookingData.FindAll(delegate(ViewBookingDTO booking) { return(booking.ProposedBooking == true); }); } SessionServices.ViewBooking_BookingData = oBookingData; } else { oBookingData = SessionServices.ViewBooking_BookingData; } //dgBookings.DataSource = null; //dgBookings.DataBind(); //if (ds1 != null && ds1.Tables[0].Rows.Count > 0) //{ // dgBookings.DataSource = ds1; // if (dgBookings.PageCount > 0) // { // dgBookings.CurrentPageIndex = dgBookings.CurrentPageIndex > dgBookings.PageCount ? dgBookings.PageCount : dgBookings.CurrentPageIndex; // } // dgBookings.DataBind(); //} //else //{ // if (IsPostBack) // { // base.DisplayAlert("Bookings are not found for the mentioned criteria."); // } //} oBookingManager = null; oBookingData = null; }
private void RefreshGrid() { ENums.BookingStatusTypes bookingStatusType = ENums.BookingStatusTypes.NONE; ENums.BookingStatusTypes newBookingStatusType = ENums.BookingStatusTypes.NONE; BookingServices oBookingManager = new BookingServices(); List <ViewBookingDTO> oBookingData = null; DateTime checkInDate, checkOutDate; DateTime.TryParse(txtStartDate.Text, out checkInDate); DateTime.TryParse(txtEndDate.Text, out checkOutDate); bookingStatusType = GetBookingStatusType(ddlBookingStatusTypes.SelectedItem.Text); int AccomTypeId = 0; Int32.TryParse(ddlAccomType.SelectedValue.ToString(), out AccomTypeId); if (AccomTypeId <= 0) { AccomTypeId = 0; //To handle the -1 value of Choose option. } if (SessionServices.ViewBooking_BookingData == null) { if (!String.IsNullOrEmpty(txtBookingCode.Text.Trim()) || (checkInDate != DateTime.MinValue && checkOutDate != DateTime.MinValue)) { newBookingStatusType = bookingStatusType; if (bookingStatusType == ENums.BookingStatusTypes.PROPOSED) { newBookingStatusType = ENums.BookingStatusTypes.BOOKED; } cdtGetBookingsInput getBookingsInput = new cdtGetBookingsInput(); getBookingsInput.AccomTypeId = AccomTypeId; getBookingsInput.FromDate = checkInDate; getBookingsInput.ToDate = checkOutDate; getBookingsInput.BookingStatusType = newBookingStatusType; getBookingsInput.BookingCode = txtBookingCode.Text.Trim(); getBookingsInput.AgentId = Convert.ToInt32(ddlAgent.SelectedValue.ToString()); getBookingsInput.RefAgentId = Convert.ToInt32(ddlRefAgent.SelectedValue.ToString()); oBookingData = oBookingManager.GetBookings(getBookingsInput); if (bookingStatusType == ENums.BookingStatusTypes.PROPOSED) { oBookingData = oBookingData.FindAll(delegate(ViewBookingDTO booking) { return(booking.ProposedBooking == true); }); } SessionServices.ViewBooking_BookingData = oBookingData; } } else { oBookingData = SessionServices.ViewBooking_BookingData; } dgBookings.DataSource = null; dgBookings.DataBind(); if (oBookingData != null && oBookingData.Count > 0) { dgBookings.DataSource = oBookingData; if (dgBookings.PageCount > 0) { dgBookings.CurrentPageIndex = dgBookings.CurrentPageIndex > dgBookings.PageCount ? dgBookings.PageCount : dgBookings.CurrentPageIndex; } dgBookings.DataBind(); } else { if (IsPostBack) { base.DisplayAlert("Bookings are not found for the mentioned criteria."); } } oBookingManager = null; oBookingData = null; }
public List <ViewBookingDTO> GetBookings(cdtGetBookingsInput getBookingsInput) { List <ViewBookingDTO> bookingList; ViewBookingDTO booking; DataRow dr; DataSet dsBookingData; string sProcName; dsBookingData = null; bookingList = null; if (getBookingsInput.FromDate == DateTime.MinValue || getBookingsInput.FromDate == DateTime.MaxValue) { getBookingsInput.FromDate = GF.GetDate().AddYears(-10); } if (getBookingsInput.ToDate == DateTime.MinValue || getBookingsInput.ToDate == DateTime.MaxValue) { getBookingsInput.ToDate = GF.GetDate().AddYears(20); } try { oDB = new DatabaseManager(); sProcName = "up_Get_Bookings"; oDB.DbCmd = oDB.GetStoredProcCommand(sProcName); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@FromDate", DbType.Date, getBookingsInput.FromDate); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ToDate", DbType.Date, getBookingsInput.ToDate); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingStatusTypeId", DbType.Int32, getBookingsInput.BookingStatusType); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomTypeId", DbType.Int32, getBookingsInput.AccomTypeId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomId", DbType.Int32, getBookingsInput.AccomodationId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AgentId", DbType.Int32, getBookingsInput.AgentId); oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@BookingCode", DbType.String, getBookingsInput.BookingCode); dsBookingData = oDB.ExecuteDataSet(oDB.DbCmd); } catch (Exception exp) { oDB = null; dsBookingData = null; GF.LogError("clsBookingHandler.GetBookings", exp.Message); } if (dsBookingData != null) { //oBookingData[dsBookingData.Tables[0].Rows.Count] = new clsBookingData(); bookingList = new List <ViewBookingDTO>(); for (int i = 0; i < dsBookingData.Tables[0].Rows.Count; i++) { booking = new ViewBookingDTO(); dr = dsBookingData.Tables[0].Rows[i]; booking.BookingId = Convert.ToInt32(dr.ItemArray.GetValue(0)); booking.BookingCode = Convert.ToString(dr.ItemArray.GetValue(1)); booking.BookingReference = Convert.ToString(dr.ItemArray.GetValue(2)); booking.SDate = Convert.ToString(dr.ItemArray.GetValue(3)); booking.EDate = Convert.ToString(dr.ItemArray.GetValue(4)); booking.StartDate = Convert.ToDateTime(dr.ItemArray.GetValue(3).ToString()); booking.EndDate = Convert.ToDateTime(dr.ItemArray.GetValue(4).ToString()); booking.BookingStatus = Convert.ToString(dr.ItemArray.GetValue(5)); booking.AccomodationType = Convert.ToString(dr.ItemArray.GetValue(6)); if (dr.ItemArray.GetValue(7) != DBNull.Value) { booking.ProposedBooking = Convert.ToBoolean(dr.ItemArray.GetValue(7)); } if (dr.ItemArray.GetValue(8) != DBNull.Value) { if (Convert.ToInt32(dr.ItemArray.GetValue(8)) > 0) { booking.HasForeignTourists = true; } } if (dr.ItemArray.GetValue(9) != DBNull.Value) { if (Convert.ToInt32(dr.ItemArray.GetValue(9)) > 0) { booking.HasIndianTourists = true; } } if (dr.ItemArray.GetValue(10) != DBNull.Value) { booking.CharteredBooking = Convert.ToBoolean(dr.ItemArray.GetValue(10)); } if (dr.ItemArray.GetValue(11) != DBNull.Value) { booking.PaymentStatus = Convert.ToBoolean(dr.ItemArray.GetValue(11)); } if (dr.ItemArray.GetValue(12) != DBNull.Value) { booking.PaidAmt = Convert.ToDouble(dr.ItemArray.GetValue(12)); } if (dr.ItemArray.GetValue(14) != DBNull.Value) { booking.InvoiceAmount = Convert.ToDouble(dr.ItemArray.GetValue(14)); } bookingList.Add(booking); } } return(bookingList); }