public bool RemoveUserActivity(int id)
{
UsersActivity removeUserActivity = _db.UsersActivities.Single(ua => ua.UsersActivityId == id);
_db.UsersActivities.Remove(removeUserActivity);
return(_db.SaveChanges() == 1);
}
public UsersActivityDetail GetUserActivityById(int id)
{
UsersActivity getUserActivity = _db.UsersActivities.Single(ua => ua.UsersActivityId == id);
UsersActivityDetail activityDetail = new UsersActivityDetail()
{
UsersActivityId = getUserActivity.UsersActivityId,
ActivityId = getUserActivity.ActivityId,
ProfileId = getUserActivity.ProfileId
};
return(activityDetail);
}
public bool JoinActivityToUsersActivity(UsersActivityCreate model)
{
UserProfile userProfile = _db.UserProfiles.Single(up => up.OwnerId == _userId);
UsersActivity usersActivity = new UsersActivity()
{
ActivityId = model.ActivityId,
ProfileId = userProfile.ProfileId
};
_db.UsersActivities.Add(usersActivity);
return(_db.SaveChanges() == 1);
}
public bool CreateUsersActivity(UsersActivityCreate model)
{
var entity =
new UsersActivity()
{
ActivityId = model.ActivityId,
ProfileId = model.ProfileId
};
using (var ctx = new ApplicationDbContext())
{
ctx.UsersActivities.Add(entity);
return ctx.SaveChanges() == 1;
}
}
public UsersActivity SavePostedComments(UsersActivity objCommnt)
{
try
{
UsersActivity objNewComment = new UsersActivity();
string sessionUserId = HttpContext.Session.GetString("UserId");
if (objCommnt != null)
{
var getOldTblData = dbContext.UsersActivity.Where(x => x.PostedMessageId == objCommnt.PostedMessageId && x.LoginUserId == Convert.ToInt32(sessionUserId)).FirstOrDefault();
if (getOldTblData != null)
{
if (getOldTblData.PostedComments != null)
{
objNewComment.LoginUserId = objCommnt.LoginUserId;
objNewComment.PostedUserId = objCommnt.PostedUserId;
objNewComment.PostedMessageId = objCommnt.PostedMessageId;
objNewComment.PostedComments = objCommnt.PostedComments;
objNewComment.CreatedDate = DateTime.Now;
dbContext.Entry(objNewComment).State = EntityState.Added;
}
else
{
getOldTblData.PostedComments = objCommnt.PostedComments;
getOldTblData.UpdatedDate = DateTime.Now;
dbContext.Entry(getOldTblData).Property(x => x.CreatedDate).IsModified = false;
dbContext.Entry(getOldTblData).Property(x => x.IsLike).IsModified = false;
dbContext.Entry(getOldTblData).State = EntityState.Modified;
objNewComment = getOldTblData;
}
}
else
{
objNewComment.LoginUserId = objCommnt.LoginUserId;
objNewComment.PostedUserId = objCommnt.PostedUserId;
objNewComment.PostedMessageId = objCommnt.PostedMessageId;
objNewComment.PostedComments = objCommnt.PostedComments;
objNewComment.CreatedDate = DateTime.Now;
dbContext.Entry(objNewComment).State = EntityState.Added;
}
dbContext.SaveChanges();
}
return(objNewComment);
}
catch (Exception ex)
{
throw ex;
}
}
public UsersActivity SaveLikeUpdated(UsersActivity objActivity)
{
try
{
UsersActivity objNewActivity = new UsersActivity();
string sessionUserId = HttpContext.Session.GetString("UserId");
if (objActivity != null)
{
var getOldData = dbContext.UsersActivity.Where(x => x.PostedMessageId == objActivity.PostedMessageId && x.LoginUserId == Convert.ToInt32(sessionUserId)).FirstOrDefault();
if (getOldData != null)
{
if (getOldData.IsLike == true)
{
getOldData.IsLike = false;
}
else
{
getOldData.IsLike = true;
}
getOldData.UpdatedDate = DateTime.Now;
dbContext.Entry(getOldData).Property(x => x.CreatedDate).IsModified = false;
dbContext.Entry(getOldData).State = EntityState.Modified;
objNewActivity = getOldData;
}
else
{
objNewActivity.LoginUserId = objActivity.LoginUserId;
objNewActivity.PostedUserId = objActivity.PostedUserId;
objNewActivity.PostedMessageId = objActivity.PostedMessageId;
objNewActivity.IsLike = true;
objNewActivity.CreatedDate = DateTime.Now;
dbContext.Entry(objNewActivity).State = EntityState.Added;
}
dbContext.SaveChanges();
}
return(objNewActivity);
}
catch (Exception ex)
{
throw ex;
}
}
private string FormatActivityForDetails(UsersActivity x)
{
//string url_ip = Url.Action("View", "IP", new { Id = x.UsersIP.route, secondid = x.UsersIPId });
try
{
string url_ip = Url.Action("View", "IP", new { Id = x.UsersIPId });
string url_voicer = Url.Action("Details", "User", new { Id = x.User.Id });
var v = "<a href='" + url_voicer + "' class='link-text'>" + Extension.Truncate(x.User.Nickname, 10) + "</a> "
+ x.RowText.ToLower() + " <a href='" + url_ip + "' class='link-text'>" + Extension.Truncate(x.UsersIP.Name, 20) + "</a> on <small>" + x.Date.ToLongDateString() + "</small>";
return(v);
} catch (Exception e)
{
Console.WriteLine(e.Message);
}
return("");
}
