/// <summary>
/// 设置首次登录信息
/// </summary>
/// <param name="conn"></param>
/// <param name="id"></param>
/// <param name="nickName"></param>
/// <returns></returns>
public static bool SetFirstLoginInformationById(int id, string nickName)
{
try
{
using (BeMyMouthDB db = new BeMyMouthDB())
{
foreach (var user in db.Users)
{
if (user.Id == id)
{
user.NickName = nickName;
user.IsFirstLogin = false;
break;
}
}
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
Console.WriteLine("当SetFirstLoginInformationById时出现异常：" + e);
return(false);
}
}
/// <summary>
/// 获取聊天消息
/// </summary>
/// <param name="sendId"></param>
/// <returns></returns>
public static string GetReciveMessage(int sendId)
{
StringBuilder sb = new StringBuilder();
try
{
using (BeMyMouthDB db = new BeMyMouthDB())
{
foreach (var mes in db.Messages)
{
if (mes.SendId == sendId && mes.HasRead == false)
{
sb.Append(mes.SendId + ',');
}
}
}
if (sb.Length > 0)
{
sb.Remove(sb.Length - 1, 1);
}
return(sb.ToString());
}
catch (Exception e)
{
Console.WriteLine("当GetReciveMessage时出现异常：" + e);
return(null);
}
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static bool ModifyUserInfo(int id, string username, string password)
{
try
{
using (BeMyMouthDB db = new BeMyMouthDB())
{
var user = db.Users.Where(u => u.Id == id).FirstOrDefault();
if (user != null)
{
if (username != string.Empty)
{
user.NickName = username;
}
if (password != string.Empty)
{
user.Password = password;
}
}
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
Console.WriteLine("创建用户失败");
return(false);
}
}
/// <summary>
/// 验证用户信息
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static bool VerifyUserInfo(string username, string password)
{
using (BeMyMouthDB db = new BeMyMouthDB())
{
foreach (var user in db.Users)
{
if (user.UserName.Equals(username) && user.Password.Equals(password))
{
return(true);
}
}
}
return(false);
}
/// <summary>
/// 验证信息是否存在
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public static bool VerifyExist(string username)
{
using (BeMyMouthDB db = new BeMyMouthDB())
{
foreach (var user in db.Users)
{
if (user.UserName.Equals(username))
{
return(true);
}
}
}
return(false);
}
/// <summary>
/// 根据用户ID获取昵称
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static string GetNickNameById(int id)
{
using (BeMyMouthDB db = new BeMyMouthDB())
{
foreach (var user in db.Users)
{
if (user.Id == id)
{
return(user.NickName);
}
}
}
return(string.Empty);
}
/// <summary>
/// 根据用户名获取UserModel
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public static User GetUserInfoByUserName(string username)
{
using (BeMyMouthDB db = new BeMyMouthDB())
{
foreach (var user in db.Users)
{
if (user.UserName.Equals(username))
{
return(user);
}
}
}
return(null);
}
/// <summary>
/// 保存消息
/// </summary>
public static void SavaMessage(string message, int sendId, int reciveId, DateTime dateTime)
{
try
{
Messages messages = new Messages()
{
Message = message,
SendId = sendId,
ReciveId = reciveId,
};
using (BeMyMouthDB db = new BeMyMouthDB())
{
db.Messages.Add(messages);
db.SaveChanges();
}
}
catch (Exception e)
{
}
}
/// <summary>
/// 通过ID添加好友
/// </summary>
/// <param name="friendId"></param>
/// <param name="selfId"></param>
/// <returns></returns>
public static bool AddFriendById(int friendId, int selfId)
{
try
{
using (BeMyMouthDB db = new BeMyMouthDB())
{
Friend friend = new Friend()
{
LeftId = friendId,
RightId = selfId
};
db.Friends.Add(friend);
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
return(false);
}
}
/// <summary>
/// 通过昵称获取用户数据
/// </summary>
/// <param name="nickname"></param>
/// <returns></returns>
public static string GetUsersByNickname(string nickname)
{
try
{
using (BeMyMouthDB db = new BeMyMouthDB())
{
foreach (var user in db.Users)
{
if (user.NickName.Contains(nickname))
{
return(user.UserName);
}
}
}
return(string.Empty);
}
catch (Exception e)
{
return(string.Empty);
}
}
/// <summary>
///获取好友列表
/// </summary>
/// <param name="conn"></param>
/// <param name="id"></param>
/// <returns></returns>
public static string GetFriendsIdById(int id)
{
StringBuilder sb = new StringBuilder();
try
{
using (BeMyMouthDB db = new BeMyMouthDB())
{
User user = db.Users.Where((u) => u.Id == id).First();
foreach (var friend in db.Friends)
{
if (friend.LeftId == id)
{
sb.Append(friend.RightId.ToString());
sb.Append(',');
}
}
//foreach (var friend in db.Friends)
//{
// if (friend.RightId == id)
// {
// sb.Append(friend.LeftId.ToString());
// sb.Append(',');
// }
//}
}
if (sb.Length > 0)
{
sb.Remove(sb.Length - 1, 1);
}
return(sb.ToString());
}
catch (Exception e)
{
Console.WriteLine("当GetFriendsIdById时出现异常：" + e);
return(string.Empty);
}
}
public string SearchFriend(string name)
{
try
{
string str = string.Empty;
using (BeMyMouthDB db = new BeMyMouthDB())
{
foreach (var user in db.Users)
{
if (user.NickName.Contains(name))
{
str += user.NickName + ',';
}
}
}
return(str);
}
catch (Exception e)
{
Console.WriteLine("创建用户失败");
return(string.Empty);
}
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static bool AddUser(string username, string password)
{
try
{
using (BeMyMouthDB db = new BeMyMouthDB())
{
User user = new User()
{
UserName = username,
Password = password,
NickName = "用户007",
IsFirstLogin = true
};
db.Users.Add(user);
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
Console.WriteLine("创建用户失败");
return(false);
}
}