private SqlJobMetricViewModel build_sql_job_metric_view_model(SqlJobMetrics metric)
{
var metric_view_model = new SqlJobMetricViewModel();
metric_view_model.job_name = metric.job_name;
metric_view_model.last_run = metric.last_run.ToString("M.d.yyyy h:mm");
metric_view_model.message = metric.message;
metric_view_model.job_step = metric.job_step.ToString();
return metric_view_model;
}
SqlJobMetrics build_sql_job_metric_from_reader(SqlDataReader reader)
{
var metric = new SqlJobMetrics();
metric.job_name = reader.GetString(0);
metric.message = reader.GetString(1);
var job_outcome_key = reader.GetByte(2);
metric.job_status = get_job_outcome_from_key(job_outcome_key);
metric.last_run = reader.GetDateTime(3);
metric.job_step = reader.GetInt16(4);
return metric;
}