/// <summary> /// Gets the total time spended on TS3 for specified client. /// </summary> /// <param name="clientDatabaseId">The client database id.</param> /// <param name="fromTime">From time.</param> /// <param name="toTime">To time.</param> /// <returns></returns> public double GetTime(uint clientDatabaseId, 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 = {0}", clientDatabaseId); 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.Sum(m => m.GetTime(fromTime, toTime)); } } }