protected void DeleteButton_Click(object sender, System.EventArgs e) { AdminImageContent.ImageUrl = ""; int LastSlashIndex = Request.QueryString["Target"].LastIndexOf("/"); string ThumbRelativePath = Request.QueryString["Target"].Substring(0, LastSlashIndex + 1) + "Thumbs/" + Request.QueryString["Target"].Substring(LastSlashIndex + 1); System.IO.File.Delete(Server.MapPath(Request.QueryString["Target"])); System.IO.File.Delete(Server.MapPath(ThumbRelativePath)); //SQLString = "INSERT INTO FlickrCommands ( FlickrCommandType, FlickrCommandParameter ) //SELECT 'DeletePhoto', Photos.PhotoFlickrID FROM Photos //WHERE PhotoFlickrID Is Not Null AND PhotoID=" + int.Parse(PhotoIDLabel.Text) + " AND PhotoOwner = '" + Session["GalleryOwner"] + "'"; IEnumerable<string> PhotoFlickrID = from photo in GDC.Photos where (photo.PhotoFlickrID != null) && photo.PhotoID == int.Parse(PhotoIDLabel.Text) && photo.PhotoOwner.Equals((string)Session["GalleryOwner"]) select photo.PhotoFlickrID; if (PhotoFlickrID.Count() > 0) { FlickrCommand fc = new FlickrCommand(); fc.FlickrCommandType = "DeletePhoto"; fc.FlickrCommandParameter = PhotoFlickrID.First(); GDC.FlickrCommands.InsertOnSubmit(fc); GDC.SubmitChanges(); } //SQLString = "DELETE FROM Photos //WHERE PhotoID=" + int.Parse(Request.QueryString["PhotoID"]) + " AND PhotoOwner='" + Session["GalleryOwner"] + "'"; Photo p = ( from photo in GDC.Photos where photo.PhotoID == int.Parse(Request.QueryString["PhotoID"]) && photo.PhotoOwner.Equals((string)Session["GalleryOwner"]) select photo ).First(); GDC.Photos.DeleteOnSubmit(p); GDC.SubmitChanges(); this.Page.ClientScript.RegisterStartupScript(this.GetType(), "CloseWindow", "<script type=\"text/javascript\">window.opener.location.href = window.opener.location.href;window.close();</script>"); }
partial void DeleteFlickrCommand(FlickrCommand instance);
partial void UpdateFlickrCommand(FlickrCommand instance);
partial void InsertFlickrCommand(FlickrCommand instance);
protected void UpdateButton_Click(object sender, System.EventArgs e) { // SQLString = "UPDATE Photos SET PhotoDate = #" + DateTime.Parse(PhotoDateTextBox.Text).ToString() + "#, PhotoDescription = '" + PhotoDescriptionTextBox.Text.Replace("'", "''") + // "', PhotoWidth = '" + PhotoWidthTextBox.Text + "', PhotoHeight = '" + PhotoHeightTextBox.Text + "', PhotoResolution = '" + PhotoResolutionTextBox.Text + "', PhotoVisible = " + PhotoVisibleCheckBox.Checked + // " WHERE PhotoID = " + int.Parse(PhotoIDLabel.Text) + " AND PhotoOwner = '" + Session["GalleryOwner"] + "'"; string ownr = (string)Session["GalleryOwner"]; Photo toupdate = GDC.Photos.First(phot => phot.PhotoOwner.Equals(ownr) && phot.PhotoID == int.Parse(PhotoIDLabel.Text)); toupdate.PhotoDate = DateTime.Parse(PhotoDateTextBox.Text); toupdate.PhotoDescription = PhotoDescriptionTextBox.Text.Replace("'", string.Empty); toupdate.PhotoWidth = short.Parse(PhotoWidthTextBox.Text); toupdate.PhotoHeight = short.Parse(PhotoHeightTextBox.Text); toupdate.PhotoResolution = short.Parse(PhotoResolutionTextBox.Text); toupdate.PhotoVisible = PhotoVisibleCheckBox.Checked; GDC.SubmitChanges(); //Clear and reassign the categories //SQLString = "DELETE FROM PhotosJoinCategories WHERE PhotoNumber=" + int.Parse(PhotoIDLabel.Text); IEnumerable<PhotoCategoryJoin> todelete = from pcj in GDC.PhotoCategoryJoins where pcj.PhotoNumber == int.Parse(PhotoIDLabel.Text) select pcj; if (todelete != null) { GDC.PhotoCategoryJoins.DeleteAllOnSubmit(todelete); GDC.SubmitChanges(); } //Stub statement, needs more OR's to get anything //SQLString = "INSERT INTO PhotosJoinCategories ( CategoryNumber, PhotoNumber ) SELECT CategoryID, " + int.Parse(PhotoIDLabel.Text) + " FROM Categories WHERE CategoryID = 0"; List<PhotoCategoryJoin> pcjlist = new List<PhotoCategoryJoin>(); PhotoCategoryJoin pcjoin; for (int i = 0; i <= AllCategoriesList.Items.Count - 1; i++) { if (AllCategoriesList.Items[i].Selected) { //SQLString = SQLString + " OR CategoryID = " + AllCategoriesList.Items[i].Value; pcjoin = new PhotoCategoryJoin(); pcjoin.PhotoNumber = int.Parse(PhotoIDLabel.Text); pcjoin.CategoryNumber = int.Parse(AllCategoriesList.Items[i].Value); pcjlist.Add(pcjoin); } } GDC.PhotoCategoryJoins.InsertAllOnSubmit(pcjlist); GDC.SubmitChanges(); //If it's already Flickr'ed, mark it for an update on the next sweep //SQLString = "INSERT INTO FlickrCommands ( FlickrCommandType, FlickrCommandPhoto ) //SELECT 'UpdatePhoto', Photos.PhotoID FROM Photos WHERE PhotoFlickrID Is Not Null AND PhotoID=" + int.Parse(PhotoIDLabel.Text) + " AND PhotoOwner = '" + Session["GalleryOwner"] + "'"; IEnumerable<int> flickrphotos = from photo in GDC.Photos where (photo.PhotoFlickrID != null) && photo.PhotoID == int.Parse(PhotoIDLabel.Text) && photo.PhotoOwner.Equals((string)Session["GalleryOwner"]) select photo.PhotoID; if (flickrphotos.Count() != 0) { int flickrphoto = flickrphotos.First(); FlickrCommand fc = new FlickrCommand(); fc.FlickrCommandType = "UpdatePhoto"; fc.FlickrCommandPhoto = flickrphoto; GDC.FlickrCommands.InsertOnSubmit(fc); GDC.SubmitChanges(); } LoadPictureData(); this.Page.ClientScript.RegisterStartupScript(this.GetType(), "CloseWindow", "<script type=\"text/javascript\">window.opener.location.href = window.opener.location.href;window.close();</script>"); }