/// <summary> /// Gets the total time spended on TS3 for specified clients. /// </summary> /// <param name="clientDatabaseIds">The client database ids.</param> /// <param name="fromTime">From time.</param> /// <param name="toTime">To time.</param> /// <returns></returns> public Dictionary<uint, double> GetTime(IEnumerable<uint> clientDatabaseIds, DateTime? fromTime, DateTime? toTime) { lock (Container.lockTimeClientList) { lock (Repository.Container.lockDatabase) { var times = new List<TimeClientEntity>(); using (var command = new SQLiteCommand(this.Container.DatabaseConnection)) { command.CommandText = string.Format("SELECT ClientDatabaseId, Joined, Disconnected, TotalMinutes FROM Time WHERE ClientDatabaseId IN ({0})", string.Join(", ", clientDatabaseIds)); if (fromTime.HasValue) command.CommandText += string.Format(" AND Disconnected > {0}", fromTime.Value.ToTimeStamp()); if (toTime.HasValue) command.CommandText += string.Format(" AND Joined < {0}", toTime.Value.ToTimeStamp()); using (var reader = command.ExecuteReader()) { while (reader.HasRows && reader.Read()) { times.Add(new TimeClientEntity { User = (uint)reader.GetInt32(0), Joined = reader.GetInt32(1).ToDateTime(), Disconnected = reader.GetInt32(2).ToDateTime(), TotalMinutes = reader.GetInt32(3) }); } } } return times.GroupBy(m => m.User).ToDictionary(g => (uint)g.Key, g => g.Sum(m => m.GetTime(fromTime, toTime))); } } }