public List <JSSECategory> GetAllActiveMasterCategories(int?org_Id)
{
List <JSSECategory> oJsses = new List <JSSECategory>();
try
{
var dbJsses = jsseRepo.GetCategoryBehaviors().ToList();
var dbRatings = jsseRepo.GetRatings().ToList();
foreach (var dbJSSE in dbJsses)
{
JSSECategory oJsse = new JSSECategory();
oJsse.Category_ID = dbJSSE.Category_ID;
oJsse.Category = dbJSSE.Category;
oJsse.CategoryDesc = dbJSSE.CategoryDesc;
oJsse.SortOrder = dbJSSE.SortOrder;
// to validate comments required
if (dbJSSE.IsRequired == true)
{
oJsse.IsRequired = true;
}
else
{
oJsse.IsRequired = false;
}
List <JSSEBehavior> objMBehaviors = new List <JSSEBehavior>();
List <JSSERating> objRatings = new List <JSSERating>();
foreach (var dbCat in dbJSSE.T_JSSE_Master_CategoryBehavior_Map)
{
JSSEBehavior objMBehav = new JSSEBehavior();
objMBehav.Behavior_ID = dbCat.T_JSSE_Master_Behavior.Behavior_ID;
objMBehav.Behavior = dbCat.T_JSSE_Master_Behavior.Behavior;
objMBehav.BehaviorDesc = dbCat.T_JSSE_Master_Behavior.BehaviorDesc;
objMBehav.SortOrder = dbCat.T_JSSE_Master_Behavior.SortOrder;
objMBehav.BehaviorType_ID = dbCat.T_JSSE_Master_Behavior.T_JSSE_Master_BehaviorType.BehaviorType_ID;
objMBehav.BehaviorType = dbCat.T_JSSE_Master_Behavior.T_JSSE_Master_BehaviorType.BehaviorType;
objMBehav.Org_ID = dbCat.T_JSSE_Master_Behavior.Org_ID;
objMBehav.IsActive = Convert.ToBoolean(dbCat.Active);
objMBehaviors.Add(objMBehav);
}
objMBehaviors = objMBehaviors.OrderBy(o => o.SortOrder).ToList();
foreach (var dbRate in dbRatings)
{
JSSERating objRate = new JSSERating();
objRate.Rating_ID = dbRate.Rating_ID;
objRate.Rating = dbRate.Rating;
objRatings.Add(objRate);
}
int entBehavID = (int)BehaviorType.Enterprise;
int orgBehavID = (int)BehaviorType.Organization;
oJsse.EntBehaviors = objMBehaviors.Where(d => d.BehaviorType_ID == entBehavID && d.IsActive == true).ToArray();
oJsse.OrgBehaviors = objMBehaviors.Where(d => d.BehaviorType_ID == orgBehavID && d.Org_ID == org_Id && d.IsActive == true).ToArray();
oJsse.Ratings = objRatings.ToArray();
oJsse.IsActive = Convert.ToBoolean(dbJSSE.Active);
//oJsse.Comments = "test";
oJsses.Add(oJsse);
}
oJsses = oJsses.Where(c => c.IsActive == true).OrderBy(x => x.SortOrder).ToList();
}
catch
{ }
return(oJsses);
}
public List <JSSECategory> GetAllActiveMasterCategories(string userName)
{
List <JSSECategory> oJsses = new List <JSSECategory>();
try
{
List <string> myOrgList = new List <string>();
userName = string.IsNullOrWhiteSpace(userName) ? null : "Coned\\" + userName;
var orgArrays = GetUserMajorGroups(userName, 2).Select(s => s.Organizations);
foreach (var orgArray in orgArrays)
{
foreach (var myOrg in orgArray)
{
if (myOrgList.IndexOf(myOrg.Org_Id) < 0)
{
myOrgList.Add(myOrg.Org_Id);
}
}
}
var dbJsses = jsseRepo.GetCategoryBehaviors().ToList();
var dbRatings = jsseRepo.GetRatings().ToList();
foreach (var dbJSSE in dbJsses)
{
JSSECategory oJsse = new JSSECategory();
oJsse.Category_ID = dbJSSE.Category_ID;
oJsse.Category = dbJSSE.Category;
oJsse.CategoryDesc = dbJSSE.CategoryDesc;
oJsse.SortOrder = dbJSSE.SortOrder;
// to validate comments required
if (dbJSSE.IsRequired == true)
{
oJsse.IsRequired = true;
}
else
{
oJsse.IsRequired = false;
}
List <JSSEBehavior> objMBehaviors = new List <JSSEBehavior>();
List <JSSERating> objRatings = new List <JSSERating>();
foreach (var dbCat in dbJSSE.T_JSSE_Master_CategoryBehavior_Map)
{
JSSEBehavior objMBehav = new JSSEBehavior();
objMBehav.Behavior_ID = dbCat.T_JSSE_Master_Behavior.Behavior_ID;
objMBehav.Behavior = dbCat.T_JSSE_Master_Behavior.Behavior;
objMBehav.BehaviorDesc = dbCat.T_JSSE_Master_Behavior.BehaviorDesc;
objMBehav.SortOrder = dbCat.T_JSSE_Master_Behavior.SortOrder;
objMBehav.BehaviorType_ID = dbCat.T_JSSE_Master_Behavior.T_JSSE_Master_BehaviorType.BehaviorType_ID;
objMBehav.BehaviorType = dbCat.T_JSSE_Master_Behavior.T_JSSE_Master_BehaviorType.BehaviorType;
objMBehav.Org_ID = dbCat.T_JSSE_Master_Behavior.Org_ID;
objMBehav.IsActive = Convert.ToBoolean(dbCat.Active);
objMBehaviors.Add(objMBehav);
}
objMBehaviors = objMBehaviors.OrderBy(o => o.SortOrder).ToList();
foreach (var dbRate in dbRatings)
{
JSSERating objRate = new JSSERating();
objRate.Rating_ID = dbRate.Rating_ID;
objRate.Rating = dbRate.Rating;
objRatings.Add(objRate);
}
int entBehavID = (int)BehaviorType.Enterprise;
int orgBehavID = (int)BehaviorType.Organization;
oJsse.EntBehaviors = objMBehaviors.Where(d => d.BehaviorType_ID == entBehavID && d.IsActive == true).ToArray();
List <JSSEBehavior[]> orgBehaviors = new List <JSSEBehavior[]>();
foreach (string org in myOrgList)
{
int orgId = Int32.Parse(org);
var orgs = objMBehaviors.Where(d => d.BehaviorType_ID == orgBehavID && d.Org_ID == orgId && d.IsActive == true).ToArray();
orgBehaviors.Add(orgs);
}
oJsse.AllOrgBehaviors = orgBehaviors;
oJsse.Ratings = objRatings.ToArray();
oJsse.IsActive = Convert.ToBoolean(dbJSSE.Active);
//oJsse.Comments = "test";
oJsses.Add(oJsse);
}
oJsses = oJsses.Where(c => c.IsActive == true).OrderBy(x => x.SortOrder).ToList();
}
catch
{ }
return(oJsses);
}
