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(); }