public int Create(int companyId, Format_Create parseData)
{
try
{
JObject.Parse(parseData.Content);
}
catch
{
throw new CDSException(12303);
}
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
WidgetCatalog newData = new WidgetCatalog();
newData.CompanyID = companyId;
newData.MessageCatalogID = parseData.MessageCatalogId;
newData.Name = parseData.Name;
newData.Level = parseData.Level;
newData.WidgetClassKey = parseData.WidgetClassKey;
newData.Title = parseData.Title;
newData.TitleBgColor = parseData.TitleBgColor ?? "";
newData.Content = parseData.Content;
newData.ContentBgColor = parseData.ContentBgColor ?? "";
dbEntity.WidgetCatalog.Add(newData);
dbEntity.SaveChanges();
return(newData.Id);
}
}
public void deleteWidgetCatalog(int id)
{
DBHelper._WidgetCatalog dbhelp = new DBHelper._WidgetCatalog();
WidgetCatalog existingWidgetCatalog = dbhelp.GetByid(id);
dbhelp.Delete(existingWidgetCatalog);
}
public Format_Detail GetById(int id)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
WidgetCatalog existingData = (from c in dbEntity.WidgetCatalog.AsNoTracking()
where c.Id == id
select c).SingleOrDefault <WidgetCatalog>();
if (existingData == null)
{
throw new CDSException(10701);
}
return(new Format_Detail()
{
Id = existingData.Id,
MessageCatalogId = existingData.MessageCatalogID,
MessageCatalogName = existingData.MessageCatalog == null ? "" : existingData.MessageCatalog.Name,
Name = existingData.Name,
Level = existingData.Level,
WidgetClassKey = existingData.WidgetClassKey,
Title = existingData.Title,
TitleBgColor = existingData.TitleBgColor,
Content = JObject.Parse(existingData.Content),
ContentBgColor = existingData.ContentBgColor
});
}
}
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 void DeleteById(int id)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
WidgetCatalog existingData = dbEntity.WidgetCatalog.Find(id);
if (existingData == null)
{
throw new CDSException(12302);
}
dbEntity.WidgetCatalog.Remove(existingData);
dbEntity.SaveChanges();
}
}
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)
});
}
