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