//This method tests to make sure edit role works correctly
public string EditRole()
{
//Create a role
RoleController rc = new RoleController();
Role role = new Models.Role();
role.RoleName = "Testing Role";
role.RoleCount = 7;
role.RoleDescription = "Role for testing purposes";
try
{
role = rc.createRole(role);
}
catch (System.Data.SqlClient.SqlException)
{
}
try
{
int test = role.Id;
}
catch (NullReferenceException)
{
return("Create Role Failed");
}
Role getRole = rc.getRoleById(role.Id);
if (!(getRole.Id >= 0))
{
return("Get Role Failed");
}
//Edit the role
getRole.RoleName = "Edit Name of Role!";
try
{
rc.editRole(getRole);
}
catch
{
}
//Test to see if the Role was edited
if (!getRole.RoleName.Equals("Edit Name of Role!"))
{
return("Edit Role Failed");
}
try
{
rc.deleteRole(role.Id);
}
catch (System.Data.SqlClient.SqlException)
{
}
catch (NullReferenceException)
{
}
if (!(rc.getRoleById(role.Id).Id >= 0))
{
return("Delete Role Failed");
}
return("Success");
}
public async Task <IActionResult> EditRole(long id)
{
ResultModel res = await GetAsync <ResultModel>("?id=" + id, _urlSettings.Role.GetRoleById);
Models.Role role = JsonConvert.DeserializeObject <Models.Role>(res.Data.ToString());
return(View(role));
}
// GET: Account
public ActionResult Overview()
{
PlanningSysteemEntities context = new PlanningSysteemEntities();
List <Models.Account> allAccounts = new List <Models.Account>();
List <Account> accounts = context.Account.Where(a => a.isDisabled == false).ToList();
foreach (Account i in accounts)
{
Models.Role roleinDB = new Models.Role()
{
roleId = i.Role.roleId,
roleName = i.Role.roleName
};
Models.Account account = new Models.Account()
{
userId = i.userId,
username = i.username,
role = roleinDB,
createdAt = i.createdAt,
firstLogin = i.firstLogin
};
allAccounts.Add(account);
}
return(View(allAccounts));
}
public static int Register(Models.Role role)
{
return(Register(new List <Models.Role>()
{
role
}));
}
public async Task <IdentityResult> Update([FromBody] Models.Role model)
{
var role = _roleManager.Roles.Where(r => r.Id == model.Id).FirstOrDefault();
Mapper.Map <Models.Role, Entities.Role>(model, role);
return(await _roleManager.UpdateAsync(role));
}
public virtual System.Web.Mvc.ActionResult Create([System.Web.Mvc.Bind(Include = "IsActive,Name")] Models.Role role)
{
// **************************************************
// Business Validation
if ((role.Name != null) && (role.Name.Length < 4) && (role.IsActive))
{
//ModelState.AddModelError
// (key: "Name", errorMessage: "Some business error message!");
ModelState.AddModelError
(key: string.Empty, errorMessage: "Some business error message!");
}
// **************************************************
if (ModelState.IsValid)
{
MyDatabaseContext.Roles.Add(role);
MyDatabaseContext.SaveChanges();
return(RedirectToAction(MVC.Roles.Index()));
}
//return (View());
return(View(model: role));
}
public ActionResult Create(Models.Role o)
{
/// Authentication and authorisation.
if (Session["UserId"] == null)
{
return(RedirectToAction("Login", "home"));
}
if (!BAL.AccessBO.CanAccessAppFunctionByUserId(Session["UserId"].ToString(), "role_create"))
{
return(RedirectToAction("NoAccess", "home"));
}
if (!ModelState.IsValid)
{
return(View(o));
}
if (o == null)
{
ModelState.AddModelError(string.Empty, "Role is NULL.");
return(View(o));
}
/// check whether name already exists in database.
if (string.IsNullOrEmpty(o.UniqueName))
{
o.UniqueName = o.UniqueName.Trim();
}
if (DAO.RoleDao.UniqueNameExists(o.UniqueName))
{
ModelState.AddModelError(string.Empty, "Unique Name already exists.");
return(View(o));
}
return(View("CreateConfirm", o));
}
public static int InsertUnit(Models.Role o)
{
if (o == null)
{
return(-1);
}
string sql = "INSERT INTO Roles (UniqueName,DisplayName,IsDisabled,CreatedDt,CreatedBy,UpdatedDt,UpdatedBy,Description) VALUES (@UniqueName,@DisplayName,@IsDisabled,@UpdatedDt,@UpdatedBy,@UpdatedDt,@UpdatedBy,@Description)";
return(DbHandler.IsMssqlConnected ?
DbHandler.MSSQL.ExecuteNonQuery(sql,
new SqlParameter("@UniqueName", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.UniqueName)
},
new SqlParameter("@DisplayName", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.DisplayName)
},
new SqlParameter("@IsDisabled", SqlDbType.Bit)
{
Value = o.IsDisabled
},
new SqlParameter("@UpdatedDt", SqlDbType.DateTime)
{
Value = o.UpdatedDt
},
new SqlParameter("@UpdatedBy", SqlDbType.Int)
{
Value = o.UpdatedBy
},
new SqlParameter("@Description", SqlDbType.VarChar)
{
Value = DbHandler.GetObjectToDb(o.Description)
}) :
DbHandler.SQLite.ExecuteNonQuery(sql,
new System.Data.SQLite.SQLiteParameter("@UniqueName", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.UniqueName)
},
new System.Data.SQLite.SQLiteParameter("@DisplayName", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.DisplayName)
},
new System.Data.SQLite.SQLiteParameter("@IsDisabled", DbType.Boolean)
{
Value = o.IsDisabled
},
new System.Data.SQLite.SQLiteParameter("@UpdatedDt", DbType.DateTime)
{
Value = o.UpdatedDt
},
new System.Data.SQLite.SQLiteParameter("@UpdatedBy", DbType.Int32)
{
Value = o.UpdatedBy
},
new System.Data.SQLite.SQLiteParameter("@Description", DbType.AnsiString)
{
Value = DbHandler.GetObjectToDb(o.Description)
}));
}
public IActionResult Create(Models.Role role)
{
db.Add(role);
db.SaveChanges();
return(Redirect("/backend/roles"));
}
public virtual System.Web.Mvc.ActionResult Edit
([System.Web.Mvc.Bind(Include = "Id,IsActive,Name")] Models.Role role)
{
Models.Role oOriginalRole =
MyDatabaseContext.Roles
.Find(role.Id);
if (oOriginalRole == null)
{
return(HttpNotFound());
}
if (ModelState.IsValid)
{
//MyDatabaseContext.Entry(role).State = EntityState.Modified;
oOriginalRole.Name = role.Name;
oOriginalRole.IsActive = role.IsActive;
MyDatabaseContext.SaveChanges();
return(RedirectToAction(MVC.Roles.Index()));
}
return(View(model: role));
}
public static string Insert(string temp)
{
JObject jo = (JObject)JsonConvert.DeserializeObject(temp);
string msg;
Models.Role role = new Models.Role(jo["name"].ToString(), jo["authority"].ToString(), jo["note"].ToString());
return(Models.BLL.RoleManage.Add(role, out msg) ? JsonConvert.SerializeObject(new Packet(200, "插入成功")) : JsonConvert.SerializeObject(new Packet(203, msg)));
}
public ActionResult EditRole(Models.Role role)
{
if (ModelState.IsValid)
{
_rolesHandler.Update(ConvertToBlModel(role));
}
return(RedirectToAction("Roles"));
}
public static string SaveRole(Models.Role role, string userId = null)
{
userId = string.IsNullOrEmpty(userId) ? AuditId : userId;
role.PortalId = string.IsNullOrEmpty(role.PortalId) ? Portal.CurrentPortalId : role.PortalId;
Validate(role);
return(AccountService.SaveRole(role, userId));
}
public static string Update(string temp)
{
JObject jo = (JObject)JsonConvert.DeserializeObject(temp);
string msg;
Models.Role role = new Models.Role((int)jo["id"], jo["name"].ToString(), jo["authority"].ToString(), jo["note"].ToString());
return(Models.BLL.RoleManage.Update(role, out msg) ? JsonConvert.SerializeObject(new Packet(200, "修改成功")) : JsonConvert.SerializeObject(new Packet(202, msg)));
}
public virtual System.Web.Mvc.ViewResult Create()
{
Models.Role oRole = new Models.Role();
oRole.IsActive = true;
return(View(model: oRole));
}
public override System.Web.Mvc.ActionResult Edit(Models.Role role)
{
var callInfo = new T4MVC_System_Web_Mvc_ActionResult(Area, Name, ActionNames.Edit);
ModelUnbinderHelpers.AddRouteValues(callInfo.RouteValueDictionary, "role", role);
EditOverride(callInfo, role);
return(callInfo);
}
/// <summary>
/// 添加角色信息
/// </summary>
/// <param name="role">角色信息</param>
/// <returns></returns>
public int Add(Models.Role role)
{
string sql = @"INSERT into
[Role](Name,IsActive)
VALUES(@Name,@IsActive);";
var parms = ConvertHelper.ToSqlParameterArray <Role>(role);
return(SqlHelper.ExecuteNonQuery(sql, CommandType.Text, parms));
}
public static string ImportRole(string portalId, Models.Role role, string userId = null)
{
userId = string.IsNullOrEmpty(userId) ? Account.AuditId : userId;
var existing = GetRole(role.Name, portalId);
role.PortalId = portalId;
role.Id = existing != null ? existing.Id : null;
return(SaveRole(role, userId));
}
public override void Update(Models.Role @new, Models.Role old)
{
var update = Get(old);
update.Name = @new.Name;
update.Permissions = @new.Permissions;
_dbContext.SaveChanges();
}
public static bool IsDuplicate(Models.Role role)
{
var r = GetRole(role.Name, role.PortalId);
if (r != null)
{
return(r.Id != role.Id);
}
return(false);
}
/// <summary>
/// 更新信息
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public int Edit(Models.Role role)
{
string sql = @"update [Role]
set
Name=@Name
where ID=@ID";
var parms = ConvertHelper.ToSqlParameterArray <Role>(role);
return(SqlHelper.ExecuteNonQuery(sql, CommandType.Text, parms));
}
public virtual System.Web.Mvc.ActionResult Edit([System.Web.Mvc.Bind(Include = "Id,Name,IsActive")] Models.Role role)
{
if (ModelState.IsValid)
{
UnitOfWork.RoleUserManagerUnitOfWork.RoleRepository.Insert(role);
UnitOfWork.RoleUserManagerUnitOfWork.RoleRepository.Save();
return(RedirectToAction(MVC.Roles.Index()));
}
return(View(role));
}
public UsersController(Users view)
{
this.view = view;
this.userModel = new Models.User();
this.roleModel = new Models.Role();
this.sectorModel = new Models.Sector();
this.operatorModel = new Models.Operator();
this.doctorModel = new Models.Doctor();
this.nurseModel = new Models.Nurse();
}
public virtual System.Web.Mvc.ActionResult Create([System.Web.Mvc.Bind(Include = "Id,IsActive,Name")] Models.Role role)
{
if (ModelState.IsValid)
{
MyDatabaseContext.Roles.Add(role);
MyDatabaseContext.SaveChanges();
return(RedirectToAction(MVC.Roles.Index()));
}
return(View(role));
}
public static DLL.DTO.Role ToDAL(this Models.Role role)
{
return(role is null ? null : new DLL.DTO.Role
{
Name = role.Name,
ContentManager = role.ContentManager,
Seller = role.Seller,
UserAdmin = role.UserAdmin,
Сourier = role.Сourier
});
}
private List <Models.Role> GetAllRoles()
{
List <Models.Role> lstRoles = null;
if (ModelState.IsValid)
{
Models.Role oRole = new Models.Role();
lstRoles = oRole.GetAllRoles(0, "ALL");
}
return(lstRoles);
}
Create([System.Web.Mvc.Bind
(Exclude = "Id")] Models.Role role)
{
if (ModelState.IsValid)
{
MyDatabaseContext.Roles.Add(role);
MyDatabaseContext.SaveChanges();
return(RedirectToAction(MVC.Roles.Index()));
}
return(View(role));
}
public ActionResult AddEmployeeRole(string Role, string Colour)
{
if (_data.Roles == null) _data.Roles = new List<Role>();
Role temp = new Models.Role();
temp.Title = Role;
temp.Colour = Colour;
_data.Roles.Add(temp);
return View("Index", _data);
}
public virtual System.Web.Mvc.ViewResult Create()
{
//return (View());
// **************************************************
Models.Role defaultItem = new Models.Role();
defaultItem.IsActive = true;
// **************************************************
return(View(model: defaultItem));
}
/*
* Controller and DAO Level Role Method Tests
*/
//Tests Creating, Getting, and Deleting a Role
public string CreateGetDeleteRole()
{
//Create a role
RoleController rc = new RoleController();
Role role = new Models.Role();
role.RoleName = "Testing Role";
role.RoleCount = 7;
role.RoleDescription = "Role for testing purposes";
//First test creating a role
try
{
role = rc.createRole(role);
}
catch (System.Data.SqlClient.SqlException)
{
}
//If the role id is null then return "Create Role Failed"
try
{
int test = role.Id;
}
catch (NullReferenceException)
{
return("Create Role Failed");
}
//Second test get role
Role getRole = rc.getRoleById(role.Id);
//If the returned role doesn't have an id then return "Get Role Failed"
if (!(getRole.Id >= 0))
{
return("Get Role Failed");
}
//Third test delete role
try
{
rc.deleteRole(role.Id);
}
catch (System.Data.SqlClient.SqlException)
{
}
catch (NullReferenceException)
{
}
//If the role isn't deleted return "Delete Role Failed"
if (!(rc.getRoleById(role.Id).Id >= 0))
{
return("Delete Role Failed");
}
//Return "Success" if nothing failed
return("Success");
}
// AjoutRole
public void AjoutRole()
{
Models.Role roleA_ajouter = new Models.Role()
{
Title = NouveauRole
};
DBContext.Roles.Add(roleA_ajouter);
DBContext.SaveChanges();
Roles.Add(roleA_ajouter);
}
