public void deleteMessageCatalog(int id)
{
DBHelper._MessageCatalog dbhelp = new DBHelper._MessageCatalog();
MessageCatalog existingMessageCatalog = dbhelp.GetByid(id);
dbhelp.Delete(existingMessageCatalog);
}
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 updateMessageCatalog(int id, Edit messageCatalog)
{
DBHelper._MessageCatalog dbhelp = new DBHelper._MessageCatalog();
MessageCatalog existingMessageCatalog = dbhelp.GetByid(id);
existingMessageCatalog.Name = messageCatalog.Name;
existingMessageCatalog.CompanyID = messageCatalog.CompanyId;
existingMessageCatalog.Description = messageCatalog.Description;
existingMessageCatalog.ChildMessageFlag = messageCatalog.ChildMessageFlag;
dbhelp.Update(existingMessageCatalog);
}
public List <Detail> GetAllNonChildMessageCatalogByCompanyId(int companyId)
{
DBHelper._MessageCatalog dbhelp = new DBHelper._MessageCatalog();
return(dbhelp.GetAllNonChildByCompanyId(companyId).Select(s => new Detail()
{
Id = s.Id,
Name = s.Name,
Description = s.Description,
ChildMessageFlag = s.ChildMessageFlag
}).ToList <Detail>());
}
public Detail getMessageCatalogById(int id)
{
DBHelper._MessageCatalog dbhelp = new DBHelper._MessageCatalog();
MessageCatalog messageCatalog = dbhelp.GetByid(id);
return(new Detail()
{
Id = messageCatalog.Id,
Name = messageCatalog.Name,
Description = messageCatalog.Description,
ChildMessageFlag = messageCatalog.ChildMessageFlag
});
}
public List <Detail> GetAllMessageCatalogByCompanyId(int companyId)
{
DBHelper._MessageCatalog dbhelp = new DBHelper._MessageCatalog();
return(dbhelp.GetAllByCompanyId(companyId).Select(s => new Detail()
{
Id = s.Id,
Name = s.Name,
Description = s.Description,
MonitorFrequenceInMinSec = (int)s.MonitorFrequenceInMinSec,
ChildMessageFlag = s.ChildMessageFlag
}).ToList <Detail>());
}
public void addMessageCatalog(Edit messageCatalog)
{
DBHelper._MessageCatalog dbhelp = new DBHelper._MessageCatalog();
var newMessageCatalog = new MessageCatalog()
{
Name = messageCatalog.Name,
CompanyID = messageCatalog.CompanyId,
Description = messageCatalog.Description,
ChildMessageFlag = messageCatalog.ChildMessageFlag,
DeletedFlag = false
};
dbhelp.Add(newMessageCatalog);
}
public void addMessageCatalog(Edit messageCatalog)
{
DBHelper._MessageCatalog dbhelp = new DBHelper._MessageCatalog();
var newMessageCatalog = new MessageCatalog()
{
Name = messageCatalog.Name,
CompanyID = messageCatalog.CompanyId,
Description = messageCatalog.Description,
MonitorFrequenceInMinSec = (int)messageCatalog.MonitorFrequenceInMinSec,
ChildMessageFlag = messageCatalog.ChildMessageFlag
};
dbhelp.Add(newMessageCatalog);
}
public Template GetMessageCatalogTemplate(int messageId, string iotHubDeviceId)
{
DBHelper._MessageCatalog dbhelp = new DBHelper._MessageCatalog();
MessageCatalog msgCatalog = dbhelp.GetByid(messageId);
dynamic msgCatalogPayload = new ExpandoObject();
GetMessageCatalogPayload(messageId, msgCatalog.CompanyID, iotHubDeviceId, ref msgCatalogPayload, "");
Template template = new Template();
template.MessageId = messageId;
template.MessageName = msgCatalog.Name;
template.MessagePayload = msgCatalogPayload;
return(template);
}
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);
}
