public Guid UpdateTweet(NewTweetDTO updatedTweet) { using (glitterEntities DBContext = new glitterEntities()) { Tweet tweet = DBContext.Tweet.Where(ds => ds.ID == updatedTweet.TweetID).FirstOrDefault(); tweet.Message = updatedTweet.Message; tweet.CreatedAt = System.DateTime.Now; DBContext.SaveChanges(); } return(updatedTweet.TweetID); }
public async Task <NewTweetDTO> CreateNewTweet(NewTweetDTO tweetInput) { using (glitterEntities DBContext = new glitterEntities()) { Tweet newTweet = new Tweet(); newTweet.ID = System.Guid.NewGuid(); newTweet.Message = tweetInput.Message; newTweet.UserID = tweetInput.UserID; newTweet.CreatedAt = System.DateTime.Now; DBContext.Tweet.Add(newTweet); await DBContext.SaveChangesAsync(); tweetInput.TweetID = newTweet.ID; } return(tweetInput); }
/// <summary> /// db context function to add tags to the db contained in a particular tweet /// </summary> /// <param name="tags"></param> /// <param name="tweetid"></param> /// <returns></returns> public bool AddTags(List <string> tags, Guid tweetid) { using (glitterEntities dbcontext = new glitterEntities()) { foreach (string s in tags) { Tag newtag = new Tag(); newtag.ID = Guid.NewGuid(); newtag.TweetID = tweetid; newtag.TagName = s; dbcontext.Tag.Add(newtag); dbcontext.SaveChanges(); } } return(true); }
public bool updateSearchCount(Tag item) { using (glitterEntities DBContext = new glitterEntities()) { Tag updateTag = DBContext.Tag.Where(dr => dr.ID == item.ID).FirstOrDefault(); if (updateTag.SearchCount == null) { updateTag.SearchCount = 1; } else { updateTag.SearchCount = updateTag.SearchCount + 1; } DBContext.SaveChanges(); } return(true); }
public bool DeleteTweet(Guid uid, Guid tid) { using (glitterEntities DBContext = new glitterEntities()) { Tweet tweet = DBContext.Tweet.Where(ds => ds.ID == tid && ds.UserID == uid).FirstOrDefault(); if (tweet != null) { tagdb.DeleteTag(tweet.ID); DBContext.Entry(tweet).State = EntityState.Deleted; DBContext.SaveChanges(); return(true); } else { return(false); } } }
public UserDBContext() { DBContext = new glitterEntities(); var userAuthMapperConfig = new MapperConfiguration(cfg => { cfg.CreateMap <User, UserAuthDTO>() .ForMember(dest => dest.Password, opt => opt.MapFrom(src => src.PasswordHash)); }); UserAuthMapper = new Mapper(userAuthMapperConfig); var userBasicMapperConfig = new MapperConfiguration(cfg => { cfg.CreateMap <User, UserBasicDTO>(); }); UserBasicMapper = new Mapper(userBasicMapperConfig); }
/// <summary> /// Db Context dunction to delete all tags of a particular tweet /// </summary> /// <param name="tweetId"></param> /// <returns></returns> public bool DeleteTag(Guid tweetId) { using (glitterEntities DBContext = new glitterEntities()) { IList <Tag> taglist = DBContext.Tag.Where(dr => dr.TweetID == tweetId).ToList(); if (taglist.Count > 0) { foreach (var item in taglist) { DBContext.Entry(item).State = EntityState.Deleted; DBContext.SaveChanges(); } return(true); } else { return(false); } } }
public TweetDBContext() { tagdb = new TagDBContext(); DBContext = new glitterEntities(); }