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);
}
