public void GetChatHistory(String uid, String fid) { Chat _Chat = new Chat(uid, fid); SqlWrapper _SqlWrapper = new SqlWrapper(@"Server=tcp:yq6ulqknjf.database.windows.net,1433;Database=ModulesDB;User ID=rstyle@yq6ulqknjf;Password=Zxcv2345;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;"); DataTable _DataTable = _SqlWrapper.executeQuery(@"SELECT uid, fid, message, timestamp FROM chathistory WHERE chatID = '" + _Chat.ChatID + "'"); String strMessage; foreach (DataRow _DataRow in _DataTable.Rows) { String msg = _DataRow["message"].ToString(); String datetime = _DataRow["timestamp"].ToString(); //If this message is sent by me if (_DataRow["uid"].ToString() == uid) { strMessage = GetUIDChatString(msg, datetime); Clients.Caller.updateChat(strMessage); } else { strMessage = GetFIDChatString(msg, datetime, uid, fid); Clients.Caller.updateChat(strMessage); } } }
public void Send(String msg, String uid, String fid, String datetime) { Chat _Chat = new Chat(uid, fid); String strMessage; strMessage = GetFIDChatString(msg, datetime, uid, fid); //Clients.Others.updateChat(strMessage); Clients.OthersInGroup(_Chat.ChatID).updateChat(strMessage); strMessage = GetUIDChatString(msg, datetime); Clients.Caller.updateChat(strMessage); /* Add Message to DB */ SqlWrapper _SqlWrapper = new SqlWrapper(@"Server=tcp:yq6ulqknjf.database.windows.net,1433;Database=ModulesDB;User ID=rstyle@yq6ulqknjf;Password=Zxcv2345;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;"); _SqlWrapper.executeNonQuery(@"INSERT INTO ChatHistory (chatID, uid, fid, message, timestamp) VALUES ('" + _Chat.ChatID + "', '" + _Chat.UserID + "', '" + _Chat.FriendID + "', N'" + msg + "', '" + datetime + "')"); }
public void RegisterChatGroup(String uid, String fid) { Chat _Chat = new Chat(uid, fid); Groups.Add(Context.ConnectionId, _Chat.ChatID); }