/// <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); }