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