public bool IndependentDataEntry(int entityID) { using (var projectContext = new MyIdeaEntities()) { return(projectContext.TableDrivedEntity.First(x => x.ID == entityID).IndependentDataEntry == true); } }
public List <TableDrivedEntityDTO> GetOtherDrivedEntities(int entityID, int tableID, bool withInheritance) { List <TableDrivedEntityDTO> result = new List <TableDrivedEntityDTO>(); using (var projectContext = new MyIdeaEntities()) { if (withInheritance) { var list = projectContext.TableDrivedEntity.Where(x => x.ID != entityID && x.TableID == tableID && x.Relationship.Any(y => y.TableDrivedEntityID1 == x.ID && y.TableDrivedEntityID2 == entityID && y.RelationshipType != null && y.RelationshipType.SubToSuperRelationshipType != null)); foreach (var item in list) { result.Add(ToTableDrivedEntityDTO(item, EntityColumnInfoType.WithSimpleColumns, EntityRelationshipInfoType.WithoutRelationships)); } } else { var list = projectContext.TableDrivedEntity.Where(x => x.ID != entityID && x.TableID == tableID); foreach (var item in list) { result.Add(ToTableDrivedEntityDTO(item, EntityColumnInfoType.WithSimpleColumns, EntityRelationshipInfoType.WithoutRelationships)); } } } return(result); }
public void MergeUnionRelationships(string name, List <UnionRelationshipDTO> relationships, UnionRelationshipDTO selectedOne) { using (var projectContext = new MyIdeaEntities()) { // int UnionRelationID = 0; foreach (var relationship in relationships) { //if (relationship == selectedOne) // UnionRelationID = relationship.ID; //else //{ var dbRelationship = projectContext.UnionRelationshipType.First(x => x.ID == relationship.ID); foreach (var detail in dbRelationship.UnionToSubUnionRelationshipType) { detail.UnionRelationshipTypeID = selectedOne.ID; } foreach (var detail in dbRelationship.SubUnionToUnionRelationshipType) { detail.UnionRelationshipTypeID = selectedOne.ID; } //} } projectContext.SaveChanges(); } }
public void MergeISARelationships(string name, List <ISARelationshipDTO> relationships, ISARelationshipDTO selectedOne) { using (var projectContext = new MyIdeaEntities()) { int isaRelationID = 0; foreach (var relationship in relationships) { //if (relationship == selectedOne) // isaRelationID = relationship.ID; //else //{ var dbRelationship = projectContext.ISARelationship.First(x => x.ID == relationship.ID); foreach (var detail in dbRelationship.SuperToSubRelationshipType) { detail.ISARelationshipID = selectedOne.ID; } foreach (var detail in dbRelationship.SubToSuperRelationshipType) { detail.ISARelationshipID = selectedOne.ID; } //} } projectContext.SaveChanges(); } }
public List <ColumnDTO> GetColumns(int entityID, bool simple) { using (var projectContext = new MyIdeaEntities()) { var dbEntity = projectContext.TableDrivedEntity.First(x => x.ID == entityID); return(GetColumns(dbEntity, simple)); } }
public Type GetColumnDotNetType(int columnID) { using (var projectContext = new MyIdeaEntities()) { var column = projectContext.Column.First(x => x.ID == columnID); return(GetColumnDotNetType(column.DataType)); } }
public static I_DBHelper GetDBHelper(int dbID) { using (var context = new MyIdeaEntities()) { var database = context.DatabaseInformation.First(x => x.ID == dbID); return(GetDBHelper(database)); } }
public DatabaseDTO GetDatabase(string dbName) { using (var context = new MyIdeaEntities()) { var db = context.DatabaseInformation.First(x => x.Name == dbName); return(ToDatabaseDTO(db)); } }
public DatabaseDTO GetDatabase(int databaseID) { using (var context = new MyIdeaEntities()) { var db = context.DatabaseInformation.First(x => x.ID == databaseID); return(ToDatabaseDTO(db)); } }
public static I_DBHelper GetDBHelper(string dbName) { using (var context = new MyIdeaEntities()) { var database = context.DatabaseInformation.First(x => x.Name == dbName); return(GetDBHelper(database)); } }
public int GetDefaultEntityID(int tableID) { List <TableDrivedEntityDTO> result = new List <TableDrivedEntityDTO>(); using (var projectContext = new MyIdeaEntities()) { return(projectContext.Table.First(x => x.ID == tableID).TableDrivedEntity.First().ID); } }
public string GetTableName(int entityID) { List <TableDrivedEntityDTO> result = new List <TableDrivedEntityDTO>(); using (var projectContext = new MyIdeaEntities()) { return(projectContext.TableDrivedEntity.First(x => x.ID == entityID).Table.Name); } }
{//ترنزکشن اضافه شود //public static I_DBHelper GetDBHelper(string catalog) //{ // //کش شود // var databaseDTO = new BizDatabase().GetDatabaseDTO(catalog); // return GetDBHelper(databaseDTO); //} public static I_DBHelper GetDBHelperByEntityID(int entityID) { //کش شود using (var context = new MyIdeaEntities()) { var database = context.TableDrivedEntity.First(x => x.ID == entityID).Table.DBSchema.DatabaseInformation; return(GetDBHelper(database)); } }
public ColumnDTO GetColumn(int columnID, bool simple) { ColumnDTO result = new ColumnDTO(); using (var projectContext = new MyIdeaEntities()) { var column = projectContext.Column.First(x => x.ID == columnID); return(ToColumnDTO(column, simple)); } }
public TableDTO GetTable(int tableID) { List <TableDTO> result = new List <TableDTO>(); using (var projectContext = new MyIdeaEntities()) { var table = projectContext.Table.First(x => x.ID == tableID); return(ToTableDTO(table)); } }
public ISARelationshipDTO GetISARelationships(int baseEntityID, int drivedEntitID) { ISARelationshipDTO result = new ISARelationshipDTO(); using (var projectContext = new MyIdeaEntities()) { var isaRelationship = projectContext.Relationship.First(x => x.TableDrivedEntityID2 == baseEntityID && x.RelationshipType.SubToSuperRelationshipType != null).RelationshipType.SubToSuperRelationshipType.ISARelationship; return(ToISARelationshipDTO(isaRelationship)); } }
public void UpdateISARelationships(List <ISARelationshipDTO> relationships) { using (var projectContext = new MyIdeaEntities()) { foreach (var relationship in relationships) { Save(relationship); } } }
public TableDrivedEntityDTO GetTableDrivedEntity(int entityID, EntityColumnInfoType columnInfoType, EntityRelationshipInfoType relationshipInfoType) { List <TableDrivedEntityDTO> result = new List <TableDrivedEntityDTO>(); using (var projectContext = new MyIdeaEntities()) { var table = projectContext.TableDrivedEntity.First(x => x.ID == entityID); return(ToTableDrivedEntityDTO(table, columnInfoType, relationshipInfoType)); } }
public void UpdateDateColumnType(List <DateColumnTypeDTO> columnTypes) { using (var projectContext = new MyIdeaEntities()) { foreach (var column in columnTypes) { var dbColumn = projectContext.DateColumnType.First(x => x.ColumnID == column.ColumnID); dbColumn.IsPersianDate = column.IsPersianDate; } projectContext.SaveChanges(); } }
public void UpdateStringColumnType(List <StringColumnTypeDTO> columnTypes) { using (var projectContext = new MyIdeaEntities()) { foreach (var column in columnTypes) { var dbColumn = projectContext.StringColumnType.First(x => x.ColumnID == column.ColumnID); dbColumn.MaxLength = column.MaxLength; dbColumn.Format = column.Format; } projectContext.SaveChanges(); } }
//public List<DbServerDTO> GetDBServers() //{ // List<DbServerDTO> result = new List<DbServerDTO>(); // using (var context = new MyIdeaEntities()) // { // var servers = context.DBServer; // foreach (var item in servers) // { // result.Add(ToDBServerDTO(item)); // } // return result; // } //} //public DbServerDTO GetDBServer(int dbServerID) //{ // using (var context = new MyIdeaEntities()) // { // var db = context.DBServer.First(x => x.ID == dbServerID); // return ToDBServerDTO(db); // } //} //public int SaveServer(DbServerDTO message) //{ // using (var projectContext = new MyIdeaEntities()) // { // var dbServer = projectContext.DBServer.FirstOrDefault(x => x.ID == message.ID); // if (dbServer == null) // dbServer = new DBServer(); // dbServer.Name = message.Name; // dbServer.Title = message.Title; // dbServer.IPAddress = message.IPAddress; // if (dbServer.ID == 0) // projectContext.DBServer.Add(dbServer); // projectContext.SaveChanges(); // return dbServer.ID; // } //} //private DbServerDTO ToDBServerDTO(DBServer dbServer) //{ // DbServerDTO result = new DbServerDTO(); // result.ID = dbServer.ID; // result.Name = dbServer.Name; // result.Title = dbServer.Title; // result.IPAddress = dbServer.IPAddress; // foreach (var linked in dbServer.LinkedServer) // { // result.LinkedServers.Add(ToLinkedServer(linked)); // } // return result; //} //public DatabaseDTO GetDatabaseDTO(string catalog) //{ // using (var context = new MyIdeaEntities()) // { // var dbInfo = context.DatabaseInformation.FirstOrDefault(x => x.Name == catalog); // if (dbInfo != null) // return ToDatabaseDTO(dbInfo); // return null; // } //} public List <DatabaseDTO> GetDatabases() { List <DatabaseDTO> result = new List <DatabaseDTO>(); using (var projectContext = new MyIdeaEntities()) { var list = projectContext.DatabaseInformation; foreach (var item in list) { result.Add(ToDatabaseDTO(item)); } } return(result); }
//public List<UnionRelationshipDTO> GetUnionRelationships(int tableDrivedEntityID) //{ // List<UnionRelationshipDTO> result = new List<UnionRelationshipDTO>(); // using (var projectContext = new MyIdeaEntities()) // { // var list = projectContext.UnionRelationship.Where(x => x.TableDrivedEntityID1 == tableDrivedEntityID || x.TableDrivedEntityID2 == tableDrivedEntityID); // foreach (var item in list) // { // result.Add(ToUnionRelationshipDTO(item)); // } // } // return result; //} public List <UnionRelationshipDTO> GetUnionRelationshipsBySuperUnionEntity(int superunionEntityID, bool unionHoldsKeys) { List <UnionRelationshipDTO> result = new List <UnionRelationshipDTO>(); using (var projectContext = new MyIdeaEntities()) { var UnionRelationships = projectContext.UnionRelationshipType.Where(x => x.UnionHoldsKeys == unionHoldsKeys && x.UnionToSubUnionRelationshipType.Any(y => y.RelationshipType.Relationship.TableDrivedEntity.ID == superunionEntityID)); foreach (var UnionRelationship in UnionRelationships) { result.Add(ToUnionRelationshipDTO(UnionRelationship)); } } return(result); }
public List <DateColumnTypeDTO> GetDateColumType(int columnID) { ColumnDTO result = new ColumnDTO(); using (var projectContext = new MyIdeaEntities()) { var column = projectContext.Column.First(x => x.ID == columnID); if (column.DateColumnType != null) { return(GeneralHelper.CreateListFromSingleObject <DateColumnTypeDTO>(ToDateColumTypeDTO(column.DateColumnType))); } } return(null); }
public List <ISARelationshipDTO> GetISARelationshipsByEntityID(int superEntityID) { List <ISARelationshipDTO> result = new List <ISARelationshipDTO>(); using (var projectContext = new MyIdeaEntities()) { var isaRelationships = projectContext.ISARelationship.Where(x => x.SuperToSubRelationshipType.Any(y => y.RelationshipType.Relationship.TableDrivedEntity.ID == superEntityID)); foreach (var isaRelationship in isaRelationships) { result.Add(ToISARelationshipDTO(isaRelationship)); } } return(result); }
public List <ISARelationshipDTO> GetISARelationships(int databaseID) { List <ISARelationshipDTO> result = new List <ISARelationshipDTO>(); using (var projectContext = new MyIdeaEntities()) { // string catalogName = GeneralHelper.GetCatalogName(serverName, dbName); foreach (var item in projectContext.ISARelationship.Where(x => x.SuperToSubRelationshipType.Any(y => y.RelationshipType.Relationship.TableDrivedEntity.Table.DBSchema.DatabaseInformationID == databaseID))) { result.Add(ToISARelationshipDTO(item)); } } return(result); }
public ColumnKeyValueDTO GetColumnKeyValue(int columnID) { ColumnKeyValueDTO result = new ColumnKeyValueDTO(); using (var projectContext = new MyIdeaEntities()) { var column = projectContext.Column.FirstOrDefault(x => x.ID == columnID); if (column.ColumnKeyValue != null) { return(ToColumnKeyValueDTO(column.ColumnKeyValue)); } } return(null); }
//public List<ColumnDTO> GetColumnsForEdit(int entityID) //{ // List<ColumnDTO> result = new List<ColumnDTO>(); // using (var projectContext = new MyIdeaEntities()) // { // var entity = projectContext.TableDrivedEntity.First(x => x.ID == entityID); // ICollection<Column> columns = null; // if (entity.Column.Count > 0) // { // columns = entity.Column; // } // else // { // columns = entity.Table.Column; // } // columns = columns.Where(x => x.IsDBCalculatedColumn == false).ToList(); // foreach (var column in columns) // result.Add(ToColumnDTO(column, true)); // return result; // } //} //public List<ColumnDTO> GetColumnsSimple(int entityID) //{ // using (var projectContext = new MyIdeaEntities()) // { // var entity = projectContext.TableDrivedEntity.First(x => x.ID == entityID); // if (entity.Column.Count > 0) // { // return GetColumnsSimple(entity.Column); // } // else // { // return GetColumnsSimple(entity.Table.Column); // } // } //} //private List<ColumnDTO> GetColumnsSimple(ICollection<Column> columns) //{ // BizColumn bizColumn = new BizColumn(); // List<ColumnDTO> result = new List<ColumnDTO>(); // foreach (var column in columns) // result.Add(bizColumn.ToColumnDTO(column, true)); // return result; //} //public List<ColumnDTO> GetColums(int tableID, bool simple) //{ // List<ColumnDTO> result = new List<ColumnDTO>(); // using (var projectContext = new MyIdeaEntities()) // { // var list = projectContext.Column.Where(x => x.TableID == tableID); // foreach (var item in list) // { // result.Add(ToColumnDTO(item, simple)); // } // } // return result; //} public List <ColumnDTO> GetOtherColums(int columnID) { List <ColumnDTO> result = new List <ColumnDTO>(); using (var projectContext = new MyIdeaEntities()) { var column = projectContext.Column.First(x => x.ID == columnID); var list = column.Table.Column.ToList(); foreach (var item in list) { result.Add(ToColumnDTO(item, true)); } } return(result); }
//public string GetCatalog(int entityID) //{ // using (var projectContext = new MyIdeaEntities()) // { // return projectContext.TableDrivedEntity.First(x => x.ID == entityID).Table.Catalog; // } //} //public List<TableDrivedEntityDTO> GetAllEntities(int databaseID) //{ // List<TableDrivedEntityDTO> result = new List<TableDrivedEntityDTO>(); // using (var projectContext = new MyIdeaEntities()) // { // //string catalogName = GeneralHelper.GetCatalogName(serverName, dbName); // var listEntity = projectContext.TableDrivedEntity.Where(x => x.Table.DBSchema.DatabaseInformationID == databaseID); // foreach (var item in listEntity) // result.Add(ToTableDrivedEntityDTO(item, EntityColumnInfoType.WithoutColumn, EntityRelationshipInfoType.WithoutRelationships)); // } // return result; //} public List <TableDrivedEntityDTO> GetAllEntities(int databaseID) { //بهتره خود انتیتی با دیتابیس رابطه داشته باشد List <TableDrivedEntityDTO> result = new List <TableDrivedEntityDTO>(); using (var projectContext = new MyIdeaEntities()) { var listEntity = projectContext.TableDrivedEntity.Where(x => x.Table.DBSchema.DatabaseInformationID == databaseID); foreach (var item in listEntity) { result.Add(ToTableDrivedEntityDTO(item, EntityColumnInfoType.WithoutColumn, EntityRelationshipInfoType.WithoutRelationships)); } } return(result); }
public void UpdateNumericColumnType(List <NumericColumnTypeDTO> columnTypes) { using (var projectContext = new MyIdeaEntities()) { foreach (var column in columnTypes) { var dbColumn = projectContext.NumericColumnType.First(x => x.ColumnID == column.ColumnID); dbColumn.MaxValue = column.MaxValue; dbColumn.MinValue = column.MinValue; dbColumn.Precision = column.Precision; dbColumn.Scale = column.Scale; } projectContext.SaveChanges(); } }
public List <TableDTO> GetTables(int databaseID) { List <TableDTO> result = new List <TableDTO>(); using (var projectContext = new MyIdeaEntities()) { // string catalogName = GeneralHelper.GetCatalogName(serverName, dbName); var list = projectContext.Table.Where(x => x.DBSchema.DatabaseInformationID == databaseID).ToList(); foreach (var item in list) { result.Add(ToTableDTO(item)); } } return(result); }