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 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 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);
}
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 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 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 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();
}
}
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 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 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 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 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 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 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);
}
}
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 DeleteBackendActionActivity(int iD)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbBackendActionActivity = projectContext.BackendActionActivity.FirstOrDefault(x => x.ID == iD);
projectContext.BackendActionActivity.Remove(dbBackendActionActivity);
projectContext.SaveChanges();
}
}
public int UpdateEntitySearchs(EntitySearchDTO message)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbItem = SaveItem(projectContext, message);
projectContext.SaveChanges();
return(dbItem.ID);
}
}
public bool SetDefaultDataMenuSetting(int entityID, int iD)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbEntity = projectContext.TableDrivedEntity.FirstOrDefault(x => x.ID == entityID);
dbEntity.DataMenuSettingID = iD;
projectContext.SaveChanges();
}
return(true);
}
public int UpdateBackendActionActivitys(BackendActionActivityDTO BackendActionActivity)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbBackendActionActivity = projectContext.BackendActionActivity.FirstOrDefault(x => x.ID == BackendActionActivity.ID);
if (dbBackendActionActivity == null)
{
dbBackendActionActivity = new DataAccess.BackendActionActivity();
}
if (BackendActionActivity.CodeFunctionID != 0)
{
dbBackendActionActivity.CodeFunctionID = BackendActionActivity.CodeFunctionID;
}
else
{
dbBackendActionActivity.CodeFunctionID = null;
}
if (BackendActionActivity.DatabaseFunctionEntityID != 0)
{
dbBackendActionActivity.DatabaseFunctionEntityID = BackendActionActivity.DatabaseFunctionEntityID;
}
else
{
dbBackendActionActivity.DatabaseFunctionEntityID = null;
}
dbBackendActionActivity.ID = BackendActionActivity.ID;
dbBackendActionActivity.Type = (short)BackendActionActivity.Type;
//dbBackendActionActivity.ActivityType = (short)BackendActionActivity.BackendActionActivityType;
dbBackendActionActivity.Title = BackendActionActivity.Title;
if (BackendActionActivity.EntityID == 0)
{
dbBackendActionActivity.TableDrivedEntityID = null;
}
else
{
dbBackendActionActivity.TableDrivedEntityID = BackendActionActivity.EntityID;
}
dbBackendActionActivity.StepType = (short)BackendActionActivity.Step;
dbBackendActionActivity.ResultSensetive = BackendActionActivity.ResultSensetive;
if (dbBackendActionActivity.ID == 0)
{
projectContext.BackendActionActivity.Add(dbBackendActionActivity);
}
projectContext.SaveChanges();
return(dbBackendActionActivity.ID);
}
}
public void UpdateEntityCommands(EntityCommandDTO EntityCommand)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbEntityCommand = projectContext.EntityCommand.FirstOrDefault(x => x.ID == EntityCommand.ID);
if (dbEntityCommand == null)
{
dbEntityCommand = new DataAccess.EntityCommand();
dbEntityCommand.SecurityObject = new SecurityObject();
dbEntityCommand.SecurityObject.Type = (int)DatabaseObjectCategory.Command;
}
//if (EntityCommand.FormulaID != 0)
// dbEntityCommand.FormulaID = EntityCommand.FormulaID;
//else
// dbEntityCommand.FormulaID = null;
//if (EntityCommand.CodeFunctionID != 0)
//{
dbEntityCommand.CodeFunctionID = EntityCommand.CodeFunctionID;
//}
//else
// dbEntityCommand.CodeFunctionID = null;
// dbEntityCommand.TableDrivedEntityID = EntityCommand.TableDrivedEntityID;
dbEntityCommand.ID = EntityCommand.ID;
//dbEntityCommand.Message = EntityCommand.Message;
dbEntityCommand.Title = EntityCommand.Title;
dbEntityCommand.Type = (short)EntityCommand.Type;
var entityIds = EntityCommand.Entities.Select(x => x.EntityID).ToList();
var removeList = dbEntityCommand.TableDrivedEntity_EntityCommand.Where(x => !entityIds.Contains(x.TableDrivedEntityID));
foreach (var item in removeList)
{
projectContext.TableDrivedEntity_EntityCommand.Remove(item);
}
foreach (var item in entityIds)
{
if (!dbEntityCommand.TableDrivedEntity_EntityCommand.Any(x => x.TableDrivedEntityID == item))
{
dbEntityCommand.TableDrivedEntity_EntityCommand.Add(new TableDrivedEntity_EntityCommand()
{
TableDrivedEntityID = item
});
}
}
//dbEntityCommand.Value = EntityCommand.Value;
if (dbEntityCommand.ID == 0)
{
projectContext.EntityCommand.Add(dbEntityCommand);
}
projectContext.SaveChanges();
}
}
public void Save(List <DatabaseFunctionDTO> list)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
foreach (var dbFunction in list)
{
var dbEntity = projectContext.DatabaseFunction.First(x => x.ID == dbFunction.ID);
dbEntity.Title = dbFunction.Title;
//dbEntity.ValueCustomType = (short)dbFunction.ValueCustomType;
}
projectContext.SaveChanges();
}
}
//public FormulaDTO GetCustomCalculationFormula(int columnID)
//{
// using (var projectContext = new DataAccess.MyProjectEntities())
// {
// var column = projectContext.Column.FirstOrDefault(x => x.ID == columnID);
// if (column.CustomCalculatedColumn != null)
// return new BizFormula().GetFormula(column.CustomCalculatedColumn.FormulaID, false);
// }
// return null;
//}
public void UpdateColumns(int entityID, List <ColumnDTO> columns)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbEntity = projectContext.TableDrivedEntity.First(x => x.ID == entityID);
dbEntity.ColumnsReviewed = true;
foreach (var column in columns)
{
var dbColumn = projectContext.Column.First(x => x.ID == column.ID);
dbColumn.Alias = column.Alias;
dbColumn.DefaultValue = column.DefaultValue;
dbColumn.IsMandatory = column.IsMandatory;
dbColumn.Position = column.Position;
dbColumn.Description = column.Description;
if (column.PrimaryKey || column.ForeignKey)
{
}
else
{
dbColumn.IsDisabled = column.IsDisabled;
dbColumn.IsReadonly = column.IsReadonly;
dbColumn.DataEntryEnabled = column.DataEntryEnabled;
dbColumn.IsNotTransferable = column.IsNotTransferable;
}
//if(dbEntity.IsView)
//{
// dbColumn.PrimaryKey = column.PrimaryKey;
//}
// if (column.CustomFormulaID != 0)
// {
// //if (dbColumn.CustomCalculatedColumn == null)
// // dbColumn.CustomCalculatedColumn = new CustomCalculatedColumn();
// //dbColumn.CustomCalculatedColumn.FormulaID = column.CustomFormulaID;
// //dbColumn.IsCustomColumn = true;
// }
// else
// {
//// dbColumn.IsCustomColumn = false;
// //if (dbColumn.CustomCalculatedColumn != null)
// //{
// // projectContext.CustomCalculatedColumn.Remove(dbColumn.CustomCalculatedColumn);
// //}
// }
}
projectContext.SaveChanges();
}
}
public bool DeleteEntitySecurityDirect(int id)
{
EntitySecurityDirectDTO result = new EntitySecurityDirectDTO();
using (var projectContext = new DataAccess.MyProjectEntities())
{
var item = projectContext.EntitySecurityDirect.FirstOrDefault(x => x.ID == id);
//foreach (var child in item.EntitySecurityDirectStates.ToList())
// projectContext.EntitySecurityDirectStates.Remove(child);
projectContext.EntitySecurityDirect.Remove(item);
projectContext.SaveChanges();
return(true);
}
}
public void UpdateStringColumnType(List <StringColumnTypeDTO> columnTypes)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
foreach (var column in columnTypes)
{
var dbColumn = projectContext.StringColumnType.First(x => x.ColumnID == column.ColumnID);
dbColumn.MaxLength = column.MaxLength;
dbColumn.MinLength = column.MinLength;
dbColumn.Format = column.Format;
}
projectContext.SaveChanges();
}
}
public void DeleteColumnCustomFormula(int columnID)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbColumn = projectContext.Column.First(x => x.ID == columnID);
if (dbColumn.ColumnCustomFormula == null)
{
projectContext.ColumnCustomFormula.Remove(dbColumn.ColumnCustomFormula);
}
projectContext.SaveChanges();
}
}
public int UpdateEntityListViews(EntityListViewDTO message)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbEntityListView = SaveItem(projectContext, message);
try
{
projectContext.SaveChanges();
}
catch (Exception ex)
{
}
return(dbEntityListView.ID);
}
}
public void UpdateNumericColumnType(List <NumericColumnTypeDTO> columnTypes)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
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 ColumnValueRangeDTO GetColumnValueRange(column)
//{
// ColumnDTO result = new ColumnDTO();
// using (var projectContext = new DataAccess.MyProjectEntities())
// {
// var column = projectContext.ColumnValueRange.First(x => x.ID == id);
// return ToColumnValueRangeDTO(column);
// }
//}
public void RemoveColumnValueRangeID(int columnID)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbColumnValueRange = projectContext.ColumnValueRange.FirstOrDefault(x => x.ID == columnID);
if (dbColumnValueRange != null)
{
while (dbColumnValueRange.ColumnValueRangeDetails.Any())
{
projectContext.ColumnValueRangeDetails.Remove(dbColumnValueRange.ColumnValueRangeDetails.First());
}
projectContext.ColumnValueRange.Remove(dbColumnValueRange);
projectContext.SaveChanges();
}
}
}
public int GetOrCreateEntityRelationshipTailID(int entityID, string path)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
//var dbEntityRelationshipTail = ToEntityRelationshipTail(entityID, targetEntityID, EntityRelationshipTail, "");
//projectContext.EntityRelationshipTail.Add(dbEntityRelationshipTail);
var dbItem = projectContext.EntityRelationshipTail.FirstOrDefault(x => x.TableDrivedEntityID == entityID && x.RelationshipPath == path);
if (dbItem == null)
{
dbItem = GetOrCreateEntityRelationshipTail(projectContext, entityID, path);
projectContext.SaveChanges();
}
return(dbItem.ID);
}
}
public void UpdateSubUnionToSuperUnionRelationships(List <SubUnionToSuperUnionRelationshipDTO> relationships)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
foreach (var relationship in relationships)
{
var dbRelationship = projectContext.SubUnionToUnionRelationshipType.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;
}
projectContext.SaveChanges();
}
}
