protected void btnUpdate_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null) { Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx"); }
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
ModuleRole moduleRole = new ModuleRole();
moduleRole = ModuleRoleManager.GetModuleRoleByID(Int32.Parse(Request.QueryString["moduleRoleID"]));
ModuleRole tempModuleRole = new ModuleRole();
tempModuleRole.ModuleRoleID = moduleRole.ModuleRoleID;
tempModuleRole.ModuleID = Int32.Parse(ddlModule.SelectedValue);
tempModuleRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
tempModuleRole.AddedDate = DateTime.Now;
tempModuleRole.AddedBy = loginID;
tempModuleRole.ModifyDate = DateTime.Now;
tempModuleRole.ModifyBy = loginID;
tempModuleRole.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = ModuleRoleManager.UpdateModuleRole(tempModuleRole);
Response.Redirect("AdminModuleRoleDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null)
{
Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx");
}
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
ModuleRole moduleRole = new ModuleRole();
moduleRole = ModuleRoleManager.GetModuleRoleByID(Int32.Parse(Request.QueryString["moduleRoleID"]));
ModuleRole tempModuleRole = new ModuleRole();
tempModuleRole.ModuleRoleID = moduleRole.ModuleRoleID;
tempModuleRole.ModuleID = Int32.Parse(ddlModule.SelectedValue);
tempModuleRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
tempModuleRole.AddedDate = DateTime.Now;
tempModuleRole.AddedBy = loginID;
tempModuleRole.ModifyDate = DateTime.Now;
tempModuleRole.ModifyBy = loginID;
tempModuleRole.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
bool result = ModuleRoleManager.UpdateModuleRole(tempModuleRole);
Response.Redirect("AdminModuleRoleDisplay.aspx");
}
public ApiResultObject <ModuleRole> Unlock(ModuleRole data)
{
ApiResultObject <ModuleRole> result = new ApiResultObject <ModuleRole>(null);
try
{
bool valid = true;
valid = valid && IsNotNull(param);
valid = valid && IsNotNull(data);
ModuleRole resultData = null;
if (valid && new AasModuleRoleLock(param).Unlock(data))
{
resultData = data;
}
result = this.PackResult(resultData);
this.FailLog(result.Success, data, result.Data);
}
catch (Exception ex)
{
LogSystem.Error(ex);
param.HasException = true;
}
return(result);
}
public ModuleRole GetById(long id, AasModuleRoleSO search)
{
ModuleRole result = null;
try
{
bool valid = true;
valid = valid && IsGreaterThanZero(id);
if (valid)
{
using (var ctx = new Base.AppContext())
{
var query = ctx.ModuleRoles.AsQueryable().Where(p => p.Id == id);
if (search.listModuleRoleExpression != null && search.listModuleRoleExpression.Count > 0)
{
foreach (var item in search.listModuleRoleExpression)
{
query = query.Where(item);
}
}
result = query.SingleOrDefault();
}
}
}
catch (Exception ex)
{
Logging(LogUtil.TraceData("id", id) + LogUtil.TraceData("search", search), LogType.Error);
LogSystem.Error(ex);
result = null;
}
return(result);
}
internal bool VerifyRequireField(ModuleRole data)
{
bool valid = true;
try
{
if (data == null)
{
throw new ArgumentNullException("data");
}
}
catch (ArgumentNullException ex)
{
BugUtil.SetBugCode(param, LibraryBug.Bug.Enum.Common__ThieuThongTinBatBuoc);
LogSystem.Error(ex);
valid = false;
}
catch (Exception ex)
{
LogSystem.Error(ex);
valid = false;
param.HasException = true;
}
return(valid);
}
public ApiResultObject <bool> Delete(ModuleRole data)
{
ApiResultObject <bool> result = new ApiResultObject <bool>(false);
try
{
bool valid = true;
valid = valid && IsNotNull(param);
valid = valid && IsNotNull(data);
bool resultData = false;
if (valid)
{
resultData = new AasModuleRoleTruncate(param).Truncate(data);
}
result = this.PackResult(resultData);
this.FailLog(result.Success, data, result.Data);
}
catch (Exception ex)
{
LogSystem.Error(ex);
param.HasException = true;
}
return(result);
}
internal bool Create(ModuleRole data)
{
bool result = false;
try
{
bool valid = true;
AasModuleRoleCheck checker = new AasModuleRoleCheck(param);
valid = valid && checker.VerifyRequireField(data);
if (valid)
{
if (!DAOWorker.AasModuleRoleDAO.Create(data))
{
BugUtil.SetBugCode(param, LibraryBug.Bug.Enum.AasModuleRole_ThemMoiThatBai);
throw new Exception("Them moi thong tin AasModuleRole that bai." + LogUtil.TraceData("data", data));
}
this.recentAasModuleRoles.Add(data);
result = true;
}
}
catch (Exception ex)
{
LogSystem.Error(ex);
param.HasException = true;
result = false;
}
return(result);
}
internal bool Update(ModuleRole data)
{
bool result = false;
try
{
bool valid = true;
AasModuleRoleCheck checker = new AasModuleRoleCheck(param);
valid = valid && checker.VerifyRequireField(data);
ModuleRole raw = null;
valid = valid && checker.VerifyId(data.Id, ref raw);
valid = valid && checker.IsUnLock(raw);
if (valid)
{
if (!DAOWorker.AasModuleRoleDAO.Update(data))
{
BugUtil.SetBugCode(param, LibraryBug.Bug.Enum.AasModuleRole_CapNhatThatBai);
throw new Exception("Cap nhat thong tin AasModuleRole that bai." + LogUtil.TraceData("data", data));
}
this.beforeUpdateAasModuleRoles.Add(raw);
result = true;
}
}
catch (Exception ex)
{
LogSystem.Error(ex);
param.HasException = true;
result = false;
}
return(result);
}
public static ModuleRole GetModuleRoleByID(int id)
{
ModuleRole moduleRole = new ModuleRole();
SqlModuleRoleProvider sqlModuleRoleProvider = new SqlModuleRoleProvider();
moduleRole = sqlModuleRoleProvider.GetModuleRoleByID(id);
return moduleRole;
}
internal bool Truncate(ModuleRole data)
{
bool result = false;
try
{
bool valid = true;
AasModuleRoleCheck checker = new AasModuleRoleCheck(param);
valid = valid && IsNotNull(data);
ModuleRole raw = null;
valid = valid && checker.VerifyId(data.Id, ref raw);
valid = valid && checker.IsUnLock(raw);
valid = valid && checker.CheckConstraint(data.Id);
if (valid)
{
result = DAOWorker.AasModuleRoleDAO.Truncate(data);
}
}
catch (Exception ex)
{
LogSystem.Error(ex);
param.HasException = true;
result = false;
}
return(result);
}
public void AddSubModulesToRole(long roleId, params string[] subModules)
{
var modRole = _context.Set <ModuleRole>().Where(x => x.RoleId == roleId);
foreach (var item in modRole)
{
var modrole = _context.Set <ModuleRole>()
.FirstOrDefault(x => x.RoleId == item.RoleId && x.SubModuleId == item.SubModuleId);
if (modrole != null)
{
_context.Set <ModuleRole>().Remove(modrole);
}
}
_context.SaveChanges();
foreach (var item in subModules)
{
var mod = _subModule.Query().Where(x => x.ActiveSubModule).FirstOrDefault(x => x.Name.Contains(item));
if (mod == null)
{
continue;
}
var newModrole = new ModuleRole
{
RoleId = roleId,
SubModuleId = mod.Id
};
_context.Set <ModuleRole>().Add(newModrole);
}
_context.SaveChanges();
UpdateClaimValueForRole();
}
public static ModuleRole GetModuleRoleByID(int id)
{
ModuleRole moduleRole = new ModuleRole();
SqlModuleRoleProvider sqlModuleRoleProvider = new SqlModuleRoleProvider();
moduleRole = sqlModuleRoleProvider.GetModuleRoleByID(id);
return(moduleRole);
}
public async Task <ActionResult> ModuleRole()
{
var noduleCodes = ModuleEnum.Account.ToSelectListEnumRaw();
long roleId = Convert.ToInt64(Request.Params["roleId"]);
var roleCt = _repository.GetRepository <Role>().Read(roleId);
roleCt.IsLevel1 = (bool)("on".Equals(Request.Params["IsLevel1"]) ? true : false);
roleCt.IsLevel2 = (bool)("on".Equals(Request.Params["IsLevel2"]) ? true : false);
roleCt.IsLevel3 = (bool)("on".Equals(Request.Params["IsLevel3"]) ? true : false);
_repository.GetRepository <Role>().Update(roleCt, AccountId);
var moduleRoles = noduleCodes.Select(item => new ModuleRole()
{
RoleId = roleId,
Read = (byte?)("on".Equals(Request.Params[item.Value + "_Read"]) ? 1 : 0),
Create = (byte?)("on".Equals(Request.Params[item.Value + "_Create"]) ? 1 : 0),
Update = (byte?)("on".Equals(Request.Params[item.Value + "_Update"]) ? 1 : 0),
Delete = (byte?)("on".Equals(Request.Params[item.Value + "_Delete"]) ? 1 : 0),
Verify = (byte?)("on".Equals(Request.Params[item.Value + "_Verify"]) ? 1 : 0),
//Publish = (byte?)("on".Equals(Request.Params[item.Value + "_Publish"]) ? 1 : 0),
ModuleCode = item.Value
}).ToList();
if (moduleRoles != null && moduleRoles.Any())
{
foreach (var item in moduleRoles)
{
ModuleRole moduleRole = await _repository.GetRepository <ModuleRole>().ReadAsync(o => o.RoleId == roleId && o.ModuleCode == item.ModuleCode);
if (moduleRole != null)
{
moduleRole.Read = item.Read;
moduleRole.Create = item.Create;
moduleRole.Update = item.Update;
moduleRole.Delete = item.Delete;
moduleRole.Verify = item.Verify;
//moduleRole.Publish = item.Publish;
await _repository.GetRepository <ModuleRole>().UpdateAsync(moduleRole, AccountId);
}
else
{
await _repository.GetRepository <ModuleRole>().CreateAsync(item, AccountId);
}
}
}
var accountRoles = _repository.GetRepository <AccountRole>().GetAll(o => o.AccountId == AccountId).ToList();
var moduleRoles1 = _repository.GetRepository <ModuleRole>().GetAll().ToList();
CacheFactory _cacheFactory = new CacheFactory();
_cacheFactory.SaveCache("AccountRoles_" + AccountId, accountRoles);
_cacheFactory.SaveCache("ModuleRoles", moduleRoles1);
TempData["Success"] = "Đã ghi nhận thành công!";
return(RedirectToRoute("RoleModuleRole", new { id = roleId }));
}
public ModuleRoleEntity(ModuleRole ModuleRole, params object[] args) :base(ModuleRole)
{
foreach(object arg in args)
{
if (arg is Module Module)
ModuleEntity = new ModuleEntity(Module);
if (arg is Role Role)
RoleEntity = new RoleEntity(Role);
}
}
//复权
public Dictionary <string, object> CreateModuleOperate()
{
var context = (HttpContextBase)Request.Properties["MS_HttpContext"];
var request = context.Request;
string operate = request.Form["operate"];
string roleid = request.Form["roleid"];
OpeateModuleView model = operate.JsonToEntity <OpeateModuleView>();
IDatabase database = DataFactory.Database();
DbTransaction isOpenTrans = database.BeginTrans();
try
{
StringBuilder sbModuleOperateRole = new StringBuilder("delete ModuleOperateRole where RoleId=@RoleId");
SqlParameter[] par = { new SqlParameter("@RoleId", SqlDbType.Int) };
par[0].Value = int.Parse(roleid);
int newid = database.ExecuteBySql(sbModuleOperateRole, par, isOpenTrans);
StringBuilder sbModuleRole = new StringBuilder("delete ModuleRole where RoleId=@RoleId");
int newid1 = database.ExecuteBySql(sbModuleRole, par, isOpenTrans);
foreach (var item in model.ModuleList)
{
if (item.ischecked)
{
ModuleRole moduleRole = new ModuleRole();
moduleRole.RoleId = int.Parse(roleid);
moduleRole.ModuleId = item.ModuleId;
database.Insert(moduleRole, isOpenTrans);
foreach (var item1 in item.List)
{
if (item1.IsCheck)
{
ModuleOperateRole moduleOperateRole = new ModuleOperateRole();
moduleOperateRole.RoleId = int.Parse(roleid);
moduleOperateRole.ModuleOperateId = item1.OperateId;
database.Insert(moduleOperateRole, isOpenTrans);
}
}
}
}
database.Commit();
return(new Dictionary <string, object>
{
{ "code", "1" }
});
}
catch (Exception)
{
database.Rollback();
return(new Dictionary <string, object>
{
{ "code", "0" }
});
}
}
public async Task <ActionResult> Init(string key)
{
if (key != "ghost7it")
{
return(RedirectToAction("Index", "Login"));
}
var account = new Account()
{
Name = "Administrator",
Password = StringHelper.StringToMd5(StringHelper.StringToMd5("eBtech!23").ToLower()),
Email = "*****@*****.**",
CreateDate = DateTime.Now,
IsManageAccount = true,
IsNormalAccount = false,
PhoneNumber = "0987.6996.87"
};
await _repository.GetRepository <Account>().CreateAsync(account, 0);
var oganization = new Organization()
{
Name = "eBtech Team",
IsSystemOwner = true,
IsApproved = true
};
await _repository.GetRepository <Organization>().CreateAsync(oganization, 0);
var role = new Role()
{
Name = "Quản trị hệ thống"
};
await _repository.GetRepository <Role>().CreateAsync(role, 0);
var accountRole = new AccountRole()
{
AccountId = 1,
RoleId = 1
};
await _repository.GetRepository <AccountRole>().CreateAsync(accountRole, 0);
var moduleRole = new ModuleRole()
{
RoleId = 1,
ModuleCode = "Account",
Create = 1,
Read = 1,
Update = 1,
Delete = 1
};
await _repository.GetRepository <ModuleRole>().CreateAsync(moduleRole, 0);
return(RedirectToAction("Index", "Login"));
}
private void showModuleRoleData()
{
ModuleRole moduleRole = new ModuleRole();
moduleRole = ModuleRoleManager.GetModuleRoleByID(Int32.Parse(Request.QueryString["moduleRoleID"]));
ddlModule.SelectedValue = moduleRole.ModuleID.ToString();
ddlRole.SelectedValue = moduleRole.RoleID.ToString();
txtAddedBy.Text = moduleRole.AddedBy;
txtModifyDate.Text = moduleRole.ModifyDate.ToString("dd MMM yyyy hh:mm tt");
txtModifyBy.Text = moduleRole.ModifyBy;
ddlRowStatus.SelectedValue = moduleRole.RowStatusID.ToString();
}
public bool Update(ModuleRole data)
{
bool result = false;
try
{
result = UpdateWorker.Update(data);
}
catch (Exception ex)
{
LogSystem.Error(ex);
result = false;
}
return(result);
}
public ModuleRole GetById(long id, AasModuleRoleSO search)
{
ModuleRole result = null;
try
{
result = GetWorker.GetById(id, search);
}
catch (Exception ex)
{
LogSystem.Error(ex);
result = null;
}
return(result);
}
public ModuleRole GetById(long id)
{
ModuleRole result = null;
try
{
result = new ModuleRoleGet(param).GetById(id);
}
catch (Exception ex)
{
LogSystem.Error(ex);
param.HasException = true;
result = null;
}
return(result);
}
public bool UpdateModuleRole(ModuleRole moduleRole)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_UpdateModuleRole", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ModuleRoleID", SqlDbType.Int).Value = moduleRole.ModuleRoleID;
cmd.Parameters.Add("@ModuleID", SqlDbType.Int).Value = moduleRole.ModuleID;
cmd.Parameters.Add("@RoleID", SqlDbType.Int).Value = moduleRole.RoleID;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = moduleRole.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = moduleRole.AddedBy;
cmd.Parameters.Add("@ModifyDate", SqlDbType.DateTime).Value = moduleRole.ModifyDate;
cmd.Parameters.Add("@ModifyBy", SqlDbType.NVarChar).Value = moduleRole.ModifyBy;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = moduleRole.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
/// <summary>
/// Kiem tra du lieu co o trang thai unlock (su dung doi tuong)
/// </summary>
/// <param name="id"></param>
/// <param name="data"></param>
/// <returns></returns>
internal bool IsUnLock(ModuleRole data)
{
bool valid = true;
try
{
if (Constant.IS_TRUE != data.IsActive)
{
valid = false;
MessageUtil.SetMessage(param, LibraryMessage.Message.Enum.Common__DuLieuDangBiKhoa);
}
}
catch (Exception ex)
{
LogSystem.Error(ex);
valid = false;
param.HasException = true;
}
return(valid);
}
/// <summary>
/// Kiem tra su ton tai cua id dong thoi lay ve du lieu
/// </summary>
/// <param name="id"></param>
/// <param name="data"></param>
/// <returns></returns>
internal bool VerifyId(long id, ref ModuleRole data)
{
bool valid = true;
try
{
data = new ModuleRoleManagerGet().GetById(id);
if (data == null)
{
BugUtil.SetBugCode(param, LibraryBug.Bug.Enum.Common__KXDDDuLieuCanXuLy);
Logging("Id invalid." + LogUtil.TraceData("id", id), LogType.Error);
valid = false;
}
}
catch (Exception ex)
{
LogSystem.Error(ex);
valid = false;
param.HasException = true;
}
return(valid);
}
public ModuleRole GetModuleRoleFromReader(IDataReader reader)
{
try
{
ModuleRole moduleRole = new ModuleRole
(
(int)reader["ModuleRoleID"],
(int)reader["ModuleID"],
(int)reader["RoleID"],
(DateTime)reader["AddedDate"],
reader["AddedBy"].ToString(),
(DateTime)reader["ModifyDate"],
reader["ModifyBy"].ToString(),
(int)reader["RowStatusID"]
);
return(moduleRole);
}
catch (Exception ex)
{
return(null);
}
}
internal bool Unlock(ModuleRole data)
{
bool result = false;
try
{
bool valid = true;
ModuleRole raw = null;
valid = valid && new AasModuleRoleCheck().VerifyId(data.Id, ref raw);
if (valid && raw != null)
{
if (raw.IsActive == Constant.IS_TRUE)
{
MessageUtil.SetMessage(param, LibraryMessage.Message.Enum.Common__DuLieuDangMoKhoa);
throw new Exception("Du lieu dang duoc mo khoa");
}
raw.IsActive = Constant.IS_TRUE;
result = DAOWorker.AasModuleRoleDAO.Update(raw);
if (result)
{
data.IsActive = raw.IsActive;
}
}
else
{
BugUtil.SetBugCode(param, LibraryBug.Bug.Enum.Common__KXDDDuLieuCanXuLy);
}
}
catch (Exception ex)
{
LogSystem.Error(ex);
param.HasException = true;
result = false;
}
return(result);
}
public ModuleRole GetModuleRoleFromReader(IDataReader reader)
{
try
{
ModuleRole moduleRole = new ModuleRole
(
(int)reader["ModuleRoleID"],
(int)reader["ModuleID"],
(int)reader["RoleID"],
(DateTime)reader["AddedDate"],
reader["AddedBy"].ToString(),
(DateTime)reader["ModifyDate"],
reader["ModifyBy"].ToString(),
(int)reader["RowStatusID"]
);
return moduleRole;
}
catch(Exception ex)
{
return null;
}
}
private void showModuleRoleData()
{
ModuleRole moduleRole = new ModuleRole();
moduleRole = ModuleRoleManager.GetModuleRoleByID(Int32.Parse(Request.QueryString["moduleRoleID"]));
ddlModule.SelectedValue = moduleRole.ModuleID.ToString();
ddlRole.SelectedValue = moduleRole.RoleID.ToString();
txtAddedBy.Text = moduleRole.AddedBy;
txtModifyDate.Text = moduleRole.ModifyDate.ToString("dd MMM yyyy hh:mm tt");
txtModifyBy.Text = moduleRole.ModifyBy;
ddlRowStatus.SelectedValue = moduleRole.RowStatusID.ToString();
}
public static int InsertModuleRole(ModuleRole moduleRole)
{
SqlModuleRoleProvider sqlModuleRoleProvider = new SqlModuleRoleProvider();
return sqlModuleRoleProvider.InsertModuleRole(moduleRole);
}
public static bool UpdateModuleRole(ModuleRole moduleRole)
{
SqlModuleRoleProvider sqlModuleRoleProvider = new SqlModuleRoleProvider();
return sqlModuleRoleProvider.UpdateModuleRole(moduleRole);
}
public bool Truncate(ModuleRole data)
{
return(IsNotNull(data) && IsGreaterThanZero(data.Id) && bridgeDAO.Truncate(data.Id));
}
public bool Create(ModuleRole data)
{
return(IsNotNull(data) && bridgeDAO.Create(data));
}
public static bool UpdateModuleRole(ModuleRole moduleRole)
{
SqlModuleRoleProvider sqlModuleRoleProvider = new SqlModuleRoleProvider();
return(sqlModuleRoleProvider.UpdateModuleRole(moduleRole));
}
public static int InsertModuleRole(ModuleRole moduleRole)
{
SqlModuleRoleProvider sqlModuleRoleProvider = new SqlModuleRoleProvider();
return(sqlModuleRoleProvider.InsertModuleRole(moduleRole));
}
public async Task <ActionResult> Init(string key)
{
if (!key.Equals("dung"))
{
return(RedirectToAction("Index", "Login"));
}
// account
if (_repository.GetRepository <Account>().Any(o => o.Id == 1))
{
return(RedirectToAction("Index", "Login"));
}
var account = new Account()
{
FullName = "Nguyễn Anh Dũng",
Password = StringHelper.stringToSHA512("123456").ToLower(),
Email = "*****@*****.**",
CreateDate = DateTime.Now,
IsManageAccount = true,
IsNormalAccount = false,
PhoneNumber = "0978132474"
};
await _repository.GetRepository <Account>().CreateAsync(account, 0);
// role
var role = new Role()
{
Name = "Quản trị hệ thống"
};
await _repository.GetRepository <Role>().CreateAsync(role, 1);
//gán quyền
var accountRole = new AccountRole()
{
AccountId = 1,
RoleId = 1
};
await _repository.GetRepository <AccountRole>().CreateAsync(accountRole, 1);
// app module quyền
var moduleRole = new ModuleRole()
{
RoleId = 1,
ModuleCode = "Account",
Create = 1,
Read = 1,
Update = 1,
Delete = 1
};
await _repository.GetRepository <ModuleRole>().CreateAsync(moduleRole, 1);
var moduleRole2 = new ModuleRole()
{
RoleId = 1,
ModuleCode = "Role",
Create = 1,
Read = 1,
Update = 1,
Delete = 1
};
await _repository.GetRepository <ModuleRole>().CreateAsync(moduleRole2, 1);
var moduleRole3 = new ModuleRole()
{
RoleId = 1,
ModuleCode = "DonVi",
Create = 1,
Read = 1,
Update = 1,
Delete = 1
};
await _repository.GetRepository <ModuleRole>().CreateAsync(moduleRole3, 1);
var si = new ModuleRole()
{
RoleId = 1,
ModuleCode = "SystemInformation",
Create = 1,
Read = 1,
Update = 1,
Delete = 1
};
await _repository.GetRepository <ModuleRole>().CreateAsync(si, 1);
return(RedirectToAction("Index", "Login"));
}
public bool UpdateModuleRole(ModuleRole moduleRole)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("Login_UpdateModuleRole", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ModuleRoleID", SqlDbType.Int).Value = moduleRole.ModuleRoleID;
cmd.Parameters.Add("@ModuleID", SqlDbType.Int).Value = moduleRole.ModuleID;
cmd.Parameters.Add("@RoleID", SqlDbType.Int).Value = moduleRole.RoleID;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = moduleRole.AddedDate;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = moduleRole.AddedBy;
cmd.Parameters.Add("@ModifyDate", SqlDbType.DateTime).Value = moduleRole.ModifyDate;
cmd.Parameters.Add("@ModifyBy", SqlDbType.NVarChar).Value = moduleRole.ModifyBy;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = moduleRole.RowStatusID;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
protected void btnRoleWisePageNMenuAccess_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null) { Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx"); }
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
RoleManager.DeleteModuleMenuPageButtonRole(int.Parse(ddlRole.SelectedValue));
int resutl = 0;
foreach (GridViewRow grModule in gvModule.Rows)
{
CheckBox chkSelect = (CheckBox)grModule.FindControl("chkSelect");
if (chkSelect.Checked)
{
ModuleRole moduleRole = new ModuleRole();
moduleRole.ModuleID = Int32.Parse(chkSelect.ToolTip);
moduleRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
moduleRole.AddedDate = DateTime.Now;
moduleRole.AddedBy = loginID;
moduleRole.ModifyDate = DateTime.Now;
moduleRole.ModifyBy = loginID;
moduleRole.RowStatusID = 1;
resutl = ModuleRoleManager.InsertModuleRole(moduleRole);
GridView gvPagenMenu = (GridView)grModule.FindControl("gvPagenMenu");
foreach (GridViewRow grPageNMenu in gvPagenMenu.Rows)
{
CheckBox chkSelectPageNMenu = (CheckBox)grPageNMenu.FindControl("chkSelectPageNMenu");
if (chkSelectPageNMenu.Checked)
{
PageRole pageRole = new PageRole();
pageRole.PageID = Int32.Parse(chkSelectPageNMenu.ToolTip);
pageRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
pageRole.AddedDate = DateTime.Now;
pageRole.AddedBy = loginID;
pageRole.ModifyDate = DateTime.Now;
pageRole.ModifyBy = loginID;
pageRole.RowStatusID = 1;
resutl = PageRoleManager.InsertPageRole(pageRole);
if (chkSelectPageNMenu.ValidationGroup != "0")
{
MenuRole menuRole = new MenuRole();
menuRole.MenuID = Int32.Parse(chkSelectPageNMenu.ValidationGroup);
menuRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
menuRole.AddedDate = DateTime.Now;
menuRole.AddedBy = loginID;
menuRole.ModifyDate = DateTime.Now;
menuRole.ModifyBy = loginID;
menuRole.RowStatusID = 1;
resutl = MenuRoleManager.InsertMenuRole(menuRole);
}
DataList dlButton = (DataList)grPageNMenu.FindControl("dlButton");
foreach (DataListItem dliButton in dlButton.Items)
{
CheckBox chkSelectButton = (CheckBox)dliButton.FindControl("chkSelectButton");
if (chkSelectButton.Checked)
{
ButtonRole buttonRole = new ButtonRole();
buttonRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
buttonRole.ButtonID = Int32.Parse(chkSelectButton.ToolTip);
buttonRole.AddedDate = DateTime.Now;
buttonRole.AddedBy = loginID;
buttonRole.ModifyDate = DateTime.Now;
buttonRole.ModifyBy = loginID;
buttonRole.RowStatusID = 1;
resutl = ButtonRoleManager.InsertButtonRole(buttonRole);
}
}
}
}
}
{
GridView gvPagenMenu = (GridView)grModule.FindControl("gvPagenMenu");
foreach (GridViewRow grPageNMenu in gvPagenMenu.Rows)
{
CheckBox chkSelectPageNMenu = (CheckBox)grPageNMenu.FindControl("chkSelectPageNMenu");
if (!chkSelectPageNMenu.Checked)
{
DataList dlButton = (DataList)grPageNMenu.FindControl("dlButton");
foreach (DataListItem dliButton in dlButton.Items)
{
CheckBox chkSelectButton = (CheckBox)dliButton.FindControl("chkSelectButton");
if (chkSelectButton.Checked)
{
ButtonRole buttonRole = new ButtonRole();
buttonRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
buttonRole.ButtonID = Int32.Parse(chkSelectButton.ToolTip);
buttonRole.AddedDate = DateTime.Now;
buttonRole.AddedBy = loginID;
buttonRole.ModifyDate = DateTime.Now;
buttonRole.ModifyBy = loginID;
buttonRole.RowStatusID = 1;
resutl = ButtonRoleManager.InsertButtonRole(buttonRole);
}
}
}
}
}
}
Response.Redirect(HttpContext.Current.Request.Url.AbsoluteUri);
}
protected void btnRoleWisePageNMenuAccess_Click(object sender, EventArgs e)
{
string loginID = "1";
try
{
if (Session["Login"] == null)
{
Session["PreviousPage"] = HttpContext.Current.Request.Url.AbsoluteUri; Response.Redirect("../LoginPage.aspx");
}
loginID = ((Login)Session["Login"]).LoginID.ToString();
}
catch (Exception ex)
{ }
RoleManager.DeleteModuleMenuPageButtonRole(int.Parse(ddlRole.SelectedValue));
int resutl = 0;
foreach (GridViewRow grModule in gvModule.Rows)
{
CheckBox chkSelect = (CheckBox)grModule.FindControl("chkSelect");
if (chkSelect.Checked)
{
ModuleRole moduleRole = new ModuleRole();
moduleRole.ModuleID = Int32.Parse(chkSelect.ToolTip);
moduleRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
moduleRole.AddedDate = DateTime.Now;
moduleRole.AddedBy = loginID;
moduleRole.ModifyDate = DateTime.Now;
moduleRole.ModifyBy = loginID;
moduleRole.RowStatusID = 1;
resutl = ModuleRoleManager.InsertModuleRole(moduleRole);
GridView gvPagenMenu = (GridView)grModule.FindControl("gvPagenMenu");
foreach (GridViewRow grPageNMenu in gvPagenMenu.Rows)
{
CheckBox chkSelectPageNMenu = (CheckBox)grPageNMenu.FindControl("chkSelectPageNMenu");
if (chkSelectPageNMenu.Checked)
{
PageRole pageRole = new PageRole();
pageRole.PageID = Int32.Parse(chkSelectPageNMenu.ToolTip);
pageRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
pageRole.AddedDate = DateTime.Now;
pageRole.AddedBy = loginID;
pageRole.ModifyDate = DateTime.Now;
pageRole.ModifyBy = loginID;
pageRole.RowStatusID = 1;
resutl = PageRoleManager.InsertPageRole(pageRole);
if (chkSelectPageNMenu.ValidationGroup != "0")
{
MenuRole menuRole = new MenuRole();
menuRole.MenuID = Int32.Parse(chkSelectPageNMenu.ValidationGroup);
menuRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
menuRole.AddedDate = DateTime.Now;
menuRole.AddedBy = loginID;
menuRole.ModifyDate = DateTime.Now;
menuRole.ModifyBy = loginID;
menuRole.RowStatusID = 1;
resutl = MenuRoleManager.InsertMenuRole(menuRole);
}
DataList dlButton = (DataList)grPageNMenu.FindControl("dlButton");
foreach (DataListItem dliButton in dlButton.Items)
{
CheckBox chkSelectButton = (CheckBox)dliButton.FindControl("chkSelectButton");
if (chkSelectButton.Checked)
{
ButtonRole buttonRole = new ButtonRole();
buttonRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
buttonRole.ButtonID = Int32.Parse(chkSelectButton.ToolTip);
buttonRole.AddedDate = DateTime.Now;
buttonRole.AddedBy = loginID;
buttonRole.ModifyDate = DateTime.Now;
buttonRole.ModifyBy = loginID;
buttonRole.RowStatusID = 1;
resutl = ButtonRoleManager.InsertButtonRole(buttonRole);
}
}
}
}
}
{
GridView gvPagenMenu = (GridView)grModule.FindControl("gvPagenMenu");
foreach (GridViewRow grPageNMenu in gvPagenMenu.Rows)
{
CheckBox chkSelectPageNMenu = (CheckBox)grPageNMenu.FindControl("chkSelectPageNMenu");
if (!chkSelectPageNMenu.Checked)
{
DataList dlButton = (DataList)grPageNMenu.FindControl("dlButton");
foreach (DataListItem dliButton in dlButton.Items)
{
CheckBox chkSelectButton = (CheckBox)dliButton.FindControl("chkSelectButton");
if (chkSelectButton.Checked)
{
ButtonRole buttonRole = new ButtonRole();
buttonRole.RoleID = Int32.Parse(ddlRole.SelectedValue);
buttonRole.ButtonID = Int32.Parse(chkSelectButton.ToolTip);
buttonRole.AddedDate = DateTime.Now;
buttonRole.AddedBy = loginID;
buttonRole.ModifyDate = DateTime.Now;
buttonRole.ModifyBy = loginID;
buttonRole.RowStatusID = 1;
resutl = ButtonRoleManager.InsertButtonRole(buttonRole);
}
}
}
}
}
}
Response.Redirect(HttpContext.Current.Request.Url.AbsoluteUri);
}
