/// <summary> /// Add user and collection to collection mapping table /// </summary> /// <param name="obj"> New Collection Object containing user eamil as obj.user and collectionsharing id as obj.name</param> /// <returns></returns> public bool AddUserToCollection(NewCollectionsObj obj) { // 3 checks // 1 - is count == 0 CollectionSharing sharing = ShareCounter(obj.name); // 2 - is the user different from the other users-- already mapped into UserCollectionsMapping UserCollectionMapping mapping = new UserCollectionMapping(sharing.CollectionId, obj.User); if (sharing.count == 0 && mapping.CheckUser()) { // set the counter to +1 sharing.CountIncrament(); try { using (FinPlannerContext _context = new FinPlannerContext()) { _context.Entry(sharing).State = EntityState.Modified; _context.UserCollectionMapping.Add(mapping); _context.SaveChanges(); } return(true); } catch (Exception e) { return(false); } } else { return(false); } }
private CollectionSharing ShareCounter(string id) { using (FinPlannerContext _context = new FinPlannerContext()) { CollectionSharing sharing = _context.CollectionSharing.Find(id); return(sharing); } }
private void SavedCollection(CollectionSharing collectionSharing) { using (FinPlannerContext _context = new FinPlannerContext()) { _context.CollectionSharing.Add(collectionSharing); _context.SaveChanges(); } }