public bool ifUserFollowedByOpenId(string openId, string userId)
{
SqlSugarClient db = SqlSugarInstance.newInstance();
tbl_userFollowed followed = new tbl_userFollowed();
followed = db.Queryable <tbl_userFollowed>().Where(o => o.userId == openId && o.followedUser == userId).First();
if (followed != null)
{
return(true);
}
else
{
return(false);
}
}
public void addFollow(string openId, string postsId)
{
SqlSugarClient db = SqlSugarInstance.newInstance();
tbl_posts posts = db.Queryable <tbl_posts>().Where(o => o.postsID == postsId).First();
string postsMaker = posts.postsMaker;
tbl_userFollowed followed = new tbl_userFollowed();
followed.followId = Guid.NewGuid().ToString();
followed.userId = openId;
followed.followedUser = postsMaker;
followed.followedTime = DateTime.Now;
tbl_userFollowed tf = new tbl_userFollowed();
long i = db.Queryable <tbl_userFollowed>().Where(o => o.userId == openId && o.followedUser == postsMaker).Count();
if (i == 0)
{
db.Insertable <tbl_userFollowed>(followed).ExecuteCommand();
}
}
public void newOrUpdateUser(tbl_user user, string refer)
{
try
{
SqlSugarClient db = SqlSugarInstance.newInstance();
tbl_user curUser = db.Queryable <tbl_user>().Where(o => o.openid == user.openid).First();
if (curUser != null)
{
if (curUser.avantarUrl != user.avantarUrl || curUser.nickName != user.nickName || curUser.gender != user.gender || curUser.country != user.country || curUser.city != user.city || curUser.province != user.province)
{
curUser.lastLoginDate = DateTime.Now;
//user.registerDate = curUser.registerDate;
//user.userStatus = curUser.userStatus;
curUser.avantarUrl = user.avantarUrl;
curUser.nickName = user.nickName;
curUser.gender = user.gender;
curUser.country = user.country;
curUser.city = user.city;
curUser.province = user.province;
db.Updateable <tbl_user>(curUser).Where(o => o.openid == user.openid).ExecuteCommand();
}
updateLastLoginDate(user.openid);
}
else
{
user.referBy = refer;
user.registerDate = DateTime.Now;
user.lastRefreshDate = DateTime.Now;
user.lastRefreshFans = DateTime.Now;
user.userStatus = 0;//0 means the user is under active status
user.lastLoginDate = DateTime.Now;
db.Insertable <tbl_user>(user).ExecuteCommand();
tbl_userFollowed followedSelf = new tbl_userFollowed();
followedSelf.followedTime = DateTime.Now;
followedSelf.followedUser = user.openid;
followedSelf.followId = Guid.NewGuid().ToString();
followedSelf.userId = user.openid;
db.Insertable <tbl_userFollowed>(followedSelf).ExecuteCommand();
List <tbl_admin> admin = new List <tbl_admin>();
admin = db.Queryable <tbl_admin>().ToList();
foreach (var item in admin)
{
bool ifFollowed = false;
ifFollowed = db.Queryable <tbl_userFollowed>().Where(o => o.userId == user.openid && o.followedUser == item.openId).Count() > 0;
if (!ifFollowed)
{
tbl_userFollowed followed = new tbl_userFollowed();
followed.followedTime = DateTime.Now;
followed.followedUser = item.openId;
followed.followId = Guid.NewGuid().ToString();
followed.userId = user.openid;
db.Insertable <tbl_userFollowed>(followed).ExecuteCommand();
}
}
db.Insertable <tbl_userConfig>(new tbl_userConfig {
userId = user.openid, byTime = 0, byViewed = 1, onlyLoved = 0, onlyVerify = 0, videoMuted = 1
}).ExecuteCommand();
}
}
catch (Exception e)
{
string err = e.Message;
}
}
