public ActionResult approval_rules()
{
try
{
Page_Permission_Detail info = new Page_Permission_Detail();
info = dblayer.Get_Page_UserPermission(Convert.ToInt32(Session["emp_id"].ToString()), 35);
ViewBag.event_permission = info;
List <SelectListItem> li_level = new List <SelectListItem>();
ViewBag.level = li_level;
}
catch (Exception ex)
{
}
return(View());
}
public ActionResult Hierarchy()
{
try
{
Page_Permission_Detail info = new Page_Permission_Detail();
info = dblayer.Get_Page_UserPermission(Convert.ToInt32(Session["emp_id"].ToString()), 43);
ViewBag.event_permission = info;
List <SelectListItem> li_emp = new List <SelectListItem>();
ViewBag.employee = li_emp;
}
catch (Exception)
{
throw;
}
return(View());
}
public Page_Permission_Detail Get_Page_UserPermission(int emp_id, int page_id)
{
Page_Permission_Detail info = new Page_Permission_Detail();
info.View = 0;
info.Update = 0;
info.Create = 0;
info.Import = 0;
info.Export = 0;
connection();
SqlCommand cmd = new SqlCommand("PRC_GetUserPermission", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Emp_ID", emp_id);
cmd.Parameters.AddWithValue("@PageID", page_id);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
info.emp_id = Convert.ToInt32(dr["EMP_ID"].ToString());
info.page_id = Convert.ToInt32(dr["PAGE_ID"].ToString());
if (dr["PERMISSION_NAME"].ToString().Trim() == "View")
{
info.View = 1;
}
if (dr["PERMISSION_NAME"].ToString().Trim() == "Update")
{
info.Update = 1;
}
if (dr["PERMISSION_NAME"].ToString().Trim() == "Create")
{
info.Create = 1;
}
if (dr["PERMISSION_NAME"].ToString().Trim() == "Import")
{
info.Import = 1;
}
if (dr["PERMISSION_NAME"].ToString().Trim() == "Export")
{
info.Export = 1;
}
}
con.Close();
return(info);
}
