public List <ScreenAccess_VM> GetScreen(ScreenAccess_VM VM)
{
List <ScreenAccess_VM> query = new List <ScreenAccess_VM>();
using (var db = new WebPortalEntities())
{
query = db.Database.SqlQuery <ScreenAccess_VM>("exec GetScreen", new SqlParameter[] { }).ToList();
}
return(query);
}
public List <ScreenAccess_VM> GetScreenAccess(ScreenAccess_VM VM)
{
List <ScreenAccess_VM> query = new List <ScreenAccess_VM>();
using (var db = new WebPortalEntities())
{
//Get Opportunity Type of string type
query = db.Database.SqlQuery <ScreenAccess_VM>("exec GetScreenAccess @p_MenuCode,@p_UserRoleID,@p_ModuleCode",
new SqlParameter[] {
new SqlParameter("p_MenuCode", GetDBNULLString(VM.MenuCode)),
new SqlParameter("p_UserRoleID", GetDBNULL(VM.UserRoleID)),
new SqlParameter("p_ModuleCode", GetDBNULL(VM.CurrentModuleCode))
}).ToList();
}
return(query);
}
public Accesspermission_Wrapper GetMenuAndScreenData(ScreenAccess_VM Model)
{
Accesspermission_Wrapper query = new Accesspermission_Wrapper();
using (var db = new DBConnection())
{
DataSet ds = db.ExecuteDataSet("GetMenuAndScreenData", new SqlParameter[] {
new SqlParameter("@pUserRoleID", GetDBNULL(Model.UserRoleID))
});
query.MenuList = ConvertToList <MenuScreen_VM>(ds.Tables[0]);
query.ScreenActionList = ConvertToList <ScreenAction_VM>(ds.Tables[1]);
}
return(query);
}
public JsonResult GetScreenAccess(string MenuCode, short UserRoleID, string CurrentModuleCode = null)
{
if (UserRoleID > 0)
{
var obj = new ScreenAccess_VM()
{
MenuCode = MenuCode, UserRoleID = UserRoleID, CurrentModuleCode = CurrentModuleCode
};
var response = _RoleRepo.GetScreenAccess(obj);
return(Json(new JsonResponse("Success", "Success", response), JsonRequestBehavior.AllowGet));
}
return(Json(new JsonResponse("Error", "Invalid Request. Please reload the screen and try again.", null), JsonRequestBehavior.AllowGet));
}
