protected void gvwUsers_SelectedIndexChanged(object sender, EventArgs e)
{
gvwEditStocks.Visible = false;
rBtnAdmin.Visible = true;
rBtnUser.Visible = true;
fvwUser.Visible = true;
chkApproval.Visible = true;
List <Role> listRole = new List <Role>();
listRole = RoleDB.GetUserRoles((Guid)gvwUsers.SelectedDataKey.Value);
isApproved = MembershipDB.GetRoleId((Guid)gvwUsers.SelectedDataKey.Value);
chkApproval.Checked = isApproved;
foreach (Role role in listRole)
{
if (role.id == adminRoleId)
{
rBtnAdmin.Checked = true;
rBtnUser.Checked = false;
isAdmin = true;
break;
}
if (role.id == userRoleId)
{
rBtnUser.Checked = true;
rBtnAdmin.Checked = false;
isAdmin = false;
}
}
rBtnAdmin.Enabled = false;
rBtnUser.Enabled = false;
chkApproval.Enabled = false;
}
public JsonResult SaveRoleWithPermissionMenus(RoleMenus roleWithPermissionMenus)
{
ReturnMenuRole returnResult = new ReturnMenuRole();
returnResult.Code = "00";
//validate
if (roleWithPermissionMenus.lstMenuRole == null)
{
returnResult.Code = "99";
returnResult.Message = "Không có dữ liệu/No data.";
return(Json(returnResult, JsonRequestBehavior.AllowGet));
}
RoleDB roleDB = new RoleDB();
ReturnMenuRole returnRoleWithPermissionMenus;
foreach (MenuRole menuRole in roleWithPermissionMenus.lstMenuRole)
{
returnRoleWithPermissionMenus = roleDB.SaveRoleWithPermissionMenus(menuRole);
if (returnRoleWithPermissionMenus.Code == "99")
{
returnResult.Code = "99";
returnResult.Message += "Lỗi phân quyền : " + menuRole.MenuName + "; ";
}
}
return(Json(returnResult, JsonRequestBehavior.AllowGet));
}
//private string curDateString;
protected void Page_Load(object sender, EventArgs e)
{
contentInfo = ContentDB.GetInfo(ConvertUtility.ToInt32(Request.QueryString["contentid"]));
if (contentInfo == null)
{
Response.Redirect(AppEnv.ADMIN_ACCESSDENY);
}
//curDateString = contentInfo.Content_CreateDate.Year + "_" + contentInfo.Content_CreateDate.Month + "_" + contentInfo.Content_CreateDate.Day;
isManager = RoleDB.CheckRole(CurrentAdminInfo.User_ID, (int)AppEnv.CMSRole.Manager);
isDeployer = RoleDB.CheckRole(CurrentAdminInfo.User_ID, (int)AppEnv.CMSRole.Deployer);
isCreater = RoleDB.CheckRole(CurrentAdminInfo.User_ID, (int)AppEnv.CMSRole.Creater);
//string userUploadPath = Constants.UploadPath + contentInfo.Content_UserID + "/" + curDateString;
//Editor1.UploadDir = userUploadPath;
//txtAttachFile.fpUploadDir = userUploadPath;
//txtAvatar.fpUploadDir = userUploadPath;
//Editor1.UploadDir = Constants.UploadContent;
//txtAttachFile.fpUploadDir = Constants.UploadAvatar;
//txtAvatar.fpUploadDir = Constants.UploadAvatar;
if (!IsPostBack)
{
LoadZones();
}
lblStatusUpdate.Text = string.Empty;
}
protected void Page_Load(object sender, EventArgs e)
{
isManager = RoleDB.CheckRole(CurrentAdminInfo.User_ID, (int)AppEnv.CMSRole.Manager);
isDeployer = RoleDB.CheckRole(CurrentAdminInfo.User_ID, (int)AppEnv.CMSRole.Deployer);
if (!IsPostBack)
{
LoadZones();
}
lblStatusUpdate.Text = string.Empty;
}
public void tearDown()
{
try
{
testRole = null;
db = null;
}
catch
{
throw new Exception();
}
}
public static void tearDownAfterClass()
{
try
{
testRole = null;
db = null;
}
catch
{
throw new Exception();
}
}
public void setUp()
{
try
{
testRole = new Role {
Id = "1234", Name = "Admin"
};
db = new RoleDB();
}
catch
{
throw new Exception();
}
}
bool AddUser(DomainUser newUser, RoleDB role)
{
/*
CREATE LOGIN "PNG\GazeevAP" FROM WINDOWS;
CREATE USER "PNG\GazeevAP";
EXEC sp_addrolemember 'db_datareader', "PNG\GazeevAP"
*/
string fullUserName = GetFullUserName(newUser);
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandText = "CREATE LOGIN \"" + fullUserName + "\" FROM WINDOWS;";
try
{
comm.ExecuteNonQuery();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message, "Create login", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
comm.CommandText = "CREATE USER \"" + fullUserName + "\";";
try
{
comm.ExecuteNonQuery();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message, "Create user", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
comm.CommandText = "EXEC sp_addrolemember \"" + role.Role + "\", \"" + fullUserName + "\";";
try
{
comm.ExecuteNonQuery();
}
catch (Exception exc)
{
MessageBox.Show(exc.Message, "Add user to the role", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return false;
}
}
return true;
}
protected void cmdUpdate_Click(object sender, EventArgs e)
{
if (lblUserEmail.Text == string.Empty)
{
return;
}
UserInfo info = UserDB.GetInfoByEmail(lblUserEmail.Text);
try
{
foreach (ListItem item in chkRoles.Items)
{
if (item.Selected)
{
RoleDB.AddUserRole(info.User_ID, Convert.ToInt32(item.Value));
}
else
{
RoleDB.RemoverUserRole(info.User_ID, Convert.ToInt32(item.Value));
}
}
string cmsRoles = string.Empty;
foreach (ListItem item in lstCMSRoles.Items)
{
if (item.Selected)
{
cmsRoles += item.Value + "|";
}
}
if (cmsRoles.Length > 0)
{
cmsRoles = "|" + cmsRoles;
}
if (cmsRoles != string.Empty)
{
RoleDB.SetUserCMSRoles(info.User_ID, AppEnv.GetLanguage(), cmsRoles);
}
lblUpdateStatus.Text = MiscUtility.UPDATE_SUCCESS;
}
catch
{
lblUpdateStatus.Text = MiscUtility.UPDATE_ERROR;
}
}
public static void LoadZones(ListItemCollection lstZones, int userID)
{
LoadZones(lstZones);
string cmsRoles = "|" + RoleDB.GetUserCMSRoles(userID, AppEnv.GetLanguage());
int i = 0;
while (i < lstZones.Count)
{
if (cmsRoles.IndexOf("|" + lstZones[i].Value + "|") < 0)
{
lstZones.RemoveAt(i);
}
else
{
i += 1;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
contentInfo = ContentDB.GetInfo(ConvertUtility.ToInt32(Request.QueryString["contentid"]));
if (contentInfo == null)
{
Response.Redirect(AppEnv.ADMIN_ACCESSDENY);
}
isManager = RoleDB.CheckRole(CurrentAdminInfo.User_ID, (int)AppEnv.CMSRole.Manager);
isDeployer = RoleDB.CheckRole(CurrentAdminInfo.User_ID, (int)AppEnv.CMSRole.Deployer);
isCreater = RoleDB.CheckRole(CurrentAdminInfo.User_ID, (int)AppEnv.CMSRole.Creater);
lblStatusUpdate.Text = string.Empty;
if (!IsPostBack)
{
LoadZones();
}
}
async Task <IEnumerable <string> > GetSelectRole(string[] roleId, TDContext db)
{
var lst = new List <string>();
var roleDB = new RoleDB(db);
if (roleId != null && roleId.Length > 0)
{
for (int i = 0, j = roleId.Length; i < j; i++)
{
var item = await roleDB.FindOrCreate(roleId[i]);
if (item != null)
{
lst.Add(item.Id);
}
}
}
return(lst);
}
protected void dtgUsers_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "roles")
{
lblUserEmail.Text = e.Item.Cells[1].Text;
UserInfo info = UserDB.GetInfoByEmail(lblUserEmail.Text);
string roles = "|";
DataTable dtRoles = RoleDB.GetByUserID(info.User_ID);
foreach (DataRow row in dtRoles.Rows)
{
roles += row["User_Role"] + "|";
}
foreach (ListItem item in chkRoles.Items)
{
if (roles.IndexOf("|" + item.Value + "|") >= 0)
{
item.Selected = true;
}
else
{
item.Selected = false;
}
}
string cmsRoles = "|" + RoleDB.GetUserCMSRoles(info.User_ID, AppEnv.GetLanguage());
foreach (ListItem item in lstCMSRoles.Items)
{
if (cmsRoles.IndexOf("|" + item.Value + "|") >= 0)
{
item.Selected = true;
}
else
{
item.Selected = false;
}
}
}
}
public int SaveRole(RoleDB objDB, SqlTransaction objTrans)
{
int RoleID = 0;
DataAccessLayer objDataLayer = new DataAccessLayer();
SqlCommand objCmd = new SqlCommand();
try
{
if (objDB.CheckID == 0)
{
objCmd.CommandText = "usp_SaveRole";
}
else
{
objCmd.CommandText = "usp_UpdateRole";
objCmd.Parameters.AddWithValue("@Id", objDB.Id);
}
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.Parameters.AddWithValue("@Role", objDB.Role);
objCmd.Parameters.AddWithValue("@IsActive", objDB.IsActive);
objCmd.Parameters.AddWithValue("@RoleID", SqlDbType.Int);
objCmd.Parameters["@RoleID"].Direction = ParameterDirection.Output;
objCmd.Transaction = objTrans;
objCmd.Connection = objTrans.Connection;
objDataLayer.Command = objCmd;
objDataLayer.ExecQuery();
RoleID = Convert.ToInt32(objCmd.Parameters["@RoleID"].Value);
return RoleID;
}
catch (Exception ex)
{
throw ex;
}
}
public int Save(RoleUI objUI, System.Data.SqlClient.SqlTransaction objTrans)
{
int RoleID = 0;
bool flagTransation = true;
RoleDB objDB = new RoleDB();
objDB.Role = objUI.Role;
objDB.IsActive = objUI.IsActive;
objDB.Id = objUI.Id;
objDB.CheckID = objUI.CheckID;
DataAccessLayer objDataAccess = new DataAccessLayer();
try
{
if (objTrans == null)
{
flagTransation = false;
objDataAccess.GetConnection.Open();
SqlTransaction objTransaction = objDataAccess.GetConnection.BeginTransaction();
objTrans = objTransaction;
}
RoleManager objManager = new RoleManager();
RoleID=objManager.SaveRole(objDB, objTrans);
if (!flagTransation)
objTrans.Commit();
return RoleID;
}
catch (Exception ex)
{
if (!flagTransation)
objTrans.Rollback();
throw ex;
}
finally
{
objDataAccess.GetConnection.Close();
}
}
public void AddRole(RoleMaster rolemaster, List <MenuPermissionMapMaster> menupermissionList)
{
RoleDB Rdb = new RoleDB(ConStr);
Rdb.AddRole(rolemaster, menupermissionList);
}
public ActionResult AddRole(RoleDB _role)
{
AdminManage.SaveRoleinDB(_role.Name);
return(View());
}
private void btAddUser_Click(object sender, EventArgs e)
{
DataGridViewRow userCh = dtgAllUsers.CurrentRow;
if (userCh == null)
{
throw new ApplicationException("You must choose user");
}
DomainUser user = new DomainUser(userCh.Cells["Domain"].Value.ToString(),
userCh.Cells["Account"].Value.ToString(),
userCh.Cells["Name"].Value.ToString());
DataGridViewRow roleCh = dtgRoles.CurrentRow;
if (roleCh == null)
{
throw new ApplicationException("You must choose role");
}
RoleDB role = new RoleDB(roleCh.Cells["Role"].Value.ToString(), roleCh.Cells["Description"].Value.ToString());
if (!AddUser(user, role))
{
throw new ApplicationException("Can not add user to DB");
}
MessageBox.Show("User was successfully added", "Add user", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
public RoleMaster GetByRoleId(int roleId, int schoolid)
{
RoleDB Rdb = new RoleDB(ConStr);
return(Rdb.GetByRoleId(roleId, schoolid));
}
public RoleBusinessLogic()
{
objDB = new RoleDB();
}
protected void dsUser_Updated(object sender, ObjectDataSourceStatusEventArgs e)
{
Guid userId = (Guid)gvwUsers.SelectedDataKey.Value;
Label lblUserErrorMessage = (Label)fvwUser.FindControl("lblUserErrorMessage");
if (e.Exception != null)
{
lblUserErrorMessage.Text = "A database error has occurred.<br /><br />" +
e.Exception.Message;
if (e.Exception.InnerException != null)
{
lblUserErrorMessage.Text += "<br />Message: "
+ e.Exception.InnerException.Message;
}
e.ExceptionHandled = true;
return;
}
else if (e.AffectedRows == 0)
{
lblUserErrorMessage.Text = "Another user may have edited this user"
+ "<br />Please try again.";
return;
}
//makes sure the user isn't given a role he allready has
if (rBtnAdmin.Checked != isAdmin)
{
try
{
RoleDB.DeleteUserRole(userId, adminRoleId);
RoleDB.DeleteUserRole(userId, userRoleId);
}
catch (SqlException sqlEx)
{
lblRoleErrorMessage.Text += "A database error has occurred.<br /><br />" +
sqlEx.Message;
}
try
{
if (rBtnAdmin.Checked)
{
RoleDB.InsertUserRole(userId, adminRoleId);
}
else
{
RoleDB.InsertUserRole(userId, userRoleId);
}
}
catch (SqlException sqlEx)
{
lblRoleErrorMessage.Text += "A database error has occurred.<br /><br />" +
sqlEx.Message;
}
}
if (chkApproval.Checked != isApproved)
{
try
{
MembershipDB.updateUserApproval(userId, chkApproval.Checked);
}
catch (SqlException sqlEx)
{
lblRoleErrorMessage.Text += "A database error has occurred.<br /><br />" +
sqlEx.Message;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
adminRoleId = RoleDB.GetRoleId("Administrator");
userRoleId = RoleDB.GetRoleId("User");
}
