[Authorize] //[Authorize(Roles = "Admin")]
public ActionResult UserMaintenance()
{
ViewBag.Title = "User Maintenance";
string sql = @" select aur.id,
aur.idApplication,
aur.ActiveDirectory,
ar.Role,
aur.ActiveFlag
FROM COM.applicationUserRoles aur
join COM.applicationRoles ar on ar.id = aur.idRole
WHERE aur.idApplication = 1 and aur.ActiveFlag = 1
order by aur.ActiveDirectory";
String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["PuroDB"].ConnectionString;
DataTable dt = new DataTable();
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, connection);
da.Fill(dt);
connection.Close();
connection.Dispose();
ViewBag.result = dt;
List <SelectListItem> userRoleList = HelperDropdowns.getUserRoles();
ViewBag.userRoleList = userRoleList;
string userrole = Session["userrole"].ToString();
ViewBag.userrole = userrole;
return(View());
}
public ActionResult EditAccess()
{
string username = Request.Form["username"].Trim();
var aur = db.applicationUserRoles.Where(x => x.ActiveDirectory.Equals(username)).FirstOrDefault();
List <SelectListItem> districts = HelperDropdowns.getDistrictList();
List <SelectListItem> regions = HelperDropdowns.getRegionList();
List <SelectListItem> users = HelperDropdowns.getUserList();
var previouslySelectedDistricts = db.ApplicationDistrictsAlloweds.Where(x => x.ActiveDirectory.Equals(username)).ToList();
var previouslySelectedBranches = db.ApplicationRegionsAlloweds.Where(x => x.ActiveDirectory.Equals(username)).ToList();
var previouslySelectDR = db.ApplicationUsersAlloweds.Where(x => x.ActiveDirectory.Equals(username)).ToList();
var signature = db.Signatures.Where(x => x.ActiveDirectory.Equals(username)).FirstOrDefault();
List <SelectListItem> userRoleList = HelperDropdowns.getUserRoles();
ViewBag.userRoleList = userRoleList;
ViewBag.applicationUserRoles = aur;
ViewBag.districtList = districts;
ViewBag.regionList = regions;
ViewBag.userList = users;
ViewBag.previouslySelectedDistricts = previouslySelectedDistricts;
ViewBag.previouslySelectedBranches = previouslySelectedBranches;
ViewBag.previouslySelectDR = previouslySelectDR;
ViewBag.signature = signature != null ? "../" + signature.ImageURL.Trim().Replace("\\", "/") : "";
ViewBag.Title = "Edit Access";
return(View(aur));
}