public frmDatabaseFunction_Entity(int ID, int entityID)
{
InitializeComponent();
// DatabaseFunctionParamTypes = DatabaseFunctionParamTypes;
Entity = bizEntity.GetTableDrivedEntity(MyProjectManager.GetMyProjectManager.GetRequester(), entityID, EntityColumnInfoType.WithSimpleColumns, EntityRelationshipInfoType.WithoutRelationships);
SetLookups();
if (ID == 0)
{
DatabaseFunctionEntity = new DatabaseFunction_EntityDTO();
lokDatabaseFunction.ItemsSource = bizDatabaseFunction.GetDatabaseFunctions(MyProjectManager.GetMyProjectManager.GetRequester(), Enum_DatabaseFunctionType.None, Entity.DatabaseID);
}
else
{
lokDatabaseFunction.Visibility = Visibility.Collapsed;
GetDatabaseFunctionEntity(ID);
}
SetDataGridColumns();
}
public DatabaseFunction_EntityDTO ToDatabaseFunction_EntityDTO(DatabaseFunction_TableDrivedEntity cItem, bool withColumns)
{
BizColumn bizColumn = new BizColumn();
var result = new DatabaseFunction_EntityDTO();
result.ID = cItem.ID;
result.Title = cItem.Title;
result.Name = cItem.Name;
result.EntityID = cItem.TableDrivedEntityID;
result.DatabaseFunctionID = cItem.DatabaseFunctionID;
result.DatabaseFunction = ToDatabaseFunctionDTO(cItem.DatabaseFunction, withColumns);
if (withColumns)
{
result.DatabaseFunctionEntityColumns = ToDatabaseFunctionEntityColumnsDTO(cItem);
}
return(result);
}
public int UpdateDatabaseFunctionEntity(DatabaseFunction_EntityDTO DatabaseFunctionEntity)
{
using (var projectContext = new DataAccess.MyProjectEntities())
{
var dbDatabaseFunctionEntity = projectContext.DatabaseFunction_TableDrivedEntity.FirstOrDefault(x => x.ID == DatabaseFunctionEntity.ID);
if (dbDatabaseFunctionEntity == null)
{
dbDatabaseFunctionEntity = new DatabaseFunction_TableDrivedEntity();
}
dbDatabaseFunctionEntity.DatabaseFunctionID = DatabaseFunctionEntity.DatabaseFunctionID;
dbDatabaseFunctionEntity.TableDrivedEntityID = DatabaseFunctionEntity.EntityID;
dbDatabaseFunctionEntity.Title = DatabaseFunctionEntity.Title;
dbDatabaseFunctionEntity.Name = DatabaseFunctionEntity.Name;
while (dbDatabaseFunctionEntity.DatabaseFunction_TableDrivedEntity_Columns.Any())
{
dbDatabaseFunctionEntity.DatabaseFunction_TableDrivedEntity_Columns.Remove(dbDatabaseFunctionEntity.DatabaseFunction_TableDrivedEntity_Columns.First());
}
foreach (var column in DatabaseFunctionEntity.DatabaseFunctionEntityColumns)
{
DatabaseFunction_TableDrivedEntity_Columns dbColumn = new DataAccess.DatabaseFunction_TableDrivedEntity_Columns();
if (column.ColumnID != 0)
{
dbColumn.ColumnID = column.ColumnID;
dbColumn.FixedParamID = null;
}
else
{
dbColumn.ColumnID = null;
dbColumn.FixedParamID = (short)column.FixedParam;
}
dbColumn.DatabaseFunctionParameterID = column.DatabaseFunctionParameterID;
dbDatabaseFunctionEntity.DatabaseFunction_TableDrivedEntity_Columns.Add(dbColumn);
}
if (dbDatabaseFunctionEntity.ID == 0)
{
projectContext.DatabaseFunction_TableDrivedEntity.Add(dbDatabaseFunctionEntity);
}
projectContext.SaveChanges();
return(dbDatabaseFunctionEntity.ID);
}
}
private void SetDatabaseFunctionParametersToGrid(List <DatabaseFunctionColumnDTO> functionColumns, DatabaseFunction_EntityDTO DatabaseFunctionEntity)
{
dtgDatabaseFunctionParams.ItemsSource = null;
List <DatabaseFunction_Entity_ColumnDTO> gridColumns = new List <DatabaseFunction_Entity_ColumnDTO>();
foreach (var item in functionColumns.Where(x => x.InputOutput == Enum_DatabaseFunctionParameterType.Input || x.InputOutput == Enum_DatabaseFunctionParameterType.InputOutput))
{
var row = new DatabaseFunction_Entity_ColumnDTO();
row.DatabaseFunctionParameterID = item.ID;
row.FunctionColumnParamName = item.ParameterName;
row.FunctionDataType = item.DataType;
row.FunctionColumnDotNetType = item.DotNetType;
var existingRow = DatabaseFunctionEntity.DatabaseFunctionEntityColumns.FirstOrDefault(x => x.FunctionColumnParamName == item.ParameterName);
if (existingRow != null)
{
row.ColumnID = existingRow.ColumnID;
}
gridColumns.Add(row);
}
dtgDatabaseFunctionParams.ItemsSource = gridColumns;
}