public string FollowOKUsers(string SearchUserName, string Email)
{
//string UserName = "******";
//string PassWord = "******";
//string SelfEmail = "*****@*****.**";
string SelfEmail = Session["Email"].ToString();
string PassWord = Session["PassWord"].ToString();
string UserName = Session["UserName"].ToString();
using (剧享网Entities db = new 剧享网Entities())
{
//查找被关注人的Id
var selectBeFollowerUser = from info in db.T_User where info.U_UserName == SearchUserName && info.U_Email == Email select info;
int BeFollowerU_Id = 0;
foreach (var info in selectBeFollowerUser)
{
BeFollowerU_Id = info.U_Id;
}
//获取当前用户的Id
var selectCurrentUser = from info in db.T_User where info.U_UserName == UserName && info.U_Email == SelfEmail && info.U_UserPassWord == PassWord select info;
int FollowerU_Id = 0;
foreach (var info in selectCurrentUser)
{
FollowerU_Id = info.U_Id;
}
//关注自己判断
if (FollowerU_Id == BeFollowerU_Id)
{
return("Laugh");
}
//关注的时间
string FollowTime = Convert.ToString(DateTime.Now);
//先找关注表是否有对应关注信息了
int FollowCount = (from info in db.T_FollowUsers where info.F_FollowerId == FollowerU_Id && info.F_BeFollowerId == BeFollowerU_Id select info).Count();
if (FollowCount > 0)
{
return("Followed");
}
//保存数据
T_FollowUsers followUsers = new T_FollowUsers();
followUsers.F_FollowerId = FollowerU_Id;
followUsers.F_BeFollowerId = BeFollowerU_Id;
followUsers.F_FollowTime = FollowTime;
db.T_FollowUsers.Add(followUsers);
db.SaveChanges();
//通知被关注者关注信息,W_Id依旧是0，类似系统通知，作品名是null
ManagerController manager = new ManagerController();
manager.NotifyInfo("关注了你", SearchUserName, 0, UserName, null);
return("Success");
}
}
public string FollowOverUsers(string SearchUserName, string Email)
{
//string UserName = "******";//session["UserName"]
//string SelfEmail = "*****@*****.**";//session["Email"]
//string PassWord = "******";//session["PassWord"]
string SelfEmail = Session["Email"].ToString();
string PassWord = Session["PassWord"].ToString();
string UserName = Session["UserName"].ToString();
using (剧享网Entities db = new 剧享网Entities())
{
//查找被关注人的Id
var selectBeFollowerUser = from info in db.T_User where info.U_UserName == SearchUserName && info.U_Email == Email select info;
int BeFollowerU_Id = 0;
foreach (var info in selectBeFollowerUser)
{
BeFollowerU_Id = info.U_Id;
}
//获取当前用户的Id
var selectCurrentUser = from info in db.T_User where info.U_UserName == UserName && info.U_Email == SelfEmail && info.U_UserPassWord == PassWord select info;
int FollowerU_Id = 0;
foreach (var info in selectCurrentUser)
{
FollowerU_Id = info.U_Id;
}
//先找关注表是否有对应关注信息了
int FollowCount = (from info in db.T_FollowUsers where info.F_FollowerId == FollowerU_Id && info.F_BeFollowerId == BeFollowerU_Id select info).Count();
if (FollowCount <= 0)
{
return("NoneFollow");
}
//获取对应关注信息的自增ID
var GetId = from info in db.T_FollowUsers where info.F_FollowerId == FollowerU_Id && info.F_BeFollowerId == BeFollowerU_Id select info;
//通过ID，删除的对应数据
int DeleteId = 0;
foreach (var info in GetId)
{
DeleteId = info.F_Id;
}
//先实例化表的对象
T_FollowUsers followUsers = new T_FollowUsers();
//接着绑定该ID
followUsers = db.T_FollowUsers.Find(DeleteId);
//然后删除该ID对应的信息
db.T_FollowUsers.Remove(followUsers);
//最后保存操作即可
db.SaveChanges();
return("Success");
}
}
