/* Get User Info of a user by alias */
public Entities.UserInfo GetUserInfo(string userName)
{
Entities.UserInfo userInfo = new Entities.UserInfo();
try
{
var dbUserGroup = JSSESecurityManager.GetUserInfo(userName);
if (dbUserGroup != null)
{
userInfo.CompanyId = dbUserGroup.Company_Cd;
userInfo.Emp_Id = dbUserGroup.Emp_No;
userInfo.User_ID = dbUserGroup.PRIMARY_WINDOWS_NT_ACCOUNT;
userInfo.FirstName = dbUserGroup.FIRST_NAME;
userInfo.LastName = dbUserGroup.LAST_NAME;
userInfo.FullName = dbUserGroup.LAST_NAME + " " + dbUserGroup.FIRST_NAME;
userInfo.Email = dbUserGroup.EMAIL_ADDRESS_COMPANY;
userInfo.MajorGroup_Id = dbUserGroup.VP_CD.ToString();
userInfo.Org_Id = dbUserGroup.ORG_CD.ToString();
userInfo.Dept_Id = dbUserGroup.DEPT_CD.ToString();
userInfo.Section_Id = dbUserGroup.SECT_CD.ToString();
}
}
catch
{
throw;
}
return(userInfo);
}
public JSSEMain GetJSSE(int jsseId)
{
JSSEMain oJsse = new JSSEMain();
try
{
var dbJsses = jsseRepo.GetJSSE(jsseId).ToList();
foreach (var dbJSSE in dbJsses)
{
oJsse.IsAnonymous = dbJSSE.IsAnonymous;
//Observers
List <UserInfo> oObservers = new List <UserInfo>();
List <UserInfo> oSupervisors = new List <UserInfo>();
var selObservers = string.Empty;
var selSupervisors = string.Empty;
foreach (var dbObserver in dbJSSE.T_JSSE_Observer.Where(j => j.Active == true))
{
UserInfo observer = new UserInfo();
observer.Emp_Id = Convert.ToInt64(dbObserver.Emp_ID);
observer.FirstName = dbObserver.FirstName;
observer.LastName = dbObserver.LastName;
observer.FullName = dbObserver.LastName + " , " + dbObserver.FirstName;
observer.MajorGroup_Id = Convert.ToString(dbObserver.T_JSSE_Hierarchy.MajorGroup_Id);
observer.Org_Id = Convert.ToString(dbObserver.T_JSSE_Hierarchy.Org_Id);
observer.Dept_Id = Convert.ToString(dbObserver.T_JSSE_Hierarchy.Dept_Id);
observer.Section_Id = Convert.ToString(dbObserver.T_JSSE_Hierarchy.Sect_Id);
observer.User_ID = dbObserver.User_Id;
observer.UserRole = dbObserver.UserRole;
if (dbObserver.UserRole != "Supervisor")
{
oObservers.Add(observer);
if (!string.IsNullOrEmpty(selObservers))
{
selObservers = selObservers + "; " + observer.FullName;
}
else
{
selObservers = observer.FullName;
}
}
else
{
oSupervisors.Add(observer);
if (!string.IsNullOrEmpty(selSupervisors))
{
selSupervisors = selSupervisors + "; " + observer.FullName;
}
else
{
selSupervisors = observer.FullName;
}
}
}
if (oObservers.Count > 0)
{
if (string.IsNullOrEmpty(oObservers[0].UserRole))
{
oJsse.IsSupervsrOBSRSame = -1;
}
else
{
oJsse.IsSupervsrOBSRSame = 1;
}
if (oObservers[0].User_ID.ToLower() == "anonymous")
{
oJsse.IsOBSRAnonymous = true;
}
else
{
oJsse.IsOBSRAnonymous = false;
}
if (oSupervisors.Count > 0)
{
if (oObservers[0].Emp_Id != oSupervisors[0].Emp_Id)
{
oJsse.IsSupervsrOBSRSame = 0;
}
else
{
oJsse.IsSupervsrOBSRSame = 1;
}
}
}
oJsse.Observers = oObservers.ToArray();
oJsse.SelObservers = selObservers;
oJsse.Supervisors = oSupervisors.ToArray();
oJsse.SelSupervisors = selSupervisors;
//Observees
List <UserInfo> oObservees = new List <UserInfo>();
var selObservees = string.Empty;
foreach (var dbObservee in dbJSSE.T_JSSE_Observee.Where(j => j.Active == true))
{
UserInfo observee = new UserInfo();
observee.Emp_Id = Convert.ToInt64(dbObservee.Emp_ID);
observee.FirstName = dbObservee.FirstName;
observee.LastName = dbObservee.LastName;
observee.FullName = dbObservee.LastName + " , " + dbObservee.FirstName;
observee.MajorGroup_Id = Convert.ToString(dbObservee.T_JSSE_Hierarchy.MajorGroup_Id);
observee.Org_Id = Convert.ToString(dbObservee.T_JSSE_Hierarchy.Org_Id);
observee.Dept_Id = Convert.ToString(dbObservee.T_JSSE_Hierarchy.Dept_Id);
observee.Section_Id = Convert.ToString(dbObservee.T_JSSE_Hierarchy.Sect_Id);
observee.User_ID = dbObservee.User_Id;
//observee.UserTitle = "User Title";
oObservees.Add(observee);
if (!string.IsNullOrEmpty(selObservees))
{
selObservees = selObservees + "; " + observee.FullName;
}
else
{
selObservees = observee.FullName;
}
}
oJsse.Observees = oObservees.ToArray();
oJsse.SelObservees = selObservees;
oJsse.JSSE_ID = dbJSSE.JSSE_ID;
oJsse.Base64_JSSE_ID = dbJSSE.JSSE_ID.ToString();//Crypto.DecryptStringAES(Convert.ToString(dbJSSE.JSSE_ID), "JSSE");
oJsse.JobName = dbJSSE.JobName;
oJsse.JobDescription = dbJSSE.JobDescription;
oJsse.JSSEDate = dbJSSE.JSSEDate;
oJsse.JSSEStatus = dbJSSE.Status;
oJsse.Location = dbJSSE.Location;
var createdId = dbJSSE.CreatedBy != "Anonymous" && !dbJSSE.CreatedBy.StartsWith("CONED") ? "CONED\\" + dbJSSE.CreatedBy : dbJSSE.CreatedBy;
if (dbJSSE.CreatedBy != "Anonymous")
{
var createdUser = JSSESecurityManager.GetUserInfo(createdId);
if (createdUser != null)
{
oJsse.JSSECreator = createdUser.LAST_NAME + ", " + createdUser.FIRST_NAME;
}
else
{
oJsse.JSSECreator = dbJSSE.CreatedBy;
}
}
else
{
oJsse.JSSECreator = dbJSSE.CreatedBy;
}
oJsse.JSSEEnteredBy = dbJSSE.CreatedBy;
oJsse.Region_ID = dbJSSE.T_JSSE_Master_Region.Region_ID;
oJsse.Location = dbJSSE.Location;
oJsse.MajorGroup_Id = Convert.ToInt32(oJsse.Observees[0].MajorGroup_Id);
oJsse.Org_Id = Convert.ToInt32(oJsse.Observees[0].Org_Id);
oJsse.Dept_Id = !string.IsNullOrEmpty(oJsse.Observees[0].Dept_Id) ? Convert.ToInt32(oJsse.Observees[0].Dept_Id) : 0;
oJsse.Section_Id = !string.IsNullOrEmpty(oJsse.Observees[0].Section_Id) ? Convert.ToInt32(oJsse.Observees[0].Section_Id) : 0;
oJsse.Hierarchy_ID = dbJSSE.T_JSSE_Observee.FirstOrDefault(d => d.Active == true) != null?dbJSSE.T_JSSE_Observee.FirstOrDefault(d => d.Active == true).T_JSSE_Hierarchy.Hierarchy_ID : 0;
//oJsse.majorgroups = GetMajorGroups().ToArray();
//oJsse.organizations = GetOrganizations(oJsse.MajorGroup_Id.ToString()).ToArray();
//oJsse.departments = GetDepartments(oJsse.Org_Id.ToString()).ToArray();
//oJsse.sections = GetSections(oJsse.Dept_Id.ToString()).ToArray();
List <JSSECategory> oSelCats = new List <JSSECategory>();
//Build the selected cats
foreach (var dbSelCat in dbJSSE.T_JSSE_Category.Where(j => j.Active == true))
{
JSSECategory oSelCat = new JSSECategory();
oSelCat.Category_ID = dbSelCat.T_JSSE_Master_Category.Category_ID;
if (dbSelCat.T_JSSE_Master_Rating != null)
{
oSelCat.RatingID = Convert.ToString(dbSelCat.T_JSSE_Master_Rating.Rating_ID);
}
else
{
oSelCat.RatingID = "0";
}
oSelCat.Comments = dbSelCat.T_JSSE_Comment.SingleOrDefault().Comment;
oSelCat.JSSE_ID = dbSelCat.T_JSSE_Main.JSSE_ID;
oSelCat.IsActive = Convert.ToBoolean(dbSelCat.Active);
//Build the selecrted behs
List <JSSEBehavior> oSelBehs = new List <JSSEBehavior>();
foreach (var dbSelBeh in dbSelCat.T_JSSE_Behavior.Where(j => j.Active == true))
{
JSSEBehavior oSelBeh = new JSSEBehavior();
oSelBeh.Behavior_ID = dbSelBeh.T_JSSE_Master_Behavior.Behavior_ID;
oSelBeh.BehaviorType_ID = dbSelBeh.T_JSSE_Master_Behavior.T_JSSE_Master_BehaviorType.BehaviorType_ID;
oSelBeh.Category_ID = dbSelBeh.T_JSSE_Category.JSSECategory_ID;
if (dbSelBeh.T_JSSE_Master_Rating != null)
{
oSelBeh.Rating_ID = dbSelBeh.T_JSSE_Master_Rating.Rating_ID;
oSelBeh.Rating = dbSelBeh.T_JSSE_Master_Rating.Rating;
}
else
{
oSelBeh.Rating_ID = 2; // if rating is blank for old records then rating is effective
}
oSelBeh.Comments = dbSelBeh.Comment;
oSelBeh.IsActive = Convert.ToBoolean(dbSelBeh.Active);
oSelBehs.Add(oSelBeh);
}
oSelCat.EntBehaviors = oSelBehs.ToArray();
oSelCats.Add(oSelCat);
}
//Can be fine-tuned later
List <JSSECategory> oAllCats = null;
if (oSelCats.Count > 0)
{
oAllCats = GetAllMasterCategories(oJsse.Org_Id);
}
else
{
oAllCats = GetAllActiveMasterCategories(oJsse.Org_Id);
}
foreach (var oSelCat in oSelCats)
{
foreach (var oCat in oAllCats)
{
if (oCat.Category_ID == oSelCat.Category_ID)
{
oCat.RatingID = oSelCat.RatingID;
oCat.Comments = oSelCat.Comments;
oCat.JSSE_ID = oSelCat.JSSE_ID;
foreach (var oBeh in oCat.EntBehaviors)
{
foreach (var oSelBeh in oSelCat.EntBehaviors)
{
if (oBeh.Behavior_ID == oSelBeh.Behavior_ID)
{
oBeh.BehviorChecked = true;
oBeh.Category_ID = oSelBeh.Category_ID;
oBeh.Rating_ID = oSelBeh.Rating_ID;
oBeh.Rating = oSelBeh.Rating;
oBeh.Comments = oSelBeh.Comments;
}
}
}
foreach (var oBeh in oCat.OrgBehaviors)
{
foreach (var oSelBeh in oSelCat.EntBehaviors)
{
if (oBeh.Behavior_ID == oSelBeh.Behavior_ID)
{
oBeh.BehviorChecked = true;
oBeh.Category_ID = oSelBeh.Category_ID;
oBeh.Rating_ID = oSelBeh.Rating_ID;
oBeh.Rating = oSelBeh.Rating;
oBeh.Comments = oSelBeh.Comments;
}
}
}
}
oCat.EntBehaviors = oCat.EntBehaviors.Where(eb => eb.IsActive == true || eb.Category_ID != null).ToArray();
oCat.OrgBehaviors = oCat.OrgBehaviors.Where(ob => ob.IsActive == true || ob.Category_ID != null).ToArray();
}
}
oJsse.Categories = oAllCats.Where(c => c.IsActive == true || c.JSSE_ID != null).ToArray();
//Get the attachments for the JSSE
List <JSSEAttachment> oAttachments = new List <JSSEAttachment>();
foreach (var dbAttachment in dbJSSE.T_JSSE_Attachments.Where(j => j.Active == true))
{
JSSEAttachment attachment = new JSSEAttachment();
attachment.Title = dbAttachment.Title;
attachment.Description = dbAttachment.Description;
attachment.FileName = dbAttachment.FileName;
attachment.Base64ImageString = CreateBase64Image(dbAttachment.Image);
oAttachments.Add(attachment);
}
oJsse.Attachments = oAttachments.ToArray();
}
}
catch (Exception ex) { throw ex; }
return(oJsse);
}
