public void PostUsageTime(UsageTime usage)
{
UsageTimeModel model = new UsageTimeModel();
model.UserId = usage.User.Id;
model.ActiveMinutes = usage.ActiveMinutes;
model.IdleMinutes = usage.IdleMinutes;
model.StartTime = usage.StartTime;
model.EndTime = usage.EndTime;
GlobalConfig.Connection.UsageTime_Insert(model);
}
public void UsageTime_Insert(UsageTimeModel model)
{
using (IDbConnection connection = new SqlConnection(GlobalConfig.CnnString(databaseName)))
{
var p = new DynamicParameters();
p.Add("@ActiveMinutes", model.ActiveMinutes);
p.Add("@IdleMinutes", model.IdleMinutes);
p.Add("@StartTime", model.StartTime);
p.Add("@EndTime", model.EndTime);
p.Add("@UserId", model.UserId);
p.Add("@id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("spUsageTimes_Insert", p, commandType: CommandType.StoredProcedure);
model.Id = p.Get <int>("@id");
}
}
