public static bool IsModuleViewAllowed(int atmsId, int userId, int moduleId) { bool isAllowed = false; //Admin and superUser has all the rights if (userId == 1) { return(true); } //Check module right foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.UserModuleRightCBE userModuleRight in userModuleRights) { if (userModuleRight.UserId == userId) { foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleActivityCBE moduleActivity in moduleActivities) { if (userModuleRight.ModuleActivityEntryId == moduleActivity.EntryId && moduleActivity.ModuleId == moduleId && moduleActivity.ActivityId == (int)VaaaN.MLFF.Libraries.CommonLibrary.Constants.Activity.View) { isAllowed = true; break; } } } if (isAllowed) { break; } } if (isAllowed) { //Check if there is any submodule if multiple submodule and there is no rights for at leat one submodule then module right should be denied VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection subModules = VaaaN.MLFF.Libraries.CommonLibrary.BLL.SubModuleBLL.GetAll(); ArrayList alSubModules = new ArrayList(); foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCBE subModule in subModules) { if (subModule.ModuleId == moduleId) { if (IsSubModuleViewAllowed(userId, subModule.SubModuleId)) { alSubModules.Add(subModule); } } } if (alSubModules.Count == 0) { isAllowed = false; } } return(isAllowed); }
public JsonResult GetAllReports() { VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection subModules = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection(); subModules = VaaaN.MLFF.Libraries.CommonLibrary.BLL.SubModuleBLL.GetByUserId(Convert.ToInt16(Session["LoggedUserId"]), 7); // only for report submodules List <SelectListItem> reports = new List <SelectListItem>(); foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCBE submodule in subModules) { reports.Add(new SelectListItem { Value = Convert.ToString(submodule.SubModuleId), Text = submodule.SubModuleName }); } return(Json(reports)); }
public static string NewMenu(int userId) { StringBuilder sb = new StringBuilder(); //string path = Server.MapPath(""); try { VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleCollection modules = null; // Get all modules which are authorized to this user. if (userId == 1)// super admin { modules = VaaaN.MLFF.Libraries.CommonLibrary.DAL.ModuleDAL.GetAll(); } else { modules = VaaaN.MLFF.Libraries.CommonLibrary.DAL.ModuleDAL.GetByUserId(userId); } foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleCBE module in modules) { string link = ""; // Get all submodules which are authorized to this user VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection subModules = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection(); if (userId == 1)// super admin { VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection subModulesTemp = VaaaN.MLFF.Libraries.CommonLibrary.BLL.SubModuleBLL.GetAll(); foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCBE subModule in subModulesTemp) { if (subModule.ModuleId == module.ModuleId) { subModules.Add(subModule); } } } else { subModules = VaaaN.MLFF.Libraries.CommonLibrary.BLL.SubModuleBLL.GetByUserId(userId, module.ModuleId); } link = string.Empty; ResourceManager rm = new ResourceManager(typeof(VaaaN.MLFF.Libraries.CommonLibrary.Resource.Resourceen)); string someString = rm.GetString(module.ModuleName); if ((subModules.Count == 0) || module.ModuleId == 7) //7 for reports { if (module.IsGuiVisible != 0) { sb.Append("<a id=\"module_" + module.ModuleId + "\" class=\"parent list-group-item list-group-item-info\" data-parent=\"#MainMenu\" href=\"" + module.ModuleUrl.ToLower() + "\">");//module.Url //// sb.Append("<i style=\"padding-right:10%; padding-left:1%;\" class=\"" + "" + "\"></i>"+ module.ModuleName + "</a>"); sb.Append("<i style=\"padding-right:10%; padding-left:1%;\" class=\"" + "" + "\"></i>" + someString + "</a>"); } } else { sb.Append("<a id=\"module_" + module.ModuleId + "\" class=\"parent list-group-item list-group-item-info\" data-toggle=\"collapse\" data-Parent=\"#MainMenu\" href=\"#" + someString + "subMenu\">"); sb.Append("<i style=\"padding-right:10%; padding-left:1%;\" class=\"" + "" + "\"></i>" + someString + ""); sb.Append("<i style=\"float:right\" class=\"fa fa-caret-down\"></i></a>"); sb.Append("<div class=\"collapse list-group-submenu\" id=\"" + someString + "subMenu\">"); foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCBE subModule in subModules) { if (subModule.IsGuiVisible != 0) { string substring = rm.GetString(subModule.SubModuleName); sb.Append("<a id=\"submodule_" + subModule.SubModuleId + "\" class=\"list-group-item list-group-item-info\" data-parent=\"#" + module.ModuleName + "subMenu\" href=\"" + subModule.SubmoduleUrl.ToLower() + "\">");//Submodule.Url sb.Append("<i style=\"padding-right:10%; padding-left:1%;\" class=\"fa fa-caret-right\"></i>" + substring + "</a>"); } } sb.Append("</div>"); } } } catch (Exception) { //VaaaN.ATMS.Libraries.CCHLibrary.ErrorLogger.LogMessage("Failed to create menu." + ex.Message); } return(sb.ToString()); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string startDate = Convert.ToString(Session["startDate"]); string endDate = Convert.ToString(Session["endDate"]); Int32 rptnameid = Convert.ToInt32(Session["rptname"]); Int32 GantryId = 0; Int32 VehicleClassId = 0; Int32 TransactionCategoryId = 0; if (Session["GantryId"] != null) { GantryId = Convert.ToInt32(Session["GantryId"]); } if (Session["VehicleClassId"] != null) { VehicleClassId = Convert.ToInt32(Session["VehicleClassId"]); } if (Session["TransactionCategoryId"] != null) { VehicleClassId = Convert.ToInt32(Session["TransactionCategoryId"]); } ReportViewer1.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Local; Microsoft.Reporting.WebForms.LocalReport rvReportViewer1 = ReportViewer1.LocalReport; string rptname = ""; if (rptnameid > 0) { VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection subModules = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection(); subModules = VaaaN.MLFF.Libraries.CommonLibrary.BLL.SubModuleBLL.GetByUserId(Convert.ToInt16(Session["LoggedUserId"]), 7); foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCBE submodule in subModules) { if (submodule.SubModuleId == rptnameid) { rptname = submodule.SubModuleName; break; } } if (rptname != "") { ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.ServerReport.Refresh(); DataSet lds = new DataSet(); switch (rptname) { #region Transaction Details Report case "Transaction Details": { string strQuery = " WHERE 1=1 "; if (startDate != null && endDate != null) { strQuery += " AND TRANSACTION_DATETIME BETWEEN TO_DATE('" + startDate + "','DD/MM/YYYY HH24:MI:SS') AND TO_DATE('" + endDate + "','DD/MM/YYYY HH24:MI:SS')"; } else if (startDate != null) { strQuery += " AND TRANSACTION_DATETIME >= TO_DATE('" + startDate + "','DD/MM/YYYY HH24:MI:SS')"; } else if (endDate != null) { strQuery += " AND TRANSACTION_DATETIME <= TO_DATE('" + endDate + "','DD/MM/YYYY HH24:MI:SS')"; } if (GantryId > 0) { strQuery += " AND T.PLAZA_ID = " + GantryId; } if (VehicleClassId > 0) { strQuery += " AND (CV_CTP.VEHICLE_CLASS_ID = " + VehicleClassId + " OR NFPF.VEHICLE_CLASS_ID = " + VehicleClassId + " OR NFPR.VEHICLE_CLASS_ID = " + VehicleClassId + ")"; } if (TransactionCategoryId == 0) { strQuery += " AND NVL(IS_BALANCE_UPDATED,0) <> 1"; } else if (TransactionCategoryId == 1) { strQuery += " AND T.CT_ENTRY_ID IS NOT NULL "; } else if (TransactionCategoryId == 2) { strQuery += " AND T.NF_ENTRY_ID_FRONT IS NOT NULL "; } else if (TransactionCategoryId == 3) { strQuery += " AND T.NF_ENTRY_ID_REAR IS NOT NULL "; } dt = VaaaN.MLFF.Libraries.CommonLibrary.BLL.TransactionBLL.GetDataTableFilteredRecords(strQuery); rvReportViewer1.ReportPath = Server.MapPath("~/Reports/TranscationReport.rdlc"); rvReportViewer1.DataSources.Add(new ReportDataSource("ReportDataSet", dt)); rvReportViewer1.DataSources.Add(new ReportDataSource("CommonDataSet", CreateCommonDataTable(rptname))); break; } #endregion } ReportViewer1.ShowRefreshButton = false; // Section 2 ReportViewer1.DataBind(); ReportViewer1.LocalReport.Refresh(); ReportViewer1.ServerReport.Refresh(); } } } }
public static string NewMenu(int userId, string MenuName, string ChildMenuName) { StringBuilder sb = new StringBuilder(); //string path = Server.MapPath(""); try { VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleCollection modules = null; // Get all modules which are authorized to this user. if (userId == 1)// super admin { modules = VaaaN.MLFF.Libraries.CommonLibrary.DAL.ModuleDAL.GetAll(); } else { modules = VaaaN.MLFF.Libraries.CommonLibrary.DAL.ModuleDAL.GetByUserId(userId); } int i = 0; foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.ModuleCBE module in modules) { string link = ""; // Get all submodules which are authorized to this user VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection subModules = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection(); if (userId == 1)// super admin { subModules = VaaaN.MLFF.Libraries.CommonLibrary.BLL.SubModuleBLL.GetByModuleId(module.ModuleId); } else { subModules = VaaaN.MLFF.Libraries.CommonLibrary.BLL.SubModuleBLL.GetByUserId(userId, module.ModuleId); } link = string.Empty; ResourceManager rm = new ResourceManager(typeof(VaaaN.MLFF.Libraries.CommonLibrary.Resource.Resourceen)); string someString = rm.GetString(module.ModuleName); if (!string.IsNullOrEmpty(module.ModuleUrl) && (subModules.Count == 0)) { if (MenuName.ToLower() == module.ModuleName.ToLower()) { if (i == 0) { sb.Append("<li class='nav-item mT-30 dropdown'>"); } else { sb.Append("<li class='nav-item active'>"); } } else { if (i == 0) { sb.Append("<li class='nav-item mT-30'>"); } else { sb.Append("<li class='nav-item'>"); } } sb.Append(" <a class='sidebar-link' href='" + module.ModuleUrl.ToLower() + "'>"); sb.Append(" <span class='icon-holder'>"); sb.Append(" <i class='c-blue-500 " + module.Icon + "'></i>"); sb.Append(" </span>"); sb.Append(" <span class='title'>" + someString + "</span>"); sb.Append(" </a>"); sb.Append("</li>"); } else { if (subModules.Count != 0) { if (MenuName.ToLower() == module.ModuleName.ToLower()) { if (i == 0) { sb.Append("<li class='nav-item dropdown'>"); } else { sb.Append("<li class='nav-item dropdown open'>"); } } else { sb.Append("<li class='nav-item dropdown'>"); } sb.Append(" <a class='dropdown-toggle' href='javascript:void(0);'>"); sb.Append(" <span class='icon-holder'>"); sb.Append(" <i class='c-blue-500 " + module.Icon + "'></i>"); sb.Append(" </span>"); sb.Append(" <span class='title'>" + someString + "</span>"); sb.Append(" <span class='arrow'>"); sb.Append(" <i class='ti-angle-right'></i>"); sb.Append(" </span>"); sb.Append(" </a>"); if (MenuName.ToLower() == module.ModuleName.ToLower()) { sb.Append(" <ul class='dropdown-menu' style='display: block;'>"); } else { sb.Append(" <ul class='dropdown-menu'>"); } foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCBE submodule in subModules) { someString = rm.GetString(submodule.SubModuleName); if (ChildMenuName.ToLower() == submodule.SubModuleName.ToLower()) { sb.Append("<li class='active'>"); } else { sb.Append("<li>"); } sb.Append(" <a class='dropdown-toggle' href='" + submodule.SubmoduleUrl.ToLower() + "'>"); //sb.Append(" <span class='icon-holder'>"); //sb.Append(" <i class='c-indigo-500 " + submodule.Icon + "'></i>"); //sb.Append(" </span>"); sb.Append(" <span class='title'>" + someString + "</span>"); sb.Append(" </a>"); sb.Append("</li>"); } sb.Append(" </ul>"); sb.Append("</li>"); } } i++; } } catch (Exception) { //VaaaN.ATMS.Libraries.CCHLibrary.ErrorLogger.LogMessage("Failed to create menu." + ex.Message); } return(sb.ToString()); }
// GET: Report public ActionResult ReportSelection() { if (Session["LoggedUserId"] == null) { return(Redirect("Login")); } try { ViewBag.MainMenu = HelperClass.NewMenu(Convert.ToInt16(Session["LoggedUserId"])); #region Report Filter VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection subModules = new VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCollection(); subModules = VaaaN.MLFF.Libraries.CommonLibrary.BLL.SubModuleBLL.GetByUserId(Convert.ToInt16(Session["LoggedUserId"]), 7); // only for report submodules List <SelectListItem> reports = new List <SelectListItem>(); reports.Add(new SelectListItem() { Text = "--Select Report--", Value = "0" }); foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.SubmoduleCBE submodule in subModules) { reports.Add(new SelectListItem { Value = Convert.ToString(submodule.SubModuleId), Text = submodule.SubModuleName }); } ViewBag.ReportType = reports; #endregion #region Gantry Class Dropdown List <SelectListItem> gantryList = new List <SelectListItem>(); List <VaaaN.MLFF.Libraries.CommonLibrary.CBE.PlazaCBE> plaza = VaaaN.MLFF.Libraries.CommonLibrary.BLL.PlazaBLL.GetAllAsList(); gantryList.Add(new SelectListItem() { Text = "--Select All--", Value = "0" }); foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.PlazaCBE cr in plaza) { gantryList.Add(new SelectListItem() { Text = cr.PlazaName, Value = System.Convert.ToString(cr.PlazaId) }); } ViewBag.Gantry = gantryList; #endregion #region Lane Class Dropdown List <SelectListItem> laneList = new List <SelectListItem>(); List <VaaaN.MLFF.Libraries.CommonLibrary.CBE.LaneCBE> Lane = new List <Libraries.CommonLibrary.CBE.LaneCBE>(); Lane = VaaaN.MLFF.Libraries.CommonLibrary.BLL.LaneBLL.GetAll().Cast <VaaaN.MLFF.Libraries.CommonLibrary.CBE.LaneCBE>().ToList(); laneList.Add(new SelectListItem() { Text = "--Select All--", Value = "0" }); foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.LaneCBE cr in Lane) { laneList.Add(new SelectListItem() { Text = cr.LaneName, Value = System.Convert.ToString(cr.LaneId) }); } ViewBag.Lane = laneList; #endregion #region Vehicle Class Dropdown List <SelectListItem> vehicleClass = new List <SelectListItem>(); List <VaaaN.MLFF.Libraries.CommonLibrary.CBE.VehicleClassCBE> vehicle = VaaaN.MLFF.Libraries.CommonLibrary.BLL.VehicleClassBLL.GetAll(); vehicleClass.Add(new SelectListItem() { Text = "--Select All--", Value = "0" }); foreach (VaaaN.MLFF.Libraries.CommonLibrary.CBE.VehicleClassCBE vc in vehicle) { vehicleClass.Add(new SelectListItem() { Text = vc.Name, Value = System.Convert.ToString(vc.Id) }); } ViewBag.VehicleClass = vehicleClass; #endregion #region Transaction Category ViewBag.TransactionCategory = HelperClass.GetReportTransactionCategory(); #endregion } catch (Exception ex) { HelperClass.LogMessage("Failed to load Report Selection Page" + ex); } return(View()); }