protected void GetAllSecurables()
{
var securablesAll = new RoleRightsBO()
.GetSecurableItemsList();
Application["AppSecurables"] = securablesAll;
}
public ActionResult RoleRights(string Role = "")
{
List <LayoutMenuRights> lstMenu = new List <LayoutMenuRights>();
if (!string.IsNullOrWhiteSpace(Role))
{
var securablesAll = (List <Securables>)System.Web.HttpContext.Current.Application["AppSecurables"];
var securables = new RoleRightsBO().GetSecurableItemsListByRoleCode(Role);
var menuItems = securablesAll.Where(x => x.ActionType == "TopMenu")
.Select(x => new { securableItem = x.SecurableItem, Icon = x.Icon, GroupId = x.GroupID }).Distinct().ToList();
for (var i = 0; i < menuItems.Count; i++)
{
LayoutMenuRights item = new LayoutMenuRights();
item.MenuName = menuItems[i].securableItem;
item.Icon = menuItems[i].Icon;
item.securablesLst = securablesAll.Where(x => x.GroupID == menuItems[i].securableItem && (x.ActionType == "Menu"))
.Select(x => new SecurablesRights
{
SecurableItem = x.SecurableItem,
GroupID = x.GroupID,
Description = x.Description,
ActionType = x.ActionType,
Link = x.Link,
Icon = x.Icon,
hasRight = (securables.Where(j => j.SecurableItem == x.SecurableItem).Count() > 0),
Sequence = x.Sequence,
ParentSequence = x.ParentSequence,
ActionMenus = securablesAll.Where(y => y.GroupID == menuItems[i].securableItem && (y.ActionType == "Action") && y.ParentSequence == x.Sequence)
.Select(y => new SecurablesRights
{
SecurableItem = y.SecurableItem,
GroupID = y.GroupID,
Description = y.Description,
ActionType = y.ActionType,
Link = y.Link,
Icon = y.Icon,
hasRight = (securables.Where(jk => jk.SecurableItem == y.SecurableItem).Count() > 0),
Sequence = y.Sequence,
ParentSequence = y.ParentSequence
}).ToList <SecurablesRights>()
}).OrderBy(x => x.ParentSequence).ToList <SecurablesRights>();
if (item.securablesLst.Count > 0)
{
lstMenu.Add(item);
}
}
ViewBag.RoleCode = Role;
}
return(View("RoleRights", lstMenu));
}
/// <summary>
/// To Insert details of RoleRights in tbl_RoleRights_T table
/// Created By : Darshan, 26/Mar/2014
/// Modified By :
/// </summary>
/// <param name="objRoleRightsBO"></param>
/// <returns></returns>
public ApplicationResult RoleRights_Insert(RoleRightsBO objRoleRightsBO)
{
try
{
pSqlParameter = new SqlParameter[4];
pSqlParameter[0] = new SqlParameter("@RoleID", SqlDbType.Int);
pSqlParameter[0].Direction = ParameterDirection.Input;
pSqlParameter[0].Value = objRoleRightsBO.RoleID;
pSqlParameter[1] = new SqlParameter("@TrustMID", SqlDbType.Int);
pSqlParameter[1].Direction = ParameterDirection.Input;
pSqlParameter[1].Value = objRoleRightsBO.TrustMID;
pSqlParameter[2] = new SqlParameter("@SchoolMID", SqlDbType.Int);
pSqlParameter[2].Direction = ParameterDirection.Input;
pSqlParameter[2].Value = objRoleRightsBO.SchoolMID;
pSqlParameter[3] = new SqlParameter("@ScreenID", SqlDbType.Int);
pSqlParameter[3].Direction = ParameterDirection.Input;
pSqlParameter[3].Value = objRoleRightsBO.ScreenID;
sSql = "usp_tbl_RoleRights_T_Insert";
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
{
objRoleRightsBO = null;
}
}
public ActionResult SaveRights(List <RoleRightsMenu> right)
{
try
{
var lstRoleRights = new List <RoleRights>();
right.Where(r => r.hasRight == true)
.ToList()
.ForEach(r => lstRoleRights.Add(new RoleRights {
RoleCode = r.RoleCode, SecurableItem = r.SecurableItem
}));
var result = new RoleRightsBO().SaveRoleRights(lstRoleRights);
}
catch (Exception ex)
{
ModelState.AddModelError("Error", ex.Message);
}
return(RedirectToAction("RoleRights"));
}
public ActionResult Login(LoginViewModel model, string returnUrl)
{
model.CompanyCode = "EZY";
var BranchDetails = new BranchBO().GetList().Where(x => x.BranchID == model.BranchID).ToList();
string BranchName = BranchDetails.Select(x => x.BranchName).FirstOrDefault();
//if (!string.IsNullOrEmpty(Request.QueryString["companyCode"]))
//{
// var companyCode = UrlEncryptionHelper.Decrypt(Request.QueryString["companyCode"]);
// var branchList = new BranchBO().GetList().Where(x => x.CompanyCode == companyCode).ToList();
// model.BranchList = new SelectList(branchList, "BranchID", "BranchName");
// var compist = new CompanyBO().GetList();
// for (var i = 0; i < compist.Count; i++)
// {
// compist[i].CompanyCode = UrlEncryptionHelper.Encrypt(compist[i].CompanyCode);
// }
// model.CompaniesList = new SelectList(compist, "CompanyCode", "CompanyName");
// return View("Index", model);
//}
if (!ModelState.IsValid)
{
return(RedirectToAction("Index"));
}
var lstUsers = new UsersBO().GetList();
var currentUser = lstUsers.Where(
ur => ur.UserID.ToLower() == model.UserID.ToLower() &&
ur.Password.ToLower() == model.Password.ToLower()).FirstOrDefault();
var userBranch = new UserBranchBO().GetList(model.UserID)
.Where(x => x.BranchID == model.BranchID)
.FirstOrDefault();
if (currentUser != null && userBranch != null)
{
FormsAuthentication.SetAuthCookie(currentUser.UserID, false);
var _CompanyId = model.CompanyCode;
var SsnObj = new SessionObject {
UserID = currentUser.UserID,
UserName = currentUser.UserName,
Email = currentUser.Email,
RoleCode = currentUser.RoleCode,
BranchId = model.BranchID,
BranchName = BranchName,
CompanyId = _CompanyId,
CompanyName = new CompanyBO().GetList().Where(x => x.CompanyCode == _CompanyId).FirstOrDefault().CompanyName
};
USER_OBJECT = SsnObj;
USER_SECURABLES = new RoleRightsBO().GetSecurableItemsListByRoleCode(SsnObj.RoleCode);
Session["UserID"] = currentUser.UserID;
Session["UserName"] = currentUser.UserName;
Session["BranchId"] = model.BranchID;
if (Url.IsLocalUrl(returnUrl) && returnUrl.Length > 1 && returnUrl.StartsWith("/") &&
!returnUrl.StartsWith("//") && !returnUrl.StartsWith("/\\"))
{
return(Redirect(returnUrl));
}
else
{
return(RedirectToAction("Education", "Home"));
}
}
else
{
//ModelState.AddModelError("", "The user name or password provided is incorrect.");
ViewBag.ErrMsg = "The user name or password provided is incorrect.";
LoginViewModel modelObj = new LoginViewModel();
var compist = new CompanyBO().GetList();
for (var i = 0; i < compist.Count; i++)
{
compist[i].CompanyCode = UrlEncryptionHelper.Encrypt(compist[i].CompanyCode);
}
modelObj.CompaniesList = new SelectList(compist, "CompanyCode", "CompanyName");
var companyCode = "EZY";
var branchList = new BranchBO().GetList().Where(x => x.CompanyCode == companyCode).ToList();
modelObj.BranchList = new SelectList(branchList, "BranchID", "BranchName").ToList();
return(View("Index", modelObj));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
RoleRightsBO objRoleRightsBO = new RoleRightsBO();
RoleRightsBL objRoleRightsBL = new RoleRightsBL();
ApplicationResult objResultsInsert = new ApplicationResult();
ApplicationResult objResultsSelect = new ApplicationResult();
ApplicationResult objResultsDelete = new ApplicationResult();
DataTable dtRoleRights = new DataTable();
int j = 0;
CheckBox chk;
for (int i = 0; i < gvSelectRights.Rows.Count; i++)
{
objResultsSelect = objRoleRightsBL.RoleRights_T_Select(Convert.ToInt32(ddlRole.SelectedValue), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), 0, Convert.ToInt32(gvSelectRights.Rows[i].Cells[0].Text));
chk = (CheckBox)gvSelectRights.Rows[i].Cells[2].FindControl("chkRights");
if (chk.Checked == true)
{
if (rblSelect.SelectedValue == "0")
{
if (objResultsSelect != null)
{
if (objResultsSelect.resultDT.Rows.Count > 0)
{
}
else
{
objRoleRightsBO.RoleID = Convert.ToInt32(ddlRole.SelectedValue);
objRoleRightsBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objRoleRightsBO.SchoolMID = 0;
objRoleRightsBO.ScreenID = Convert.ToInt32(gvSelectRights.Rows[i].Cells[0].Text);
objResultsInsert = objRoleRightsBL.RoleRights_Insert(objRoleRightsBO);
if (Convert.ToInt32(gvSelectRights.Rows[i].Cells[1].Text) == 1)
{
ApplicationResult objResults = new ApplicationResult();
SchoolBL objSchool = new SchoolBL();
objResults = objSchool.School_SelectAll(Convert.ToInt32(Session[ApplicationSession.TRUSTID]));
if (objResults != null)
{
if (objResults.resultDT.Rows.Count > 0)
{
foreach (DataRow dt in objResults.resultDT.Rows)
{
objRoleRightsBO.RoleID = Convert.ToInt32(ddlRole.SelectedValue);
objRoleRightsBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objRoleRightsBO.SchoolMID = Convert.ToInt32(dt[0].ToString());
objRoleRightsBO.ScreenID = Convert.ToInt32(Convert.ToInt32(gvSelectRights.Rows[i].Cells[0].Text));
objResultsInsert = objRoleRightsBL.RoleRights_Insert(objRoleRightsBO);
}
}
}
}
}
}
}
else
{
objRoleRightsBO.RoleID = Convert.ToInt32(ddlRole.SelectedValue);
objRoleRightsBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
objRoleRightsBO.SchoolMID = Convert.ToInt32(ViewState["SchoolMID"].ToString());
objRoleRightsBO.ScreenID = Convert.ToInt32(Convert.ToInt32(gvSelectRights.Rows[i].Cells[0].Text));
objResultsInsert = objRoleRightsBL.RoleRights_Insert(objRoleRightsBO);
}
}
else
{
if (rblSelect.SelectedValue == "0")
{
dtRoleRights = objResultsSelect.resultDT;
if (objResultsSelect.resultDT.Rows.Count > 0)
{
objResultsDelete = objRoleRightsBL.RoleRights_Delete(Convert.ToInt32(ddlRole.SelectedValue), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), 0, Convert.ToInt32(gvSelectRights.Rows[i].Cells[0].Text));
}
}
else
{
objResultsDelete = objRoleRightsBL.RoleRights_Delete(Convert.ToInt32(ddlRole.SelectedValue), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(ViewState["SchoolMID"].ToString()), Convert.ToInt32(gvSelectRights.Rows[i].Cells[0].Text));
}
}
}
if (objResultsInsert.status == ApplicationResult.CommonStatusType.SUCCESS)
{
ClearAll();
BindScreen();
lblMsg.Visible = true;
lblMsg.Text = "Roles Applied Successfully";
}
//objResultsSelect = objRoleRightsBL.RoleRights_Select(Convert.ToInt32(ddlRole.SelectedValue), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(ViewState["SchoolMID"].ToString()));
//if (objResultsSelect != null)
//{
// dtRoleRights = objResultsSelect.resultDT;
// if (dtRoleRights.Rows.Count > 0)
// {
// // objResultsDelete = objRoleRightsBL.RoleRights_Delete(Convert.ToInt32(ddlRole.SelectedValue), Convert.ToInt32(Session[ApplicationSession.TRUSTID]), Convert.ToInt32(ViewState["SchoolMID"].ToString()));
// }
//}
//for (int i = 0; i < gvSelectRights.Rows.Count; i++)
//{
// chk = (CheckBox)gvSelectRights.Rows[i].Cells[2].FindControl("chkRights");
// if (chk.Checked == true)
// {
// objRoleRightsBO.RoleID = Convert.ToInt32(ddlRole.SelectedValue);
// objRoleRightsBO.TrustMID = Convert.ToInt32(Session[ApplicationSession.TRUSTID]);
// objRoleRightsBO.SchoolMID = Convert.ToInt32(ViewState["SchoolMID"].ToString());
// objRoleRightsBO.ScreenID = Convert.ToInt32(gvSelectRights.Rows[i].Cells[1].Text);
// objResultsInsert = objRoleRightsBL.RoleRights_Insert(objRoleRightsBO);
// }
//}
//
}
catch (Exception ex)
{
logger.Error("Error", ex);
ClientScript.RegisterStartupScript(typeof(Page), "MessagePopUp", "<script>alert('Oops! There is some technical Problem. Contact to your Administrator.');</script>");
}
}
