public async Task <int> ReturnProcessTypeFlowPass(SipUser CurrentUser, FrontProcessUpdateGet Process)
{
var Flows = await _frontProcessProvider.FrontProcessUpdateReturnFlows(Process.ProcessTypeStageId);
foreach (var FlowId in Flows)
{
string From = "SELECT ProcessTypeFlowId FROM ProcessTypeFlowPasses";
string Where = " WHERE ProcessTypeFlowId = " + FlowId + " AND ";
var Passes = await _frontProcessProvider.FrontProcessNewReturnFlowPasses(FlowId);
foreach (var Pass in Passes)
{
if (Pass.ProcessTypeFlowConditionTypeId == 1) //Creator is user
{
// From = From + NewProcess. ' '
//Have to check if this can be used in general or only new processes
}
if (Pass.ProcessTypeFlowConditionTypeId == 2) // Field
{
if (!new[] { 1, 2, 12, 13, 30, 31, 32 }.Contains(Pass.ProcessTypeFieldTypeId))
{
Where = Where + " 1=2 ";
}
}
if (Pass.ProcessTypeFlowConditionTypeId == 3) // Security level user
{
var UserSecurityLevel = await _userProvider.UserSecurityLevel(CurrentUser.Id);
if (Pass.ComparisonOperatorID == 1) //Comparison blank
{
Where = Where + " 1=2 ";
}
if (Pass.ComparisonOperatorID == 2 && UserSecurityLevel != Pass.ProcessTypeFlowConditionInt) //Equal
{
Where = Where + " 1=2 ";
}
if (Pass.ComparisonOperatorID == 3 && UserSecurityLevel <= Pass.ProcessTypeFlowConditionInt) //
{
Where = Where + " 1=2 ";
}
if (Pass.ComparisonOperatorID == 4 && UserSecurityLevel >= Pass.ProcessTypeFlowConditionInt)
{
Where = Where + " 1=2 ";
}
if (Pass.ComparisonOperatorID == 5 && UserSecurityLevel < Pass.ProcessTypeFlowConditionInt)
{
Where = Where + " 1=2 ";
}
if (Pass.ComparisonOperatorID == 6 && UserSecurityLevel > Pass.ProcessTypeFlowConditionInt)
{
Where = Where + " 1=2 ";
}
if (Pass.ComparisonOperatorID == 7 && UserSecurityLevel == Pass.ProcessTypeFlowConditionInt)
{
Where = Where + " 1=2 ";
}
}
if (Pass.ProcessTypeFlowConditionTypeId == 4) // Role user
{
var Roles = await _userProvider.UserRoles(CurrentUser.Id);
if (!Roles.Contains(Process.Fields.Find(x => x.ProcessTypeFieldId == Pass.ProcessTypeFieldId).StringValue ?? ""))
{
Where = Where + " 1=2 ";
}
}
//PETER not sure yet
if (Pass.ProcessTypeFlowConditionTypeId == 5) // Manager user field
{
}
if (Pass.ProcessTypeFlowConditionTypeId == 6) // Organization user
{
var Organizations = await _userProvider.UserOrganizations(CurrentUser.Id);
if (!Organizations.Contains(Process.Fields.Find(x => x.ProcessTypeFieldId == Pass.ProcessTypeFieldId).IntValue ?? 0))
{
Where = Where + " 1=2 ";
}
}
if (Pass.ProcessTypeFlowConditionTypeId == 7) // Organization role user
{
var RoleId = Process.Fields.Find(x => x.ProcessTypeFieldId == Pass.ProcessTypeFieldIDRole).StringValue ?? "";
var Organizations = await _userProvider.UserRoleOrganizations(CurrentUser.Id, RoleId);
if (!Organizations.Contains(Process.Fields.Find(x => x.ProcessTypeFieldId == Pass.ProcessTypeFieldId).IntValue ?? 0))
{
Where = Where + " 1=2 ";
}
}
//PETER TODO
if (Pass.ProcessTypeFlowConditionTypeId == 8) // Organization parent user
{
}
if (Pass.ProcessTypeFlowConditionTypeId == 9) // Organization parent role user
{
}
if (Pass.ProcessTypeFlowConditionTypeId == 10) // Project user
{
var Projects = await _userProvider.UserProjects(CurrentUser.Id);
if (!Projects.Contains(Process.Fields.Find(x => x.ProcessTypeFieldId == Pass.ProcessTypeFieldId).IntValue ?? 0))
{
Where = Where + " 1=2 ";
}
}
if (Pass.ProcessTypeFlowConditionTypeId == 11) //Project role user
{
var RoleId = Process.Fields.Find(x => x.ProcessTypeFieldId == Pass.ProcessTypeFieldIDRole).StringValue ?? "";
var Projects = await _userProvider.UserRoleProjects(CurrentUser.Id, RoleId);
if (!Projects.Contains(Process.Fields.Find(x => x.ProcessTypeFieldId == Pass.ProcessTypeFieldId).IntValue ?? 0))
{
Where = Where + " 1=2 ";
}
}
if (Pass.ProcessTypeFlowConditionTypeId == 12) //Project parent user
{
}
if (Pass.ProcessTypeFlowConditionTypeId == 13) //Project parent role user
{
}
if (Pass.ProcessTypeFlowConditionTypeId == 14) //Default organization user
{
var Organization = await _userProvider.UserDefaultOrganization(CurrentUser.Id);
var OrganizationInField = Process.Fields.Find(x => x.ProcessTypeFieldId == Pass.ProcessTypeFieldId).IntValue ?? 0;
if (Organization != OrganizationInField)
{
Where = Where + " 1=2 ";
}
}
if (Pass.ProcessTypeFlowConditionTypeId == 15) //Open bracket
{
Where = Where + " ( ";
}
if (Pass.ProcessTypeFlowConditionTypeId == 16) //and
{
Where = Where + " AND ";
}
if (Pass.ProcessTypeFlowConditionTypeId == 17) //or
{
Where = Where + " OR ";
}
if (Pass.ProcessTypeFlowConditionTypeId == 18) //Close bracket
{
Where = Where + " ) ";
}
if (Pass.ProcessTypeFlowConditionTypeId == 19) //User
{
var UserInField = Process.Fields.Find(x => x.ProcessTypeFieldId == Pass.ProcessTypeFieldId).StringValue ?? "";
if (CurrentUser.Id != UserInField)
{
Where = Where + " 1=2 ";
}
}
if (Pass.ProcessTypeFlowConditionTypeId == 20) //Relation to creator
{
}
if (Pass.ProcessTypeFlowConditionTypeId == 21) //Relation to user field
{
}
if (Pass.ProcessTypeFlowConditionTypeId == 22) //Classification relation
{
}
if (Pass.ProcessTypeFlowConditionTypeId == 23) //Classification relation type
{
}
}
if (Where == " WHERE ProcessTypeFlowId = " + FlowId + " AND ")
{
Where = " WHERE ProcessTypeFlowId = " + FlowId;
}
var SQLStatement = From + Where;
var x = await _frontProcessProvider.ReturnProcessTypeFlowPass(CurrentUser.Id, SQLStatement);
if (x.Count() > 0)
{
return(x.First());
}
else
{
return(0);
}
}
return(0);
}
