public ImageItem InsertImage(string albumId, ImageItem image) { var imageAdapter = new ImageAdapter(); image = imageAdapter.Insert(image); var param = new[] { new SqlParameter("@albumId", albumId), new SqlParameter("@imageId", image.Id), }; Call(SP_ALBUM_IMAGE_INSERT, param); return(image); }
public List <PhotoAlbum> GetByHouseId(string houseId) { var param = new[] { new SqlParameter("@houseId", houseId), }; var albums = Call(SP_PHOTO_ALBUM_GETBYHOUSEID, param, DataReader.ReadAlbum); foreach (var album in albums) { var imageAdapter = new ImageAdapter(); album.Items = imageAdapter.GetByAlbumId(album.Id); } return(albums); }
public PhotoAlbum GetById(string id) { var param = new[] { new SqlParameter("@id", id), }; var album = Call(SP_PHOTO_ALBUM_GETBYID, param, DataReader.ReadAlbum).FirstOrDefault(); if (album != null) { var imageAdapter = new ImageAdapter(); album.Items = imageAdapter.GetByAlbumId(album.Id); } return(album); }
public ImageItem InsertImage(string roomTypeId, ImageItem image) { var imageAdapter = new ImageAdapter(); image = imageAdapter.Insert(image); var param = new[] { new SqlParameter("@imageId", image.Id), new SqlParameter("@roomTypeId", roomTypeId), }; Call(SP_ROOMTYPEIMAGE_INSERT, param); return(image); }
public List <RoomType> GetByHouseId(string houseId) { var param = new[] { new SqlParameter("@houseId", houseId), }; var roomTypes = Call(SP_ROOMTYPE_GETBYHOUSEID, param, DataReader.ReadRoomType); var imageAdapter = new ImageAdapter(); foreach (var roomType in roomTypes) { roomType.Images = imageAdapter.GetByRoomTypId(roomType.Id); } return(roomTypes); }
public RoomType GetById(string id) { var param = new[] { new SqlParameter("@id", id), }; var roomType = Call(SP_ROOMTYPE_GETBYID, param, DataReader.ReadRoomType).FirstOrDefault(); if (roomType == null) { return(null); } var articleAdapter = new ArticleAdapter(); roomType.Article = articleAdapter.GetById(roomType.Article.Id); var imageAdapter = new ImageAdapter(); roomType.Images = imageAdapter.GetByRoomTypId(id); return(roomType); }