public void deleteMessageElement(int id)
{
DBHelper._MessageElement dbhelp = new DBHelper._MessageElement();
MessageElement existingMessageElement = dbhelp.GetByid(id);
dbhelp.Delete(existingMessageElement);
}
public List <Detail> GetAllMessageElementByMessageCatalogId(int messageCatalogId)
{
DBHelper._MessageElement dbhelp = new DBHelper._MessageElement();
List <Detail> result = new List <Detail>();
foreach (var element in dbhelp.GetAllByMessageCatalog(messageCatalogId))
{
if (element.ChildMessageCatalogID != null)
{
DBHelper._MessageCatalog dbhelp_messageCatalog = new DBHelper._MessageCatalog();
if (dbhelp_messageCatalog.GetByid((int)element.ChildMessageCatalogID) == null)
{
continue;
}
}
result.Add(new Detail()
{
Id = element.Id,
MessageCatalogID = element.MessageCatalogID,
ElementName = element.ElementName,
ElementDataType = element.ElementDataType,
ChildMessageCatalogID = element.ChildMessageCatalogID,
MandatoryFlag = element.MandatoryFlag,
CDSMandatoryFlag = element.CDSMandatoryFlag
});
}
return(result);
}
public void updateMessageElement(int id, Update messageElement)
{
DBHelper._MessageElement dbhelp = new DBHelper._MessageElement();
MessageElement existingMessageElement = dbhelp.GetByid(id);
existingMessageElement.ElementName = messageElement.ElementName;
existingMessageElement.ElementDataType = messageElement.ElementDataType;
existingMessageElement.ChildMessageCatalogID = messageElement.ElementDataType.ToLower().Equals("message") ? messageElement.ChildMessageCatalogID : null;
existingMessageElement.MandatoryFlag = messageElement.MandatoryFlag;
existingMessageElement.CDSMandatoryFlag = messageElement.CDSMandatoryFlag;
dbhelp.Update(existingMessageElement);
}
public void addMessageElement(Add messageElement)
{
DBHelper._MessageElement dbhelp = new DBHelper._MessageElement();
var newMessageElement = new MessageElement()
{
MessageCatalogID = messageElement.MessageCatalogID,
ElementName = messageElement.ElementName,
ElementDataType = messageElement.ElementDataType,
ChildMessageCatalogID = messageElement.ElementDataType.ToLower().Equals("message") ? messageElement.ChildMessageCatalogID : null,
MandatoryFlag = messageElement.MandatoryFlag,
CDSMandatoryFlag = messageElement.CDSMandatoryFlag
};
dbhelp.Add(newMessageElement);
}
public void addMessageElement(Add messageElement)
{
DBHelper._MessageElement dbhelp = new DBHelper._MessageElement();
var newMessageElement = new MessageElement()
{
MessageCatalogID = messageElement.MessageCatalogID,
ElementName = messageElement.ElementName,
ElementDataType = messageElement.ElementDataType,
ChildMessageCatalogID = messageElement.ElementDataType.ToLower().Equals("message") ? messageElement.ChildMessageCatalogID : null,
MandatoryFlag = messageElement.MandatoryFlag,
SFMandatoryFlag = messageElement.SFMandatoryFlag,
ShowOnEquipmentList = messageElement.ShowOnEquipmentList,
ShowOnFactoryBoard = messageElement.ShowOnFactoryBoard
};
dbhelp.Add(newMessageElement);
}
public List <Elements> GetMessageCatalogElements(int messageCatalogId)
{
DBHelper._MessageCatalog dbhelp_msgCatalog = new DBHelper._MessageCatalog();
DBHelper._MessageElement dbhelp_msgElement = new DBHelper._MessageElement();
var msgCatalog = dbhelp_msgCatalog.GetByid(messageCatalogId);
var msgElements = dbhelp_msgElement.GetAllByMessageCatalog(messageCatalogId);
List <Elements> elementList = new List <Elements>();
foreach (var msgElement in msgElements)
{
if (msgElement.ElementDataType.ToLower().Equals("message"))
{
var msgChildElements = dbhelp_msgElement.GetAllByMessageCatalog((int)msgElement.ChildMessageCatalogID);
foreach (var msgChildElement in msgChildElements)
{
elementList.Add(new Elements()
{
Id = msgChildElement.Id,
ParentId = msgElement.Id,
Name = msgElement.ElementName + "_" + msgChildElement.ElementName,
DataType = msgChildElement.ElementDataType,
MandatoryFlag = msgChildElement.MandatoryFlag
});
}
continue;
}
else
{
elementList.Add(new Elements()
{
Id = msgElement.Id,
Name = msgElement.ElementName,
DataType = msgElement.ElementDataType,
MandatoryFlag = msgElement.MandatoryFlag
});
}
}
return(elementList);
}
public Schema GetMessageCatalogElementSchema(int messageCatalogId)
{
DBHelper._MessageCatalog dbhelp_msgCatalog = new DBHelper._MessageCatalog();
DBHelper._MessageElement dbhelp_msgElement = new DBHelper._MessageElement();
Schema returnSchem = new Schema();
var msgCatalog = dbhelp_msgCatalog.GetByid(messageCatalogId);
var msgElements = dbhelp_msgElement.GetAllByMessageCatalog(messageCatalogId);
returnSchem.MessageCatalogId = msgCatalog.Id;
returnSchem.Name = msgCatalog.Name;
returnSchem.ElementList = new List <Schema_element>();
foreach (var msgElement in msgElements)
{
if (msgElement.ElementDataType.ToLower().Equals("message"))
{
var msgChildElements = dbhelp_msgElement.GetAllByMessageCatalog((int)msgElement.ChildMessageCatalogID);
foreach (var msgChildElement in msgChildElements)
{
returnSchem.ElementList.Add(new Schema_element()
{
Name = msgElement.ElementName + "_" + msgChildElement.ElementName,
DataType = msgChildElement.ElementDataType,
MandatoryFlag = msgChildElement.MandatoryFlag
});
}
continue;
}
returnSchem.ElementList.Add(new Schema_element()
{
Name = msgElement.ElementName,
DataType = msgElement.ElementDataType,
MandatoryFlag = msgElement.MandatoryFlag
});
}
return(returnSchem);
}
private void GetMessageCatalogPayload(int messageCatalogId, int companyId, string iotHubDeviceId, ref dynamic msgCatalogPayload, string prefixName)
{
DBHelper._MessageElement dbhelp_messageElement = new DBHelper._MessageElement();
var msgElements = dbhelp_messageElement.GetAllByMessageCatalog(messageCatalogId);
foreach (var msgElement in msgElements)
{
switch (msgElement.ElementDataType.ToLower())
{
case "string":
if (msgElement.ElementName.ToLower().Equals("equipmentid"))
{
DBHelper._Equipment dbhelp_equipment = new DBHelper._Equipment();
int count = 0;
string availableEquipmentIdList = "";
foreach (Equipment equipment in dbhelp_equipment.GetAllByIoTHubDeviceId(iotHubDeviceId))
{
if (count > 0)
{
availableEquipmentIdList += (", " + equipment.EquipmentId);
}
else
{
availableEquipmentIdList += (" || " + equipment.EquipmentId);
}
count++;
}
AddProperty(msgCatalogPayload, prefixName + msgElement.ElementName, msgElement.ElementDataType + " || " + (msgElement.MandatoryFlag ? "mandatory" : "option") + availableEquipmentIdList);
}
else
{
AddProperty(msgCatalogPayload, prefixName + msgElement.ElementName, msgElement.ElementDataType + " || " + (msgElement.MandatoryFlag ? "mandatory" : "option"));
}
break;
case "numeric":
switch (msgElement.ElementName.ToLower())
{
case "companyid":
AddProperty(msgCatalogPayload, prefixName + msgElement.ElementName, msgElement.ElementDataType + " || " + (msgElement.MandatoryFlag ? "mandatory" : "option") + " || " + companyId.ToString());
break;
case "equipmentrunstatus":
AddProperty(msgCatalogPayload, prefixName + msgElement.ElementName, msgElement.ElementDataType + " || " + (msgElement.MandatoryFlag ? "mandatory" : "option") + " || 0, 1, -1");
break;
default:
AddProperty(msgCatalogPayload, prefixName + msgElement.ElementName, msgElement.ElementDataType + " || " + (msgElement.MandatoryFlag ? "mandatory" : "option"));
break;
}
break;
case "bool":
AddProperty(msgCatalogPayload, prefixName + msgElement.ElementName, msgElement.ElementDataType + " || " + (msgElement.MandatoryFlag ? "mandatory" : "option") + " || True, False");
break;
case "datetime":
AddProperty(msgCatalogPayload, prefixName + msgElement.ElementName, msgElement.ElementDataType + " || " + (msgElement.MandatoryFlag ? "mandatory" : "option") + " || yyyy-MM-ddTHH:mm:ss");
break;
case "message":
if (messageCatalogId != (int)msgElement.ChildMessageCatalogID)
{
GetMessageCatalogPayload((int)msgElement.ChildMessageCatalogID, companyId, iotHubDeviceId, ref msgCatalogPayload, prefixName + msgElement.ElementName + "_"); //Recurssive Call
}
break;
}
}
}
