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