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