public ActionResult AddRoleToMenu(RoleAccess roleAccess)
{
if (ModelState.IsValid)
{
try
{
//Delete Menu Access
RoleManagementTables.DeleteRolesMenu(roleAccess.roleID);
//Insert Data
foreach (AccessType accessType in roleAccess.dataaccess)
{
RoleManagementTables.InsertNewRoleAccess(new RoleMenuAccess {
RoleID = roleAccess.roleID, MenuHdrID = accessType.moduleID
});
}
return(Json(new { isError = "F", message = "New role has been added!" }));
}
catch (Exception ex)
{
return(Json(new { isError = "T", message = "Could not insert data." }));
}
}
else
{
return(Json(new { isError = "T", message = "Could not insert data." }));
}
}
public async Task SetCharacterRoleAccessAsync
(
IRole discordRole,
RoleAccess access
)
{
var getExistingRoleResult = await _characterRoles.GetCharacterRoleAsync(discordRole);
if (!getExistingRoleResult.IsSuccess)
{
await _feedback.SendErrorAsync(this.Context, getExistingRoleResult.ErrorReason);
return;
}
var setRoleAccessResult = await _characterRoles.SetCharacterRoleAccessAsync
(
getExistingRoleResult.Entity,
access
);
if (!setRoleAccessResult.IsSuccess)
{
await _feedback.SendErrorAsync(this.Context, setRoleAccessResult.ErrorReason);
return;
}
await _feedback.SendConfirmationAsync
(
this.Context, "Character role access conditions set."
);
}
public async Task <RoleAccess> GetRoleAccessAsync(string roleId)
{
try
{
using (var conn = new SqlConnection(_options.ConnectionString))
{
const string query = "SELECT [Id], [RoleId], [Access] FROM [RoleAccess] WHERE [RoleId] = @RoleId";
using (var cmd = new SqlCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@RoleId", roleId);
conn.Open();
var reader = await cmd.ExecuteReaderAsync();
if (!reader.Read())
{
return(null);
}
var roleAccess = new RoleAccess();
roleAccess.Id = int.Parse(reader[0].ToString());
roleAccess.RoleId = reader[1].ToString();
var json = reader[2].ToString();
roleAccess.Controllers = JsonConvert.DeserializeObject <IEnumerable <MvcControllerInfo> >(json);
return(roleAccess);
}
}
}
catch (Exception ex)
{
_logger.LogError(ex, "An error has occurred while getting data from RoleAccess table");
return(null);
}
}
/// <summary>
/// 获取角色信息
/// </summary>
public void GetRoleInfo()
{
List <RoleEntity> ls = RoleAccess.GetInstance().GetRoleInfo();
JsonConvert <RoleEntity> jc = new JsonConvert <RoleEntity>();
Response.Write(jc.ToDataGrid(ls, ls.Count));
}
/// <summary>
/// Creates a new character role from the given Discord role and access condition.
/// </summary>
/// <param name="guildID">The ID of the guild the role is on.</param>
/// <param name="roleID">The ID of the discord role.</param>
/// <param name="access">The access conditions.</param>
/// <param name="ct">The cancellation token in use.</param>
/// <returns>A creation result which may or may not have succeeded.</returns>
public async Task <Result <CharacterRole> > CreateCharacterRoleAsync
(
Snowflake guildID,
Snowflake roleID,
RoleAccess access,
CancellationToken ct = default
)
{
var getExistingRoleResult = await GetCharacterRoleAsync(guildID, roleID, ct);
if (getExistingRoleResult.IsSuccess)
{
return(new UserError
(
"That role is already registered as a character role."
));
}
var getServerResult = await _servers.GetOrRegisterServerAsync(guildID, ct);
if (!getServerResult.IsSuccess)
{
return(Result <CharacterRole> .FromError(getServerResult));
}
var server = getServerResult.Entity;
var characterRole = _database.CreateProxy <CharacterRole>(server, roleID, access);
_database.CharacterRoles.Update(characterRole);
await _database.SaveChangesAsync(ct);
return(characterRole);
}
public frmVendorCreateOrder(AccessToken acctoken)
{
InitializeComponent();
_myAccessToken = acctoken;
_vendorList = _myVendorManager.GetVendors();
_productList = _myProductManager.GetProducts();
var RoleAccess = new RoleAccess(acctoken, this);
tbOrderDate.Text = DateTime.Now.ToString();
populateListView();
for (int i = 0; i <= 100; i++)
{
comboQuanity.Items.Add(i);
}
for (int i = 0; i <= 10; i++)
{
comboShipments.Items.Add(i);
}
foreach (var vendor in _vendorList)
{
comboVendor.Items.Add(vendor.Id + " " + vendor.Name);
}
Instance = this;
}
public Task <bool> AddRoleAccessAsync(RoleAccess roleAccess)
{
roleAccess.Id = roleAccess.Id == 0 ? 1 : roleAccess.Id;
var collection = _store.GetCollection <RoleAccess>();
return(collection.InsertOneAsync(roleAccess));
}
public void DeleteRoleAccess(RoleAccessViewModel roleAccess)
{
RoleAccess selectedRoleAccess = _roleAccessRepository.GetById(roleAccess.Id);
_roleAccessRepository.Delete(selectedRoleAccess);
_unitOfWork.SaveChanges();
}
public async Task <bool> AddRoleAccessAsync(RoleAccess roleAccess)
{
try
{
using (var conn = new SqlConnection(_options.ConnectionString))
{
const string insertCommand = "INSERT INTO RoleAccess VALUES(@RoleId, @Access)";
using (var cmd = new SqlCommand(insertCommand, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@RoleId", roleAccess.RoleId);
var access = JsonConvert.SerializeObject(roleAccess.Controllers);
cmd.Parameters.AddWithValue("@Access", access);
conn.Open();
var affectedRows = await cmd.ExecuteNonQueryAsync();
return(affectedRows > 0);
}
}
}
catch (Exception ex)
{
_logger.LogError(ex, "An error has occurred while inserting access into RoleAccess table");
return(false);
}
}
public async Task <IActionResult> PutRolePage([FromBody] RoleAccess roleaccess)
{
var result = new Result <string>();
RoleAccess ra = new RoleAccess();
try
{
ra = await _ablemusicContext.RoleAccess
.Where(s => s.RoleAccessId == roleaccess.RoleAccessId
).FirstOrDefaultAsync();
if (ra != null)
{
ra.IsMobile = roleaccess.IsMobile;
ra.PageId = roleaccess.PageId;
ra.RoleAccessId = roleaccess.RoleAccessId;
ra.RoleId = roleaccess.RoleId;
await _ablemusicContext.SaveChangesAsync();
}
}
catch (Exception e)
{
result.ErrorMessage = e.Message;
result.IsSuccess = false;
return(BadRequest(result));
}
return(Ok(result));
}
public FrmVendor(AccessToken acctoken)
{
InitializeComponent();
var RoleAccess = new RoleAccess(acctoken, this);
_myAccessToken = acctoken;
Instance = this;
}
public ActionResult Edit(RoleAccess model)
{
ActionResult action;
RoleAccess roleAccess = new RoleAccess();
try
{
if (base.ModelState.IsValid)
{
Service.Parameters.Clear();
if (!Service.Put("RoleAccessWithFilter", JsonConvert.SerializeObject(model)))
{
Alerts.body = "Sorry!, Unsuccessfull";
Alerts.ErrorMessage = "Unable to save new department record";
base.TempData["Message"] = Alerts.ErrorMessage;
}
else
{
Alerts.body = "Success!";
Alerts.Success = "userGroup Saved Successfully";
base.TempData["Message"] = Alerts.Success;
action = base.RedirectToAction("List", "RoleAccess");
return(action);
}
}
return(base.View(roleAccess));
}
catch (Exception exception)
{
throw exception;
}
//return action;
}
public async Task <CreateEntityResult <CharacterRole> > CreateCharacterRoleAsync
(
[NotNull] IRole role,
RoleAccess access
)
{
var getExistingRoleResult = await GetCharacterRoleAsync(role);
if (getExistingRoleResult.IsSuccess)
{
return(CreateEntityResult <CharacterRole> .FromError
(
"That role is already registered as a character role."
));
}
var getServerResult = await _servers.GetOrRegisterServerAsync(role.Guild);
if (!getServerResult.IsSuccess)
{
return(CreateEntityResult <CharacterRole> .FromError(getServerResult));
}
var server = getServerResult.Entity;
var characterRole = new CharacterRole(server, (long)role.Id, access);
_database.CharacterRoles.Update(characterRole);
await _database.SaveChangesAsync();
return(CreateEntityResult <CharacterRole> .FromSuccess(characterRole));
}
/// <summary>
/// Creates a new character role from the given Discord role and access condition.
/// </summary>
/// <param name="role">The discord role.</param>
/// <param name="access">The access conditions.</param>
/// <param name="ct">The cancellation token in use.</param>
/// <returns>A creation result which may or may not have succeeded.</returns>
public async Task <CreateEntityResult <CharacterRole> > CreateCharacterRoleAsync
(
IRole role,
RoleAccess access,
CancellationToken ct = default
)
{
var getExistingRoleResult = await GetCharacterRoleAsync(role, ct);
if (getExistingRoleResult.IsSuccess)
{
return(CreateEntityResult <CharacterRole> .FromError
(
"That role is already registered as a character role."
));
}
var getServerResult = await _servers.GetOrRegisterServerAsync(role.Guild, ct);
if (!getServerResult.IsSuccess)
{
return(CreateEntityResult <CharacterRole> .FromError(getServerResult));
}
var server = getServerResult.Entity;
var characterRole = _database.CreateProxy <CharacterRole>(server, (long)role.Id, access);
_database.CharacterRoles.Update(characterRole);
await _database.SaveChangesAsync(ct);
return(characterRole);
}
public async Task <RuntimeResult> SetCharacterRoleAccessAsync
(
IRole discordRole,
RoleAccess access
)
{
var getExistingRoleResult = await _characterRoles.GetCharacterRoleAsync(discordRole);
if (!getExistingRoleResult.IsSuccess)
{
return(getExistingRoleResult.ToRuntimeResult());
}
var setRoleAccessResult = await _characterRoles.SetCharacterRoleAccessAsync
(
getExistingRoleResult.Entity,
access
);
if (!setRoleAccessResult.IsSuccess)
{
return(setRoleAccessResult.ToRuntimeResult());
}
return(RuntimeCommandResult.FromSuccess("Character role access conditions set."));
}
//protected override void OnActionExecuting(ActionExecutingContext filterContext)
//{
// try
// {
// if (Session["AuthenticatedUser"] != null)
// {
// userData = ((User)Session["AuthenticatedUser"]);
// }
// else
// {
// //return RedirectToAction("UserLogin", "Login", new { lbl = "Your Session Expired" });
// filterContext.Controller.TempData.Add("UserLogin", "Login");
// }
// }
// catch
// {
// //filterContext.Result = new RedirectResult("~/Login/UserLogin");
// filterContext.Controller.TempData.Add("UserLogin", "Login");
// }
//}
/// <summary>
/// CreatedBy : Kanishka SHM
/// CreatedDate: 2016/01/16
///
/// Inserting user details
///
/// argument: None
///
/// </summary>
/// <returns>Return view</returns>
// GET: CreateUser
public ActionResult Create(string lbls)
{
int.Parse(Session["userId"].ToString());
if (lbls != null)
{
ViewBag.SuccessMsg = "User Successfully Created";
}
//int id = (int)Session["userId"];
int id = Convert.ToInt32(Session["userId"].ToString());
UserAccess ua = new UserAccess();
User curUser = ua.retreiveUserByUserId(id);
ViewBag.CurrUserRoleType = curUser.RoleId;
//Restrict to create above user role
RoleAccess ra = new RoleAccess();
List <UserRole> roleList = ra.GetAllUserRoles();
List <UserRole> tempRoleList = new List <UserRole>();
//if current user is first super admin he can create aditional super admin
if (curUser.UserId == curUser.CreatedBy)
{
//ViewBag.RoleId = new SelectList(roleList, "RoleId", "RoleName");
tempRoleList = roleList;
}
else
{
for (int i = 1; i < roleList.Count && ViewBag.CurrUserRoleType != 3; i++)
{
UserRole tempRole = new UserRole()
{
RoleId = roleList[i].RoleId,
RoleName = roleList[i].RoleName
};
tempRoleList.Add(tempRole);
}
}
_createById = curUser.UserId;
_companyId = curUser.Company_Id;
_curUserRoleId = curUser.RoleId;
ViewBag.RoleId = new SelectList(tempRoleList, "RoleId", "RoleName");
_curBranchId = curUser.BranchId;
// get all branches
List <Branch> branchesLists = (new BranchAccess()).getBranches(curUser.Company_Id);
//if current user is admin restrict to creat user for another branch
if (ViewBag.CurrUserRoleType == 2)
{
//ViewBag.BranchId = new SelectList(branchesLists, "BranchId", "BranchName", curUser.BranchId);
_curBranchId = curUser.BranchId;
}
else
{
ViewBag.BranchId = new SelectList(branchesLists, "BranchId", "BranchName");
}
return(PartialView("Create"));
}
public frmVendorCreateOrder(AccessToken acctoken)
{
InitializeComponent();
_myAccessToken = acctoken;
_vendorList = _myVendorManager.GetVendors();
_productList = _myProductManager.GetProducts();
var RoleAccess = new RoleAccess(acctoken, this);
tbOrderDate.Text = DateTime.Now.ToString();
populateListView();
for (int i = 0; i <= 100; i++)
{
comboQuanity.Items.Add(i);
}
for (int i = 0; i <= 10; i++)
{
comboShipments.Items.Add(i);
}
foreach (var vendor in _vendorList)
{
comboVendor.Items.Add(vendor.Id + " " + vendor.Name);
}
Instance = this;
}
public void AddRoleAccess(AssignMenuModel model)
{
using (TransactionScope ts = new TransactionScope())
{
unitOfWork.RoleAccessRepository.Delete(x => x.RoleId == model.Id);
foreach (var item in model.Menu)
{
if (item.Create || item.Read || item.Update || item.Delete)
{
var roleAccess = new RoleAccess
{
RoleId = model.Id,
MenuId = item.Id,
AllowAdd = item.Create,
AllowView = item.Read,
AllowEdit = item.Update,
AllowDelete = item.Delete
};
unitOfWork.RoleAccessRepository.Create(roleAccess);
}
}
ts.Complete();
}
}
public virtual async Task <bool> RemoveRoleAccessAsync(RoleAccess item)
{
var res = await _unitOfWork.RoleAccesses.RemoveAsync(item);
await _unitOfWork.CommitAsync();
return(res);
}
public Task <bool> EditRoleAccessAsync(RoleAccess roleAccess)
{
var collection = _store.GetCollection <RoleAccess>();
return(collection.AsQueryable().Any(ra => ra.RoleId == roleAccess.RoleId)
? collection.ReplaceOneAsync(roleAccess.RoleId, roleAccess)
: collection.InsertOneAsync(roleAccess));
}
public FrmVendor(AccessToken acctoken)
{
InitializeComponent();
var RoleAccess = new RoleAccess(acctoken, this);
_myAccessToken = acctoken;
Instance = this;
}
public virtual async Task <RoleAccess> EditRoleAccessAsync(RoleAccess item)
{
var roleAccess = await _unitOfWork.RoleAccesses.EditAsync(item);
await _unitOfWork.CommitAsync();
return(roleAccess);
}
public AddVendorWindow(string productId, AccessToken _myAccessToken)
{
var RoleAccess = new RoleAccess(_myAccessToken, this);
var vendors = _vendorManager.GetVendors();
foreach (var vendor in vendors)
{
lvVendors.Items.Add(vendor.ToString());
}
}
//Constructor with AccessToken as the only parameter.
public FrmProduct(AccessToken acctoken)
{
InitializeComponent();
_myAccessToken = acctoken;
//Instantiates a ProductManager.
_myProductManager = new ProductManager();
Instance = this;
RoleAccess = new RoleAccess(_myAccessToken, this);
}//End of FrmProduct(.)
/// <summary>
/// Set enabled of child items
/// </summary>
/// <param name="parentItem"></param>
private void SetChildMenuItemsEnabled(MenuItem parentItem)
{
parentItem.Enabled = RoleAccess.Check(CurrentCustomer, parentItem.NavigateUrl.ToLower()) && (!modules.ContainsKey(parentItem.Value) || modules[parentItem.Value]);
foreach (MenuItem item in parentItem.ChildItems)
{
SetChildMenuItemsEnabled(item);
}
}
//Constructor with AccessToken as the only parameter.
public FrmProduct(AccessToken acctoken)
{
InitializeComponent();
_myAccessToken = acctoken;
//Instantiates a ProductManager.
_myProductManager = new ProductManager();
Instance = this;
RoleAccess = new RoleAccess(_myAccessToken, this);
}
public async Task <ActionResult> Edit(string id, RoleViewModel viewModel)
{
if (!ModelState.IsValid)
{
ViewData["Controllers"] = _mvcControllerDiscovery.GetControllers();
return(View(viewModel));
}
// Check role exit
var role = await _roleManager.FindByIdAsync(id);
if (role == null)
{
ModelState.AddModelError("", "Role not found");
ViewData["Controllers"] = _mvcControllerDiscovery.GetControllers();
return(View());
}
// Update role if role's name is changed
if (role.Name != viewModel.Name)
{
role.Name = viewModel.Name;
var result = await _roleManager.UpdateAsync(role);
if (!result.Succeeded)
{
foreach (var error in result.Errors)
{
ModelState.AddModelError("", error.Description);
}
ViewData["Controllers"] = _mvcControllerDiscovery.GetControllers();
return(View(viewModel));
}
}
// Update role access list
if (viewModel.SelectedControllers != null && viewModel.SelectedControllers.Any())
{
foreach (var controller in viewModel.SelectedControllers)
{
foreach (var action in controller.Actions)
{
action.ControllerId = controller.Id;
}
}
}
var roleAccess = new RoleAccess
{
Controllers = viewModel.SelectedControllers?.ToList(),
RoleId = role.Id
};
await _roleAccessStore.EditRoleAccessAsync(roleAccess);
return(RedirectToAction(nameof(Index)));
}
public frmStartUp(AccessToken acctoken)
{
InitializeComponent();
var RoleAccess = new RoleAccess(acctoken, this);
_myAccessToken = acctoken;
this.Text = " " + _myAccessToken.FirstName + " " + _myAccessToken.LastName + " logged in as a " + _myAccessToken.Role.Name;
this.WindowState = FormWindowState.Maximized;
}
public static new int Insert(Sys_Role model)
{
model.SRIsEnabled = 1;
model.SRDeleteMark = 0;
model.SRCreateUser = OperatorProvider.Instance.Current.UserId;
model.SRCreateTime = DateTime.Now;
model.SRModifyUser = model.SRCreateUser;
model.SRModifyTime = model.SRCreateTime;
return(RoleAccess.Insert(model));
}
public frmStartUp(AccessToken acctoken)
{
InitializeComponent();
var RoleAccess = new RoleAccess(acctoken, this);
_myAccessToken = acctoken;
this.Text = " " + _myAccessToken.FirstName + " " + _myAccessToken.LastName + " logged in as a " + _myAccessToken.Role.Name;
this.WindowState = FormWindowState.Maximized;
}
public AddVendorWindow(string productId, AccessToken _myAccessToken)
{
var RoleAccess = new RoleAccess(_myAccessToken, this);
var vendors = _vendorManager.GetVendors();
foreach (var vendor in vendors)
{
lvVendors.Items.Add(vendor.ToString());
}
}
public FrmShipping(AccessToken acctoken)
{
InitializeComponent();
var RoleAccess = new RoleAccess(acctoken, this);
_myAccessToken = acctoken;
_myVendorManager = new ShippingVendorManager();
_myTermManager = new ShippingTermManager();
_myOrderManager = new ShippingOrderManager();
}
public FrmShipping(AccessToken acctoken)
{
InitializeComponent();
var RoleAccess = new RoleAccess(acctoken, this);
_myAccessToken = acctoken;
_myVendorManager = new ShippingVendorManager();
_myTermManager = new ShippingTermManager();
_myOrderManager = new ShippingOrderManager();
}//End FrmShipping(.)
public frmOpenVendorOrders(AccessToken acctkn)
{
InitializeComponent();
var RoleAccess = new RoleAccess(acctkn, this);
_myAccessToken = acctkn;
Instance = this;
// Add a CellClick handler to handle clicks in the button column.
dgvOpenVendorOrders.CellClick += new DataGridViewCellEventHandler(dgv_CellClick);
}
protected void Page_LoadComplete(object sender, EventArgs e)
{
if (CustomerContext.CurrentCustomer.CustomerRole == Role.Administrator ||
(CustomerContext.CurrentCustomer.CustomerRole == Role.Moderator &&
RoleAccess.Check(CustomerContext.CurrentCustomer, "product.aspx")))
{
hrefAdmin.Visible = true;
}
GetOffer();
}
public FrmVendorAddUpdate(AccessToken acctkn)
{
InitializeComponent();
_myAccessToken = acctkn;
btMorph.Text = "Add Vendor";
var RoleAccess = new RoleAccess(acctkn, this);
PopulateStateCombo();
PopulateCountryCombo();
Instance = this;
}
public Task <bool> EditRoleAccessAsync(RoleAccess roleAccess)
{
var collection = _store.GetCollection <RoleAccess>();
var access = collection.AsQueryable().FirstOrDefault(ra => ra.RoleId == roleAccess.RoleId);
if (access == null)
{
return(collection.InsertOneAsync(roleAccess));
}
roleAccess.Id = access.Id;
return(collection.ReplaceOneAsync(roleAccess.Id, roleAccess));
}
public ProductView(AccessToken accToken)
{
InitializeComponent();
var RoleAccess = new RoleAccess(accToken, this);
_myAccessToken = accToken;
_productManager = new ProductManager();
_vendorManager = new VendorManager();
_vendorSourceManager = new VendorSourceItemManager();
this.Text = "Add Product";
btMorph.Text = "Add Product";
PopulateLocationCombo();
PopulateActiveCombo();
tbProductID.Enabled = false;
tbProductID.Text = "The ID will automatically be created.";
this.lblVendors.Visible = false;
this.lvVendors.Visible = false;
this.btAddVendor.Visible = false;
lblPriceDisplay.Text = String.Format("{0:C}", 0);
lblWeightDisplay.Text = "0.0 lbs";
tbProductID.Focus();
Instance = this;
}
public FrmVendorSource(AccessToken acctoken)
{
InitializeComponent();
_myAccessToken = acctoken;
var RoleAccess = new RoleAccess(acctoken, this);
}
