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