private void SetColumnValueGrid() { using (var projectContext = new DataAccess.MyProjectEntities()) { var column = projectContext.Column.First(x => x.ID == ColumnID); dtgColumnValues.DataSource = column.ColumnValue.ToList(); var col = dtgColumnValue_Columns.Columns[0] as GridViewComboBoxColumn; col.DataSource = column.Table.Column.ToList(); col.DisplayMember = "Name"; col.ValueMember = "ID"; var rel = dtgColumnValue_Relationships.Columns[0] as GridViewComboBoxColumn; List <Relationship> listRelationships = new List <Relationship>(); foreach (var item in column.Table.TableDrivedEntity) { foreach (var relationship in item.Relationship) { listRelationships.Add(relationship); } foreach (var relationship in item.Relationship1) { listRelationships.Add(relationship); } } rel.DataSource = listRelationships; rel.DisplayMember = "Name"; rel.ValueMember = "ID"; } }
public void UpdateSuperUnionToSubUnionRelationships(List <UnionToSubUnionRelationshipDTO> relationships) { using (var projectContext = new DataAccess.MyProjectEntities()) { foreach (var relationship in relationships) { var dbRelationship = projectContext.UnionToSubUnionRelationshipType.First(x => x.ID == relationship.ID); dbRelationship.RelationshipType.IsOtherSideCreatable = relationship.IsOtherSideCreatable; dbRelationship.RelationshipType.IsOtherSideDirectlyCreatable = relationship.IsOtherSideDirectlyCreatable; //dbRelationship.RelationshipType.IsOtherSideTransferable = relationship.IsOtherSideTransferable; dbRelationship.RelationshipType.Relationship.Name = relationship.Name; dbRelationship.RelationshipType.Relationship.Alias = relationship.Alias; dbRelationship.DeterminerColumnValue = relationship.DeterminerColumnValue; if (relationship.DeterminerColumnID != 0) { dbRelationship.DeterminerColumnID = relationship.DeterminerColumnID; } else { dbRelationship.DeterminerColumnID = null; } } projectContext.SaveChanges(); } }
public bool EntityHasUIComposition(TableDrivedEntityDTO entity) { using (var projectContext = new DataAccess.MyProjectEntities()) { return(projectContext.TableDrivedEntity.First(x => x.ID == entity.ID).EntityUIComposition.Any()); } }
public bool LinkedServerExists(int firstSideServerID, int secondSideServerId) { using (var projectContext = new DataAccess.MyProjectEntities()) { return(projectContext.LinkedServer.Any(x => x.SourceDBServerID == firstSideServerID && x.TargetDBServerID == secondSideServerId)); } }
public void UpdateDateTimeColumnType(List <DateTimeColumnTypeDTO> columnTypes) { using (var projectContext = new DataAccess.MyProjectEntities()) { foreach (var column in columnTypes) { var dbColumn = projectContext.DateTimeColumnType.First(x => x.ColumnID == column.ColumnID); dbColumn.ShowMiladiDateInUI = column.ShowMiladiDateInUI; dbColumn.ShowAMPMFormat = column.ShowAMPMFormat; dbColumn.HideTimePicker = column.HideTimePicker; if ((Enum_ColumnType)dbColumn.Column.OriginalTypeEnum == Enum_ColumnType.String) { dbColumn.StringDateIsMiladi = column.StringDateIsMiladi; dbColumn.StringTimeISAMPMFormat = column.StringTimeISAMPMFormat; dbColumn.StringTimeIsMiladi = column.StringTimeIsMiladi; } else { dbColumn.StringDateIsMiladi = null; dbColumn.StringTimeISAMPMFormat = null; dbColumn.StringTimeIsMiladi = null; } } projectContext.SaveChanges(); } }
public void UpdateEntityOrganizationSecurityDirect(EntityOrganizationSecurityDirectDTO message) { using (var projectContext = new DataAccess.MyProjectEntities()) { var dbItem = projectContext.EntityOrganizationSecurityDirect.FirstOrDefault(x => x.ID == message.ID); if (dbItem == null) { dbItem = new DataAccess.EntityOrganizationSecurityDirect(); projectContext.EntityOrganizationSecurityDirect.Add(dbItem); } dbItem.TableDrivedEntityID = message.TableDrivedEntityID; dbItem.ColumnID = message.ColumnID; if (message.DBFunctionID != 0) { dbItem.DatabaseFunctionID = message.DBFunctionID; dbItem.Operator = (short)message.Operator; } else { dbItem.DatabaseFunctionID = null; dbItem.Operator = null; } projectContext.SaveChanges(); } }
//public List<CodeFunctionDTO> GetCodeFunctionsByEntityID(DR_Requester requester, int entityID) //{ // List<CodeFunctionDTO> result = new List<CodeFunctionDTO>(); // using (var projectContext = new DataAccess.MyProjectEntities()) // { // IQueryable<CodeFunction> listCodeFunction; // listCodeFunction = projectContext.CodeFunction.Where(x => x.CodeFunction_TableDrivedEntity.Any(y => y.TableDrivedEntityID == entityID)); // foreach (var item in listCodeFunction) // result.Add(ToCodeFunctionDTO(item, false)); // } // return result; //} public List <CodeFunctionDTO> GetAllCodeFunctions(DR_Requester requester, string generalFilter, List <Enum_CodeFunctionParamType> paramTypes) { List <CodeFunctionDTO> result = new List <CodeFunctionDTO>(); using (var projectContext = new DataAccess.MyProjectEntities()) { IQueryable <CodeFunction> listCodeFunction; listCodeFunction = projectContext.CodeFunction; if (!string.IsNullOrEmpty(generalFilter)) { listCodeFunction = listCodeFunction.Where(x => x.Name.Contains(generalFilter) || x.ClassName.Contains(generalFilter) || x.FunctionName.Contains(generalFilter)); } if (paramTypes != null && paramTypes.Any()) { List <short> list = new List <short>(); paramTypes.ForEach(x => list.Add((short)x)); listCodeFunction = listCodeFunction.Where(x => list.Contains(x.Type)); } foreach (var item in listCodeFunction) { result.Add(ToCodeFunctionDTO(item, false)); } } return(result); }
private void dtgRuleOnValues_SelectionChanged(object sender, EventArgs e) { if (dtgArcGroup.SelectedRows.Count > 0) { var arcGroup = dtgArcGroup.SelectedRows.First().DataBoundItem as ArcRelationshipGroup; if (arcGroup.ID == 0) { btnUpdateArcRelationships.Enabled = false; dtgArcRelationships.Enabled = false; } else { btnUpdateArcRelationships.Enabled = true; dtgArcRelationships.Enabled = true; } using (var projectContext = new DataAccess.MyProjectEntities()) { var listRel = projectContext.ArcRelationshipGroup_Relationship.Where(x => x.ArcRelationshipGroupID == arcGroup.ID); dtgArcRelationships.DataSource = listRel.ToList(); } } else { btnUpdateArcRelationships.Enabled = false; dtgArcRelationships.Enabled = false; } }
public bool EntityHasAnyProcess(int targetEntityID) { using (var projectContext = new DataAccess.MyProjectEntities()) { return projectContext.Process.Any(x => x.TableDrivedEntityID == targetEntityID); } }
public bool UpdateColumnValueRange(ColumnValueRangeDTO message) { using (var projectContext = new DataAccess.MyProjectEntities()) { var dbColumn = projectContext.Column.First(x => x.ID == message.ID); if (dbColumn.ColumnValueRange == null) { dbColumn.ColumnValueRange = new ColumnValueRange(); // projectContext.ColumnValueRange.Add(dbColumnValueRange); } //else // dbColumnValueRange = projectContext.ColumnValueRange.First(x => x.ID == message.ID); // dbColumnValueRange.ID = message.ID; //dbColumn.ColumnValueRange.ValueFromTitleOrValue = message.ValueFromTitleOrValue; while (dbColumn.ColumnValueRange.ColumnValueRangeDetails.Any()) { projectContext.ColumnValueRangeDetails.Remove(dbColumn.ColumnValueRange.ColumnValueRangeDetails.First()); } foreach (var keyValueRange in message.Details) { dbColumn.ColumnValueRange.ColumnValueRangeDetails.Add(new ColumnValueRangeDetails() { Value = keyValueRange.Value, KeyTitle = keyValueRange.KeyTitle, Tag1 = keyValueRange.Tag1, Tag2 = keyValueRange.Tag2 }); } //dbColumnValueRange.Name = message.Name; projectContext.SaveChanges(); return(true); } }
internal EntityRelationshipTailDTO ToEntityRelationshipTailDTO(int entityID, string relationshipIDTail) { using (var projectContext = new DataAccess.MyProjectEntities()) { return(ToEntityRelationshipTailDTO(projectContext, relationshipIDTail, entityID, "", 0, "", null, false).Item1); } }
public int UpdateEntityRelationshipTailDataMenu(EntityRelationshipTailDataMenuDTO message) { using (var projectContext = new DataAccess.MyProjectEntities()) { EntityRelationshipTailDataMenu dbItem = null; if (message.ID == 0) { dbItem = new EntityRelationshipTailDataMenu(); projectContext.EntityRelationshipTailDataMenu.Add(dbItem); } else { dbItem = projectContext.EntityRelationshipTailDataMenu.First(x => x.ID == message.ID); } dbItem.Name = message.Name; dbItem.EntityRelationshipTailID = message.EntityRelationshipTailID; while (dbItem.EntityRelationshipTailDataMenuItems.Any()) { projectContext.EntityRelationshipTailDataMenuItems.Remove(dbItem.EntityRelationshipTailDataMenuItems.First()); } foreach (var fitem in message.Items.Where(x => x.DataMenuSettingID != 0)) { dbItem.EntityRelationshipTailDataMenuItems.Add(new EntityRelationshipTailDataMenuItems() { DataMenuSettingID = fitem.DataMenuSettingID, Path = fitem.Path, TableDrivedEntityID = fitem.TableDrivedEntityID }); } projectContext.SaveChanges(); return(dbItem.ID); } }
public List <EntityCommandDTO> GetEntityCommands(DR_Requester requester, int entityID, bool withDetails) { //var cachedItem = CacheManager.GetCacheManager().GetCachedItem(CacheItemType.Command, entityID.ToString()); //if (cachedItem != null) // return (cachedItem as List<EntityCommandDTO>); List <EntityCommandDTO> result = new List <EntityCommandDTO>(); using (var projectContext = new DataAccess.MyProjectEntities()) { IQueryable <EntityCommand> listEntityCommand; if (entityID != 0) { listEntityCommand = projectContext.EntityCommand.Where(x => x.TableDrivedEntity_EntityCommand.Any(y => y.TableDrivedEntityID == entityID)); } else { listEntityCommand = projectContext.EntityCommand; } foreach (var item in listEntityCommand) { if (DataIsAccessable(requester, item)) { result.Add(ToEntityCommandDTO(requester, item, withDetails)); } } } //CacheManager.GetCacheManager().AddCacheItem(result, CacheItemType.Command, entityID.ToString()); return(result); }
private void dtgColumnValues_SelectionChanged(object sender, EventArgs e) { if (dtgColumnValues.SelectedRows.Count > 0) { var ColumnValue = dtgColumnValues.SelectedRows.First().DataBoundItem as ColumnValue; if (ColumnValue.ID == 0) { pageRuleOnColumns.Enabled = false; pageRuleOnRelationships.Enabled = false; } else { pageRuleOnColumns.Enabled = true; pageRuleOnRelationships.Enabled = true; } using (var projectContext = new DataAccess.MyProjectEntities()) { var listCol = projectContext.ColumnValue_Column.Where(x => x.ColumnValueID == ColumnValue.ID); dtgColumnValue_Columns.DataSource = listCol.ToList(); var listRel = projectContext.ColumnValue_Relationship.Where(x => x.ColumnValueID == ColumnValue.ID); dtgColumnValue_Relationships.DataSource = listRel.ToList(); } } else { pageRuleOnColumns.Enabled = false; pageRuleOnRelationships.Enabled = false; } }
public void MergeISARelationships(string name, List <ISARelationshipDTO> relationships, ISARelationshipDTO selectedOne) { using (var projectContext = new DataAccess.MyProjectEntities()) { 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(); } }
//private string GetSchemaObjectName(string dbName, string schemaName) //{ // return dbName + ">" + schemaName; //} public ObjectDTO GetParentObject(DatabaseObjectCategory objectCategory, int objectIdentity) { if (objectCategory == DatabaseObjectCategory.Database) { return(null); } using (var projectContext = new DataAccess.MyProjectEntities()) { ObjectDTO result = null; if (objectCategory == DatabaseObjectCategory.Schema) { //var dbName = objectIdentity.Split('>')[0]; var schema = projectContext.DBSchema.First(x => x.ID == objectIdentity); result = ToObjectDTO(DatabaseObjectCategory.Database, schema.DatabaseInformationID, schema.DatabaseInformation.Name, "", 0); } else if (objectCategory == DatabaseObjectCategory.Entity) { //int id = Convert.ToInt32(objectIdentity); var entity = projectContext.TableDrivedEntity.First(x => x.ID == objectIdentity); result = ToObjectDTO(DatabaseObjectCategory.Schema, entity.Table.DBSchemaID, entity.Table.DBSchema.Name, "", 0); } else if (objectCategory == DatabaseObjectCategory.Column) { //var column = projectContext.TableDrivedEntity.First(x => x.ID == objectIdentity); //result = ToObjectDTO("Schema", GetSchemaObjectName(entity.Table.Catalog, entity.Table.RelatedSchema), entity.Table.RelatedSchema); } return(result); } }
public int Save(ISARelationshipDTO item) { using (var projectContext = new DataAccess.MyProjectEntities()) { ISARelationship dbItem = null; if (item.ID == 0) { dbItem = new ISARelationship(); projectContext.ISARelationship.Add(dbItem); } else { dbItem = projectContext.ISARelationship.First(x => x.ID == item.ID); } dbItem.Name = item.Name; dbItem.IsDisjoint = item.IsDisjoint; dbItem.InternalTable = item.InternalTable == true; //dbItem.InternalTableColumnID = item.InternalTableColumnID == 0 ? (int?)null : item.InternalTableColumnID; dbItem.IsGeneralization = item.IsGeneralization; dbItem.IsSpecialization = !item.IsSpecialization; dbItem.IsTolatParticipation = item.IsTolatParticipation; projectContext.SaveChanges(); return(dbItem.ID); } }
public bool HasEntityNotInNavigationTree(int databaseID) { using (var projectContext = new DataAccess.MyProjectEntities()) { return(projectContext.TableDrivedEntity.Any(x => x.IsOrginal == true && x.IsView == false && x.IsDisabled == false && x.Table.DBSchema.DatabaseInformationID == databaseID && x.IndependentDataEntry == true && !projectContext.NavigationTree.Any(y => y.Category == "Entity" && y.ItemIdentity == x.ID))); } }
public void UpdateEntityExternalReports(DR_Requester requester, EntityExternalReportDTO message) { using (var projectContext = new DataAccess.MyProjectEntities()) { BizEntityReport bizEntityReport = new MyModelManager.BizEntityReport(); var dbEntitySpecifiedReport = projectContext.EntityExternalReport.FirstOrDefault(x => x.ID == message.ID); if (dbEntitySpecifiedReport == null) { message.ReportType = ReportType.SearchableReport; message.SearchableReportType = SearchableReportType.ExternalReport; dbEntitySpecifiedReport = new EntityExternalReport(); dbEntitySpecifiedReport.EntitySearchableReport = bizEntitySearchableReport.ToNewEntitySearchableReport(message); } else { bizEntitySearchableReport.ToUpdateEntitySearchableReport(dbEntitySpecifiedReport.EntitySearchableReport, message); } dbEntitySpecifiedReport.URL = message.URL; if (dbEntitySpecifiedReport.ID == 0) { projectContext.EntityExternalReport.Add(dbEntitySpecifiedReport); } var entity = new BizTableDrivedEntity().GetSimpleEntityWithColumns(requester, message.TableDrivedEntityID); CreateReportTable(entity); //ساختن جدول معادل projectContext.SaveChanges(); } }
public void UpdateEntityActionActivities(int entityId, List <EntityActionActivityDTO> entityActionActivities) { using (var projectContext = new DataAccess.MyProjectEntities()) { var dbEntityActionActivities = projectContext.ActionActivity_TableDrivedEntity.Where(x => x.TableDrivedEntityID == entityId); var sentIds = entityActionActivities.Select(y => y.ID).ToList(); var removeList = dbEntityActionActivities.Where(x => !sentIds.Contains(x.ID)).ToList(); foreach (var item in removeList) { projectContext.ActionActivity_TableDrivedEntity.Remove(item); } foreach (var entityActionActivity in entityActionActivities) { var dbEntityActionActivity = projectContext.ActionActivity_TableDrivedEntity.FirstOrDefault(x => x.ID == entityActionActivity.ID); if (dbEntityActionActivity == null) { dbEntityActionActivity = new DataAccess.ActionActivity_TableDrivedEntity(); } dbEntityActionActivity.StepType = (short)entityActionActivity.Step; dbEntityActionActivity.ActionActivityID = entityActionActivity.ActionActivityID; dbEntityActionActivity.TableDrivedEntityID = entityId; dbEntityActionActivity.ID = entityActionActivity.ID; dbEntityActionActivity.ResultSensetive = entityActionActivity.ResultSensetive; if (dbEntityActionActivity.ID == 0) { projectContext.ActionActivity_TableDrivedEntity.Add(dbEntityActionActivity); } } projectContext.SaveChanges(); } }
//public bool AddCodeFunctionToEntity(int codefuntionID, int entityID, bool showInFormula) //{ // using (var projectContext = new DataAccess.MyProjectEntities()) // { // var dbCodeFunctionEntity = projectContext.CodeFunction_TableDrivedEntity.FirstOrDefault(x => x.TableDrivedEntityID == entityID && x.CodeFunctionID == codefuntionID); // if (dbCodeFunctionEntity == null) // { // projectContext.CodeFunction_TableDrivedEntity.Add(new CodeFunction_TableDrivedEntity() { CodeFunctionID = codefuntionID, TableDrivedEntityID = entityID, ShowInFormula = showInFormula }); // } // else // { // dbCodeFunctionEntity.ShowInFormula = showInFormula; // } // projectContext.SaveChanges(); // } // return true; //} public int UpdateCodeFunctionEntity(CodeFunction_EntityDTO CodeFunctionEntity) { using (var projectContext = new DataAccess.MyProjectEntities()) { var dbCodeFunctionEntity = projectContext.CodeFunction_TableDrivedEntity.FirstOrDefault(x => x.ID == CodeFunctionEntity.ID); if (dbCodeFunctionEntity == null) { dbCodeFunctionEntity = new CodeFunction_TableDrivedEntity(); } dbCodeFunctionEntity.CodeFunctionID = CodeFunctionEntity.CodeFunctionID; dbCodeFunctionEntity.TableDrivedEntityID = CodeFunctionEntity.EntityID; dbCodeFunctionEntity.Title = CodeFunctionEntity.Title; dbCodeFunctionEntity.Name = CodeFunctionEntity.Name; while (dbCodeFunctionEntity.CodeFunction_TableDrivedEntity_Parameters.Any()) { projectContext.CodeFunction_TableDrivedEntity_Parameters.Remove(dbCodeFunctionEntity.CodeFunction_TableDrivedEntity_Parameters.First()); } //if (!CodeFunctionEntity.CodeFunctionEntityColumns.Any(x => x.ColumnID == 0)) //{ foreach (var column in CodeFunctionEntity.CodeFunctionEntityColumns) { CodeFunction_TableDrivedEntity_Parameters dbColumn = new DataAccess.CodeFunction_TableDrivedEntity_Parameters(); dbColumn.ColumnID = column.ColumnID; dbColumn.CodeFunctionParameterID = column.CodeFunctionParameterID; dbCodeFunctionEntity.CodeFunction_TableDrivedEntity_Parameters.Add(dbColumn); } //} if (dbCodeFunctionEntity.ID == 0) { projectContext.CodeFunction_TableDrivedEntity.Add(dbCodeFunctionEntity); } projectContext.SaveChanges(); return(dbCodeFunctionEntity.ID); } }
public bool OrginalEntityExists(string functionName, int databaseID) { using (var projectContext = new DataAccess.MyProjectEntities()) { return(projectContext.DatabaseFunction.Any(x => x.FunctionName == functionName && x.DBSchema.DatabaseInformationID == databaseID)); } }
public int SaveDatabase(DatabaseDTO message) { using (var projectContext = new DataAccess.MyProjectEntities()) { var dbDatabase = projectContext.DatabaseInformation.FirstOrDefault(x => x.ID == message.ID); if (dbDatabase == null) { dbDatabase = new DatabaseInformation(); dbDatabase.SecurityObject = new SecurityObject(); dbDatabase.SecurityObject.Type = (int)DatabaseObjectCategory.Database; } dbDatabase.DBServerID = message.DBServerID; dbDatabase.Name = message.Name; dbDatabase.Title = message.Title; dbDatabase.DBHasDate = message.DBHasData; dbDatabase.ConnectionString = message.ConnectionString; dbDatabase.DBType = message.DBType.ToString(); if (dbDatabase.ID == 0) { projectContext.DatabaseInformation.Add(dbDatabase); } projectContext.SaveChanges(); return(dbDatabase.ID); } }
public DatabaseFunctionDTO GetOrginalDatabaseFunction(string name, int databaseID) { using (var projectContext = new DataAccess.MyProjectEntities()) { return(ToDatabaseFunctionDTO(projectContext.DatabaseFunction.First(x => x.FunctionName == name && x.DBSchema.DatabaseInformationID == databaseID), true)); } }
public void UpdateTimeColumnType(List <TimeColumnTypeDTO> columnTypes) { using (var projectContext = new DataAccess.MyProjectEntities()) { foreach (var column in columnTypes) { var dbColumn = projectContext.TimeColumnType.First(x => x.ColumnID == column.ColumnID); //if (!column.StringValueIsMiladi) //{ // if ((Enum_ColumnType)dbColumn.Column.OriginalTypeEnum == Enum_ColumnType.Time) // { // throw new Exception("ستون از نوع زمان می باشد و گزینه مقدار شمسی به اشتباه انتخاب شده است"); // } //} dbColumn.ShowMiladiTime = column.ShowMiladiTime; dbColumn.ShowAMPMFormat = column.ShowAMPMFormat; if ((Enum_ColumnType)dbColumn.Column.OriginalTypeEnum == Enum_ColumnType.String) { dbColumn.StringTimeIsMiladi = column.StringTimeIsMiladi; dbColumn.StringTimeISAMPMFormat = column.StringTimeISAMPMFormat; } else { dbColumn.StringTimeIsMiladi = null; dbColumn.StringTimeISAMPMFormat = null; } } projectContext.SaveChanges(); } }
public List <DatabaseFunctionDTO> GetAllDatabaseFunctions(DR_Requester dR_Requester, string generalFilter, Enum_DatabaseFunctionType type) { List <DatabaseFunctionDTO> result = new List <DatabaseFunctionDTO>(); using (var projectContext = new DataAccess.MyProjectEntities()) { IQueryable <DatabaseFunction> listDatabaseFunction; listDatabaseFunction = projectContext.DatabaseFunction; if (!string.IsNullOrEmpty(generalFilter)) { listDatabaseFunction = listDatabaseFunction.Where(x => x.FunctionName.Contains(generalFilter)); } if (type == Enum_DatabaseFunctionType.Function) { listDatabaseFunction = listDatabaseFunction.Where(x => x.Type == (short)Enum_DatabaseFunctionType.Function); } else if (type == Enum_DatabaseFunctionType.StoredProcedure) { listDatabaseFunction = listDatabaseFunction.Where(x => x.Type == (short)Enum_DatabaseFunctionType.StoredProcedure); } foreach (var item in listDatabaseFunction) { result.Add(ToDatabaseFunctionDTO(item, false)); } } return(result); }
public void MergeUnionRelationships(string name, List <UnionRelationshipDTO> relationships, UnionRelationshipDTO selectedOne) { using (var projectContext = new DataAccess.MyProjectEntities()) { // 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 List <DatabaseFunctionDTO> GetDatabaseFunctions(DR_Requester requester, Enum_DatabaseFunctionType type, int databaseID = 0) { List <DatabaseFunctionDTO> result = new List <DatabaseFunctionDTO>(); using (var projectContext = new DataAccess.MyProjectEntities()) { //projectContext.Configuration.LazyLoadingEnabled = false; IQueryable <DatabaseFunction> listDatabaseFunction; if (databaseID == 0) { listDatabaseFunction = projectContext.DatabaseFunction; } else { listDatabaseFunction = projectContext.DatabaseFunction.Where(x => x.DBSchema.DatabaseInformationID == databaseID); } if (type == Enum_DatabaseFunctionType.Function) { listDatabaseFunction = listDatabaseFunction.Where(x => x.Type == (short)Enum_DatabaseFunctionType.Function); } else if (type == Enum_DatabaseFunctionType.StoredProcedure) { listDatabaseFunction = listDatabaseFunction.Where(x => x.Type == (short)Enum_DatabaseFunctionType.StoredProcedure); } foreach (var item in listDatabaseFunction) { result.Add(ToDatabaseFunctionDTO(item, false)); } } return(result); }
public void Save(int entityID, List <EntityUICompositionDTO> items) { using (var projectContext = new DataAccess.MyProjectEntities()) { SaveItem(projectContext, entityID, items); try { projectContext.SaveChanges(); } catch (System.Data.Entity.Validation.DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } }
public bool UpdateArchiveFolder(ArchiveFolderDTO message) { List <ArchiveFolderDTO> result = new List <ArchiveFolderDTO>(); using (var projectContext = new DataAccess.MyProjectEntities()) { ArchiveFolder dbitem = null; if (message.ID != 0) { dbitem = projectContext.ArchiveFolder.First(x => x.ID == message.ID); } else { dbitem = new ArchiveFolder(); } dbitem.Name = message.Name; dbitem.TableDrivedEntityID = (message.EntityID == 0 ? (int?)null : message.EntityID); if (dbitem.ID == 0) { projectContext.ArchiveFolder.Add(dbitem); } projectContext.SaveChanges(); } return(true); }