public void DeleteKBEntityField(int id)
{
using (var c = new iskateli_devEntities1())
{
var _class = c.Class.SingleOrDefault(x => x.Id == id);
c.Class.Remove(_class);
c.SaveChanges();
}
}
public void UpdateKBSimpleType(KBSimpleType entity)
{
using (var c = new iskateli_devEntities1())
{
var _class = c.Class.SingleOrDefault(x => x.Id == entity.Id);
_class.Alias = entity.Alias;
var data = c.Data.SingleOrDefault(x => x.ClassId == entity.Id);
data.Data1 = entity.Name;
c.SaveChanges();
}
}
public bool DeleteKBSimpleType(int id)
{
using (var c = new iskateli_devEntities1())
{
var _class = c.Class.SingleOrDefault(x => x.Id == id);
var entities = c.Entity.Where(x => x.ClassId == id);
if (entities.Any())
{
return(false);
}
c.Class.Remove(_class);
c.SaveChanges();
return(true);
}
}
public List <KBSimpleType> GetKBSimpleTypeList()
{
using (var c = new iskateli_devEntities1())
{
var query = from cl in c.Class
join d in c.Data on cl.Id equals d.ClassId
where cl.ParentId == (int)KBClassType.KBSimpleType
select new KBSimpleType()
{
Id = cl.Id,
Alias = cl.Alias,
Name = d.Data1
};
return(query.ToList());
}
}
public KBEntity GetKBEntity(int id)
{
using (var c = new iskateli_devEntities1())
{
var query = from cl in c.Class
join d in c.Data on cl.Id equals d.ClassId
where cl.Id == id
select new KBEntity()
{
Id = cl.Id,
Name = d.Data1,
Alias = cl.Alias
};
return(query.SingleOrDefault());
}
}
public void AddKBSimpleType(string typeName, string typeAlias)
{
using (var c = new iskateli_devEntities1())
{
var _class = c.Class.Create();
_class.ParentId = (int)KBClassType.KBSimpleType;
_class.TypeClassId = (int)KBClassType.KBSimpleType;
_class.Alias = typeAlias;
c.Class.Add(_class);
c.SaveChanges();
var data = c.Data.Create();
data.ClassId = _class.Id;
data.Data1 = typeName;
c.Data.Add(data);
c.SaveChanges();
}
}
public void AddKBEntityField(int entityId, string name, string alias, int typeId)
{
using (var c = new iskateli_devEntities1())
{
var _class = c.Class.Create();
_class.ParentId = entityId;
_class.TypeClassId = typeId;
_class.Alias = alias;
c.Class.Add(_class);
c.SaveChanges();
var data = c.Data.Create();
data.ClassId = _class.Id;
data.Data1 = name;
c.Data.Add(data);
c.SaveChanges();
}
}
public List <KBEntityField> GetKBEntityFieldList(int entityId)
{
using (var c = new iskateli_devEntities1())
{
return((from cl in c.Class
join d in c.Data on cl.Id equals d.ClassId
join td in c.Data on cl.TypeClassId equals td.ClassId
where cl.ParentId == entityId && d.EntityId == null && d.RelationId == null
select new KBEntityField()
{
Id = cl.Id,
Alias = cl.Alias,
Name = d.Data1,
TypeId = cl.TypeClassId.Value,
TypeName = td.Data1
}).ToList());
}
}
