public IList <RawDataDTO> Get_Raw_Data_By_Element_Id(long element_id)
{
try
{
tblElement tbl_element = _dbcontext.tblElements.Find(element_id);
if (tbl_element?.Connector_History_ID != null)
{
//Get connection information
int connection_id = (int)tbl_element.Connector_History_ID;
ConnectorDTO _dto_connector = _connector_rep.GetExistingConnectionById(connection_id);
InnonAnalyticsEngineEntities __dbcontext = new InnonAnalyticsEngineEntities();
IRawDataRepository _rawDataRepository = new RawDataRepository();
DateTime fromDate = DateTime.Now.AddMonths(-6);
DateTime ToDate = DateTime.Now;
return(_rawDataRepository.GetRowData(tbl_element.Source_Element_Name_History, fromDate, ToDate, _dto_connector, __dbcontext));
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public static tblElement ConvertDTOToTable(DiscoveryElementDTO objElementDTO, long parentId, long tagId)
{
tblElement objElementTable = new tblElement();
if (objElementDTO.ConnectionInfo.DataConnectorType == DataSouceConnectionType.Live)
{
objElementTable.Connector_Live_ID = objElementDTO.ConnectionInfo.ConnectionID;
objElementTable.Source_Element_Name_Live = objElementDTO.ElementSourceName;
}
else
{
objElementTable.Connector_History_ID = objElementDTO.ConnectionInfo.ConnectionID;
objElementTable.Source_Element_Name_History = objElementDTO.ElementSourceName;
}
objElementTable.Element_Name = objElementDTO.ElementSourceName;
objElementTable.Is_Disabled = false;
objElementTable.Parent_Element_ID = parentId;
//tblTagElement _tagelement = new tblTagElement();
//_tagelement.Tag_ID = tagId;
//objElementTable.tblTagElements.Add(_tagelement);
objElementTable.Element_Tag_Type = Enum.ToObject(typeof(TagType), tagId).ToString();
return(objElementTable);
}
public ElementDTO UpdateElement(ElementDTO elementDto)
{
if (elementDto == null)
{
throw new ElementException(Resources.ElementPointNotFound);
}
tblElement element = _dbcontext.tblElements.SingleOrDefault(e => e.ID == elementDto.ID);
if (element != null)
{
try
{
ElementDTO.ConvertDTOToTable(elementDto, ref element);
_dbcontext.SaveChanges();
//Refresh dbcontext
_dbcontext = new InnonAnalyticsEngineEntities();
element = _dbcontext.tblElements.SingleOrDefault(e => e.ID == elementDto.ID);
element.tblTagElements = element.tblTagElements.Where(d => d.Is_Deleted == false).ToList();
return(ElementDTO.ConvertTableToDTO(element));
}
catch (Exception ex)
{
throw ex;
}
}
else
{
throw new ElementException(Resources.ElementPointNotFound);
}
}
/// <summary>
///
/// </summary>
/// <param name="objElementDTO"></param>
/// <returns></returns>
public static tblElement ConvertDTOToTable(ElementDTO objElementDTO)
{
tblElement objElementTable = new tblElement();
if (objElementDTO.Connector_History != null)
{
objElementTable.Connector_History_ID = objElementDTO.Connector_History.ConnectionID;
}
if (objElementDTO.Connector_Live != null)
{
objElementTable.Connector_Live_ID = objElementDTO.Connector_Live.ConnectionID;
}
objElementTable.Element_Name = objElementDTO.Element_Name;
objElementTable.Element_Tag_Type = objElementDTO.Element_Tag_Type.ToString();
// objElementTable.tblTagElements = TagElementDTO.ConvertDTOToTbl(objElementDTO.TagElements);
objElementTable.Source_Element_Name_History = objElementDTO.Source_Element_Name_History;
objElementTable.Source_Element_Name_Live = objElementDTO.Source_Element_Name_Live;
objElementTable.Is_Disabled = objElementDTO.Is_Disabled;
objElementTable.Parent_Element_ID = objElementDTO.Parent_Element_ID;
return(objElementTable);
}
private void WriteLivePoint(LivePoint_DTO livepoint)
{
try
{
tblElement element = get_tblElement_by_Id(livepoint.Point_Id);
if (element == null)
{
throw new ArgumentNullException($"Invalid Element Id, No element found against this element ID {livepoint.Point_Id} ");
}
ILiveVariable liveVariable = new Obix(StringEncryDecry.Decrypt(element.tblConnector.Server_Name, element.tblConnector.SessionID),
StringEncryDecry.Decrypt(element.tblConnector.User_Name, element.tblConnector.SessionID),
StringEncryDecry.Decrypt(element.tblConnector.Password, element.tblConnector.SessionID));
if (livepoint.Current_Value.dValue.HasValue)
{
liveVariable.SetValueLiveVariable <decimal>(element.Source_Element_Name_Live, livepoint.Current_Value.dValue.Value);
}
else if (livepoint.Current_Value.bValue.HasValue)
{
liveVariable.SetValueLiveVariable <bool>(element.Source_Element_Name_Live, livepoint.Current_Value.bValue.Value);
}
}
catch (Exception ex)
{
throw ex;
}
}
private void ReadLivePoint(tblElement element, LivePoint_DTO livepoint)
{
if (element.tblConnector.Gateway_Type == DataGatewayType.Obix.ToString())
{
try
{
if (_connection_id != element.tblConnector.ID)
{
_connection_id = element.tblConnector.ID;
_liveVariable = new Obix(
StringEncryDecry.Decrypt(element.tblConnector.Server_Name, element.tblConnector.SessionID),
StringEncryDecry.Decrypt(element.tblConnector.User_Name, element.tblConnector.SessionID),
StringEncryDecry.Decrypt(element.tblConnector.Password, element.tblConnector.SessionID));
}
LivePoint_ResponseDTO response_dto = new LivePoint_ResponseDTO();
if (_liveVariable.Is_Connected)
{
response_dto = _liveVariable.ReadLiveVariable(element.Source_Element_Name_Live);
livepoint.Current_Value = response_dto;
}
else
{
livepoint.Error_Info = Error_Internal.SetError("Connection Error");
}
}
catch (Exception ex) { }
}
else
{
throw new Exception("Invalid GatewayType");
}
}
public static ElementDTO_WareHouse ConvertTableToDTO(tblElement objTblElement)
{
ElementDTO_WareHouse objElementDTO = new ElementDTO_WareHouse();
objElementDTO.Element_ID = objTblElement.ID;
objElementDTO.Element_Name = objTblElement.Element_Name;
objElementDTO.Element_Unit = Unit_Of_Measurement_DTO.Convert_Table_To_DTO(objTblElement.tblUnit);
return(objElementDTO);
}
public static ElementDTO_Limited_Properties ConvertTableToDTO(tblElement objTblElement)
{
ElementDTO_Limited_Properties objElementDTO = new ElementDTO_Limited_Properties();
objElementDTO.Element_ID = objTblElement.ID;
objElementDTO.Element_Name = objTblElement.Element_Name;
objElementDTO.Source_Element_History_Name = objTblElement.Source_Element_Name_History;
return(objElementDTO);
}
public LivePoint_DTO GetLivePoint(long Id)
{
tblElement tblelement = get_tblElement_by_Id(Id);
LivePoint_DTO livepoint_dto = LivePoint_Conversion.Convert_Tbl_Element_To_LivePoint_DTO(tblelement);
ReadLivePoint(tblelement, livepoint_dto);
GetLastAudit(livepoint_dto.Point_Id.ToString(), nameof(tblElement), livepoint_dto);
return(livepoint_dto);
}
public static LivePoint_DTO Convert_Tbl_Element_To_LivePoint_DTO(tblElement element) => new LivePoint_DTO()
{
Point_Id = element.ID,
Element_Parent_Child = Element_Hierarchy_Convert.Get_Element_Hierarchy(element),
Point_Type = (TagType)Enums.TryParse(typeof(TagType), element.Element_Tag_Type),
Unit = Unit_Of_Measurement_DTO.Convert_Table_To_DTO(element.tblUnit),
// Parent_Name = element.tblElement2?.Element_Name, //tblElement2 for parent
HasChildren = element.tblElement1.Any(), //tblElement1 for children
Address = element.tblElement_Extension.FirstOrDefault() != null?ElementExtension_Conversion.Convert_Tbl_Element_To_ElementExtension_DTO(element.tblElement_Extension.FirstOrDefault()).Complete_Address : "",
IsRead_Only = element.IsRead_Only
};
/// <summary>
/// This method is for to update the parent_element_id for changing the tree structure
/// </summary>
/// <param name="sourceId"></param>
/// <param name="destinationId"></param>
public void Updat_Parent_Element(long sourceId, long destinationId)
{
if (sourceId != destinationId)
{
tblElement obj_Element = _dbcontext.tblElements.SingleOrDefault(e => e.ID == sourceId);
if (obj_Element != null)
{
obj_Element.Parent_Element_ID = destinationId;
_dbcontext.SaveChanges();
}
}
}
/// <summary>
///
/// </summary>
/// <param name="objElementDTO"></param>
/// <returns></returns>
public static tblElement ConvertDTOToTable(ElementDTO objElementDTO, ref tblElement objElementTable)
{
if (objElementTable == null)
{
objElementTable = new tblElement();
}
if (objElementDTO.Connector_History != null)
{
objElementTable.Connector_History_ID = objElementDTO.Connector_History.ConnectionID;
}
if (objElementDTO.Connector_Live != null)
{
objElementTable.Connector_Live_ID = objElementDTO.Connector_Live.ConnectionID;
}
objElementTable.Element_Name = objElementDTO.Element_Name;
objElementTable.Data_Type = objElementDTO.Data_Type.ToString();
objElementTable.Element_Tag_Type = objElementDTO.Element_Tag_Type.ToString();
ICollection <tblTagElement> temp_tbl_tag_collection = objElementTable.tblTagElements;
TagElementDTO.ConvertDTOToTbl(objElementDTO.Tags, ref temp_tbl_tag_collection, objElementDTO.ID);
objElementTable.Source_Element_Name_History = objElementDTO.Source_Element_Name_History;
objElementTable.Source_Element_Name_Live = objElementDTO.Source_Element_Name_Live;
objElementTable.Is_Disabled = objElementDTO.Is_Disabled;
objElementTable.Parent_Element_ID = objElementDTO.Parent_Element_ID;
if (objElementDTO.Unit.ID > 0)
{
objElementTable.Unit_ID = objElementDTO.Unit.ID;
}
objElementTable.Freq = objElementDTO.Freq;
objElementTable.Freq_Unit = objElementDTO.Freq_Unit.ToString();
objElementTable.Recorded_Freq_Unit = objElementDTO.Recorded_Freq_Unit.ToString();
objElementTable.Recorded_Freq = objElementDTO.Recorded_Freq;
objElementTable.Max_Value = objElementDTO.Max_Value;
objElementTable.Min_Value = objElementDTO.Min_Value;
objElementTable.IsRead_Only = objElementDTO.IsRead_Only;
return(objElementTable);
}
public static Element_Hierarchy_DTO Get_Element_Hierarchy(tblElement tbl_element)
{
Element_Hierarchy_DTO element_hierarchy_dto = new Element_Hierarchy_DTO();
string site_name = "", equip_name = "", point_name = "";
Get_Parent(tbl_element, tbl_element.Element_Tag_Type, ref site_name, ref equip_name, ref point_name);
element_hierarchy_dto.Site_Name = site_name.Length > 0 ? site_name.Remove(site_name.Length - 1) : site_name;
element_hierarchy_dto.Equip_Name = equip_name.Length > 0 ? equip_name.Remove(equip_name.Length - 1): equip_name;
element_hierarchy_dto.Element_Name = point_name.Length > 0 ? point_name.Remove(point_name.Length - 1): point_name;
return(element_hierarchy_dto);
}
public static tblElement ConvertObjectToElementDto(long?parentId, string node, long tagId)
{
tblElement _elementDto = new tblElement();
_elementDto.Parent_Element_ID = parentId;
_elementDto.Element_Name = node;
//tblTagElement _tagelement = new tblTagElement();
//_tagelement.Tag_ID = tagId;
//_elementDto.tblTagElements.Add(_tagelement);
_elementDto.Element_Tag_Type = Enum.ToObject(typeof(TagType), tagId).ToString(); //TagType.Site
return(_elementDto);
}
private static void Get_Parent(tblElement tbl_element, string tag_type, ref string site_name, ref string equip, ref string element_name)
{
if (Enum.IsDefined(typeof(TagType), tag_type))
{
if ((TagType)Enums.TryParse(typeof(TagType), tbl_element.Element_Tag_Type) == TagType.site)
{
site_name = tbl_element.Element_Name + "/" + site_name;
}
else if ((TagType)Enums.TryParse(typeof(TagType), tbl_element.Element_Tag_Type) == TagType.equip)
{
equip = tbl_element.Element_Name + "/" + equip;
}
else if ((TagType)Enums.TryParse(typeof(TagType), tbl_element.Element_Tag_Type) == TagType.point)
{
element_name = tbl_element.Element_Name + "/" + element_name;
}
}
if (tbl_element.tblElement2 != null)
{
Get_Parent(tbl_element.tblElement2, tbl_element.tblElement2.Element_Tag_Type, ref site_name, ref equip, ref element_name);
}
}
public ElementDTO GetElementByID(long elementID)
{
tblElement tblelement = get_tblElement_by_Id(elementID);
return(ElementDTO.ConvertTableToDTO(tblelement));
}
private tblElement get_tblElement_by_Id(long elementID)
{
tblElement tblelement = _dbcontext.tblElements.SingleOrDefault(element => element.ID == elementID);
return(tblelement);
}
/// <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);
}
