public List <Detail> getAllWidgetCatalogByCompanyId(int companyId, string level = null) { DBHelper._WidgetCatalog dbhelp = new DBHelper._WidgetCatalog(); if (string.IsNullOrEmpty(level)) { return(dbhelp.GetAllByCompanyId(companyId).Select(s => new Detail() { Id = s.Id, Name = s.Name, CompanyId = s.CompanyID, MessageCatalogId = s.MessageCatalogID, MessageCatalogName = (s.MessageCatalog == null ? "" : s.MessageCatalog.Name), Level = s.Level, WidgetClassKey = s.WidgetClassKey, Context = JObject.Parse(s.Context) }).ToList <Detail>()); } else { return(dbhelp.GetAllByCompanyId(companyId, level).Select(s => new Detail() { Id = s.Id, Name = s.Name, CompanyId = s.CompanyID, MessageCatalogId = s.MessageCatalogID, MessageCatalogName = (s.MessageCatalog == null ? "" : s.MessageCatalog.Name), Level = s.Level, WidgetClassKey = s.WidgetClassKey, Context = JObject.Parse(s.Context) }).ToList <Detail>()); } }
public void deleteWidgetCatalog(int id) { DBHelper._WidgetCatalog dbhelp = new DBHelper._WidgetCatalog(); WidgetCatalog existingWidgetCatalog = dbhelp.GetByid(id); dbhelp.Delete(existingWidgetCatalog); }
public void updateWidgetCatalog(int id, Update widgetCatalog) { DBHelper._WidgetCatalog dbhelp = new DBHelper._WidgetCatalog(); WidgetCatalog existingWidgetCatalog = dbhelp.GetByid(id); existingWidgetCatalog.Name = widgetCatalog.Name; existingWidgetCatalog.MessageCatalogID = widgetCatalog.MessageCatalogId; existingWidgetCatalog.Level = widgetCatalog.Level; existingWidgetCatalog.WidgetClassKey = widgetCatalog.WidgetClassKey; existingWidgetCatalog.Context = widgetCatalog.Context; dbhelp.Update(existingWidgetCatalog); }
public int addWidgetCatalog(Add widgetCatalog) { DBHelper._WidgetCatalog dbhelp = new DBHelper._WidgetCatalog(); var newWidgetCatalog = new WidgetCatalog() { Name = widgetCatalog.Name, CompanyID = widgetCatalog.CompanyId, MessageCatalogID = widgetCatalog.MessageCatalogId, Level = widgetCatalog.Level, WidgetClassKey = widgetCatalog.WidgetClassKey, Context = widgetCatalog.Context }; return(dbhelp.Add(newWidgetCatalog)); }
public Detail getWidgetCatalogById(int id) { DBHelper._WidgetCatalog dbhelp = new DBHelper._WidgetCatalog(); WidgetCatalog widgetCatalog = dbhelp.GetByid(id); return(new Detail() { Id = widgetCatalog.Id, Name = widgetCatalog.Name, CompanyId = widgetCatalog.CompanyID, MessageCatalogId = widgetCatalog.MessageCatalogID, MessageCatalogName = (widgetCatalog.MessageCatalog == null ? "" : widgetCatalog.MessageCatalog.Name), Level = widgetCatalog.Level, WidgetClassKey = widgetCatalog.WidgetClassKey, Context = JObject.Parse(widgetCatalog.Context) }); }