/* * Other Functions */ public static DataToSendNotification[] GetNotificationData(int user_id) { var numRows = GetNumNotifications(user_id); var data = new DataToSendNotification[numRows]; var command = new SqliteCommand("SELECT * FROM Notifications WHERE USER_ID=@user_id AND SEEN=0", conn); command.Parameters.Add(new SqliteParameter("@user_id", user_id)); var reader = command.ExecuteReader(); var i = 0; while (reader.Read()) { //Console.WriteLine(reader["MESSAGE"]); data[i] = new DataToSendNotification(); data[i].type = "notification"; data[i].senderName = GetUsername(reader["SENDER_ID"].ToString()); data[i].roomName = GetRoomName(reader["ROOM_ID"].ToString()); data[i].timestamp = reader["TIMESTAMP"].ToString(); data[i].notificationId = Convert.ToInt32(reader["ID"].ToString()); i++; } return(data); }
async Task SendNotification(int notifiedUser_id, string senderName, int room_id, string timestamp, int notification_id) { var dataToSend = new DataToSendNotification(); dataToSend.type = "notification"; dataToSend.senderName = senderName; dataToSend.roomName = DBHandler.GetRoomName(room_id); dataToSend.timestamp = timestamp; dataToSend.notificationId = notification_id; await SendDataToUser(dataToSend, notifiedUser_id); }