public void RemoveWish(Wish wish) { var dataContext = GetWriteDataContext(); RepData.Wish wishToBeRemoved = (from w in dataContext.Wishes where w.WishId == wish.Id select w).SingleOrDefault(); dataContext.Wishes.DeleteOnSubmit(wishToBeRemoved); dataContext.SubmitChanges(); }
/// <summary> /// Saves the wish. /// </summary> /// <param name="wish">The saved wish.</param> /// <returns></returns> public Wish SaveWish(Wish wish) { var dataContext = GetWriteDataContext(); wish.Name = TruncateString(wish.Name, 100); wish.Description = TruncateString(wish.Description, 500); wish.LinkUrl = TruncateString(wish.LinkUrl, 255); DateTime timeStamp = DateTime.Now; var wishToSave = (from w in dataContext.Wishes where w.WishId == wish.Id select w).SingleOrDefault(); bool createNew = wishToSave == null; if (createNew) { wishToSave = new RepData.Wish(); dataContext.Wishes.InsertOnSubmit(wishToSave); wishToSave.Created = timeStamp; wishToSave.Changed = timeStamp; } else if (!wish.CalledDiffers(wishToSave.TjingedById)) { //We don't want to update the change time if the wish was called or uncalled wishToSave.Changed = timeStamp; } wishToSave.Name = wish.Name; wishToSave.Description = wish.Description; wishToSave.LinkUrl = wish.LinkUrl; wishToSave.TjingedById = wish.CalledByUser != null ? (int?)wish.CalledByUser.Id : null; wishToSave.OwnerId = wish.Owner.Id; dataContext.SubmitChanges(); Wish savedWish = (Wish)wish.Clone(); savedWish.Id = wishToSave.WishId; if (createNew) { savedWish.Created = wishToSave.Created; } savedWish.Changed = wishToSave.Changed; return(savedWish); }
private void detach_Wishes1(Wish entity) { this.SendPropertyChanging(); entity.User1 = null; }
private void attach_Wishes1(Wish entity) { this.SendPropertyChanging(); entity.User1 = this; }