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("Ошибка подключения к серверу"); } } } } } }