/// <summary>
/// this convert function specially for the convertion of the element tags to metric
/// these are the virtual metrics on the bases of tags
///
/// </summary>
/// <param name="tbl_tag_element"></param>
/// <returns></returns>
public static IList <MetricDTO> Convert_Tag_Element_Table_To_DTO(tblTagElement tbl_tag_element)
{
IList <MetricDTO> list_dto_metric = new List <MetricDTO>();
try
{
MetricDTO dto_metric;
IList <TagDTO> element_tags = new List <TagDTO> {
TagDTO.ConvertTableToDTO(tbl_tag_element.tblTag)
};
foreach (Rollup_Function_Option rollup_function in Enum.GetValues(typeof(Rollup_Function_Option)))
{
try
{
dto_metric = new MetricDTO();
dto_metric.Id = metric_id;
dto_metric.Metric_Name = string.Concat(rollup_function.ToString(), " ", element_tags.First().Tag_Type_Value);
dto_metric.Metric_Type = MetricType.System.ToString();
dto_metric.Source = null;
dto_metric.Tags = element_tags;
dto_metric.Rollup_Function = rollup_function;
list_dto_metric.Add(dto_metric);
metric_id--;
}
catch { }
}
}
catch { }
return(list_dto_metric);
}
/// <summary>
///
/// </summary>
/// <param name="TagElementTbl"></param>
/// <returns></returns>
public static TagElementDTO ConvertTableToDTO(tblTagElement TagElementTbl)
{
TagElementDTO objTagElementDTO = new TagElementDTO();
objTagElementDTO.ID = TagElementTbl.ID;
objTagElementDTO.TagValue = TagElementTbl.Value;
objTagElementDTO.Tag = TagDTO.ConvertTableToDTO(TagElementTbl.tblTag);
objTagElementDTO.Element = ElementDTO.ConvertTableToDTO(TagElementTbl.tblElement);
return(objTagElementDTO);
}
/// <summary>
///
/// </summary>
/// <param name="TagElementTbl"></param>
/// <returns></returns>
public static tblTagElement ConvertDTOToTbl(TagElementBaseDTO TagElementDTO)
{
tblTagElement TagElementTbl = new tblTagElement();
TagElementTbl.ID = TagElementDTO.ID;
TagElementTbl.Value = TagElementDTO.TagValue;
if (TagElementDTO.Tag != null)
{
TagElementTbl.tblTag = TagDTO.ConvertDTOtoTable(TagElementDTO.Tag);
}
return(TagElementTbl);
}
/// <summary>
/// Single Convertion of DTO to Database Table, this is used normally for when update the record in database
/// </summary>
/// <param name="tagDTO"></param>
/// <param name="tagsTable"></param>
public static void ConvertDTOtoTable(TagDTO tagDTO, ref tblTag tagsTable)
{
try
{
tagsTable.ID = tagDTO.ID;
tagsTable.Tag_Kind = tagDTO.Tag_Kind.ToString();
tagsTable.Tag_Type = tagDTO.Tag_Type.ToString();
tagsTable.Tag_Value = tagDTO.Tag_Value;
tagsTable.Is_Disabled = tagDTO.Is_Disabled;
tagsTable.tblDescription = DescriptionConvert.DescriptionConvertDTOToTbl(tagDTO.TagName);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Single Convertion of Database Table to DTO
/// </summary>
/// <param name="tagTbl"></param>
/// <returns type ="TagDTO" ></returns>
public static TagDTO ConvertTableToDTO(tblTag tagTbl)
{
TagDTO tagsDTO = new TagDTO();
try
{
tagsDTO.ID = tagTbl.ID;
tagsDTO.Tag_Kind = (TagKind)Enums.TryParse(typeof(TagKind), tagTbl.Tag_Kind);
tagsDTO.Tag_Type = (TagType)Enums.TryParse(typeof(TagType), tagTbl.Tag_Type);
tagsDTO.Tag_Value = tagTbl.Tag_Value;
tagsDTO.Is_Disabled = tagTbl.Is_Disabled;
if (tagTbl.tblDescription != null)
{
tagsDTO.TagName = DescriptionConvert.DescriptionConvertDTOToTbl(tagTbl.tblDescription);
}
return(tagsDTO);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="objElementTable"></param>
/// <returns></returns>
public static ElementDTO ConvertTableToDTO(tblElement objElementTable)
{
ElementDTO objElementDTO = new ElementDTO();
objElementDTO.ID = objElementTable.ID;
if (objElementTable.tblConnector != null)
{
//objElementDTO.Connector_Live = ConnectorDTO.ConvertTableToDTO(objElementTable.tblConnector);
objElementDTO.ConnectionInfo = ExistingConnectionNameDTO.ConvertTableToDTO(objElementTable.tblConnector);
}
else if (objElementTable.tblConnector1 != null)
{
//objElementDTO.Connector_History = ConnectorDTO.ConvertTableToDTO(objElementTable.tblConnector1);
objElementDTO.ConnectionInfo = ExistingConnectionNameDTO.ConvertTableToDTO(objElementTable.tblConnector1);
}
objElementDTO.Element_Name = objElementTable.Element_Name;
objElementDTO.Source_Element_Name_History = objElementTable.Source_Element_Name_History;
objElementDTO.Source_Element_Name_Live = objElementTable.Source_Element_Name_Live;
objElementDTO.Is_Disabled = objElementTable.Is_Disabled;
//IT does not required for the presentation layer
//objElementDTO.TagElements = TagElementBaseDTO.ConvertTableToDTO(objElementTable.tblTagElements);
objElementDTO.Tags = TagDTO.ConvertTableToDTO(objElementTable.tblTagElements);
objElementDTO.Parent_Element_ID = objElementTable.Parent_Element_ID;
if (objElementTable.tblElement1 != null)
{
objElementDTO.HasChildren = true;
}
// objElementDTO.Parent_Element = ConvertTableListToDTOList(objElementTable.tblElement1);
objElementDTO.Element_Tag_Type = (TagType)Enums.TryParse(typeof(TagType), objElementTable.Element_Tag_Type.ToString()); // (TagType)Enum.Parse(typeof(TagType), objElementTable.Element_Tag_Type); //TagType.Site
objElementDTO.Unit = Unit_Of_Measurement_DTO.Convert_Table_To_DTO(objElementTable.tblUnit);
objElementDTO.Freq = objElementTable.Freq;
objElementDTO.Recorded_Freq = objElementTable.Recorded_Freq;
if (objElementTable.Freq_Unit != null)
{
if (Enum.IsDefined(typeof(Time_Unit), objElementTable.Freq_Unit))
{
objElementDTO.Freq_Unit = (Time_Unit)Enum.Parse(typeof(Time_Unit), objElementTable.Freq_Unit);
}
}
if (objElementTable.Recorded_Freq_Unit != null)
{
if (Enum.IsDefined(typeof(Time_Unit), objElementTable.Recorded_Freq_Unit))
{
objElementDTO.Recorded_Freq_Unit = (Time_Unit)Enum.Parse(typeof(Time_Unit), objElementTable.Recorded_Freq_Unit);
}
}
if (objElementTable.Data_Type != null)
{
if (Enum.IsDefined(typeof(Data_Formate), objElementTable.Data_Type))
{
objElementDTO.Data_Type = (Data_Formate)Enum.Parse(typeof(Data_Formate), objElementTable.Data_Type);
}
}
if (objElementTable.Value_Type != null)
{
if (Enum.IsDefined(typeof(DataValueType), objElementTable.Value_Type))
{
objElementDTO.Value_Type = (DataValueType)Enum.Parse(typeof(DataValueType), objElementTable.Value_Type);
}
}
objElementDTO.Min_Value = objElementTable.Min_Value;
objElementDTO.Max_Value = objElementTable.Max_Value;
objElementDTO.IsRead_Only = objElementTable.IsRead_Only;
return(objElementDTO);
}
