public ActionResult AgencyUserFlagRemoval(vmDashboardAgency model)
{
if (model.FlagUserIDX != null && model.agency.ORG_IDX != null)
{
//get flagging user
int UserIDX = db_Accounts.GetUserIDX();
T_OE_USERS flaggingUser = db_Accounts.GetT_OE_USERSByIDX(UserIDX);
//get flagged user
T_OE_USERS flaggedUser = db_Accounts.GetT_OE_USERSByIDX(model.FlagUserIDX.GetValueOrDefault());
//notify Site Admins via email
List <T_OE_USERS> Admins = db_Accounts.GetT_OE_USERSInRole(1);
foreach (T_OE_USERS Admin in Admins)
{
Utils.SendEmail(null, Admin.EMAIL, null, null, "EECIP: " + flaggedUser.FNAME + ' ' + flaggedUser.LNAME + " flagged for removal", "The user " + flaggedUser.FNAME + ' ' + flaggedUser.LNAME + " (" + flaggedUser.EMAIL + ") has been flagged for removal by the EECIP user " + flaggedUser.FNAME + ' ' + flaggedUser.LNAME + ". Please log into EECIP and consider removing or inactivating the user account", null, null, null);
}
TempData["Success"] = "Your request has been submitted.";
}
else
{
TempData["Error"] = "Unable to make request at this time.";
}
return(RedirectToAction("Agency", "Dashboard"));
}
public ActionResult AgencyEdit(vmDashboardAgency model)
{
int UserIDX = db_Accounts.GetUserIDX();
//update general agency data
Guid?SuccID = db_Ref.InsertUpdatetT_OE_ORGANIZATION(model.agency.ORG_IDX, null, null, null, null, model.agency.CLOUD, model.agency.API, true, UserIDX);
//update database tags
db_Ref.DeleteT_OE_ORGANIZATION_TAGS(model.agency.ORG_IDX, "Database");
foreach (string expertise in model.SelectedDatabase)
{
db_Ref.InsertT_OE_ORGANIZATION_TAGS(model.agency.ORG_IDX, "Database", expertise.ConvertOrDefault <int>());
}
//update app framework tags
db_Ref.DeleteT_OE_ORGANIZATION_TAGS(model.agency.ORG_IDX, "App Framework");
foreach (string expertise in model.SelectedAppFramework)
{
db_Ref.InsertT_OE_ORGANIZATION_TAGS(model.agency.ORG_IDX, "App Framework", expertise.ConvertOrDefault <int>());
}
if (SuccID != null)
{
TempData["Success"] = "Update successful.";
}
else
{
TempData["Error"] = "Error updating data.";
}
return(RedirectToAction("Agency"));
}
public ActionResult AgencyEdit(vmDashboardAgency model)
{
int UserIDX = db_Accounts.GetUserIDX();
//CHECK PERMISSIONS
if (User.IsInRole("Admins") || db_Accounts.UserCanEditOrgIDX(UserIDX, model.agency.ORG_IDX.ConvertOrDefault <Guid>()))
{
//update general agency data
Guid?SuccID = db_Ref.InsertUpdatetT_OE_ORGANIZATION(model.agency.ORG_IDX, null, null, null, null, null, model.agency.CLOUD, model.agency.API, true, UserIDX);
//update database tags
db_Ref.DeleteT_OE_ORGANIZATION_TAGS(model.agency.ORG_IDX, "Database");
foreach (string expertise in model.SelectedDatabase ?? new List <string>())
{
db_Ref.InsertT_OE_ORGANIZATION_TAGS(model.agency.ORG_IDX, "Database", expertise);
}
//update app framework tags
db_Ref.DeleteT_OE_ORGANIZATION_TAGS(model.agency.ORG_IDX, "App Framework");
foreach (string expertise in model.SelectedAppFramework ?? new List <string>())
{
db_Ref.InsertT_OE_ORGANIZATION_TAGS(model.agency.ORG_IDX, "App Framework", expertise);
}
//award agency profile badge
if (db_Accounts.UserCanEditOrgIDX(UserIDX, model.agency.ORG_IDX.ConvertOrDefault <Guid>()))
{
db_Forum.EarnBadgeController(UserIDX, "AgencyProfile");
}
//now update the Azure search
AzureSearch.PopulateSearchIndexOrganization(SuccID);
if (SuccID != null)
{
TempData["Success"] = "Update successful.";
}
else
{
TempData["Error"] = "Error updating data.";
}
}
return(RedirectToAction("Agency", new { selAgency = model.agency.ORG_IDX }));
}
// GET: /Dashboard/Agency
public ActionResult Agency(Guid?selAgency)
{
int UserIDX = db_Accounts.GetUserIDX();
if (selAgency == null || selAgency == Guid.Empty)
{
// get agency for which the logged in user is associated
T_OE_USERS u = db_Accounts.GetT_OE_USERSByIDX(UserIDX);
if (u != null && u.ORG_IDX != null)
{
selAgency = u.ORG_IDX.ConvertOrDefault <Guid>();
}
}
//if still no agency
if (selAgency == null || selAgency == Guid.Empty)
{
TempData["Error"] = "You are not associated with an agency.";
return(RedirectToAction("AccessDenied", "Home"));
}
if (!User.IsInRole("Admins") && !db_Accounts.UserCanEditOrgIDX(UserIDX, selAgency.ConvertOrDefault <Guid>()))
{
TempData["Error"] = "You cannot edit this agency.";
return(RedirectToAction("AccessDenied", "Home"));
}
var model = new vmDashboardAgency();
model.agency = db_Ref.GetT_OE_ORGANIZATION_ByID(selAgency.ConvertOrDefault <Guid>());
model.users = db_Accounts.GetT_OE_USERSByAgency(selAgency.ConvertOrDefault <Guid>());
//database
model.SelectedDatabase = db_Ref.GetT_OE_ORGANIZATION_TAGS_ByOrgAttribute(selAgency.ConvertOrDefault <Guid>(), "Database");
model.AllDatabase = db_Ref.GetT_OE_ORGANIZATION_TAGS_ByAttributeAll(selAgency.ConvertOrDefault <Guid>(), "Database").Select(x => new SelectListItem {
Value = x, Text = x
});
//app framework
model.SelectedAppFramework = db_Ref.GetT_OE_ORGANIZATION_TAGS_ByOrgAttribute(selAgency.ConvertOrDefault <Guid>(), "App Framework");
model.AllAppFramework = db_Ref.GetT_OE_ORGANIZATION_TAGS_ByAttributeAll(selAgency.ConvertOrDefault <Guid>(), "App Framework").Select(x => new SelectListItem {
Value = x, Text = x
});
//ent services
model.org_ent_services = db_EECIP.GetT_OE_ORGANIZATION_ENTERPRISE_PLATFORM(selAgency.ConvertOrDefault <Guid>());
return(View(model));
}
public ActionResult AgencyEntServiceEdit(vmDashboardAgency model)
{
if (ModelState.IsValid)
{
var z = model.edit_ent_services;
int SuccID = db_EECIP.InsertUpdatetT_OE_ORGANIZATION_ENT_SVCS(z.ENT_PLATFORM_IDX, model.agency.ORG_IDX, z.ENT_PLATFORM_IDX, z.PROJECT_NAME, z.VENDOR, z.IMPLEMENT_STATUS,
z.COMMENTS, db_Accounts.GetUserIDX());
if (SuccID > 0)
{
TempData["Success"] = "Data Saved.";
}
else
{
TempData["Error"] = "Data Not Saved.";
}
}
return(RedirectToAction("Agency", "Dashboard"));
}
public ActionResult AgencyEntServiceEdit(vmDashboardAgency model)
{
if (ModelState.IsValid)
{
var z = model.edit_ent_services;
int SuccID = db_EECIP.InsertUpdatetT_OE_ORGANIZATION_ENT_SVCS(z.ENT_PLATFORM_IDX, model.agency.ORG_IDX, z.ENT_PLATFORM_IDX, z.PROJECT_NAME, z.VENDOR, z.IMPLEMENT_STATUS,
z.COMMENTS, z.PROJECT_CONTACT, z.ACTIVE_INTEREST_IND, false, db_Accounts.GetUserIDX(), true);
if (SuccID > 0)
{
//sync to search service
AzureSearch.PopulateSearchIndexEntServices(SuccID);
TempData["Success"] = "Data Saved.";
}
else
{
TempData["Error"] = "Data Not Saved.";
}
}
return(RedirectToAction("Agency", "Dashboard", new { selAgency = model.agency.ORG_IDX }));
}
// GET: Agency
public ActionResult Agency()
{
// get the agency for which the logged in user is associated
T_OE_USERS u = db_Accounts.GetT_OE_USERSByIDX(db_Accounts.GetUserIDX());
if (u != null && u.ORG_IDX != null)
{
var model = new vmDashboardAgency();
model.agency = db_Ref.GetT_OE_ORGANIZATION_ByID(u.ORG_IDX.ConvertOrDefault <Guid>());
model.users = db_Accounts.GetT_OE_USERSByAgency(u.ORG_IDX.ConvertOrDefault <Guid>());
//database
model.SelectedDatabase = db_Ref.GetT_OE_ORGANIZATION_TAGS_ByOrgAttribute(u.ORG_IDX.ConvertOrDefault <Guid>(), "Database");
//database
model.SelectedAppFramework = db_Ref.GetT_OE_ORGANIZATION_TAGS_ByOrgAttribute(u.ORG_IDX.ConvertOrDefault <Guid>(), "App Framework");
//ent services
model.org_ent_services = db_EECIP.GetT_OE_ORGANIZATION_ENTERPRISE_PLATFORM(u.ORG_IDX.ConvertOrDefault <Guid>());
return(View(model));
}
TempData["Error"] = "You are not associated with an agency.";
return(RedirectToAction("AccessDenied", "Home"));
}
