public static void AddMetric(Metrics metric, string valueAsString, double?valueAsNumber, DateTime?valueAsDateTime) { string cdmProcessingConnectionStrings = null; if (ConfigurationManager.ConnectionStrings["CDM_Processing"] != null) { cdmProcessingConnectionStrings = ConfigurationManager.ConnectionStrings["CDM_Processing"].ConnectionString; } if (Settings.Current.Building.LoadId <= 0 || string.IsNullOrEmpty(cdmProcessingConnectionStrings)) { return; } var dbProcessing = new DBProcessing(cdmProcessingConnectionStrings); dbProcessing.InsertMetric(Settings.Current.Building.LoadId, metric, valueAsString, valueAsNumber, valueAsDateTime); }
private static void AddMetric(Metrics metric, DateTime?start, DateTime?end, double?valueAsNumber) { var loadId = Settings.Current.Building.LoadId; string cdmProcessingConnectionStrings = null; if (ConfigurationManager.ConnectionStrings["CDM_Processing"] != null) { cdmProcessingConnectionStrings = ConfigurationManager.ConnectionStrings["CDM_Processing"].ConnectionString; } if (loadId <= 0 || string.IsNullOrEmpty(cdmProcessingConnectionStrings)) { return; } var dbProcessing = new DBProcessing(cdmProcessingConnectionStrings); if (start.HasValue && end.HasValue) { var elapsedTime = end.Value.Subtract(start.Value); var valueAsString = string.Format("{0}:{1}:{2}", (int)elapsedTime.TotalHours, elapsedTime.Minutes > 9 ? elapsedTime.Minutes.ToString(CultureInfo.InvariantCulture) : "0" + elapsedTime.Minutes, elapsedTime.Seconds > 9 ? elapsedTime.Seconds.ToString(CultureInfo.InvariantCulture) : "0" + elapsedTime.Seconds); dbProcessing.AddMetric(loadId, metric, valueAsString, null, DateTime.Now); } if (valueAsNumber.HasValue) { dbProcessing.AddMetric(loadId, metric, "", valueAsNumber, DateTime.Now); } }