public string DeleteImgAlbum(long id) { try { utblImageAlbum model = db.utblImageAlbums.Find(id); db.utblImageAlbums.Remove(model); db.SaveChanges(); return("Image Album Removed"); } catch (Exception) { return("Error: Server error, try again later"); } }
public ActionResult Photo(long id) { ImageAlbumManageModel model = new ImageAlbumManageModel(); utblImageAlbum _imodel = new utblImageAlbum(); model.Imageslist = ObjImage.GetImageByAlbumID(id); _imodel = ObjImgAlbum.GetImgAlbumByID(id); model.ImageAlbum = _imodel; if (Request.IsAjaxRequest()) { return(PartialView("_pvImageList", model)); } return(View(model)); }
public string SaveImgAlbum(utblImageAlbum model) { var parImageAlbumID = new SqlParameter("@ImageAlbumID", model.ImageAlbumID); var parImageAlbumTitle = new SqlParameter("@ImageAlbumTitle", model.ImageAlbumTitle); var parImageAlbumDesc = new SqlParameter("@ImageAlbumDesc", model.ImageAlbumDesc); var parProgramDate = new SqlParameter("@ProgramDate", model.ProgramDate); var parComponentID = new SqlParameter("@ComponentID", model.ComponentID); var parSubComponentID = new SqlParameter("@SubComponentID", model.SubComponentID); var parSchoolID = new SqlParameter("@SchoolID", model.SchoolID); var parIsPublished = new SqlParameter("@IsPublished", model.IsPublished); var parPublishDate = new SqlParameter("@PublishDate", DBNull.Value); if (model.PublishDate != null) { parPublishDate = new SqlParameter("@PublishDate", model.PublishDate); } var parTransDate = new SqlParameter("@TransDate", model.TransDate); var parUserID = new SqlParameter("@UserID", model.UserID); return(db.Database.SqlQuery <string>("udspImageAlbumSave @ImageAlbumID,@ImageAlbumTitle, @ImageAlbumDesc, @ProgramDate,@ComponentID,@SubComponentID,@SchoolID, @IsPublished,@PublishDate, @TransDate, @UserID", parImageAlbumID, parImageAlbumTitle, parImageAlbumDesc, parProgramDate, parComponentID, parSubComponentID, parSchoolID, parIsPublished, parPublishDate, parTransDate, parUserID).FirstOrDefault()); }