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