public ActionResult DeleteSingleAlbum(int AlbumID, int AlbumPhotoID) { try { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); DSRCManagementSystem.Models.Gallery objphoto = new DSRCManagementSystem.Models.Gallery(); var value = db.AlbumPhotos.Where(x => x.AlbumID == AlbumID && x.AlbumPhotoID == AlbumPhotoID).Select(o => o).FirstOrDefault(); value.IsActive = false; db.SaveChanges(); return(Json("success", JsonRequestBehavior.AllowGet)); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); return(Json("failed", JsonRequestBehavior.AllowGet)); } }
public ActionResult EditSingleAlbum(int AlbumID, int AlbumPhotoID) { DSRCManagementSystem.Models.Gallery objphoto = new DSRCManagementSystem.Models.Gallery(); try { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var value = db.AlbumPhotos.Where(x => x.AlbumID == AlbumID && x.AlbumPhotoID == AlbumPhotoID && x.IsActive == true).Select(o => o).FirstOrDefault(); objphoto.AlbumID = AlbumID; objphoto.AlbumPhotoID = AlbumPhotoID; objphoto.AlbumTitle = value.AlbumPhotoTitle; objphoto.AlbumDescription = value.AlbumPhotoDescription; objphoto.CoverPhotoPath = value.AlbumPhotoPath; } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(View(objphoto)); }
public ActionResult EditAlbum(int Id) { DSRCManagementSystem.Models.Gallery objphoto = new DSRCManagementSystem.Models.Gallery(); try { DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1(); var value = db.Albums.Where(x => x.AlbumID == Id).Select(o => o).FirstOrDefault(); objphoto.AlbumID = Id; objphoto.AlbumTitle = value.AlbumTitle; objphoto.AlbumDescription = value.AlbumDescription; objphoto.CoverPhotoPath = value.AlbumCoverPhotoPath; objphoto.EventDate = (DateTime)value.EventDate; var AlbumAccessRoles = (from p in db.Master_Roles.Where(x => x.IsActive == true) select new { RoleID = p.RoleID, RoleDescription = p.RoleName }).ToList(); List <DSRCManagementSystem.Models.AccessRoles> objrole = new List <DSRCManagementSystem.Models.AccessRoles>(); objrole = (from a in db.AlbumAccesses where a.AlbumID == Id && a.RoleID != null select new AccessRoles { RoleID = a.RoleID }).ToList(); List <int> selectedRoles = new List <int>(); for (int i = 0; i < objrole.Count(); i++) { selectedRoles.Add(Convert.ToInt32(objrole[i].RoleID)); } ViewBag.AlbumAccessRoles = new MultiSelectList(AlbumAccessRoles, "RoleID", "RoleDescription", selectedRoles); var AlbumAccessUsers = (from p in db.Users.Where(x => x.IsActive == true) select new { UserID = p.UserID, UserDescription = p.FirstName + " " + p.LastName }).ToList(); List <DSRCManagementSystem.Models.AccessUsers> objuser = new List <DSRCManagementSystem.Models.AccessUsers>(); objuser = (from a in db.AlbumAccesses where a.AlbumID == Id && a.UserId != null select new AccessUsers { UserID = a.UserId }).ToList(); List <int> selectedUsers = new List <int>(); for (int i = 0; i < objuser.Count(); i++) { selectedUsers.Add(Convert.ToInt32(objuser[i].UserID)); } ViewBag.AlbumAccessUsers = new MultiSelectList(AlbumAccessUsers, "UserID", "UserDescription", selectedUsers); objphoto.IsAccess = "all"; if (objrole.Count > 0) { objphoto.IsAccess = "role"; } else if (objuser.Count > 0) { objphoto.IsAccess = "user"; } ViewBag.AlbumExist = (from p in db.Albums where p.IsActive == true && p.AlbumID != Id select p.AlbumTitle).ToArray(); var getTagAlbumId = db.TaggedAlbums.Where(x => x.AlbumId == Id).Select(x => x.UserId).ToList(); List <int?> tagAlbumId = new List <int?>(); foreach (var item in getTagAlbumId) { tagAlbumId.Add(item); } var tagusers = (from u in db.Users.Where(x => x.IsActive == true) select new { UserId = u.UserID, FullName = u.FirstName + " " + u.LastName, }).ToList(); ViewBag.TagUsers = new MultiSelectList(tagusers, "UserId", "FullName", tagAlbumId); } catch (Exception Ex) { string actionName = this.ControllerContext.RouteData.Values["action"].ToString(); string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString(); ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName); } return(View(objphoto)); }