public void RemoveUserMetricEntry(UserMetricEntry entry) { string q = "delete usermetricentry where id = @id"; var p = new { id = entry.Id }; ExecuteNonQuery(q, p); }
public void AddUserMetricEntry(UserMetricEntry entry) { string q = "insert into usermetricentry (userid, metricid, entrytimestamp, numericalvalue, textvalue) values (@userid, @metricid, @entrytimestamp, @numericalvalue, @textvalue)"; var p = new { userid = entry.UserId, metricid = entry.Metric.Id, entrytimestamp = entry.EntryTimestamp, numericalvalue = entry.NumericalValue, textValue = entry.TextValue }; ExecuteNonQuery(q, p); }
public void RemoveUserMetricEntry(UserMetricEntry entry) { _dataProvider.RemoveUserMetricEntry(entry); }
public void AddUserMetricEntry(UserMetricEntry entry) { _dataProvider.AddUserMetricEntry(entry); }