public List<HotelRateAndAvailabilityExt> GetHotelAvailability()
{
//SQLCon.Open();
//SqlCommand cmd = new SqlCommand("TB_SP_GetHotelAvailability", SQLCon);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@StartDate", startDate);
//cmd.Parameters.AddWithValue("@EndDate", endDate);
//cmd.Parameters.AddWithValue("@HotelID", HotelID);
//DataTable dt = new DataTable();
//SqlDataAdapter sda = new SqlDataAdapter(cmd);
//sda.Fill(dt);
//SQLCon.Close();
List<HotelRateAndAvailabilityExt> HotelAvailabilityList = new List<HotelRateAndAvailabilityExt>();
if (HotelAvailabilityTable.Rows.Count > 0)
{
foreach (DataRow dr in HotelAvailabilityTable.Rows)
{
HotelRateAndAvailabilityExt HotelAvailabilityObj = new HotelRateAndAvailabilityExt();
HotelAvailabilityObj.ID = Convert.ToInt32(dr["ID"]);
HotelAvailabilityObj.DateID = Convert.ToInt64(dr["DateID"]);
HotelAvailabilityObj.WeekDay = Convert.ToInt32(dr["WeekDay"]);
HotelAvailabilityObj.HotelRoomID = Convert.ToInt32(dr["HotelRoomID"]);
HotelAvailabilityObj.AvailableRoomCount = Convert.ToInt32(dr["AvailableRoomCount"]);
HotelAvailabilityObj.RoomCount = Convert.ToInt32(dr["RoomCount"]);
HotelAvailabilityObj.CloseToArrival = Convert.ToInt32(dr["CloseToArrival"]);
HotelAvailabilityObj.CloseToDeparture = Convert.ToInt32(dr["CloseToDeparture"]);
HotelAvailabilityObj.MinimumStay = Convert.ToInt32(dr["MinimumStay"]);
HotelAvailabilityObj.Closed = Convert.ToInt32(dr["Closed"]);
HotelAvailabilityObj.RoomRateMissing = Convert.ToInt32(dr["RoomRateMissing"]);
HotelAvailabilityList.Add(HotelAvailabilityObj);
}
}
return HotelAvailabilityList;
}
public List<HotelRateAndAvailabilityExt> GetHotelRoomsList()
{
List<HotelRateAndAvailabilityExt> HotelRoomsList = new List<HotelRateAndAvailabilityExt>();
if (HotelRooms.Rows.Count > 0)
{
foreach (DataRow dr in HotelRooms.Rows)
{
HotelRateAndAvailabilityExt HotelRoomsObj = new HotelRateAndAvailabilityExt();
HotelRoomsObj.ID = Convert.ToInt32(dr["ID"]);
HotelRoomsObj.HotelID = Convert.ToInt32(dr["HotelID"]);
HotelRoomsObj.RoomTypeID = Convert.ToInt32(dr["RoomTypeID"]);
HotelRoomsObj.RoomTypeName = Convert.ToString(dr["RoomTypeName"]);
HotelRoomsObj.RoomSize = Convert.ToInt32(dr["RoomSize"]);
HotelRoomsObj.MaxPeopleCount = Convert.ToInt32(dr["MaxPeopleCount"]);
HotelRoomsObj.IDWithMaxPeopleCount = Convert.ToString(dr["IDWithMaxPeopleCount"]);
HotelRoomsObj.MaxChildrenCount = Convert.ToInt32(dr["MaxChildrenCount"]);
HotelRoomsObj.BabyCotCount = Convert.ToInt32(dr["BabyCotCount"]);
HotelRoomsObj.ExtraBedCount = Convert.ToInt32(dr["ExtraBedCount"]);
HotelRoomsObj.SmokingTypeID = Convert.ToString(dr["SmokingTypeID"]);
HotelRoomsObj.SmokingTypeName = Convert.ToString(dr["SmokingTypeName"]);
HotelRoomsObj.ViewTypeID = Convert.ToString(dr["ViewTypeID"]);
HotelRoomsObj.ViewTypeName = Convert.ToString(dr["ViewTypeName"]);
HotelRoomsObj.IncludedInRoomTypeCaption = Convert.ToString(dr["IncludedInRoomTypeCaption"]);
Encryption64 objEncryptHotelRoomID = new Encryption64();
string EncryptHotelRoomID = Convert.ToString(dr["ID"]);
EncryptHotelRoomID = System.Web.HttpContext.Current.Server.UrlEncode(ConvertStringToHex(objEncryptHotelRoomID.Encrypt(EncryptHotelRoomID, "58421043")));
HotelRoomsObj.EncryptHotelRoomID = EncryptHotelRoomID;
HotelRoomsList.Add(HotelRoomsObj);
}
}
return HotelRoomsList;
}
public List<HotelRateAndAvailabilityExt> GetDatesList()
{
//SQLCon.Open();
//SqlCommand cmd = new SqlCommand("TB_SP_GetDates", SQLCon);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@Culture", CultureValue);
//cmd.Parameters.AddWithValue("@OrderBy", OrderBy);
//cmd.Parameters.AddWithValue("@StartDate", startDate);
//cmd.Parameters.AddWithValue("@EndDate", endDate);
//SqlDataAdapter sda = new SqlDataAdapter(cmd);
//sda.Fill(dt);
//SQLCon.Close();
List<HotelRateAndAvailabilityExt> DateList = new List<HotelRateAndAvailabilityExt>();
if (Dates.Rows.Count > 0)
{
foreach (DataRow dr in Dates.Rows)
{
HotelRateAndAvailabilityExt DatesObj = new HotelRateAndAvailabilityExt();
DatesObj.DateID = Convert.ToInt32(dr["ID"]);
DatesObj.Date = Convert.ToDateTime(dr["Date"]);
DatesObj.DayID = Convert.ToInt32(dr["DayID"]);
DatesObj.Day = Convert.ToInt32(dr["Day"]);
DatesObj.WeekDay = Convert.ToInt32(dr["WeekDay"]);
DatesObj.DayName = Convert.ToString(dr["DayName"]);
DatesObj.MonthID = Convert.ToInt32(dr["MonthID"]);
DatesObj.MonthName = Convert.ToString(dr["MonthName"]);
DatesObj.Year = Convert.ToInt32(dr["Year"]);
DateList.Add(DatesObj);
}
}
return DateList;
}
