public string GetAllMessages(string username, string chatUser) { JSonResult result = new JSonResult(); result.Status = false; List<GetMessages> allMessages = new List<GetMessages>(); Chat chat = new Chat(); Users user = new Users(); Guid guid; user.GetUserGuid(username, out guid); Guid chatUserGuid; user.GetUserGuid(chatUser, out chatUserGuid); DataSet ds = chat.GetAllMessages(guid, chatUserGuid); foreach (DataRow dr in ds.Tables[0].Rows) { GetMessages message = new GetMessages(); message.FromUser = dr["FromUser"].ToString(); message.Message = dr["Comment"].ToString(); message.Time = dr["ChatingTime"].ToString(); allMessages.Add(message); } result.Status = true; JavaScriptSerializer serializer = new JavaScriptSerializer(); string jsonresult = serializer.Serialize(allMessages); return jsonresult; }
public bool CreateNewUser(string username, string password) { bool isUserExists = CheckUserExist(username); if (!isUserExists) { Guid guid = Guid.NewGuid(); string sqlQuery1 = "INSERT INTO Users (UserId, UserName, LUserName, LastActivityDate) VALUES" + "('{0}','" + username + "','" + username.ToLower() + "'" + ",GETDATE())"; string sqlQuery2 = "INSERT INTO Membership (UserId, Password, CreateDate) VALUES" + "('{0}','" + password + "', GETDATE())"; SQLExecuteBase obj = DataAccessService.Instance.SQLExecuteBase; SqlConnection sqlConn = obj.CreateConnection(DataAccessService.Instance.SQLAccess.ConnectionString); int rowsAffected = (int)obj.ExecuteNonQuery(sqlConn, String.Format(sqlQuery1, guid)); if (rowsAffected != 0) { int passwordCreatedCount = (int)obj.ExecuteNonQuery(sqlConn, String.Format(sqlQuery2, guid)); if (passwordCreatedCount != 0) { Chat chat = new Chat(); chat.CreateOnlineUsers(guid); return true; } } } return false; }
public bool CheckUserAndPasswordValid(string username, string password) { string sqlQuery1 = "SELECT UserId FROM Users WHERE UserName = '******'"; string sqlQuery2 = "SELECT Count(*) FROM Membership WHERE UserId = '{0}' and Password = '******'"; SQLExecuteBase obj = DataAccessService.Instance.SQLExecuteBase; SqlConnection sqlConn = obj.CreateConnection(DataAccessService.Instance.SQLAccess.ConnectionString); object guidobj = obj.ExecuteScalar(sqlConn, sqlQuery1); if (guidobj != null) { Guid guid; Guid.TryParse(guidobj.ToString(), out guid); if (guid != Guid.Empty) { int count = (int)obj.ExecuteScalar(sqlConn, String.Format(sqlQuery2, guid)); if (count > 0) { Chat chat = new Chat(); chat.CreateOnlineUsers(guid); return true; } } } return false; }
public string SendMessage(string fromUser, string toUser, string message) { JSonResult result = new JSonResult(); result.Status = false; Users obj = new Users(); Guid fromUserId, toUserId; obj.GetUserGuid(toUser, out toUserId); obj.GetUserGuid(fromUser, out fromUserId); Chat chat = new Chat(); result.Status = chat.SendMessage(fromUserId, toUserId, message); JavaScriptSerializer serializer = new JavaScriptSerializer(); string jsonresult = serializer.Serialize(result.Status); return jsonresult; }
public string GetAllOnlineUsers() { JSonResult result = new JSonResult(); result.Status = false; List<OnlineUser> onlineUsers = new List<OnlineUser>(); Chat chat = new Chat(); List<OnlineUser> ou = new List<OnlineUser>(); DataSet allUsersDataset = chat.GetAllOnlineUsers(); foreach (DataRow dr in allUsersDataset.Tables[0].Rows) { onlineUsers.Add (new OnlineUser(dr[0].ToString(), dr[1].ToString())); ou.Add(new OnlineUser(dr[0].ToString(), dr[1].ToString())); } result.Status = true; JavaScriptSerializer serializer = new JavaScriptSerializer(); string jsonresult = serializer.Serialize(ou); return jsonresult; }
public bool GetUserGuid(string username, out Guid guid) { string sqlQuery1 = "SELECT UserId FROM Users WHERE UserName = '******'"; SQLExecuteBase obj = DataAccessService.Instance.SQLExecuteBase; SqlConnection sqlConn = obj.CreateConnection(DataAccessService.Instance.SQLAccess.ConnectionString); Object o = obj.ExecuteScalar(sqlConn, sqlQuery1); if (o != null) { guid = (Guid)o; Chat chat = new Chat(); chat.CreateOnlineUsers(guid); return true; } guid = new Guid(); return false; }