protected void btnOK_OnClick(object sender, EventArgs e)
{
var model = projectControl.Model;
if (String.IsNullOrWhiteSpace(model.Name))
{
lblErrorMessage.Text = "შეიყვანეთ სახელი";
mpeProject.Show();
return;
}
var converter = new ProjectModelEntityConverter(HbSession);
var project = HbSession.Query <UM_Project>().FirstOrDefault(n => n.ID == model.ID);
if (project == null)
{
project = new UM_Project
{
ID = Guid.NewGuid(),
DateCreated = DateTime.Now
};
}
converter.FillObject(project, model);
HbSession.SubmitChanges(project);
FillProjectsGrid();
mpeProject.Hide();
}
protected void btProjectOK_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(tbProjectName.Text))
{
lblProjectError.Text = "შეიყვანეთ სახელი";
upnlProject.Update();
mpeProject.Show();
return;
}
var project = new UM_Project
{
ID = Guid.NewGuid(),
DateCreated = DateTime.Now
};
if (ProjectId == null)
{
DataContext.UM_Projects.InsertOnSubmit(project);
}
else
{
project = DataContext.UM_Projects.FirstOrDefault(n => n.ID == ProjectId);
if (project == null)
{
lblProjectError.Text = "პროექტი არ არსებობს";
upnlProject.Update();
mpeProject.Show();
return;
}
}
var exists = DataContext.UM_Projects.Count(n => n.Name == tbProjectName.Text && n.ID != project.ID && n.DateDeleted == null) > 0;
if (exists)
{
lblProjectError.Text = "პროექტი ამ სახელით უკვე არსებობს";
upnlProject.Update();
mpeProject.Show();
return;
}
project.Name = tbProjectName.Text;
project.IsActive = chkIsActive.Checked;
DataContext.SubmitChanges();
FillProjectsGrid();
}
public static UM_Project ToEntity(this ProjectContract contract)
{
if (contract == null)
{
return(null);
}
var entity = new UM_Project();
entity.DateChanged = contract.DateChanged;
entity.DateCreated = contract.DateCreated;
entity.DateDeleted = contract.DateDeleted;
entity.ID = contract.ID;
entity.Name = contract.Name;
return(entity);
}
public static ProjectContract ToContract(this UM_Project entity)
{
if (entity == null)
{
return(null);
}
var contract = new ProjectContract();
contract.DateChanged = entity.DateChanged;
contract.DateCreated = entity.DateCreated;
contract.DateDeleted = entity.DateDeleted;
contract.ID = entity.ID;
contract.Name = entity.Name;
contract.IsActive = entity.IsActive;
return(contract);
}
public static IEnumerable <TreeNodeUnit> CreateListOfTree(ISession session, AttributeSchemasModel model)
{
if (model == null || model.List == null)
{
yield break;
}
var projects = (from n in session.Query <UM_Project>()
where n.DateDeleted == null
orderby n.Name
select n).ToList();
var globalProjectEntity = new UM_Project
{
ID = Guid.Empty,
Name = "Global",
};
projects.Insert(0, globalProjectEntity);
var schemasLp = model.List.ToLookup(n => n.ProjectID.GetValueOrDefault());
foreach (var project in projects)
{
var projectUnit = new TreeNodeUnit
{
ID = project.ID,
Name = project.Name,
Type = "Project"
};
yield return(projectUnit);
var schemas = schemasLp[project.ID];
foreach (var schema in schemas)
{
var schemaUnit = new TreeNodeUnit
{
ID = schema.ID,
Name = schema.Name,
ParentID = project.ID,
Type = "Schema"
};
yield return(schemaUnit);
var fields = schema.Fields;
if (fields != null && fields.List != null)
{
foreach (var field in schema.Fields.List)
{
var nodeUnit = new TreeNodeUnit
{
ID = field.ID,
Name = field.Name,
ParentID = schema.ID,
Type = "Field"
};
yield return(nodeUnit);
}
}
}
}
}
public static IEnumerable <TreeNodeUnit> CreateListOfTree(ISession session)
{
var projects = (from n in session.Query <UM_Project>()
where n.DateDeleted == null
orderby n.Name
select n).ToList();
var globalProjectEntity = new UM_Project
{
ID = Guid.Empty,
Name = "Global",
};
projects.Insert(0, globalProjectEntity);
foreach (var project in projects)
{
var projectUnit = new TreeNodeUnit
{
ID = project.ID,
Name = project.Name,
Type = "Project"
};
yield return(projectUnit);
if (project.AttributesSchemas != null)
{
foreach (var schema in project.AttributesSchemas)
{
if (schema.DateDeleted != null)
{
continue;
}
var schemaUnit = new TreeNodeUnit
{
ID = schema.ID,
Name = schema.Name,
ParentID = project.ID,
Type = "Schema"
};
yield return(schemaUnit);
if (schema.AttributeFields != null)
{
foreach (var field in schema.AttributeFields)
{
if (field.DateDeleted != null)
{
continue;
}
var nodeUnit = new TreeNodeUnit
{
ID = field.ID,
Name = field.Name,
ParentID = schema.ID,
Type = "Field"
};
yield return(nodeUnit);
}
}
}
}
}
}
protected IEnumerable <TreeNodeUnit> CreateListOfTree()
{
var projects = (from n in DataContext.UM_Projects
where n.DateDeleted == null
orderby n.Name
select n).ToList();
var attributesSchemasLp = (from n in DataContext.UM_AttributesSchemas
where n.DateDeleted == null
orderby n.Name
select n).ToLookup(n => n.ProjectID.GetValueOrDefault());
var attributesSchemaNodesLp = (from n in DataContext.UM_AttributesSchemaNodes
where n.DateDeleted == null
orderby n.Name
select n).ToLookup(n => n.AttributesSchemaID);
var globalProjectEntity = new UM_Project
{
ID = Guid.Empty,
Name = "Global",
};
projects.Insert(0, globalProjectEntity);
foreach (var project in projects)
{
var projectUnit = new TreeNodeUnit
{
ID = project.ID,
Name = project.Name,
Type = "Project"
};
yield return(projectUnit);
var attributesSchemas = attributesSchemasLp[project.ID];
foreach (var attributesSchema in attributesSchemas)
{
var schemaUnit = new TreeNodeUnit
{
ID = attributesSchema.ID,
Name = attributesSchema.Name,
ParentID = project.ID,
Type = "Schema"
};
yield return(schemaUnit);
var attributesSchemaNodes = attributesSchemaNodesLp[attributesSchema.ID];
foreach (var attributesSchemaNode in attributesSchemaNodes)
{
var nodeUnit = new TreeNodeUnit
{
ID = attributesSchemaNode.ID,
Name = attributesSchemaNode.Name,
ParentID = attributesSchema.ID,
Type = "Node"
};
yield return(nodeUnit);
}
}
}
}
private IEnumerable <TreeNodeUnit> CreateListOfTree()
{
var projects = (from n in DataContext.UM_Projects
where n.DateDeleted == null
orderby n.Name
select n).ToList();
var attributeTypesLp = (from n in DataContext.UM_AttributeTypes
where n.DateDeleted == null
select n).ToLookup(n => n.ProjectID.GetValueOrDefault());
var attributeCategoriesLp = (from n in DataContext.UM_AttributeCategories
where n.DateDeleted == null
select n).ToLookup(n => n.ProjectID.GetValueOrDefault());
var globalProjectEntity = new UM_Project
{
ID = Guid.Empty,
Name = "Global",
};
projects.Insert(0, globalProjectEntity);
foreach (var project in projects)
{
var projectUnit = new TreeNodeUnit
{
ID = project.ID,
Name = project.Name,
Type = "Project"
};
yield return(projectUnit);
var typesUnit = new TreeNodeUnit
{
ID = CryptographyUtil.ComputeGuidMD5(project.ID, "Types"),
ParentID = project.ID,
Name = "ტიპები",
Type = "Types"
};
yield return(typesUnit);
var categoriesUnit = new TreeNodeUnit
{
ID = CryptographyUtil.ComputeGuidMD5(project.ID, "Categories"),
ParentID = project.ID,
Name = "კატეგორიები",
Type = "Categories"
};
yield return(categoriesUnit);
var attributesTypes = attributeTypesLp[project.ID];
foreach (var attributesType in attributesTypes)
{
var typeUnit = new TreeNodeUnit
{
ID = attributesType.ID,
Name = attributesType.Name,
ParentID = typesUnit.ID,
Type = "Type"
};
yield return(typeUnit);
}
var attributesCategories = attributeCategoriesLp[project.ID];
foreach (var attributesCategory in attributesCategories)
{
var categoryUnit = new TreeNodeUnit
{
ID = attributesCategory.ID,
Name = attributesCategory.Name,
ParentID = categoriesUnit.ID,
Type = "Category"
};
yield return(categoryUnit);
}
}
}
