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