private int Insert(FriendResquestNotExcept request)
{
lock (synlock)
{
var db = new FriendRequestNotExceptDAOSQL();
return(db.Insert(request));
}
}
private int DeleteRecord(FriendResquestNotExcept request)
{
lock (synlock)
{
var db = new FriendRequestNotExceptDAOSQL();
return(db.DeleteByMe(request));
}
}
private int Delete(FriendResquestNotExcept request)
{
lock (this)
{
var db = new FriendRequestNotExceptDAOSQL();
return(db.DeleteByMe(request));
}
}
public int DeleteByMe(FriendResquestNotExcept request)
{
try
{
Connect();
var sql = "DELETE FROM FriendRequest WHERE Sender = '" + request.Sender + "'AND Receiver = '" + request.Receiver + "'";
return(con.ExecuteNonQuery(sql));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
con.Disconnect();
}
}
public int Insert(FriendResquestNotExcept requets)
{
try
{
Connect();
var sql = "INSERT INTO FriendRequest VALUES ('" + requets.Sender + "','" + requets.Receiver + "','" + requets.Time + "')";
return(con.ExecuteNonQuery(sql));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
con.Disconnect();
}
}
public string Handling(IProtocol protocol, IChatClient client)
{
var ptc = protocol as AskBeFriendRequestProtocol;
var toView = new ToViewStringFormat(DateTime.Now, client.GetEndPoint().ToString(), ptc.SenderEmail, "Send a friend requset to user[" + ptc.ReceiverEmail + "]");
try
{
var request = new FriendResquestNotExcept(ptc.SenderEmail, ptc.ReceiverEmail, DateTime.Now);
Insert(request);
toView.Message += "\n insert request successful";
}
catch (Exception ex)
{
toView.Message += "\n insert request to db Failed \n detail : " + ex.Message;;
return(toView.ToString());
}
IChatClient _client = null;
if (Instance.OnlineUser.TryGetValue(ptc.ReceiverEmail, out _client))
{
_client.ResponseGetListUserRequestAddFriend(ListRequestOfUser(ptc.ReceiverEmail));
toView.Message += " send friend request successful!";
}
var accounts = new List <Account>();
try
{
accounts = GetRequestIAsk(ptc.SenderEmail);
}
catch (Exception ex)
{
toView.Message += "error get list user from db \n detail : " + ex.Message;
return(toView.ToString());
}
client.ResponseGetListUserIRequestAddFriend(accounts);
return(toView.ToString());
}
public int Delete(FriendResquestNotExcept request)
{
throw new NotImplementedException();
}
