Deletion of Albums using a button

mark_gilb · August 24th, 2013, 08:45 PM

I want to write code inside a button's Click event that will delete all the photo albums that have been on the site for more that 3 months from the CreateDateTime of the the album, and delete all the related pictures in the GigPics folder.

I was thinking of using a loop to go over all the records but didn't really know how to write such code?? Any help is appreciated and this is my last question.. After that my classified ads site is done and i really thank u Imar for such a GREAT book :)

Imar · August 25th, 2013, 06:48 PM

Hi Mark,

I haven't fully tested it yet, but the following should work:

Code:

using (PlanetWroxEntities myEntities = new PlanetWroxEntities())
{
  DateTime oldDate = DateTime.Now.AddMonths(-3);
  var allOldAlbums = (from a in myEntities.PhotoAlbums
                      where a.CreateDate < oldDate
                      select a).ToList();

  foreach (var album in allOldAlbums)
  {
    foreach (var picture in album.Pictures.ToList())
    {
      File.Delete(Server.MapPath(picture.ImageUrl));
      myEntities.Pictures.DeleteObject(picture);
    }
    myEntities.PhotoAlbums.DeleteObject(album);
  }
  myEntities.SaveChanges();
}

Most of it is hopefully straight forward. For an explanation of why you need the two calls to ToList, check out this SO post: http://stackoverflow.com/questions/3...n-foreach-loop

Hope this helps,

Imar