public async Task <IActionResult> RecordsPerGeometry(Guid id, bool withOnlyGeometries = false)
{
User user = Helpers.UserHelper.GetCurrentUser(User, db);
List <Project> projects = new List <Project>();
List <Project> erfassendeProjects = new List <Project>();
if (User.IsInRole("DM"))
{
projects = await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.DM);
}
if (User.IsInRole("EF"))
{
erfassendeProjects = await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.EF);
}
if (User.IsInRole("PK"))
{
projects.AddRange(await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.PK));
}
if (User.IsInRole("PL"))
{
projects.AddRange(await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.PL));
}
projects.AddRange(await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.LE));
projects.AddRange(erfassendeProjects);
Project p = await db.Projects
.Include(m => m.ProjectGroups).ThenInclude(u => u.Geometries).ThenInclude(pg => pg.Records).ThenInclude(u => u.TextData).ThenInclude(td => td.FormField)
.Include(m => m.ProjectGroups).ThenInclude(u => u.Geometries).ThenInclude(pg => pg.Records).ThenInclude(u => u.NumericData).ThenInclude(td => td.FormField)
.Include(m => m.ProjectGroups).ThenInclude(u => u.Geometries).ThenInclude(pg => pg.Records).ThenInclude(u => u.BooleanData).ThenInclude(td => td.FormField)
.Include(m => m.ProjectGroups).ThenInclude(u => u.Geometries).ThenInclude(pg => pg.Records).ThenInclude(u => u.Form).ThenInclude(f => f.FormFormFields).ThenInclude(fff => fff.FormField)
.Include(m => m.ProjectGroups).ThenInclude(u => u.Geometries).ThenInclude(pg => pg.Records).ThenInclude(u => u.Form).ThenInclude(f => f.FormFormFields).ThenInclude(fff => fff.FormField).ThenInclude(mo => mo.PublicMotherFormField)
.Include(m => m.ProjectGroups).ThenInclude(u => u.Geometries).ThenInclude(pg => pg.Records).ThenInclude(u => u.ProjectGroup.Group)
.Include(m => m.ProjectGroups).ThenInclude(u => u.Geometries).ThenInclude(pg => pg.Records).ThenInclude(u => u.Geometry)
.Include(m => m.ProjectGroups).ThenInclude(u => u.Geometries).ThenInclude(pg => pg.Records).ThenInclude(u => u.RecordChangeLogs).ThenInclude(rcl => rcl.ChangeLog).ThenInclude(cl => cl.User)
.Include(m => m.ProjectGroups).ThenInclude(u => u.Geometries).ThenInclude(pg => pg.Records).Where(pg => pg.StatusId != StatusEnum.deleted)
.Where(m => m.ProjectId == id)
.Where(m => m.StatusId != StatusEnum.deleted).FirstOrDefaultAsync();
if (p == null)
{
return(StatusCode(500));
}
if (!projects.Any(m => m.ProjectId == p.ProjectId))
{
return(RedirectToAction("NotAllowed", "Home"));
}
List <GeometrieViewModel> gvms = new List <GeometrieViewModel>();
List <Group> myGroups = await db.Groups.Where(m => m.GroupUsers.Any(u => u.UserId == user.UserId)).ToListAsync();
foreach (ProjectGroup g in p.ProjectGroups)
{
List <ReferenceGeometry> geometries = g.Geometries.Where(m => m.StatusId != StatusEnum.deleted).ToList();
foreach (ReferenceGeometry rg in geometries)
{
GeometrieViewModel gvm = new GeometrieViewModel()
{
Geometry = rg
};
gvm.Records = new List <RecordViewModel>();
await CreateDynamicView(db, rg, g, myGroups, gvm);
if (gvms.Any(m => m.Geometry.GeometryId == gvm.Geometry.GeometryId))
{
GeometrieViewModel alreadyExist = gvms.Where(m => m.Geometry.GeometryId == gvm.Geometry.GeometryId).First();
alreadyExist.Records.AddRange(gvm.Records);
}
else
{
gvms.Add(gvm);
}
}
}
ViewData["withOnlyGeometries"] = withOnlyGeometries;
if (!erfassendeProjects.Contains(p))
{
ViewData["ReadOnly"] = true;
}
else
{
ViewData["ReadOnly"] = false;
}
GeometriesViewModel returnObject = new GeometriesViewModel()
{
Project = p, GeometrieViewModels = gvms
};
return(View(returnObject));
}
public async Task <IActionResult> Details(Guid id)
{
User user = Helpers.UserHelper.GetCurrentUser(User, db);
ReferenceGeometry g = await db.Geometries
.Include(m => m.Records).ThenInclude(u => u.TextData).ThenInclude(td => td.FormField)
.Include(m => m.Records).ThenInclude(u => u.NumericData).ThenInclude(td => td.FormField)
.Include(m => m.Records).ThenInclude(u => u.BooleanData).ThenInclude(td => td.FormField)
.Include(m => m.Records).ThenInclude(u => u.Form).ThenInclude(f => f.FormFormFields).ThenInclude(fff => fff.FormField)
.Include(m => m.Records).ThenInclude(u => u.Form).ThenInclude(f => f.FormFormFields).ThenInclude(fff => fff.FormField).ThenInclude(mo => mo.PublicMotherFormField)
.Include(m => m.Records).ThenInclude(u => u.ProjectGroup.Group)
.Include(m => m.Records).ThenInclude(u => u.RecordChangeLogs).ThenInclude(rcl => rcl.ChangeLog).ThenInclude(cl => cl.User)
.Where(m => m.GeometryId == id)
.Where(m => m.StatusId != StatusEnum.deleted).FirstOrDefaultAsync();
if (g == null)
{
return(StatusCode(500));
}
List <Project> projects = new List <Project>();
List <Project> erfassendeProjects = new List <Project>();
if (User.IsInRole("DM"))
{
projects = await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.DM);
erfassendeProjects = projects;
}
else if (User.IsInRole("EF"))
{
erfassendeProjects = await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.EF);
}
if (User.IsInRole("PK"))
{
projects.AddRange(await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.PK));
erfassendeProjects.AddRange(await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.PK));
}
if (User.IsInRole("PL"))
{
projects.AddRange(await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.PL));
erfassendeProjects.AddRange(await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.PL));
}
projects.AddRange(await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.LE));
projects.AddRange(await DB.Helpers.ProjectManager.UserProjectsAsync(db, user, RoleEnum.LE_OGD));
projects.AddRange(erfassendeProjects);
if (!projects.Any(m => m.ProjectId == g.ProjectGroupProjectId))
{
return(StatusCode(StatusCodes.Status403Forbidden));
}
if (!erfassendeProjects.Any(m => m.ProjectId == g.ProjectGroupProjectId))
{
ViewData["ReadOnly"] = true;
}
else
{
ViewData["ReadOnly"] = false;
}
GeometrieViewModel gvm = new GeometrieViewModel()
{
Geometry = g
};
gvm.Records = new List <RecordViewModel>();
List <Group> myGroups;
if (User.IsInRole("DM"))
{
myGroups = await db.Groups.ToListAsync();
}
else if ((User.IsInRole("PK")) || (User.IsInRole("PL")))
{
Project p = await db.Projects.Where(m => m.ProjectId == g.ProjectGroupProjectId).Include(m => m.ProjectConfigurator).Include(m => m.ProjectManager).FirstAsync();
if ((p.ProjectConfigurator.UserId == user.UserId) || (p.ProjectManager.UserId == user.UserId))
{
myGroups = await db.Groups.ToListAsync();
}
else
{
myGroups = await db.Groups.Where(m => m.GroupUsers.Any(u => u.UserId == user.UserId)).ToListAsync();
}
}
else
{
myGroups = await db.Groups.Where(m => m.GroupUsers.Any(u => u.UserId == user.UserId)).ToListAsync();
}
await RecordsController.CreateDynamicView(db, g, g.ProjectGroup, myGroups, gvm);
List <string> pluginslist = new List <string>();
// Are there any plugins for the forms?
foreach (IReferenceGeometryPlugin rge in _referenceGeometryExtension.Plugins)
{
if (g.Records.Any(m => m.FormId == rge.FormId))
{
pluginslist.Add(rge.GetName());
}
}
ViewBag.plugins = pluginslist;
return(View(gvm));
}
public static async Task CreateDynamicView(BioDivContext db, ReferenceGeometry rg, ProjectGroup g, List <Group> myGroups, GeometrieViewModel gvm)
{
foreach (Record r in rg.Records.Where(m => m.StatusId != StatusEnum.deleted))
{
bool isReadOnly = true;
if (g == null)
{
isReadOnly = false;
}
else if ((g.GroupStatusId != GroupStatusEnum.Gruppendaten_gueltig) && (g.GroupStatusId != GroupStatusEnum.Gruppendaten_erfasst))
{
if (myGroups.Where(m => m.GroupId == r.ProjectGroupGroupId).Count() > 0)
{
isReadOnly = false;
}
}
RecordViewModel rvm = new RecordViewModel()
{
Record = r
};
List <PropertyVm> dynamicForm = new List <PropertyVm>();
// BDC Guid
PropertyVm dynamicFieldGUID = new PropertyVm(typeof(string), "Field_" + r.RecordId);
dynamicFieldGUID.DisplayName = "BDCGuid";
dynamicFieldGUID.Value = r.BDCGuid;
dynamicFieldGUID.GetCustomAttributes = () => new object[] { new Helpers.FormFactory.GuidAttribute() };
dynamicForm.Add(dynamicFieldGUID);
if (r.Form != null)
{
foreach (FormField ff in r.Form.FormFormFields.Select(fff => fff.FormField).OrderBy(m => m.Order))
{
FormField origFormField = ff;
if (ff.PublicMotherFormField != null)
{
origFormField = ff.PublicMotherFormField;
}
if (origFormField.FieldTypeId == FieldTypeEnum.Text)
{
PropertyVm dynamicField = new PropertyVm(typeof(string), "Field_" + ff.FormFieldId.ToString());
dynamicField.DisplayName = origFormField.Title;
TextData td = r.TextData.Where(m => m.FormField == ff).FirstOrDefault();
if (td != null)
{
dynamicField.Value = td.Value;
}
dynamicField.NotOptional = ff.Mandatory;
dynamicForm.Add(dynamicField);
}
else if (origFormField.FieldTypeId == FieldTypeEnum.DateTime)
{
PropertyVm dynamicField = new PropertyVm(typeof(DateTime), "Field_" + ff.FormFieldId.ToString());
dynamicField.DisplayName = origFormField.Title;
TextData td = r.TextData.Where(m => m.FormField == ff).FirstOrDefault();
DateTime myDT = new DateTime();
try
{
myDT = DateTime.ParseExact(td.Value.Replace("{0:", " ").Replace("}", ""), formats, CultureInfo.InvariantCulture, DateTimeStyles.None);
}
catch (Exception e)
{
}
if (td != null)
{
dynamicField.Value = myDT;
}
dynamicField.NotOptional = ff.Mandatory;
dynamicForm.Add(dynamicField);
}
else if (origFormField.FieldTypeId == FieldTypeEnum.Choice)
{
PropertyVm dynamicField = new PropertyVm(typeof(string), "Field_" + ff.FormFieldId.ToString());
dynamicField.DisplayName = origFormField.Title;
TextData td = r.TextData.Where(m => m.FormField == ff).FirstOrDefault();
if (td != null)
{
dynamicField.Value = td.Value;
}
await db.Entry(origFormField).Collection(m => m.FieldChoices).LoadAsync();
if (origFormField.FieldChoices != null)
{
List <string> choices = new List <string>();
foreach (FieldChoice fc in origFormField.FieldChoices.OrderBy(m => m.Order))
{
choices.Add(fc.Text);
}
dynamicField.Choices = choices;
}
dynamicField.NotOptional = ff.Mandatory;
dynamicForm.Add(dynamicField);
}
else if (origFormField.FieldTypeId == FieldTypeEnum.Boolean)
{
PropertyVm dynamicField = new PropertyVm(typeof(bool), "Field_" + ff.FormFieldId.ToString());
dynamicField.DisplayName = origFormField.Title;
BooleanData bd = r.BooleanData.Where(m => m.FormField == ff).FirstOrDefault();
if (bd != null)
{
dynamicField.Value = bd.Value;
}
dynamicField.NotOptional = ff.Mandatory;
dynamicField.GetCustomAttributes = () => new object[] { new FormFactory.Attributes.LabelOnRightAttribute() };
dynamicForm.Add(dynamicField);
}
}
PropertyVm dynamicHiddenField = new PropertyVm(typeof(string), "RecordId");
dynamicHiddenField.Value = r.RecordId.ToString();
dynamicHiddenField.NotOptional = true;
dynamicHiddenField.IsHidden = true;
dynamicForm.Add(dynamicHiddenField);
if (isReadOnly)
{
foreach (PropertyVm pv in dynamicForm)
{
pv.Readonly = true;
}
}
rvm.Readonly = isReadOnly;
rvm.DynamicForm = dynamicForm;
rvm.Group = r.ProjectGroup.Group;
gvm.Records.Add(rvm);
}
}
return;
}
