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));
}
