/// <summary>
/// This is the special Converstion method for when needs create a metric from the element
/// </summary>
/// <param name="Element_ID"></param>
/// <param name="Element_Name"></param>
/// <returns></returns>
public static tblMetric Convert_DTO_To_Table(long Element_ID, string Element_Name, int?Unit_Id, Rollup_Function_Option rollup_function_option)
{
tblMetric tbl_Metric = new tblMetric();
try
{
tbl_Metric.Metric_Name = Element_Name + " - " + rollup_function_option.ToString();
//This is speical method to convert the class object into json.
//Convert_Object_To_Json In the database source save in json structure we have to convert the class object (TAG_DTO) to json object
tbl_Metric.Source = Helper.Convert_Object_To_Json(new Source_Json {
Points = new List <Point>()
{
new Point()
{
ElementId = Element_ID
}
}
});
tbl_Metric.Rollup_Function = rollup_function_option.ToString();
if (Unit_Id == null)
{
tbl_Metric.Unit_Id = 121;
}
else
{
tbl_Metric.Unit_Id = Convert.ToInt32(Unit_Id);
}
}
catch { }
return(tbl_Metric);
}
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;
}
}
public static tblMetric Convert_DTO_To_Table(MetricDTO metric_dto, ref tblMetric tbl_Metric)
{
try
{
tbl_Metric.Id = metric_dto.Id;
tbl_Metric.Metric_Name = metric_dto.Metric_Name;
//This is speical method to convert the class object into json.
//Convert_Object_To_Json In the database source save in json structure we have to convert the class object (TAG_DTO) to json object
tbl_Metric.Source = Helper.Convert_Object_To_Json(new Source_Json {
Tags = metric_dto.Tags.Select(tag => new Tag {
TagID = tag.ID
}).ToList()
});
tbl_Metric.Rollup_Function = metric_dto.Rollup_Function.ToString();
tbl_Metric.Unit_Id = metric_dto.Unit_Id;
}
catch { }
return(tbl_Metric);
}
//public static IList<MetricDTO> Convert_List_Table_To_List_DTO(IEnumerable<tblMetric> tbl_Metrics)
//{
// IList<MetricDTO> list_metric_dto = new List<MetricDTO>();
// foreach(tblMetric tbl_Metric in tbl_Metrics)
// {
// //list_metric_dto.Add(Convert_Table_To_DTO(tbl_Metric));
// }
// return list_metric_dto;
//}
/// <summary>
///
/// </summary>
/// <param name="tbl_Metric"></param>
/// <returns></returns>
private static MetricDTO Convert_Table_To_DTO(tblMetric tbl_Metric, IList <TagDTO> tag_dto, IList <ElementDTO> element_dto)
{
MetricDTO dto_metric = new MetricDTO();
try
{
dto_metric.Id = tbl_Metric.Id;
dto_metric.Metric_Name = tbl_Metric.Metric_Name;
dto_metric.Metric_Type = MetricType.User.ToString();
dto_metric.Source = Source_Json.Convert_Json_To_Source_Json(tbl_Metric.Source);
dto_metric.Tags = tag_dto;
dto_metric.Elements = element_dto;
dto_metric.Rollup_Function = (Rollup_Function_Option)Enums.TryParse(typeof(Rollup_Function_Option), tbl_Metric.Rollup_Function.ToString());
dto_metric.Unit = Unit_Of_Measurement_DTO_Convert.Convert_Table_To_DTO(tbl_Metric.tblUnit);
dto_metric.Unit_Id = tbl_Metric.Unit_Id;
}
catch { }
return(dto_metric);
}
