public List<PropertyRoomsExt> GetPropertyRooms(int HotelID)
{
// long HotelID = 100003;
SQLCon.Open();
SqlCommand cmd = new SqlCommand("TB_SP_GetHotelRooms", SQLCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Culture", CultureValue);
cmd.Parameters.AddWithValue("@OrderBy", "ID");
cmd.Parameters.AddWithValue("@HotelID",HotelID);
cmd.Parameters.AddWithValue("@Active", true);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
SQLCon.Close();
List<PropertyRoomsExt> ListOfModel = new List<PropertyRoomsExt>();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
//if (!ArrayID.Contains(Convert.ToInt32(dr["ID"])))
//{
PropertyRoomsExt HotelRoom = new PropertyRoomsExt();
HotelRoom.ID = Convert.ToInt32(dr["ID"]);
HotelRoom.HotelID = Convert.ToInt64(dr["HotelID"]);
HotelRoom.RoomTypeID = Convert.ToInt32(dr["RoomTypeID"]);
HotelRoom.RoomCount = dr["RoomCount"].ToString();
HotelRoom.RoomTypeName = dr["RoomTypeName"].ToString();
HotelRoom.RoomSize = dr["RoomSize"].ToString();
HotelRoom.MaxPeopleCount = dr["MaxPeopleCount"].ToString();
HotelRoom.IDWithMaxPeopleCount = dr["IDWithMaxPeopleCount"].ToString();
HotelRoom.MaxChildrenCount = dr["MaxChildrenCount"].ToString();
HotelRoom.BabyCotCount = dr["BabyCotCount"].ToString();
HotelRoom.ExtraBedCount = dr["ExtraBedCount"].ToString();
HotelRoom.SmokingTypeID = dr["SmokingTypeID"].ToString();
HotelRoom.SmokingTypeName = dr["SmokingTypeName"].ToString();
HotelRoom.ViewTypeID = dr["ViewTypeID"].ToString();
HotelRoom.ViewTypeName = dr["ViewTypeName"].ToString();
HotelRoom.IncludedInRoomTypeCaption = dr["IncludedInRoomTypeCaption"].ToString();
HotelRoom.Active = Convert.ToBoolean(dr["Active"]);
HotelRoom.CreateDateTime = dr["CreateDateTime"].ToString();
HotelRoom.CreateUserID = dr["CreateUserID"].ToString();
HotelRoom.OpDateTime = dr["OpDateTime"].ToString();
HotelRoom.OpUserID = dr["OpUserID"].ToString();
Encryption64 objEncryptreservation = new Encryption64();
string EncryptRoomID = dr["ID"].ToString();
EncryptRoomID = System.Web.HttpContext.Current.Server.UrlEncode(ConvertStringToHex(objEncryptreservation.Encrypt(EncryptRoomID, "58421043")));
HotelRoom.EncryptRoomID = EncryptRoomID;
ListOfModel.Add(HotelRoom);
//}
}
}
return ListOfModel;
}
public List<HotelRoomExt> GetHotelRoomAttributes(Int64 HotelRoomID, int AttributeTypeID, string OrderBy)
{
PropertyRoomsExt obj = new PropertyRoomsExt();
DataTable dt = new DataTable();
SQLCon.Open();
SqlCommand cmd = new SqlCommand("TB_SP_GetHotelRoomAttributes", SQLCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Culture", CultureValue);
cmd.Parameters.AddWithValue("@OrderBy", OrderBy);
cmd.Parameters.AddWithValue("@HotelRoomID", HotelRoomID);
cmd.Parameters.AddWithValue("@AttributeTypeID", AttributeTypeID);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
SQLCon.Close();
foreach (var items in AttributesListOfModel)
{
HotelRoomExt HotelRoom = new HotelRoomExt();
HotelRoom.AttributeId = items.AttributeId;
HotelRoom.AttributeName = items.AttributeName;
HotelRoom.AttributeHeaderId = items.AttributeHeaderId;
if (dt.Rows.Count > 0)
{
DataRow[] hotelRoomAttribute = dt.Select("AttributeID=" + items.AttributeId);
HotelRoom.hasAttribute = (hotelRoomAttribute.Length > 0);
HotelRoom.charged = ((HotelRoom.hasAttribute) && (Convert.ToBoolean(hotelRoomAttribute[0]["charged"])));
}
HotelRooms.Add(HotelRoom);
}
return HotelRooms;
}
