public ActionResult DeleteResource(ResourceListViewModel res) { var itemID = res.EditItemID; var categoryID = res.DeleteCategoryID; //A resource will be allowed in mulitple categories Thus delete this entries from this table var categoryItems = ExigoDAL.GetResourceCategoryItems(new GetResourceCategoryItemsRequest() { ItemID = itemID }); foreach (var item in categoryItems) { //2015-09-08 //Ivan S. //66 //Reorders the following resources (setting their order to a minus 1 value) var itemOrder = item.ItemOrder; var categoryItemOrder = ExigoDAL.GetResourceCategoryItems(new GetResourceCategoryItemsRequest() { CategoryID = categoryID, ItemOrder = itemOrder }).ToList(); foreach (var catitem in categoryItemOrder) { catitem.ItemOrder = catitem.ItemOrder - 1; ExigoDAL.ModifyResourceCategoryItemOrder(catitem); } } //Delete the availabilitiy of the resource var availability = ExigoDAL.GetResourceAvailabilities(new GetResourceAvailabilitiesRequest() { ItemID = itemID }).Select(v => v.AvailabilityID).ToList(); ExigoDAL.DeleteResourceAvailabilities(availability); //Delete The Tags Associated with the item var tags = ExigoDAL.GetResourceItemTags(new GetResourceItemTagsRequest() { ItemID = itemID }).Select(t => t.TagID).ToList(); ExigoDAL.DeleteResourceItemTags(tags); //Delete the resource itself var resource = ExigoDAL.GetResourceItems(new GetResourcesRequest() { ItemID = itemID }).FirstOrDefault(); ExigoDAL.DeleteResourceItem(resource); return(RedirectToAction("ManageResources")); }
public JsonNetResult EditResource(CreateResource res, string editID) { try { var itemID = Guid.Parse(editID); //Update ResoureItem ResourceItem originalResource = new ResourceItem() { ItemID = itemID, Title = res.Title, ItemDescription = res.ItemDescription, Url = res.Url, UrlThumbnail = res.UrlThumbnail, TypeID = res.TypeID, StatusID = res.StatusID, PostDate = res.PostDate ?? DateTime.Now.ToCST(), Language = res.Language, CreatedDate = DateTime.Now.ToCST(), }; ExigoDAL.ModifyResourceItem(originalResource); //Current Availabilities List <ResourceAvailability> currentAvailability = ExigoDAL.GetResourceAvailabilities(new GetResourceAvailabilitiesRequest() { ItemID = originalResource.ItemID }).ToList(); //Wanted Availabilities List <ResourceAvailability> keepAvailabilities = new List <ResourceAvailability>(); List <Available> neededAvailabilities = new List <Available>(); foreach (var market in res.Markets) { var availability = new Available(); availability.Language = res.Language; availability.Market = market; var exist = currentAvailability.Where(ca => ca.Language == availability.Language && ca.Market == availability.Market).FirstOrDefault(); if (exist == null) { neededAvailabilities.Add(availability); } else { keepAvailabilities.Add(exist); } } //Add NEW Availabilities foreach (var avail in neededAvailabilities) { ResourceAvailability availableresource = new ResourceAvailability() { AvailabilityID = Guid.NewGuid(), ItemID = originalResource.ItemID, Market = avail.Market, Language = avail.Language }; ExigoDAL.CreateResourceAvailabilities(availableresource); } //Delete Availabilities no longer wanted List <Guid> deleteAvailabilities = currentAvailability.Except(keepAvailabilities).Select(t => t.AvailabilityID).ToList(); ExigoDAL.DeleteResourceAvailabilities(deleteAvailabilities); //Modify ResourceCategoryItems // Current ResourceCategoryItems CategoryIDs var RCI = ExigoDAL.GetResourceCategoryItems(new GetResourceCategoryItemsRequest() { ItemID = originalResource.ItemID }); var currentRCI = RCI.Select(rci => rci.CategoryID); // Wanted CategoryIDs var wantedRCI = res.CategoryID; // Needed CategoryIDs var neededRCI = wantedRCI.Except(currentRCI); //Add New CategoryItems foreach (var category in neededRCI) { var lastResource = ExigoDAL.GetResourceCategoryItems(new GetResourceCategoryItemsRequest() { CategoryID = category }) .OrderByDescending(r => r.ItemOrder) .FirstOrDefault(); int lastItemOrder = InitialOrderValue - 1; if (lastResource != null) { lastItemOrder = lastResource.ItemOrder; } ResourceCategoryItem categoryItem = new ResourceCategoryItem() { ItemID = originalResource.ItemID, CategoryID = category, ItemOrder = lastItemOrder }; ExigoDAL.CreateResourceCategoryItem(categoryItem); } //Delete Unwanted CategoryItems var unwantedRCICategoryIDs = currentRCI.Except(wantedRCI).ToList(); if (unwantedRCICategoryIDs.Any()) { ExigoDAL.DeleteResourceCategoryItems(itemID, unwantedRCICategoryIDs); } List <Tag> tags = new List <Tag>(); if (res.Keywords.Any()) { // check to see if tag existis with these keywords. if not add it //Get A List Of Tags Using Provided Keywords var existingTags = ExigoDAL.GetTagsForResources(new GetTagsForResourcesRequest() { Names = res.Keywords }); var existingTagNames = existingTags.Select(et => et.Name); //Get a List of Keywords we need to make tags for var newTagsneeded = res.Keywords.Except(existingTagNames); //Create The New Tags List <Tag> NewlyCreatedTags = new List <Tag>(); foreach (var keyword in newTagsneeded) { Tag newTag = new Tag() { TagID = Guid.NewGuid(), Name = keyword }; NewlyCreatedTags.Add(newTag); ExigoDAL.CreateTag(newTag); } //Combine existing and New Tags var completeTagList = existingTags.Union(NewlyCreatedTags).ToList(); var completeTagIDs = completeTagList.Select(v => v.TagID); //Get a list of ItemTags currently associated with the Item var currentItemTagIDs = ExigoDAL.GetResourceItemTags(new GetResourceItemTagsRequest() { ItemID = originalResource.ItemID }).Select(v => v.TagID); //Get a list of Tags we need to make ItemTags for var newItemTagsneeded = completeTagList.Where(t => !currentItemTagIDs.Contains(t.TagID)); // Update ResourceItemTags Table with new Tags foreach (var tagneeded in newItemTagsneeded) { ResourceItemTag rit = new ResourceItemTag() { TagID = tagneeded.TagID, ItemID = itemID, }; ExigoDAL.CreateResourceItemTag(rit); } // remove any pivot table tags that are no longer being used for this resource var nolongerwanted = currentItemTagIDs.Except(completeTagIDs).ToList(); if (nolongerwanted.Count > 0) { ExigoDAL.DeleteResourceItemTags(nolongerwanted); } } return(new JsonNetResult(new { success = true, })); } catch (Exception ex) { return(new JsonNetResult(new { success = false, message = ex.Message })); } }