/// <summary>
/// 添加角色
/// </summary>
/// <param name="Request"></param>
/// <param name="Response"></param>
/// <returns></returns>
public string RoleAdd(HttpRequest Request, HttpResponse Response)
{
string strXml = Request["txtXML"];
UserSession userSession = ((UserSession)Session["RoleUser"]);
strXml = PageCommon.setOpDocXML(strXml, userSession);
return(RoleBO.addRole(strXml));
}
private RoleBO IsRole(RoleBO roleBO, string param)
{
if (roleBO == null || roleBO.Id == 0 || !roleBO.RoleName.Equals(param))//если в БД нет роли client
{
roleBO = DependencyResolver.Current.GetService <RoleBO>();
roleBO.RoleName = param;
roleBO.Save(roleBO);
roleBO = roleBO.LoadAll().Where(r => r.RoleName.Equals(param)).FirstOrDefault(); //получить уже с ID
}
return(roleBO);
}
/// <summary>
/// To Update details of Role in tbl_Role_M table
/// Created By : Darshan, 09/15/2014
/// Modified By :
/// </summary>
/// <param name="objRoleBO"></param>
/// <returns></returns>
public ApplicationResult Role_Update(RoleBO objRoleBO)
{
try
{
pSqlParameter = new SqlParameter[5];
pSqlParameter[0] = new SqlParameter("@RoleID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objRoleBO.RoleID;
pSqlParameter[1] = new SqlParameter("@RoleName", SqlDbType.VarChar);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objRoleBO.RoleName;
pSqlParameter[2] = new SqlParameter("@Description", SqlDbType.VarChar);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objRoleBO.Description;
pSqlParameter[3] = new SqlParameter("@LastModifiedUserID", SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objRoleBO.LastModifiedUserID;
pSqlParameter[4] = new SqlParameter("@LastModifiedDate", SqlDbType.VarChar);
pSqlParameter[4].Direction = ParameterDirection.Input;
pSqlParameter[4].Value = objRoleBO.LastModifiedDate;
sSql = "usp_tbl_Role_M_Update";
int iResult = Database.ExecuteNonQuery(CommandType.StoredProcedure, sSql, pSqlParameter);
if (iResult > 0)
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.SUCCESS;
return(objResults);
}
else
{
ApplicationResult objResults = new ApplicationResult();
objResults.status = ApplicationResult.CommonStatusType.FAILURE;
return(objResults);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
objRoleBO = null;
}
}
public RoleBO Create(RoleBO entityToCreate)
{
if (entityToCreate == null)
{
return(null);
}
using (var unitOfWork = _facade.UnitOfWork)
{
var createdRole = unitOfWork.RoleRepository.Create(_converter.Convert(entityToCreate));
unitOfWork.Complete();
return(_converter.Convert(createdRole));
}
}
public ActionResult UserroleChildrenField(int id)
{
int count = RoleBO.GetInstance().GetUserroleCount(id);
ChildrenFieldUIModel model = new ChildrenFieldUIModel()
{
ID = id,
Count = count,
ClassName = "Userrole"
};
return(View("ChildrenField", model));
}
public ActionResult Create(RoleDataModel role)
{
RoleBO.GetInstance().Create(role);
if (Session["roleParentID"] != null)
{
return(RedirectToAction("Index", new { id = Convert.ToInt32(Session["roleParentID"]) }));
}
else
{
return(RedirectToAction("Index"));
}
}
protected override void Seed(BusLocatorContext context)
{
BusLocatorUserManager userManager = new BusLocatorUserManager(new BusLocatorUserStore(context));
BusLocatorRoleManager roleManager = new BusLocatorRoleManager(new BusLocatorRoleStore(context));
//System.Web.HttpContext.Current.GetOwinContext().
const string name = "*****@*****.**";
string password = "******";
string[] roles = { "Admin", "User", "Driver" };
foreach (string rolename in roles)
{
var role = roleManager.FindByName(rolename);
if (role == null)
{
role = new RoleBO(rolename);
var roleresult = roleManager.Create(role);
}
}
RoleBO role1 = roleManager.FindByName(roles[0]);
RoleBO role2 = roleManager.FindByName(roles[1]);
var user = userManager.FindByName(name);
if (user == null)
{
user = new UserBO
{
UserName = name,
Email = name,
FullName = "Global Admin",
EmailConfirmed = true,
LockoutEnabled = false,
Audit = new Domain.Entity.Audit(),
HasAcceptedTerms = true,
};
var result = userManager.Create(user, password);
result = userManager.SetLockoutEnabled(user.Id, false);
}
var rolesForUser = userManager.GetRoles(user.Id);
if (!rolesForUser.Contains("Admin"))
{
userManager.AddToRole(user.Id, "Admin");
}
}
public RoleBO Update(RoleBO entityToUpdate)
{
using (var unitOfWork = _facade.UnitOfWork)
{
var roleFromDB = unitOfWork.RoleRepository.GetById(entityToUpdate.Id);
if (roleFromDB == null)
{
return(null);
}
roleFromDB.Name = entityToUpdate.Name;
unitOfWork.RoleRepository.Update(roleFromDB);
unitOfWork.Complete();
return(_converter.Convert(roleFromDB));
}
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_Save_Click(object sender, EventArgs e)
{
RoleBO objRole = new RoleBO();
RoleBLL objroleBLL = new RoleBLL();
objRole.RoleID = Convert.ToInt32(ViewState["ROLEID"]);
objRole.RoleName = txtRoleName.Text.Trim();
objRole.RoleDescription = txtDescription.Text.Trim();
if (objRole.RoleDescription.Length >= 200)
{
objRole.RoleDescription = objRole.RoleDescription.Substring(0, 198);
}
string AlertMessage = string.Empty;
string message = string.Empty;
AlertMessage = "alert('" + message + "');";
if (objRole.RoleID == 0)
{
objRole.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
message = objroleBLL.AddRole(objRole);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
ClearDetails();
}
}
else
{
objRole.UpdatedBy = Convert.ToInt32(Session["USER_ID"]);
message = objroleBLL.UpdateRole(objRole);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
ClearDetails();
SetUpdateMode(false);
}
}
BindGrid(true, false);
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
public HttpResponseMessage GetFuncInfo(string pkfunc)
{
string clientIpAddress = base.Request.GetClientIpAddress();
List <RoleFuncVO> list = new RoleBO().getRoleFuncVOs(base.User.Identity.Name, clientIpAddress);
bool flag = false;
foreach (RoleFuncVO cvo2 in list)
{
if (cvo2.PKFunc.Equals(pkfunc))
{
flag = true;
break;
}
}
if (!flag)
{
throw new Exception("此功能只限内部网络访问!");
}
return(HttpHelper.toJson(new RoleBO().getFuncVO(pkfunc)));
}
protected override void Seed(Sirius.Persistence.Context.SiriusContext context)
{
var userManager = new SiriusUserManager(new SiriusUserStore(new SiriusContext()));
var roleManager = new SiriusRoleManager(new SiriusRoleStore(new SiriusContext()));
//System.Web.HttpContext.Current.GetOwinContext().
const string name = "*****@*****.**";
const string password = "******";
string[] roles = { "GlobalAdmin", "Admin", "ITAdmin", "PMAdmin", "Supervisor", "Staff" };
foreach (string rolename in roles)
{
var role = roleManager.FindByName(rolename);
if (role == null)
{
role = new RoleBO(rolename);
var roleresult = roleManager.Create(role);
}
}
var role1 = roleManager.FindByName(roles[0]);
var user = userManager.FindByName(name);
if (user == null)
{
user = new UserBO {
UserName = name, Email = name, EmailConfirmed = true, LockoutEnabled = false, Audit = new Entity.Entities.Audit(), StaffUserName = "******", DateOfBirth = DateTime.UtcNow, Gender = Entity.Enums.Gender.Male
};
var result = userManager.Create(user, password);
result = userManager.SetLockoutEnabled(user.Id, false);
}
var rolesForUser = userManager.GetRoles(user.Id);
if (!rolesForUser.Contains(role1.Name))
{
var result = userManager.AddToRole(user.Id, role1.Name);
}
}
/// <summary>
/// To Update Role
/// </summary>
/// <param name="objRole"></param>
/// <returns></returns>
public string UpdateRole(RoleBO objRole)
{
string result = string.Empty;
{
OracleConnection myConnection;
OracleCommand myCommand;
myConnection = new OracleConnection(AppConfiguration.ConnectionString);
myCommand = new OracleCommand("USP_MST_UPDATEROLE", myConnection);
myCommand.Connection = myConnection;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("@ROLEIDIN", objRole.RoleID);
myCommand.Parameters.Add("@ROLENAMEIN", objRole.RoleName);
if (string.IsNullOrEmpty(objRole.RoleDescription) == true)
{
myCommand.Parameters.Add("@RoleDescription", " ");
}
else
{
myCommand.Parameters.Add("@RoleDescription", objRole.RoleDescription);
}
myCommand.Parameters.Add("@ISDELETEDIN", "False");
myCommand.Parameters.Add("@USERIDIN", objRole.UpdatedBy);
myCommand.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
myConnection.Open();
myCommand.ExecuteNonQuery();
if (myCommand.Parameters["errorMessage_"].Value != null)
{
result = myCommand.Parameters["errorMessage_"].Value.ToString();
}
else
{
result = string.Empty;
}
myConnection.Close();
}
return(result);
}
/// <summary>
/// Set edit mode for edit comand
/// Delete data from the database for delete comand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdRoles_RowCommand(object sender, GridViewCommandEventArgs e)
{
string message = string.Empty;
try
{
if (e.CommandName == "EditRow")
{
ShowHideSections(true, false);
ViewState["ROLEID"] = e.CommandArgument;
RoleBLL objroleBLL = new RoleBLL();
RoleBO objRole = objroleBLL.GetRoleByRoleID(Convert.ToInt32(ViewState["ROLEID"]));
txtRoleName.Text = objRole.RoleName;
txtDescription.Text = objRole.RoleDescription;
SetUpdateMode(true);
ScriptManager.RegisterStartupScript(this, this.GetType(), "Added", "setDirty();", true);
}
else if (e.CommandName == "DeleteRow")
{
RoleBLL objroleBLL = new RoleBLL();
message = objroleBLL.DeleteRole(Convert.ToInt32(e.CommandArgument));
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data Deleted successfully";
}
SetUpdateMode(false);
BindGrid(false, true);
ClearDetails();
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Login(LoginModel info)
{
using (BLLContext ctx = new BLLContext())
{
UserBO user = ctx.GetUserByUsername(info.Username);
if (user == null)
{
info.Message = $"The Username '{info.Username}' does not exist in the database";
return(View(info));
}
string pass = info.Password;
RoleBO role = ctx.GetRoleByID(user.RoleID_FK);
if (pass == user.Password)
{
Session["AUTHUsername"] = info.Username;
Session["AuthRoles"] = role.Role;
return(Redirect(info.ReturnURL));
}
info.Message = "The password was incorrect";
return(View(info));
}
}
public ActionResult UpdateUserRoles(string userId)
{
UserRoleViewModel model = new UserRoleViewModel();
RoleBO GA = RoleManager.FindByName(SiriusRoles.GA);
RoleBO Machine = RoleManager.FindByName(SiriusRoles.MACHINE);
List <RoleBO> roles = RoleManager.Roles.ToList();
roles.Remove(GA);
roles.Remove(Machine);
model.UserRoles = UserManager.GetRoles(userId);
foreach (RoleBO role in roles)
{
SelectListItem item = new SelectListItem
{
Selected = model.UserRoles.Contains(role.Name),
Text = role.Name,
Value = role.Name
};
model.RoleList.Add(item);
}
model.UserId = userId;
return(PartialView(model));
}
protected override void Seed(SiriusContext context)
{
Sirius.Data.Repository.DataSource db = new Sirius.Data.Repository.DataSource();
OrganizationBO org = db.organizationRepository.FindBy(o => o.ShortName.ToLower() == "geekcamp").FirstOrDefault();
if (org == null)
{
org = new OrganizationBO
{
Name = "GeekCamp Studios",
ShortName = "geekcamp",
Status = Entity.Enums.Status.ACTIVE,
Audit = new Entity.Entities.Audit()
};
db.organizationRepository.Add(org);
db.unitofWork.Commit();
}
var userManager = new SiriusUserManager(new SiriusUserStore(context));
var roleManager = new SiriusRoleManager(new SiriusRoleStore(context));
//System.Web.HttpContext.Current.GetOwinContext().
const string name = "*****@*****.**";
const string password = "******";
string[] roles = { "GlobalAdmin", "Supervisor", "Staff", "OrganizationAdmin" };
foreach (string rolename in roles)
{
var role = roleManager.FindByName(rolename);
if (role == null)
{
role = new RoleBO(rolename);
var roleresult = roleManager.Create(role);
}
}
var role1 = roleManager.FindByName(roles[0]);
//var role2 = roleManager.FindByName(roles[6]);
var user = userManager.FindByName(name);
if (user == null)
{
user = new UserBO
{
OrganizationId = org.Id,
UserName = name,
Email = name,
FirstName = "GeekCamp",
LastName = "Admin",
EmailConfirmed = true,
LockoutEnabled = false,
Audit = new Entity.Entities.Audit(),
StaffUserName = "******",
DateOfBirth = DateTime.UtcNow,
HasAcceptedTerms = true,
Gender = Entity.Enums.Gender.Male
};
var result = userManager.Create(user, password);
result = userManager.SetLockoutEnabled(user.Id, false);
}
var rolesForUser = userManager.GetRoles(user.Id);
if (!rolesForUser.Contains(role1.Name))
{
var result = userManager.AddToRole(user.Id, role1.Name);
}
//if (!rolesForUser.Contains(role2.Name))
//{
// var result = userManager.AddToRole(user.Id, role2.Name);
//}
}
/// <summary>
/// 删除角色
/// </summary>
/// <param name="Request"></param>
/// <param name="Response"></param>
/// <returns></returns>
public string DropRole(HttpRequest Request, HttpResponse Response)
{
string strRoleID = Request["txtXML"];
return(RoleBO.DropRole(strRoleID));
}
public ActionResult Edit(int id)
{
return(View(RoleBO.GetInstance().Get(id)));
}
/// <summary>
/// 查询角色列表
/// </summary>
/// <param name="Request"></param>
/// <param name="Response"></param>
/// <returns></returns>
public string QryRoleList(HttpRequest Request, HttpResponse Response)
{
string strXML = Request["txtXML"];
return(RoleBO.roleList(strXML));
}
/// <summary>
/// 查询不属于该角色的用户
/// </summary>
/// <param name="Request"></param>
/// <param name="Response"></param>
/// <returns></returns>
public string userList_AddToRole(HttpRequest Request, HttpResponse Response)
{
string strRoleID = Request["txtXML"];
return(RoleBO.userList_AddToRole(strRoleID));
}
/// <summary>
/// 查询不属于该角色的事件
/// </summary>
/// <param name="Request"></param>
/// <param name="Response"></param>
/// <returns></returns>
public string getEventTypeList_AddToRole(HttpRequest Request, HttpResponse Response)
{
string strRoleID = Request["txtXML"];
return(RoleBO.eventTypeList_AddToRole(strRoleID));
}
/// <summary>
/// 查询角色详细信息
/// </summary>
/// <param name="Request"></param>
/// <param name="Response"></param>
/// <returns></returns>
public string RoleDetail(HttpRequest Request, HttpResponse Response)
{
string strRoleID = Request["txtXML"];
return(RoleBO.roleDetail(strRoleID));
}
/// <summary>
/// 查询角色包含的用户列表
/// </summary>
/// <param name="Request"></param>
/// <param name="Response"></param>
/// <returns></returns>
public string QryRoleUserList(HttpRequest Request, HttpResponse Response)
{
string strRoleID = Request["txtXML"];
return(RoleBO.roleUserList(strRoleID));
}
public ActionResult Delete(int id)
{
RoleBO.GetInstance().Delete(id);
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
protected void btnSaveClass_OnClick(object sender, EventArgs e)
{
try
{
RoleBO objRoleBO = new RoleBO();
RoleBL objRoleBL = new RoleBL();
ApplicationResult objResult = new ApplicationResult();
DataTable dtResult = new DataTable();
int intRoleID = 0;
objRoleBO.RoleName = txtRoleName.Text.Trim();
objRoleBO.Description = txtDescription.Text.Trim();
objRoleBO.LastModifiedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objRoleBO.LastModifiedDate = DateTime.UtcNow.AddHours(5.5).ToString();
//Code For Validate Role Name
if (ViewState["Mode"].ToString() == "Save")
{
intRoleID = -1;
}
else if (ViewState["Mode"].ToString() == "Edit")
{
intRoleID = Convert.ToInt32(ViewState["RoleID"].ToString());
}
objResult = objRoleBL.Role_ValidateName(intRoleID, objRoleBO.RoleName);
if (objResult != null)
{
dtResult = objResult.resultDT;
if (dtResult.Rows.Count > 0)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Role name already exist.');</script>");
}
else
{
if (ViewState["Mode"].ToString() == "Save")
{
objRoleBO.CreatedUserID = Convert.ToInt32(Session[ApplicationSession.USERID]);
objRoleBO.CreatedDate = DateTime.UtcNow.AddHours(5.5).ToString();
objResult = objRoleBL.Role_Insert(objRoleBO);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record saved successfully.');</script>");
}
}
else if (ViewState["Mode"].ToString() == "Edit")
{
objRoleBO.RoleID = Convert.ToInt32(ViewState["RoleID"].ToString());
objResult = objRoleBL.Role_Update(objRoleBO);
if (objResult.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Record updated successfully.');</script>");
}
}
ClearAll();
BindRole();
PanelVisibility(1);
}
}
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical issue. Please Contact to your administrator.');</script>");
}
}
public ApiResponse <int?> Create(RoleBO model)
{
return(new ApiResponse <int?>(ResponseCode.Ok, Service.Add(model)));
}
/// <summary>
/// To Add Role
/// </summary>
/// <param name="objRole"></param>
/// <returns></returns>
public string AddRole(RoleBO objRole)
{
RoleDAL objRoleDAL = new RoleDAL();
return(objRoleDAL.AddRole(objRole));
}
public ApiResponse <int> Update(RoleBO model)
{
return(new ApiResponse <int>(ResponseCode.Ok, Service.Update(model)));
}
/// <summary>
/// To Update Role
/// </summary>
/// <param name="objRole"></param>
/// <returns></returns>
public string UpdateRole(RoleBO objRole)
{
RoleDAL objRoleDAL = new RoleDAL();
return(objRoleDAL.UpdateRole(objRole));
}
public RoleBOTests()
{
_target = new RoleBO(_roleRepo, _roleUserRepo, _roleFunctionRepo, _sqlConnectionHelper);
}
