public void Enqueue(IdleTimeInfo idle_time)
{
IdleTimeInfo already_existent_idle_time;
if (!dao_.GetIdleTimeAtTime(idle_time.Timestamp,
out already_existent_idle_time)) {
dao_.AddIdleTime(idle_time);
}
}
public bool Execute(out IdleTimeInfo idle_time_info)
{
using (SqlCeConnection conn = sql_connection_provider_.CreateConnection())
using (var builder = new CommandBuilder(conn)) {
IDbCommand cmd = builder
.SetText(kExecute)
.SetType(CommandType.Text)
.Build();
try {
conn.Open();
using (IDataReader reader = cmd.ExecuteReader()) {
return mapper_.Map(reader, out idle_time_info);
}
} catch (SqlException e) {
logger_.Error(
StringResources.Log_MethodThrowsException.Fmt("Execute", kClassName),
e);
throw new ProviderException(e);
}
}
}
public void Execute(IdleTimeInfo idle_time_info)
{
using (SqlCeConnection conn = sql_connection_provider_.CreateConnection())
using (var builder = new CommandBuilder(conn)) {
IDbCommand cmd = builder
.SetText(kExecute)
.SetType(CommandType.Text)
.AddParameter("@lastInputTime", idle_time_info.LastInputTime)
.AddParameter("@machineUpTime", idle_time_info.MachineUpTime)
.AddParameter("@timestamp", idle_time_info.Timestamp)
.Build();
try {
conn.Open();
cmd.ExecuteNonQuery();
} catch (SqlCeException e) {
logger_.Error(
StringResources.Log_MethodThrowsException.Fmt("Execute", kClassName),
e);
throw new ProviderException(e);
}
}
}
public bool Pick(out IdleTimeInfo idle_info_time)
{
return dao_.GetOldestIdleTime(out idle_info_time);
}
public bool GetOldestIdleTime(out IdleTimeInfo idle_time)
{
return new OldestIdleTimeQuery(sql_ce_connection_provider_)
.Execute(out idle_time);
}
public bool GetIdleTimeAtTime(long timestamp, out IdleTimeInfo idle_time)
{
return new IdleTimeAtTimeQuery(sql_ce_connection_provider_)
.Execute(timestamp, out idle_time);
}
public void AddIdleTime(IdleTimeInfo idle_time_info)
{
new AddIdleTimeQuery(sql_ce_connection_provider_)
.Execute(idle_time_info);
}
