public void Save_Metric(MetricDTO metric_dto)
{
try
{
_dbcontext.tblMetrics.Add(MetricDTO.Convert_DTO_To_Table(metric_dto));
_dbcontext.SaveChanges();
}
catch (Exception ex) { throw ex; }
}
public void Update_Metric(MetricDTO metric_dto)
{
try
{
tblMetric tbl_Metric = _dbcontext.tblMetrics.Single(metric => metric.Id == metric_dto.Id);
MetricDTO.Convert_DTO_To_Table(metric_dto, ref tbl_Metric);
_dbcontext.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// This is use for auto metric geration when the element add in to the structure only for the history point not for the Live point.
/// </summary>
/// <param name="tbl_Element"></param>
public void Save_Metric(IEnumerable <tblElement> tbl_Elements)
{
try
{
foreach (var tbl_Element in tbl_Elements)
{
try
{
//create matric only for the history points
if (tbl_Element.Connector_Live_ID == null)
{
_dbcontext.tblMetrics.Add(MetricDTO.Convert_DTO_To_Table(tbl_Element.ID, tbl_Element.Element_Name, tbl_Element.Unit_ID, Rollup_Function_Option.SUM));
_dbcontext.tblMetrics.Add(MetricDTO.Convert_DTO_To_Table(tbl_Element.ID, tbl_Element.Element_Name, tbl_Element.Unit_ID, Rollup_Function_Option.MAX));
_dbcontext.tblMetrics.Add(MetricDTO.Convert_DTO_To_Table(tbl_Element.ID, tbl_Element.Element_Name, tbl_Element.Unit_ID, Rollup_Function_Option.MIN));
_dbcontext.tblMetrics.Add(MetricDTO.Convert_DTO_To_Table(tbl_Element.ID, tbl_Element.Element_Name, tbl_Element.Unit_ID, Rollup_Function_Option.AVG));
}
}
catch (Exception ex) { throw ex; }
}
_dbcontext.SaveChanges();
}
catch (Exception ex) { }
}
