/* Add Security Request to add User to group */
public int AddUserRequest(Entities.UserRequest request)
{
int result = 0;
T_JSSE_Security_Request dbJSSE = new T_JSSE_Security_Request();
dbJSSE.Requested_By = request.Requested_By;
dbJSSE.Description = request.Description;
dbJSSE.CreatedBy = request.Requested_By;
dbJSSE.CreatedDate = DateTime.Now;
dbJSSE.Active = true;
result = JSSESecurityManager.AddUserRequest(dbJSSE, request.Org_Id);
return(result);
}
public static int AddUserRequest(T_JSSE_Security_Request request, string orgId)
{
int result = 0;
var context = Global.Context;
var dbRequest = context.T_JSSE_Security_Request.Include("T_JSSE_Security_Group").Where(d => d.Requested_By == request.Requested_By && d.T_JSSE_Security_Group.Org_Id == orgId);
var usrGrp = context.T_JSSE_Security_Group.First(d => (d.Org_Id == orgId && d.GroupLevel == 3));
if (usrGrp == null)
{
result = -2; // -2 for User Group does not exist in Database for selected Organization
}
else if (dbRequest.Count() > 0)
{
result = -1; // User Request has been already created and Saved in database
}
else
{
//Global.Context.AddToT_JSSE_Security_Request(request);
//Global.Context.Attach(usrGrp);
request.T_JSSE_Security_Group = usrGrp;
result = Global.Context.SaveChanges();
}
return(result);
}