public void deleteMetaDataDefination(int id)
{
DBHelper._MetaDataDefination dbhelp = new DBHelper._MetaDataDefination();
MetaDataDefination existingMetaDataDef = dbhelp.GetByid(id);
dbhelp.Delete(existingMetaDataDef);
}
public int Create(int companyId, Format_Create parseData)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
MetaDataDefination newData = new MetaDataDefination()
{
CompanyId = companyId,
EntityType = parseData.EntityType,
ObjectName = parseData.ObjectName
};
dbEntity.MetaDataDefination.Add(newData);
try
{
dbEntity.SaveChanges();
}
catch (DbUpdateException ex)
{
if (ex.InnerException.InnerException.Message.Contains("Cannot insert duplicate key"))
{
throw new CDSException(11902);
}
else
{
throw ex;
}
}
return(newData.Id);
}
}
public void updateMetaDataDefination(int id, Edit metaDataDef)
{
DBHelper._MetaDataDefination dbhelp = new DBHelper._MetaDataDefination();
MetaDataDefination existingMetaDataDef = dbhelp.GetByid(id);
existingMetaDataDef.EntityType = metaDataDef.EntityType;
existingMetaDataDef.ObjectName = metaDataDef.ObjectName;
dbhelp.Update(existingMetaDataDef);
}
public int addMetaDataDefination(Edit metaDataDef)
{
DBHelper._MetaDataDefination dbhelp = new DBHelper._MetaDataDefination();
var newMetaData = new MetaDataDefination()
{
CompanyId = metaDataDef.CompanyId,
ObjectName = metaDataDef.ObjectName,
EntityType = metaDataDef.EntityType
};
int newMetaDataDefId = dbhelp.Add(newMetaData);
return(newMetaDataDefId);
}
public void DeleteById(int id, int companyId)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
MetaDataDefination existingData = (from c in dbEntity.MetaDataDefination
where c.Id == id && c.CompanyId == companyId
select c).SingleOrDefault <MetaDataDefination>();
if (existingData == null)
{
throw new CDSException(11301);
}
dbEntity.Entry(existingData).State = EntityState.Deleted;
dbEntity.SaveChanges();
}
}
public void Update(int id, Format_Update parseData, int companyId)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
//MetaDataDefination existingData = dbEntity.MetaDataDefination.Find(id);
MetaDataDefination existingData = (from c in dbEntity.MetaDataDefination
where c.Id == id && c.CompanyId == companyId
select c).SingleOrDefault <MetaDataDefination>();
if (existingData == null)
{
throw new CDSException(11301);
}
if (parseData.EntityType != null)
{
existingData.EntityType = parseData.EntityType;
}
if (parseData.ObjectName != null)
{
existingData.ObjectName = parseData.ObjectName;
}
dbEntity.Entry(existingData).State = EntityState.Modified;
try
{
dbEntity.SaveChanges();
}
catch (DbUpdateException ex)
{
if (ex.InnerException.InnerException.Message.Contains("Cannot insert duplicate key"))
{
throw new CDSException(11302);
}
else
{
throw ex;
}
}
}
}
public Format_Detail GetById(int id, int companyId)
{
using (CDStudioEntities dbEntity = new CDStudioEntities())
{
MetaDataDefination existingData = (from c in dbEntity.MetaDataDefination.AsNoTracking()
where c.Id == id && c.CompanyId == companyId
select c).SingleOrDefault <MetaDataDefination>();
if (existingData == null)
{
throw new CDSException(11301);
}
return(new Format_Detail()
{
Id = existingData.Id,
EntityType = existingData.EntityType,
ObjectName = existingData.ObjectName
});
}
}
