public bool IsSelf(string userId, Guid processId)
{
using (wfe_sampleEntities entities = new wfe_sampleEntities())
{
return(entities.WorkflowProcessTransitionHistories.FirstOrDefault(h => h.ProcessId == processId && h.FromStateName == "Initial").ExecutorIdentityId == userId);
}
}
public List <Guid> GetNonFinalizedInstances(string schemeCode)
{
var entities = new wfe_sampleEntities();
var schemeId = entities.WorkflowProcessSchemes.FirstOrDefault(w => w.SchemeCode == schemeCode && w.IsObsolete == false).Id;
return(entities.WorkflowProcessInstances.Where(w => w.SchemeId == schemeId && w.StateName != "Final").Select(s => s.Id).ToList());
}
public IHttpActionResult Users()
{
using (wfe_sampleEntities entities = new wfe_sampleEntities())
{
var users = entities.Employees.ToList();
return(Ok(new { data = users, success = true, error = "", message = "" }));
}
}
public IHttpActionResult Identities(ExecuteParameters executeParameters)
{
using (wfe_sampleEntities entities = new wfe_sampleEntities())
{
var identities = entities.Employees.Where(e => e.Role.Name == executeParameters.Name).Select(s => s.Name).ToList();
return(Ok(new { data = identities, success = true, error = "", message = "" }));
}
}
public IHttpActionResult Roles()
{
using (wfe_sampleEntities entities = new wfe_sampleEntities())
{
var roles = entities.Roles.Select(r => r.Name).ToList();
return(Ok(new { data = roles, success = true, error = "", message = "" }));
}
}
private bool IsAdmin(string userId)
{
using (wfe_sampleEntities entities = new wfe_sampleEntities())
{
var user = entities.Employees.FirstOrDefault(e => e.Name == userId && e.Role.Name == "Admin");
return(user != null);
}
}
public bool IsAuthorized(string userId)
{
using (wfe_sampleEntities entities = new wfe_sampleEntities())
{
var user = entities.Employees.FirstOrDefault(e => e.Name == userId && (e.Role.Name == "Manager" || e.Role.Name == "Admin"));
return(user != null);
}
}
public bool IsUser(string userId)
{
using (wfe_sampleEntities entities = new wfe_sampleEntities())
{
var user = entities.Employees.FirstOrDefault(e => e.Name == userId && e.Role.Name == "User");
return(user != null);
}
}
public bool IsManagerApprovalNeeded(Guid processId)
{
using (wfe_sampleEntities entities = new wfe_sampleEntities())
{
var processParams = entities.WorkflowProcessInstancePersistences.Where(w => w.ProcessId == processId);
var autoApprovedLeaveDays = Convert.ToInt32(processParams.FirstOrDefault(p => p.ParameterName == "AutoApprovedLeaveDays").Value);
var appliedLeaveDays = Convert.ToInt32(processParams.FirstOrDefault(p => p.ParameterName == "LeaveDays").Value);
return(appliedLeaveDays > autoApprovedLeaveDays);
}
}
