protected void Page_Load(object sender, EventArgs e) { var db = new PhotoArt.Data.PhotoArtDbContext(); var albums = db.Albums .Where(x => x.Images.Count > 0) .ToList() .Select(x => new { Id = x.Id, Name = x.Name, Description = x.Description, CreatedOn = x.CreatedOn, IsApproved = x.IsApproved, Url = x.Images.FirstOrDefault().Url, CoverImage1 = "data:image/jpeg;base64," + x.Images.FirstOrDefault().Content, CoverImage = "data:image/jpeg;base64," + Convert.ToBase64String(x.Images.FirstOrDefault().Content) }) .ToList(); // this.Image1.ImageUrl = pendingAlbums.FirstOrDefault().CoverImage; if (!Page.IsPostBack) { this.albums.DataSource = albums; this.albums.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session[CAROUSEL_OFFSET] == null) { Session[CAROUSEL_OFFSET] = 0; } if (Request.Params["Id"] == null) { Response.Redirect(PENDING_ALBUMS_URL); } var db = new PhotoArt.Data.PhotoArtDbContext(); var id = int.Parse(Request.Params["Id"]); // var album = db.Albums // .Where(x => x.Id == id) // .Select(x => new // { // x.Id, // x.Name, // x.Description, // Images = x.Images // .Select(i => new // { // Id = i.Id, // Url = i.Url // }) // }) // .FirstOrDefault(); // if (album == null) // { // Response.Redirect(PENDING_ALBUMS_URL); // } // // TODO: check for null var cover = db.Albums .Where(x => x.Id == id) .Select(x => x.Images .FirstOrDefault()) .FirstOrDefault(); if (cover != null) { this.CoverImage.ImageUrl = "data:image/jpeg;base64," + Convert.ToBase64String(cover.Content); } //// this.Carousel.DataSource = album.Images.Skip(0).Take(5); // this.DataBind(); }
public IQueryable<UserViewModel> UsersGrid_GetData(object sender, EventArgs e) { var db = new PhotoArt.Data.PhotoArtDbContext(); return db.Users .Select(x => new UserViewModel { Id = x.Id, Name = x.FirstName + " " + x.LastName, Country = x.Country, Email = x.Email, Albums = x.Portfolio.Albums.Count, CoverUrlPath = x.Portfolio.Albums.FirstOrDefault() != null ? x.Portfolio.Albums.FirstOrDefault().Images.FirstOrDefault() != null ? x.Portfolio.Albums.FirstOrDefault().Images.FirstOrDefault().Url : null : null }); }
//protected void Carousel_ItemDataBound(object sender, RepeaterItemEventArgs e) //{ // var item = e.Item.DataItem as Models.Image; // if (item != null) // { // e.Item.ID = item.Id.ToString(); // } //} public IQueryable<ImageViewModel> GetImages() { if (Request.Params["Id"] == null) { Response.Redirect(PENDING_ALBUMS_URL); } var id = int.Parse(Request.Params["Id"]); var skip = (int)Session[CAROUSEL_OFFSET]; var db = new PhotoArt.Data.PhotoArtDbContext(); return db.Images .Where(x => x.AlbumId == id) .Select(x => new ImageViewModel { Id = x.Id, Url = x.Url }) .OrderBy(x => x.Id) .Skip(skip) .Take(5); }