//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);
}
}
private RadTreeViewItem AddCodeFunctionNode(ItemCollection collection, CodeFunction_EntityDTO codeFunctionEntity)
{
var node = GetNode();
node.DataContext = codeFunctionEntity;
node.Header = GetNodeHeader(codeFunctionEntity.CodeFunction.ClassName, DatabaseObjectCategory.CodeFunction);
node.ToolTip = codeFunctionEntity.CodeFunction.ClassName;
collection.Add(node);
_AllItems.Add(node);
RadContextMenu.SetContextMenu(node, GetCodeFunctionContextMenu(collection, codeFunctionEntity.EntityID, codeFunctionEntity.ID));
return(node);
}
//public List<CodeFunction_EntityDTO> GetCodeFunctionEntities(int entityID)
//{
// List<CodeFunction_EntityDTO> result = new List<CodeFunction_EntityDTO>();
// using (var projectContext = new DataAccess.MyProjectEntities())
// {
// //projectContext.Configuration.LazyLoadingEnabled = false;
// var listCodeFunction = projectContext.CodeFunction_TableDrivedEntity.Where(x => x.TableDrivedEntityID == entityID);
// foreach (var item in listCodeFunction)
// result.Add(ToCodeFunction_EntityDTO(item, false));
// }
// return result;
//}
private CodeFunction_EntityDTO ToCodeFunction_EntityDTO(CodeFunction_TableDrivedEntity cItem, bool withColumns)
{
BizColumn bizColumn = new BizColumn();
var result = new CodeFunction_EntityDTO();
result.ID = cItem.ID;
result.Title = cItem.Title;
result.Name = cItem.Name;
result.EntityID = cItem.TableDrivedEntityID;
result.CodeFunctionID = cItem.CodeFunctionID;
result.CodeFunction = ToCodeFunctionDTO(cItem.CodeFunction, withColumns);
if (withColumns)
{
result.CodeFunctionEntityColumns = ToCodeFunctionEntityColumnsDTO(cItem);
}
return(result);
}
public frmCodeFunction_Entity(int ID, int entityID)
{
InitializeComponent();
// CodeFunctionParamTypes = codeFunctionParamTypes;
Entity = bizEntity.GetTableDrivedEntity(MyProjectManager.GetMyProjectManager.GetRequester(), entityID, EntityColumnInfoType.WithSimpleColumns, EntityRelationshipInfoType.WithoutRelationships);
SetLookups();
if (ID == 0)
{
CodeFunctionEntity = new CodeFunction_EntityDTO();
//lokCodeFunction.ItemsSource = bizCodeFunction.GetCodeFunctionsByEntityID(MyProjectManager.GetMyProjectManager.GetRequester(), Entity.ID);
}
else
{
//lokCodeFunction.Visibility = Visibility.Collapsed;
GetCodeFunctionEntity(ID);
}
SetDataGridColumns();
}
//private void SetCodeFunctionParametersToGrid(CodeFunction_EntityDTO codeFunctionEntity,int codeFunctionID)
//{
//}
private void SetCodeFunctionParametersToGrid(List <CodeFunctionColumnDTO> functionColumns, CodeFunction_EntityDTO codeFunctionEntity)
{
dtgCodeFunctionParams.ItemsSource = null;
List <CodeFunction_Entity_ColumnDTO> gridColumns = new List <CodeFunction_Entity_ColumnDTO>();
foreach (var item in functionColumns)
{
var row = new CodeFunction_Entity_ColumnDTO();
row.CodeFunctionParameterID = item.ID;
row.FunctionColumnParamName = item.ParameterName;
row.FunctionDataType = item.DataType;
row.FunctionColumnDotNetType = item.DotNetType;
var existingRow = codeFunctionEntity.CodeFunctionEntityColumns.FirstOrDefault(x => x.FunctionColumnParamName == item.ParameterName);
if (existingRow != null)
{
row.ColumnID = existingRow.ColumnID;
}
gridColumns.Add(row);
}
dtgCodeFunctionParams.ItemsSource = gridColumns;
}
