public List <clsTouristCountDTO> GetTouristCount(DateTime FromDate, DateTime ToDate, int AccomTypeId, int AccomId)
{
List <clsTouristCountDTO> touristCountList;
clsTouristCountDTO touristCountDto;
DataRow dr;
DataSet dsTouristCount;
string sProcName;
dsTouristCount = null;
touristCountDto = null;
if (FromDate == DateTime.MinValue || FromDate == DateTime.MaxValue)
{
FromDate = GF.GetDate();
}
if (ToDate == DateTime.MinValue || ToDate == DateTime.MaxValue)
{
ToDate = FromDate.AddMonths(1);
}
try
{
oDB = new DatabaseManager();
sProcName = "up_Get_TouristCount";
oDB.DbCmd = oDB.GetStoredProcCommand(sProcName);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@FromDate", DbType.Date, FromDate);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@ToDate", DbType.Date, ToDate);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomTypeId", DbType.Int32, AccomTypeId);
oDB.DbDatabase.AddInParameter(oDB.DbCmd, "@AccomId", DbType.Int32, AccomId);
dsTouristCount = oDB.ExecuteDataSet(oDB.DbCmd);
}
catch (Exception exp)
{
oDB = null;
dsTouristCount = null;
GF.LogError("clsBookingHandler.GetTouristCount", exp.Message);
}
touristCountList = new List <clsTouristCountDTO>();
if (dsTouristCount != null)
{
for (int i = 0; i < dsTouristCount.Tables[0].Rows.Count; i++)
{
touristCountDto = new clsTouristCountDTO();
dr = dsTouristCount.Tables[0].Rows[i];
touristCountDto.AccomodationTypeId = Convert.ToInt32(dr.ItemArray.GetValue(0));
touristCountDto.AccomodationType = Convert.ToString(dr.ItemArray.GetValue(1));
touristCountDto.AccomodationId = Convert.ToInt32(dr.ItemArray.GetValue(2));
touristCountDto.AccomodationName = Convert.ToString(dr.ItemArray.GetValue(3));
touristCountDto.BookingId = Convert.ToInt32(dr.ItemArray.GetValue(4));
touristCountDto.BookingReference = Convert.ToString(dr.ItemArray.GetValue(5).ToString());
touristCountDto.BookingStartDate = Convert.ToDateTime(dr.ItemArray.GetValue(6).ToString());
touristCountDto.BookingEndDate = Convert.ToDateTime(dr.ItemArray.GetValue(7).ToString());
touristCountDto.TotalTourist = Convert.ToInt32(dr.ItemArray.GetValue(8));
touristCountList.Add(touristCountDto);
}
}
return(touristCountList);
}
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);
}
