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"); } }