public List <FollowerModel> GetFollowers(int personId)
{
List <FollowerModel> list = new List <FollowerModel>();
sqlCommand = new SqlCommand()
{
Connection = connectionHelper.connection,
CommandType = CommandType.StoredProcedure,
CommandText = "FollowersSP",
};
sqlCommand.Parameters.Add("@PersonId", SqlDbType.Int).Value = personId;
connectionHelper.connection.Open();
SqlDataReader sqlReader = sqlCommand.ExecuteReader();
if (sqlReader.HasRows)
{
while (sqlReader.Read())
{
var model = new FollowerModel()
{
Id = Convert.ToInt32(sqlReader["Id"]),
Name = sqlReader["Name"] as string
};
list.Add(model);
}
}
connectionHelper.connection.Close();
return(list);
}
//取消关注
private async void care_Click(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
FollowerModel follower = btn.DataContext as FollowerModel;
string uri = Config.apiUserUnFollow + Config.UserPhone + "/" + follower.cphone;
string response = await HttpGet.HttpGets(uri);
}
public string DeliteYourFollower([FromBody] FollowerModel model)
{
using (var context = new AppContext())
{
var followers = context.UserToUser.Where(u => u.phoneNumberSender == model.phoneNumberReceiver & u.phoneNumberReceiver == model.phoneNumberSender).ToList();
if (followers.Count == 0)
{
return("Данный пользователь не подписан на вас");
}
else
{
if (followers[0].active == false)
{
return("Данный пользователь не подписан на вас");
}
else
{
DateTime timeNow = DateTime.Now;
string cultureInfo = "ru-RU";
var culture = new CultureInfo(cultureInfo);
followers[0].active = false;
followers[0].dateSource = timeNow.ToString(culture);
try
{
context.SaveChanges();
return("Подписка данного пользователя на вас была удалена");
}
catch
{
return("Ошибка подключения к серверу");
}
}
}
}
}
public async Task <ActionResult <FollowerModel> > PostFollower(string userToken, int followedId)
{
int userId = _context.Users.Where(x => x.Token == userToken).Select(x => x.Id).FirstOrDefault();
if (userId == 0)
{
return(BadRequest());
}
var followRecord = _context.Followers.Where(x => x.FollowedId == followedId && x.FollowerId == userId);
if (followRecord.Any())
{
foreach (var a in followRecord)
{
_context.Followers.Remove(a);
}
_context.SaveChanges();
return(null);
}
FollowerModel follower = new FollowerModel
{
FollowerId = userId,
FollowedId = followedId
};
_context.Followers.Add(follower);
await _context.SaveChangesAsync();
return(follower);
}
//关注
private void Button_Click(object sender, RoutedEventArgs e)
{
Button btn = sender as Button;
FollowerModel follower = btn.DataContext as FollowerModel;
HttpPostUserFollower.HttpPost(follower.fphone, follower.fname, follower.fimage, follower.fdream, Config.UserPhone, Config.UserName, Config.UserImage, Config.UserDream);
btn.IsEnabled = false;
}
public HttpResponseMessage AddFollower(FollowerModel followerModel)
{
if (followerModel != null)
{
var followerentity = new FollowerEntity
{
Openid = followerModel.Openid,
Nickname = followerModel.Nickname,
Sex = followerModel.Sex,
City = followerModel.City,
Country = followerModel.Country,
Private = followerModel.Private,
Language = followerModel.Language,
Headimgurl = followerModel.Headimgurl,
Subscribetime = followerModel.Subscribe_time,
Unioid = followerModel.Unioid,
Remark = followerModel.Remark,
Groupid = followerModel.Groupid,
Adduser = followerModel.Adduser,
Addtime = DateTime.Now,
Upuser = followerModel.Upuser,
Uptime = DateTime.Now
};
var phoneentity = new PhoneEntity
{
Follower = _followerService.Create(followerentity),
Openid = followerModel.Openid,
Phone = followerModel.Phone,
Adduser = followerModel.Adduser,
Addtime = DateTime.Now,
Upuser = followerModel.Upuser,
Uptime = DateTime.Now
};
try
{
_phoneService.Create(phoneentity);
return(PageHelper.toJson(PageHelper.ReturnValue(true, "数据添加成功！")));
}
catch
{
return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据添加失败！")));
}
}
return(PageHelper.toJson(PageHelper.ReturnValue(false, "数据验证错误！")));
}
public static string AsJson(this FollowerModel model) => JsonSerializer.Serialize(model);
public string AddFollower([FromBody] FollowerModel model)
{
if (model.phoneNumberSender == model.phoneNumberReceiver)
{
return("Нельзя добавить самого себя в подписчики");
}
else
{
using (var context = new AppContext())
{
var followers = context.UserToUser.Where(u => u.phoneNumberSender == model.phoneNumberSender & u.phoneNumberReceiver == model.phoneNumberReceiver).ToList();
if (followers.Count == 0)
{
DateTime timeNow = DateTime.Now;
string cultureInfo = "ru-RU";
var culture = new CultureInfo(cultureInfo);
UserToUserModel newmodel = new UserToUserModel()
{
phoneNumberSender = model.phoneNumberSender,
phoneNumberReceiver = model.phoneNumberReceiver,
dateSource = timeNow.ToString(culture),
active = true
};
try
{
context.UserToUser.Add(newmodel);
context.SaveChanges();
return("Успешно");
}
catch
{
return("Ошибка подключения к серверу");
}
}
else
{
if (followers[0].active == true)
{
return("Вы уже подписаны на данного пользователя");
}
else
{
DateTime timeNow = DateTime.Now;
string cultureInfo = "ru-RU";
var culture = new CultureInfo(cultureInfo);
followers[0].active = true;
followers[0].dateSource = timeNow.ToString(culture);
try
{
context.SaveChanges();
return("Успешно");
}
catch
{
return("Ошибка подключения к серверу");
}
}
}
}
}
}
